APPS.GMD_OUTBOUND_APIS_PUB dependencies on OE_ORDER_LINES_ALL

Line 4189: table_list := table_list ||', oe_order_lines_all ool ';

4185: END IF;
4186:
4187: IF p_cust_order_line IS NOT NULL
4188: THEN
4189: table_list := table_list ||', oe_order_lines_all ool ';
4190: where_clause := where_clause ||'AND gs.order_line_id = ool.line_id ';
4191:
4192: gmd_outbound_apis_pub.g_cust_order_line := p_cust_order_line;
4193: where_clause := where_clause||'AND ool.line_number = :cust_order_line ';

Line 4544: --dbms_output.put_line('select from oe_order_lines_all with line_id of '

4540: END IF;
4541:
4542: IF g_samples_table(i).order_line_id is not NULL
4543: THEN
4544: --dbms_output.put_line('select from oe_order_lines_all with line_id of '
4545: -- || g_samples_table(i).order_line_id);
4546: select line_number into g_samples_table(i).order_line_number
4547: from oe_order_lines_all
4548: where line_id = g_samples_table(i).order_line_id;

Line 4547: from oe_order_lines_all

4543: THEN
4544: --dbms_output.put_line('select from oe_order_lines_all with line_id of '
4545: -- || g_samples_table(i).order_line_id);
4546: select line_number into g_samples_table(i).order_line_number
4547: from oe_order_lines_all
4548: where line_id = g_samples_table(i).order_line_id;
4549: END IF;
4550:
4551: IF g_samples_table(i).org_id is not NULL

Line 4835: ||',po_lines_all pl, oe_order_lines_all ol, fm_matl_dtl fd'

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';
4837:
4838: main_where_clause:=' 1=:dummy AND se.receipt_id = rh.shipment_header_id(+)'
4839: ||' AND se.po_header_id = ph.po_header_id(+)'