APPS.GMD_OUTBOUND_APIS_PUB dependencies on FM_FORM_MST

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

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

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

4510: END IF;
4511:
4512: IF g_samples_table(i).formula_id is not NULL
4513: THEN
4514: -- dbms_output.put_line('select from fm_form_mst with formula_id of '|| g_samples_table(i).formula_id);
4515: select formula_no, formula_vers into g_samples_table(i).formula_no,
4516: g_samples_table(i).formula_vers
4517: from fm_form_mst
4518: where formula_id = g_samples_table(i).formula_id;

Line 4517: from fm_form_mst

4513: THEN
4514: -- dbms_output.put_line('select from fm_form_mst with formula_id of '|| g_samples_table(i).formula_id);
4515: select formula_no, formula_vers into g_samples_table(i).formula_no,
4516: g_samples_table(i).formula_vers
4517: from fm_form_mst
4518: where formula_id = g_samples_table(i).formula_id;
4519: END IF;
4520:
4521: IF g_samples_table(i).formulaline_id is not NULL

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

4878: ||', se.variant_id, se.archived_taken, se.reserved_taken ';
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(+)'