APPS.GMD_OUTBOUND_APIS_PUB dependencies on OE_ORDER_LINES_ALL

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

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

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

4567: END IF;
4568:
4569: IF g_samples_table(i).order_line_id is not NULL
4570: THEN
4571: --dbms_output.put_line('select from oe_order_lines_all with line_id of '
4572: -- || g_samples_table(i).order_line_id);
4573: select line_number into g_samples_table(i).order_line_number
4574: from oe_order_lines_all
4575: where line_id = g_samples_table(i).order_line_id;

Line 4574: from oe_order_lines_all

4570: THEN
4571: --dbms_output.put_line('select from oe_order_lines_all with line_id of '
4572: -- || g_samples_table(i).order_line_id);
4573: select line_number into g_samples_table(i).order_line_number
4574: from oe_order_lines_all
4575: where line_id = g_samples_table(i).order_line_id;
4576: END IF;
4577:
4578: IF g_samples_table(i).org_id is not NULL

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

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