APPS.EC_TRADING_PARTNER_PVT dependencies on PO_VENDOR_SITES

Line 48: from po_vendors pv, po_vendor_sites pvs,

44: and ca.party_id = pt.party_id;
45:
46: cursor po_site is
47: select pv.vendor_id, pvs.vendor_site_id
48: from po_vendors pv, po_vendor_sites pvs,
49: -- ece_tp_headers ec,
50: ece_tp_details etd
51: where
52: etd.translator_code = p_translator_code

Line 293: from po_vendors pv, po_vendor_sites pvs,

289: and ca.party_id = pt.party_id;
290:
291: cursor po_site is
292: select pv.vendor_id, pvs.vendor_site_id
293: from po_vendors pv, po_vendor_sites pvs,
294: ece_tp_headers eth
295: where
296: eth.tp_reference_ext1 = p_reference_ext1
297: and eth.tp_reference_ext2 = p_reference_ext2

Line 527: from ece_tp_headers ec, po_vendor_sites pvs

523: cursor po_site is
524: select pvs.ece_tp_location_code,
525: ec.tp_reference_ext1,
526: ec.tp_reference_ext2
527: from ece_tp_headers ec, po_vendor_sites pvs
528: where
529: pvs.vendor_site_id = p_entity_address_id
530: and pvs.tp_header_id = ec.tp_header_id;
531:

Line 750: from ece_tp_details tpd,po_vendor_sites povs

746: and cas.cust_acct_site_id = p_entity_id;
747:
748: cursor type_supplier is
749: select tpd.tp_detail_id
750: from ece_tp_details tpd,po_vendor_sites povs
751: where tpd.tp_header_id = povs.tp_header_id
752: and tpd.document_id = p_transaction_type
753: and tpd.document_type = nvl(p_transaction_subtype,tpd.document_type)
754: and povs.vendor_site_id = p_entity_id;