eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GMD_CONC_REPLACE_PKG dependencies on FM_FORM_MST

Line 228: l_formula_class FM_FORM_MST_B.formula_class%TYPE;

224: l_action_flag VARCHAR2(1) := 'U';
225: l_status_type GMD_STATUS_B.status_type%TYPE;
226:
227: l_item_no VARCHAR2(2000);
228: l_formula_class FM_FORM_MST_B.formula_class%TYPE;
229: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
230: l_old_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
231: l_owner_id FM_FORM_MST_B.owner_id%TYPE;
232: l_formula_id FM_FORM_MST_B.formula_id%TYPE;

Line 231: l_owner_id FM_FORM_MST_B.owner_id%TYPE;

227: l_item_no VARCHAR2(2000);
228: l_formula_class FM_FORM_MST_B.formula_class%TYPE;
229: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
230: l_old_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
231: l_owner_id FM_FORM_MST_B.owner_id%TYPE;
232: l_formula_id FM_FORM_MST_B.formula_id%TYPE;
233: l_form_id FM_FORM_MST_B.formula_id%TYPE;
234: l_scale_factor NUMBER;
235:

Line 232: l_formula_id FM_FORM_MST_B.formula_id%TYPE;

228: l_formula_class FM_FORM_MST_B.formula_class%TYPE;
229: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
230: l_old_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
231: l_owner_id FM_FORM_MST_B.owner_id%TYPE;
232: l_formula_id FM_FORM_MST_B.formula_id%TYPE;
233: l_form_id FM_FORM_MST_B.formula_id%TYPE;
234: l_scale_factor NUMBER;
235:
236: l_start_date VARCHAR2(32);

Line 233: l_form_id FM_FORM_MST_B.formula_id%TYPE;

229: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
230: l_old_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
231: l_owner_id FM_FORM_MST_B.owner_id%TYPE;
232: l_formula_id FM_FORM_MST_B.formula_id%TYPE;
233: l_form_id FM_FORM_MST_B.formula_id%TYPE;
234: l_scale_factor NUMBER;
235:
236: l_start_date VARCHAR2(32);
237: l_end_date VARCHAR2(32);

Line 333: FROM fm_form_mst_b

329: FROM mtl_system_items_b
330: WHERE inventory_item_id = V_item_id
331: AND recipe_enabled_flag = 'Y'
332: AND organization_id = (SELECT owner_organization_id
333: FROM fm_form_mst_b
334: WHERE formula_id = V_form_id);
335: /* BEGIN Declaration KSHUKLA bug 5198213 */
336: -- Cursor to check if the item revision is enabled
337: CURSOR cur_ITEM_VER_ENABLED(v_item_id NUMBER) IS

Line 346: FROM fm_form_mst_b

342: select 1
343: from mtl_item_revisions
344: where inventory_item_id = v_item_id
345: and organization_id =(SELECT owner_organization_id
346: FROM fm_form_mst_b
347: WHERE formula_id = V_form_id)
348: and REVISION = pNew_Version ;
349: l_item_rev_ctl NUMBER;
350: l_rev_access NUMBER := 0;

Line 372: FROM fm_form_mst_b

368: SELECT substitution_id
369: FROM gmd_item_substitution_hdr_b
370: WHERE original_inventory_item_id = vOriginal_item_id
371: AND owner_organization_id = (SELECT owner_organization_id
372: FROM fm_form_mst_b
373: WHERE formula_id = V_form_id) ;
374:
375: -- Cursor to chk if item is an expr item in formula owning orgn
376: CURSOR Cur_experimental_items(V_form_id NUMBER, V_item_id NUMBER) IS

Line 378: FROM fm_form_mst f, mtl_system_items i

374:
375: -- Cursor to chk if item is an expr item in formula owning orgn
376: CURSOR Cur_experimental_items(V_form_id NUMBER, V_item_id NUMBER) IS
377: SELECT COUNT(i.inventory_item_id)
378: FROM fm_form_mst f, mtl_system_items i
379: WHERE f.formula_id = V_form_id
380: AND i.organization_id = f.owner_organization_id
381: AND i.inventory_item_id = V_item_id
382: AND i.eng_item_flag = 'Y';

Line 612: FROM fm_form_mst_b fm

608: -- Get the action flag to decide on update or insert(version control)
609:
610: SELECT fm.owner_organization_id
611: INTO l_orgn_id
612: FROM fm_form_mst_b fm
613: WHERE fm.formula_id = get_object_rec.object_id;
614:
615: -- Get the Formula version control for the entity orgn.
616: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,

Line 759: FROM fm_form_mst_b

755: RAISE No_Update_Exception;
756: ELSE
757: SELECT formula_vers
758: INTO l_object_version
759: FROM fm_form_mst_b
760: WHERE formula_id = l_formula_id;
761: -- Setup message to indicate that a new version
762: -- has been created
763: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');

Line 787: UPDATE fm_form_mst_b

783: END IF;
784:
785: ELSIF (l_action_flag IN ('U')) THEN
786: IF (get_object_rec.replace_type IN ('FORMULA_CLASS','OWNER_ID')) THEN
787: UPDATE fm_form_mst_b
788: SET formula_class = DECODE(get_object_rec.replace_type,'FORMULA_CLASS'
789: ,get_object_rec.new_name
790: ,formula_class),
791: owner_id = DECODE(get_object_rec.replace_type,'OWNER_ID'

Line 1958: 'FORMULA','FM_FORM_MST_B',

1954: WHERE object_select_ind = 1
1955: AND Concurrent_id IS NULL;
1956:
1957: SELECT DECODE(pObject_type,
1958: 'FORMULA','FM_FORM_MST_B',
1959: 'RECIPE','GMD_RECIPES_B',
1960: 'OPERATION','GMD_OPERATIONS_B',
1961: 'ROUTING','GMD_ROUTINGS_B',
1962: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES'),