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 4586: --dbms_output.put_line('select from po_vendor_sites_all with supplier_site_id of '

4582: END IF;
4583:
4584: IF g_samples_table(i).supplier_site_id is not NULL
4585: THEN
4586: --dbms_output.put_line('select from po_vendor_sites_all with supplier_site_id of '
4587: -- || g_samples_table(i).supplier_site_id);
4588: select vendor_site_code into g_samples_table(i).supplier_site
4589: from po_vendor_sites_all
4590: where vendor_site_id = g_samples_table(i).supplier_site_id;

Line 4589: from po_vendor_sites_all

4585: THEN
4586: --dbms_output.put_line('select from po_vendor_sites_all with supplier_site_id of '
4587: -- || g_samples_table(i).supplier_site_id);
4588: select vendor_site_code into g_samples_table(i).supplier_site
4589: from po_vendor_sites_all
4590: where vendor_site_id = g_samples_table(i).supplier_site_id;
4591: END IF;
4592:
4593: IF g_samples_table(i).po_line_id is not NULL

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

5224:
5225: IF p_supplier_site IS NOT NULL
5226: THEN
5227: g_supplier_site := p_supplier_site;
5228: main_table_list := main_table_list||', po_vendor_sites_all vsa';
5229: main_where_clause := main_where_clause||' AND se.supplier_site_id = vsa.vendor_site_id'
5230: ||' AND vsa.vendor_site_code = :supplier_site';
5231: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supplier_site';
5232: END IF;

Line 5449: from po_vendor_sites_all

5445:
5446: IF g_sample_groups_table(i).supplier_site_id IS NOT NULL
5447: THEN
5448: select vendor_site_code into g_sample_groups_table(i).supplier_site_name
5449: from po_vendor_sites_all
5450: where vendor_site_id = g_sample_groups_table(i).supplier_site_id;
5451: END IF;
5452: END LOOP;
5453: END IF;