APPS.GMD_OUTBOUND_APIS_PUB dependencies on PO_HEADERS_ALL

Line 2104: ||' (SELECT pla.po_line_id FROM po_headers_all pha, po_lines_all pla'

2100: IF p_supl_vr_po_number IS NOT NULL
2101: THEN
2102: g_supl_vr_po_number := p_supl_vr_po_number;
2103: main_where_clause := main_where_clause||' AND msvr.po_line_id IN'
2104: ||' (SELECT pla.po_line_id FROM po_headers_all pha, po_lines_all pla'
2105: ||' WHERE pha.segment1 = :supl_vr_po_number'
2106: ||' AND pha.po_header_id = pla.po_header_id)';
2107: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supl_vr_po_number';
2108:

Line 2110: ||' (SELECT pla.po_line_id FROM po_headers_all pha, po_lines_all pla'

2106: ||' AND pha.po_header_id = pla.po_header_id)';
2107: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supl_vr_po_number';
2108:
2109: supl_vr_where_clause := supl_vr_where_clause||' AND svr.po_line_id IN'
2110: ||' (SELECT pla.po_line_id FROM po_headers_all pha, po_lines_all pla'
2111: ||' WHERE pha.segment1 = :supl_vr_po_number'
2112: ||' AND pha.po_header_id = pla.po_header_id)';
2113: supl_vr_using_clause := supl_vr_using_clause||', gmd_outbound_apis_pub.g_supl_vr_po_number';
2114: END IF;

Line 4232: table_list := table_list ||', po_headers_all ph ';

4228: END IF;
4229:
4230: IF p_supplier_po IS NOT NULL
4231: THEN
4232: table_list := table_list ||', po_headers_all ph ';
4233: where_clause := where_clause ||'AND gs.po_header_id = ph.po_header_id ';
4234:
4235: gmd_outbound_apis_pub.g_supplier_po := p_supplier_po;
4236: where_clause := where_clause||'AND ph.segment1 = :supplier_po ';

Line 4604: --dbms_output.put_line('select from po_headers_all with po_header_id of '

4600: END IF;
4601:
4602: IF g_samples_table(i).po_header_id is not NULL
4603: THEN
4604: --dbms_output.put_line('select from po_headers_all with po_header_id of '
4605: -- || g_samples_table(i).po_header_id);
4606: select segment1 into g_samples_table(i).po_number
4607: from po_headers_all
4608: where po_header_id = g_samples_table(i).po_header_id;

Line 4607: from po_headers_all

4603: THEN
4604: --dbms_output.put_line('select from po_headers_all with po_header_id of '
4605: -- || g_samples_table(i).po_header_id);
4606: select segment1 into g_samples_table(i).po_number
4607: from po_headers_all
4608: where po_header_id = g_samples_table(i).po_header_id;
4609: END IF;
4610:
4611: IF g_samples_table(i).supplier_site_id is not NULL

Line 4880: main_table_list :=' gmd_sampling_events se, rcv_shipment_headers rh, po_headers_all ph'

4876: ||', se.SAMPLE_ACTIVE_CNT '
4877: ||', se.organization_id, se.resources, se.instance_id, se.time_point_id '
4878: ||', se.variant_id, se.archived_taken, se.reserved_taken ';
4879:
4880: main_table_list :=' gmd_sampling_events se, rcv_shipment_headers rh, po_headers_all ph'
4881: ||',gme_batch_header bh, fnd_user fu1, fnd_user fu2, gmd_recipes_b r'
4882: ||',fm_form_mst_b fh, oe_order_headers_all oh, mtl_system_items_b im'
4883: ||',po_lines_all pl, oe_order_lines_all ol, fm_matl_dtl fd'
4884: ||',mtl_parameters mp';

Line 5285: main_table_list := main_table_list||', po_headers_all pha';

5281:
5282: IF p_supplier_po_number IS NOT NULL
5283: THEN
5284: g_supplier_po_number := p_supplier_po_number;
5285: main_table_list := main_table_list||', po_headers_all pha';
5286: main_where_clause := main_where_clause||' AND se.po_header_id = pha.po_header_id'
5287: ||' AND pha.segment1 = :supplier_po_number';
5288: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supplier_po_number';
5289: END IF;