APPS.ECE_TRADING_PARTNERS_PUB dependencies on PO_VENDOR_SITES_ALL

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