APPS.GMD_OUTBOUND_APIS_PUB dependencies on FM_FORM_MST

Line 4004: table_list := table_list ||', fm_form_mst ffm ';

4000:
4001: -- BUG 3082684 - incorporate formula_vers
4002: IF p_wip_formula_no IS NOT NULL or p_wip_formula_version IS NOT NULL
4003: THEN
4004: table_list := table_list ||', fm_form_mst ffm ';
4005: where_clause := where_clause ||'AND gs.formula_id = ffm.formula_id ';
4006:
4007: IF p_wip_formula_no IS NOT NULL
4008: THEN

Line 4487: -- dbms_output.put_line('select from fm_form_mst with formula_id of '|| g_samples_table(i).formula_id);

4483: END IF;
4484:
4485: IF g_samples_table(i).formula_id is not NULL
4486: THEN
4487: -- dbms_output.put_line('select from fm_form_mst with formula_id of '|| g_samples_table(i).formula_id);
4488: select formula_no, formula_vers into g_samples_table(i).formula_no,
4489: g_samples_table(i).formula_vers
4490: from fm_form_mst
4491: where formula_id = g_samples_table(i).formula_id;

Line 4490: from fm_form_mst

4486: THEN
4487: -- dbms_output.put_line('select from fm_form_mst with formula_id of '|| g_samples_table(i).formula_id);
4488: select formula_no, formula_vers into g_samples_table(i).formula_no,
4489: g_samples_table(i).formula_vers
4490: from fm_form_mst
4491: where formula_id = g_samples_table(i).formula_id;
4492: END IF;
4493:
4494: IF g_samples_table(i).formulaline_id is not NULL

Line 4834: ||',fm_form_mst_b fh, oe_order_headers_all oh, mtl_system_items_b im'

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