DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_BID_HEADERS

Line 6887: FROM PON_BID_HEADERS PBH

6883: AND (TRADING_PARTNER_ID,TRADING_PARTNER_CONTACT_ID,nvl(VENDOR_SITE_ID,-1))
6884: NOT IN (SELECT PBH.TRADING_PARTNER_ID,
6885: PBH.TRADING_PARTNER_CONTACT_ID,
6886: NVL(PBH.VENDOR_SITE_ID,-1) VENDOR_SITE_ID
6887: FROM PON_BID_HEADERS PBH
6888: WHERE PBH.SHORTLIST_FLAG = 'N'
6889: AND PBH.AUCTION_HEADER_ID IN
6890: (SELECT AUCTION_HEADER_ID
6891: FROM PON_AUCTION_HEADERS_ALL

Line 6981: FROM PON_BID_HEADERS PBH

6977: NULL REQUESTED_SUPPLIER_ID,
6978: NULL REQUESTED_SUPPLIER_NAME,
6979: NULL REQUESTED_SUPPLIER_CONTACT_ID,
6980: NULL REQUESTED_SUPP_CONTACT_NAME
6981: FROM PON_BID_HEADERS PBH
6982: WHERE PBH.SHORTLIST_FLAG <> 'N'
6983: AND PBH.AUCTION_HEADER_ID IN
6984: (SELECT AUCTION_HEADER_ID
6985: FROM PON_AUCTION_HEADERS_ALL

Line 6996: FROM pon_bid_headers pbhinner

6992: FROM PON_BIDDING_PARTIES
6993: WHERE AUCTION_HEADER_ID = p_source_auction_header_id)
6994: AND PBH.trading_partner_contact_name =
6995: (SELECT MIN(trading_partner_contact_name)
6996: FROM pon_bid_headers pbhinner
6997: WHERE pbhinner.trading_partner_id = pbh.trading_partner_id
6998: AND pbhinner.auction_header_id = pbh.auction_header_id
6999: GROUP BY pbhinner.auction_header_id, pbhinner.trading_partner_id)
7000: GROUP BY TRADING_PARTNER_ID, TRADING_PARTNER_NAME, TRADING_PARTNER_CONTACT_ID, TRADING_PARTNER_CONTACT_NAME