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 4206: table_list := table_list ||', po_vendors v ';

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

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

4557: END IF;
4558:
4559: IF g_samples_table(i).supplier_id is not NULL
4560: THEN
4561: --dbms_output.put_line('select from po_vendors using vendor_id of '|| g_samples_table(i).supplier_id);
4562: select segment1 into g_samples_table(i).supplier_no
4563: from po_vendors
4564: where vendor_id = g_samples_table(i).supplier_id;
4565: END IF;

Line 4563: from po_vendors

4559: IF g_samples_table(i).supplier_id is not NULL
4560: THEN
4561: --dbms_output.put_line('select from po_vendors using vendor_id of '|| g_samples_table(i).supplier_id);
4562: select segment1 into g_samples_table(i).supplier_no
4563: from po_vendors
4564: where vendor_id = g_samples_table(i).supplier_id;
4565: END IF;
4566:
4567: IF g_samples_table(i).sampler_id is not NULL

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

5215:
5216: IF p_supplier IS NOT NULL
5217: THEN
5218: g_supplier := p_supplier;
5219: main_table_list := main_table_list||', po_vendors v';
5220: main_where_clause := main_where_clause||' AND se.supplier_id = v.vendor_id'
5221: ||' AND v.segment1 = :supplier';
5222: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supplier';
5223: END IF;

Line 5435: from po_vendors

5431:
5432: IF g_sample_groups_table(i).supplier_id IS NOT NULL
5433: THEN
5434: select segment1 into g_sample_groups_table(i).supplier_name
5435: from po_vendors
5436: where vendor_id=g_sample_groups_table(i).supplier_id;
5437: END IF;
5438:
5439: IF g_sample_groups_table(i).ship_to_site_id IS NOT NULL