APPS.ECE_TRADING_PARTNERS_PUB dependencies on PO_VENDORS

Line 135: po_vendors pv

131: ELSIF p_address_type = G_SUPPLIER THEN
132: SELECT pvs.vendor_id,pv.vendor_name
133: INTO x_entity_id_out,x_tp_location_name_out
134: FROM po_vendor_sites_all pvs,
135: po_vendors pv
136: WHERE pvs.vendor_site_id = x_address_id_out AND
137: pvs.vendor_id = pv.vendor_id AND
138: ROWNUM = 1;
139: ELSE

Line 441: -- PO Vendors Cursor Bug 2551002

437: AND
438: */
439:
440: --Bug 2422787 pvs.vendor_site_id= NVL(cp_address_id_in,pvs.vendor_site_id) AND
441: -- PO Vendors Cursor Bug 2551002
442: CURSOR c1_vendor_sites(cp_transaction_type VARCHAR2,
443: cp_org_id_in NUMBER DEFAULT NULL,
444: cp_address_id_in NUMBER DEFAULT NULL,
445: cp_tp_location_code_in VARCHAR2 DEFAULT NULL,

Line 2921: from po_vendors pv, po_vendor_sites pvs,

2917: and ca.party_id = pt.party_id;
2918:
2919: cursor po_site is
2920: select pv.vendor_id, pvs.vendor_site_id
2921: from po_vendors pv, po_vendor_sites pvs,
2922: -- ece_tp_headers ec,
2923: ece_tp_details etd
2924: where
2925: etd.translator_code = p_translator_code

Line 3146: from po_vendors pv, po_vendor_sites pvs,

3142: and ca.party_id = pt.party_id;
3143:
3144: cursor po_site is
3145: select pv.vendor_id, pvs.vendor_site_id
3146: from po_vendors pv, po_vendor_sites pvs,
3147: ece_tp_headers eth
3148: where
3149: eth.tp_reference_ext1 = p_reference_ext1
3150: and eth.tp_reference_ext2 = p_reference_ext2