APPS.GMD_OUTBOUND_APIS_PUB dependencies on PO_VENDORS

Line 1005: supl_vr_table_list := ' gmd_supplier_spec_vrs svr, fnd_user fu10, fnd_user fu11, po_vendors v';

1001: ||', svr.created_by, fu10.user_name, svr.last_update_date, svr.last_updated_by'
1002: ||', fu11.user_name, svr.last_update_login'
1003: ||')';
1004:
1005: supl_vr_table_list := ' gmd_supplier_spec_vrs svr, fnd_user fu10, fnd_user fu11, po_vendors v';
1006:
1007: supl_vr_where_clause := ' svr.created_by = fu10.user_id AND svr.last_updated_by = fu11.user_id'
1008: ||' AND svr.spec_id = gs.spec_id AND v.vendor_id = svr.supplier_id AND 1=:dummy5';
1009: supl_vr_using_clause := '1';

Line 2005: ||' ( SELECT spec_id fROM gmd_supplier_spec_vrs msvr, po_vendors mpv'

2001:
2002:
2003: main_where_clause := main_where_clause
2004: ||' AND gs.spec_id IN'
2005: ||' ( SELECT spec_id fROM gmd_supplier_spec_vrs msvr, po_vendors mpv'
2006: ||' WHERE msvr.supplier_id = mpv.vendor_id';
2007:
2008: IF p_supl_vr_start_date IS NOT NULL
2009: THEN

Line 4208: table_list := table_list ||', po_vendors v ';

4204: END IF;
4205:
4206: IF p_supplier IS NOT NULL
4207: THEN
4208: table_list := table_list ||', po_vendors v ';
4209: where_clause := where_clause ||'AND gs.supplier_id = v.vendor_id ';
4210:
4211: gmd_outbound_apis_pub.g_supplier := p_supplier;
4212: where_clause := where_clause||'AND v.vendor_name = :supplier '; -- 5335829 rework - changed from segment1

Line 4588: --dbms_output.put_line('select from po_vendors using vendor_id of '|| g_samples_table(i).supplier_id);

4584: END IF;
4585:
4586: IF g_samples_table(i).supplier_id is not NULL
4587: THEN
4588: --dbms_output.put_line('select from po_vendors using vendor_id of '|| g_samples_table(i).supplier_id);
4589: select segment1 into g_samples_table(i).supplier_no
4590: from po_vendors
4591: where vendor_id = g_samples_table(i).supplier_id;
4592: END IF;

Line 4590: from po_vendors

4586: IF g_samples_table(i).supplier_id is not NULL
4587: THEN
4588: --dbms_output.put_line('select from po_vendors using vendor_id of '|| g_samples_table(i).supplier_id);
4589: select segment1 into g_samples_table(i).supplier_no
4590: from po_vendors
4591: where vendor_id = g_samples_table(i).supplier_id;
4592: END IF;
4593:
4594: IF g_samples_table(i).sampler_id is not NULL

Line 5267: main_table_list := main_table_list||', po_vendors v';

5263:
5264: IF p_supplier IS NOT NULL
5265: THEN
5266: g_supplier := p_supplier;
5267: main_table_list := main_table_list||', po_vendors v';
5268: main_where_clause := main_where_clause||' AND se.supplier_id = v.vendor_id'
5269: ||' AND v.segment1 = :supplier';
5270: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supplier';
5271: END IF;

Line 5483: from po_vendors

5479:
5480: IF g_sample_groups_table(i).supplier_id IS NOT NULL
5481: THEN
5482: select segment1 into g_sample_groups_table(i).supplier_name
5483: from po_vendors
5484: where vendor_id=g_sample_groups_table(i).supplier_id;
5485: END IF;
5486:
5487: IF g_sample_groups_table(i).ship_to_site_id IS NOT NULL