APPS.PON_NEGOTIATION_COPY_GRP dependencies on AP_SUPPLIERS

Line 6495: AP_SUPPLIERS PV

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
6499: AND PV.PARTY_ID = PBP.TRADING_PARTNER_ID

Line 6664: AP_SUPPLIERS PV

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
6668: AND NVL(PBP.from_emd_flag,'N') <> 'Y'-- Added by Lion for EMD on 04/02/2009

Line 6714: AP_SUPPLIERS PV

6710: NULL REQUESTED_SUPPLIER_NAME,
6711: NULL REQUESTED_SUPPLIER_CONTACT_ID,
6712: NULL REQUESTED_SUPP_CONTACT_NAME
6713: FROM PON_BIDDING_PARTIES PBP,
6714: AP_SUPPLIERS PV
6715: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6716: AND NVL(PBP.from_emd_flag,'N') <> 'Y'-- Added by Lion for EMD on 04/02/2009
6717: AND (PBP.VENDOR_SITE_ID = -1 OR
6718: PBP.VENDOR_SITE_ID IS NULL)

Line 6879: AP_SUPPLIERS PV

6875: NULL REQUESTED_SUPPLIER_NAME,
6876: NULL REQUESTED_SUPPLIER_CONTACT_ID,
6877: NULL REQUESTED_SUPP_CONTACT_NAME
6878: FROM PON_BIDDING_PARTIES PBP,
6879: AP_SUPPLIERS PV
6880: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6881: --bug 8613219
6882: --AND NVL(PBP.from_emd_flag,'N') <> 'Y'-- Added by Lion for EMD on 04/02/2009
6883: AND (TRADING_PARTNER_ID,TRADING_PARTNER_CONTACT_ID,nvl(VENDOR_SITE_ID,-1))