Tables and Views for Procurement PON_AUCTION_HEADERS_ALL_V Details Schema: FUSION Object owner: PON Object type: VIEW Columns Name
PON_AUCTION_HEADERSには、オークション、見積依頼および情報依頼ヘッダー情報が格納されます。各行には、タイプ、形式、ビジネス条件、レスポンス管理などの一般ネゴシエーション情報が含まれます。 DOCTYPE_ID列は、トランザクションがオークション、見積依頼または情報依
PON_SUPPLIER_ICF_VALUESpon_auction_headers_allAUCTION_HEADER_ID PON_SUPPLIER_ICF_VALUESpon_price_element_types_bPRICE_ELEMENT_TYPE_ID 索引 索引一意性表領域列 PON_SUPPLIER_ICF_VALUES_U1一意デフォルトSUPPLIER_ICF_ID PON_SUPPLIER_ICF_VALUES_U2一意デフォルトAUCTION_HEADER_ID, LINE_NUMBER, SUPPL...
PON_AUCTION_HEADERS_ALL pah, PON_BID_HEADERS pbh WHERE pbs.BID_NUMBER = pbh.BID_NUMBER AND pah.AUCTION_HEADER_ID = pbh.AUCTION_HEADER_ID AND ((NVL(pah.TWO_PART_FLAG, 'N') = 'N' AND NVL(pah.SEALED_AUCTION_STATUS, 'UNLOCKED') != 'LOCKED') OR (pah.TWO_PART_FLAG = 'Y' AND ...
FROM pon_auction_headers_all ah, pon_bid_headers bh , per_persons pp WHERE (ah.auction_status = 'ACTIVE' OR ah.auction_status ='AUCTION_CLOSED') AND bh.auction_header_id = ah.auction_header_id AND bh.bid_status = 'ACTIVE' AND ...
SELECT bh.bid_number bid_number, hzp.party_id party_id FROM pon_auction_headers_all ah, pon_bid_headers bh, hz_parties hzp WHERE bh.auction_header_id = ah.auction_header_id and bh.bid_status = 'ACTIVE' and ah.auction_status <> 'DRAFT' and ah.auction_status <> 'CANCELLED' and ...
Tables and Views for Procurement PON_AUCTIONITEMPRICESALL_MSV Details Schema: FUSION Object owner: PON Object type: VIEW Columns Name Query SQL_Statement
Tables and Views for Procurement PON_BID_HEADERS_MSV Details Schema: FUSION Object owner: PON Object type: VIEW Columns Name SQL_Statement
Tables and Views for Procurement Details Schema: FUSION Object owner: PON Object type: VIEW Columns Name SQL_Statement
PON_AUCTION_HEADERS stores auctions, RFQs, and RFIs header information. Each row includes general negotiation information such as type, style, business terms and conditions, response controls, et cetera. The DOCTYPE_ID column indicates whether the transa