APPS.PON_NEGOTIATION_COPY_GRP dependencies on AP_SUPPLIERS

Line 5361: AP_SUPPLIERS PV

5357: NULL REQUESTED_SUPPLIER_CONTACT_ID,
5358: NULL REQUESTED_SUPP_CONTACT_NAME
5359: FROM PON_BIDDING_PARTIES PBP,
5360: AP_SUPPLIER_SITES_ALL PS,
5361: AP_SUPPLIERS PV
5362: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
5363: AND PV.PARTY_ID = PBP.TRADING_PARTNER_ID
5364: AND PS.VENDOR_ID = PV.VENDOR_ID
5365: AND (PS.PURCHASING_SITE_FLAG = 'Y' OR PS.RFQ_ONLY_SITE_FLAG = 'Y')

Line 5526: AP_SUPPLIERS PV

5522: NULL REQUESTED_SUPPLIER_CONTACT_ID,
5523: NULL REQUESTED_SUPP_CONTACT_NAME
5524: FROM PON_BIDDING_PARTIES PBP,
5525: AP_SUPPLIER_SITES_ALL PS,
5526: AP_SUPPLIERS PV
5527: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
5528: AND PV.PARTY_ID = PBP.TRADING_PARTNER_ID
5529: AND PS.VENDOR_ID = PV.VENDOR_ID
5530: AND nvl(PV.start_date_active, sysdate) <= sysdate

Line 5575: AP_SUPPLIERS PV

5571: NULL REQUESTED_SUPPLIER_NAME,
5572: NULL REQUESTED_SUPPLIER_CONTACT_ID,
5573: NULL REQUESTED_SUPP_CONTACT_NAME
5574: FROM PON_BIDDING_PARTIES PBP,
5575: AP_SUPPLIERS PV
5576: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
5577: AND (PBP.VENDOR_SITE_ID = -1 OR
5578: PBP.VENDOR_SITE_ID IS NULL)
5579: AND PBP.TRADING_PARTNER_ID = PV.PARTY_ID

Line 5738: AP_SUPPLIERS PV

5734: NULL REQUESTED_SUPPLIER_NAME,
5735: NULL REQUESTED_SUPPLIER_CONTACT_ID,
5736: NULL REQUESTED_SUPP_CONTACT_NAME
5737: FROM PON_BIDDING_PARTIES PBP,
5738: AP_SUPPLIERS PV
5739: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
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,