DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_BID_HEADERS

Line 5744: FROM PON_BID_HEADERS PBH

5740: AND (TRADING_PARTNER_ID,TRADING_PARTNER_CONTACT_ID,nvl(VENDOR_SITE_ID,-1))
5741: NOT IN (SELECT PBH.TRADING_PARTNER_ID,
5742: PBH.TRADING_PARTNER_CONTACT_ID,
5743: NVL(PBH.VENDOR_SITE_ID,-1) VENDOR_SITE_ID
5744: FROM PON_BID_HEADERS PBH
5745: WHERE PBH.SHORTLIST_FLAG = 'N'
5746: AND PBH.AUCTION_HEADER_ID IN
5747: (SELECT AUCTION_HEADER_ID
5748: FROM PON_AUCTION_HEADERS_ALL

Line 5836: FROM PON_BID_HEADERS PBH

5832: NULL REQUESTED_SUPPLIER_ID,
5833: NULL REQUESTED_SUPPLIER_NAME,
5834: NULL REQUESTED_SUPPLIER_CONTACT_ID,
5835: NULL REQUESTED_SUPP_CONTACT_NAME
5836: FROM PON_BID_HEADERS PBH
5837: WHERE PBH.SHORTLIST_FLAG <> 'N'
5838: AND PBH.AUCTION_HEADER_ID IN
5839: (SELECT AUCTION_HEADER_ID
5840: FROM PON_AUCTION_HEADERS_ALL

Line 5851: FROM pon_bid_headers pbhinner

5847: FROM PON_BIDDING_PARTIES
5848: WHERE AUCTION_HEADER_ID = p_source_auction_header_id)
5849: AND PBH.trading_partner_contact_name =
5850: (SELECT MIN(trading_partner_contact_name)
5851: FROM pon_bid_headers pbhinner
5852: WHERE pbhinner.trading_partner_id = pbh.trading_partner_id
5853: AND pbhinner.auction_header_id = pbh.auction_header_id
5854: GROUP BY pbhinner.auction_header_id, pbhinner.trading_partner_id)
5855: GROUP BY TRADING_PARTNER_ID, TRADING_PARTNER_NAME, TRADING_PARTNER_CONTACT_ID, TRADING_PARTNER_CONTACT_NAME