APPS.ECE_TRADING_PARTNERS_PUB dependencies on PO_VENDOR_SITES

Line 134: FROM po_vendor_sites_all pvs,

130: AND ca.party_id = pt.party_id;
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;

Line 475: FROM po_vendor_sites_all pvs

471: pvs.country country,
472: TO_CHAR(NULL) region_1,
473: TO_CHAR(NULL) region_2,
474: TO_CHAR(NULL) region_3
475: FROM po_vendor_sites_all pvs
476: WHERE nvl(pvs.org_id,-99) = NVL(cp_org_id_in,nvl(pvs.org_id,-99)) AND
477: NVL(UPPER(pvs.ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%') AND
478: NVL(UPPER(pvs.address_line1),' ') LIKE NVL(UPPER(cp_address_line1_in),'%') AND
479: NVL(UPPER(pvs.address_line2),' ') LIKE NVL(UPPER(cp_address_line2_in),'%') AND

Line 509: FROM po_vendor_sites_all pvs,

505: pvs.country country,
506: TO_CHAR(NULL) region_1,
507: TO_CHAR(NULL) region_2,
508: TO_CHAR(NULL) region_3
509: FROM po_vendor_sites_all pvs,
510: ece_tp_details etd
511: WHERE nvl(pvs.org_id,-99) = NVL(cp_org_id_in,nvl(pvs.org_id,-99)) AND
512: NVL(UPPER(pvs.ece_tp_location_code),' ') LIKE NVL(UPPER(cp_tp_location_code_in),'%') AND
513: pvs.tp_header_id = etd.tp_header_id AND

Line 2420: FROM po_vendor_sites_all pvs

2416: x_country_out,
2417: x_region_1_out,
2418: x_region_2_out,
2419: x_region_3_out
2420: FROM po_vendor_sites_all pvs
2421: WHERE pvs.vendor_site_id = p_address_id_in;
2422:
2423: EXCEPTION
2424: WHEN NO_DATA_FOUND THEN

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

Line 3362: from ece_tp_headers ec, po_vendor_sites pvs

3358: cursor po_site is
3359: select pvs.ece_tp_location_code,
3360: ec.tp_reference_ext1,
3361: ec.tp_reference_ext2
3362: from ece_tp_headers ec, po_vendor_sites pvs
3363: where
3364: pvs.vendor_site_id = p_entity_address_id
3365: and pvs.tp_header_id = ec.tp_header_id;
3366: