APPS.GMD_OUTBOUND_APIS_PUB dependencies on FM_MATL_DTL

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

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

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

4492: END IF;
4493:
4494: IF g_samples_table(i).formulaline_id is not NULL
4495: THEN
4496: --dbms_output.put_line('select from fm_matl_dtl with formulaline_id of '
4497: -- || g_samples_table(i).formulaline_id);
4498: select line_no, line_type into g_samples_table(i).formulaline_no,
4499: g_samples_table(i).line_type
4500: from fm_matl_dtl

Line 4500: from fm_matl_dtl

4496: --dbms_output.put_line('select from fm_matl_dtl with formulaline_id of '
4497: -- || g_samples_table(i).formulaline_id);
4498: select line_no, line_type into g_samples_table(i).formulaline_no,
4499: g_samples_table(i).line_type
4500: from fm_matl_dtl
4501: where formulaline_id = g_samples_table(i).formulaline_id;
4502: END IF;
4503:
4504: IF g_samples_table(i).routing_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(+)'