APPS.GMD_OUTBOUND_APIS_PUB dependencies on PO_VENDOR_SITES_ALL

Line 2168: ||' (SELECT vendor_site_id FROM po_vendor_sites_all'

2164: IF p_supl_vr_supplier_site IS NOT NULL
2165: THEN
2166: g_supl_vr_supplier_site := p_supl_vr_supplier_site;
2167: main_where_clause := main_where_clause||' AND msvr.supplier_site_id = '
2168: ||' (SELECT vendor_site_id FROM po_vendor_sites_all'
2169: ||' WHERE vendor_site_code = :supl_vr_supplier_site';
2170: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supl_vr_supplier_site';
2171:
2172: supl_vr_where_clause := supl_vr_where_clause||' AND svr.supplier_site_id = '

Line 2173: ||' (SELECT vendor_site_id FROM po_vendor_sites_all'

2169: ||' WHERE vendor_site_code = :supl_vr_supplier_site';
2170: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supl_vr_supplier_site';
2171:
2172: supl_vr_where_clause := supl_vr_where_clause||' AND svr.supplier_site_id = '
2173: ||' (SELECT vendor_site_id FROM po_vendor_sites_all'
2174: ||' WHERE vendor_site_code = :supl_vr_supplier_site';
2175: supl_vr_using_clause := supl_vr_using_clause||', gmd_outbound_apis_pub.g_supl_vr_supplier_site';
2176: END IF;
2177:

Line 4613: --dbms_output.put_line('select from po_vendor_sites_all with supplier_site_id of '

4609: END IF;
4610:
4611: IF g_samples_table(i).supplier_site_id is not NULL
4612: THEN
4613: --dbms_output.put_line('select from po_vendor_sites_all with supplier_site_id of '
4614: -- || g_samples_table(i).supplier_site_id);
4615: select vendor_site_code into g_samples_table(i).supplier_site
4616: from po_vendor_sites_all
4617: where vendor_site_id = g_samples_table(i).supplier_site_id;

Line 4616: from po_vendor_sites_all

4612: THEN
4613: --dbms_output.put_line('select from po_vendor_sites_all with supplier_site_id of '
4614: -- || g_samples_table(i).supplier_site_id);
4615: select vendor_site_code into g_samples_table(i).supplier_site
4616: from po_vendor_sites_all
4617: where vendor_site_id = g_samples_table(i).supplier_site_id;
4618: END IF;
4619:
4620: IF g_samples_table(i).po_line_id is not NULL

Line 5276: main_table_list := main_table_list||', po_vendor_sites_all vsa';

5272:
5273: IF p_supplier_site IS NOT NULL
5274: THEN
5275: g_supplier_site := p_supplier_site;
5276: main_table_list := main_table_list||', po_vendor_sites_all vsa';
5277: main_where_clause := main_where_clause||' AND se.supplier_site_id = vsa.vendor_site_id'
5278: ||' AND vsa.vendor_site_code = :supplier_site';
5279: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supplier_site';
5280: END IF;

Line 5497: from po_vendor_sites_all

5493:
5494: IF g_sample_groups_table(i).supplier_site_id IS NOT NULL
5495: THEN
5496: select vendor_site_code into g_sample_groups_table(i).supplier_site_name
5497: from po_vendor_sites_all
5498: where vendor_site_id = g_sample_groups_table(i).supplier_site_id;
5499: END IF;
5500: END LOOP;
5501: END IF;