APPS.GMD_OUTBOUND_APIS_PUB dependencies on FM_MATL_DTL

Line 4033: table_list := table_list ||', fm_matl_dtl fmd ';

4029: END IF;
4030:
4031: IF (p_wip_formulaline IS NOT NULL or p_wip_line_type IS NOT NULL)
4032: THEN
4033: table_list := table_list ||', fm_matl_dtl fmd ';
4034: where_clause := where_clause ||'AND gs.formulaline_id = fmd.formulaline_id ';
4035:
4036: IF p_wip_formulaline IS NOT NULL
4037: THEN

Line 4523: --dbms_output.put_line('select from fm_matl_dtl with formulaline_id of '

4519: END IF;
4520:
4521: IF g_samples_table(i).formulaline_id is not NULL
4522: THEN
4523: --dbms_output.put_line('select from fm_matl_dtl with formulaline_id of '
4524: -- || g_samples_table(i).formulaline_id);
4525: select line_no, line_type into g_samples_table(i).formulaline_no,
4526: g_samples_table(i).line_type
4527: from fm_matl_dtl

Line 4527: from fm_matl_dtl

4523: --dbms_output.put_line('select from fm_matl_dtl with formulaline_id of '
4524: -- || g_samples_table(i).formulaline_id);
4525: select line_no, line_type into g_samples_table(i).formulaline_no,
4526: g_samples_table(i).line_type
4527: from fm_matl_dtl
4528: where formulaline_id = g_samples_table(i).formulaline_id;
4529: END IF;
4530:
4531: IF g_samples_table(i).routing_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(+)'