DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on AP_SUPPLIER_SITES_ALL

Line 6494: AP_SUPPLIER_SITES_ALL PS,

6490: NULL REQUESTED_SUPPLIER_NAME,
6491: NULL REQUESTED_SUPPLIER_CONTACT_ID,
6492: NULL REQUESTED_SUPP_CONTACT_NAME
6493: FROM PON_BIDDING_PARTIES PBP,
6494: AP_SUPPLIER_SITES_ALL PS,
6495: AP_SUPPLIERS PV
6496: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6497: --bug 8613219
6498: -- AND NVL(PBP.from_emd_flag,'N') <> 'Y' -- Added by Lion for EMD on 04/02/2009

Line 6663: AP_SUPPLIER_SITES_ALL PS,

6659: NULL REQUESTED_SUPPLIER_NAME,
6660: NULL REQUESTED_SUPPLIER_CONTACT_ID,
6661: NULL REQUESTED_SUPP_CONTACT_NAME
6662: FROM PON_BIDDING_PARTIES PBP,
6663: AP_SUPPLIER_SITES_ALL PS,
6664: AP_SUPPLIERS PV
6665: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6666: AND PV.PARTY_ID = PBP.TRADING_PARTNER_ID
6667: AND PS.VENDOR_ID = PV.VENDOR_ID