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 4230: table_list := table_list ||', po_headers_all ph ';

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

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

4573: END IF;
4574:
4575: IF g_samples_table(i).po_header_id is not NULL
4576: THEN
4577: --dbms_output.put_line('select from po_headers_all with po_header_id of '
4578: -- || g_samples_table(i).po_header_id);
4579: select segment1 into g_samples_table(i).po_number
4580: from po_headers_all
4581: where po_header_id = g_samples_table(i).po_header_id;

Line 4580: from po_headers_all

4576: THEN
4577: --dbms_output.put_line('select from po_headers_all with po_header_id of '
4578: -- || g_samples_table(i).po_header_id);
4579: select segment1 into g_samples_table(i).po_number
4580: from po_headers_all
4581: where po_header_id = g_samples_table(i).po_header_id;
4582: END IF;
4583:
4584: IF g_samples_table(i).supplier_site_id is not NULL

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

4828: ||', se.SAMPLE_ACTIVE_CNT '
4829: ||', se.organization_id, se.resources, se.instance_id, se.time_point_id '
4830: ||', se.variant_id, se.archived_taken, se.reserved_taken ';
4831:
4832: main_table_list :=' gmd_sampling_events se, rcv_shipment_headers rh, po_headers_all ph'
4833: ||',gme_batch_header bh, fnd_user fu1, fnd_user fu2, gmd_recipes_b r'
4834: ||',fm_form_mst_b fh, oe_order_headers_all oh, mtl_system_items_b im'
4835: ||',po_lines_all pl, oe_order_lines_all ol, fm_matl_dtl fd'
4836: ||',mtl_parameters mp';

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

5233:
5234: IF p_supplier_po_number IS NOT NULL
5235: THEN
5236: g_supplier_po_number := p_supplier_po_number;
5237: main_table_list := main_table_list||', po_headers_all pha';
5238: main_where_clause := main_where_clause||' AND se.po_header_id = pha.po_header_id'
5239: ||' AND pha.segment1 = :supplier_po_number';
5240: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_supplier_po_number';
5241: END IF;