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.

APPS.GMD_CONC_REPLACE_PKG dependencies on FM_FORM_MST

Line 363: l_formula_class FM_FORM_MST_B.formula_class%TYPE;

359: l_action_flag VARCHAR2(1) := 'U';
360: l_status_type GMD_STATUS_B.status_type%TYPE;
361:
362: l_item_no VARCHAR2(2000);
363: l_formula_class FM_FORM_MST_B.formula_class%TYPE;
364: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
365: l_old_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
366: l_owner_id FM_FORM_MST_B.owner_id%TYPE;
367: l_formula_id FM_FORM_MST_B.formula_id%TYPE;

Line 366: l_owner_id FM_FORM_MST_B.owner_id%TYPE;

362: l_item_no VARCHAR2(2000);
363: l_formula_class FM_FORM_MST_B.formula_class%TYPE;
364: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
365: l_old_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
366: l_owner_id FM_FORM_MST_B.owner_id%TYPE;
367: l_formula_id FM_FORM_MST_B.formula_id%TYPE;
368: l_form_id FM_FORM_MST_B.formula_id%TYPE;
369: l_scale_factor NUMBER;
370:

Line 367: l_formula_id FM_FORM_MST_B.formula_id%TYPE;

363: l_formula_class FM_FORM_MST_B.formula_class%TYPE;
364: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
365: l_old_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
366: l_owner_id FM_FORM_MST_B.owner_id%TYPE;
367: l_formula_id FM_FORM_MST_B.formula_id%TYPE;
368: l_form_id FM_FORM_MST_B.formula_id%TYPE;
369: l_scale_factor NUMBER;
370:
371: l_start_date VARCHAR2(32);

Line 368: l_form_id FM_FORM_MST_B.formula_id%TYPE;

364: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
365: l_old_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
366: l_owner_id FM_FORM_MST_B.owner_id%TYPE;
367: l_formula_id FM_FORM_MST_B.formula_id%TYPE;
368: l_form_id FM_FORM_MST_B.formula_id%TYPE;
369: l_scale_factor NUMBER;
370:
371: l_start_date VARCHAR2(32);
372: l_end_date VARCHAR2(32);

Line 486: FROM fm_form_mst_b

482: FROM mtl_system_items_b
483: WHERE inventory_item_id = V_item_id
484: AND recipe_enabled_flag = 'Y'
485: AND organization_id = (SELECT owner_organization_id
486: FROM fm_form_mst_b
487: WHERE formula_id = V_form_id);
488: /* BEGIN Declaration KSHUKLA bug 5198213 */
489: -- Cursor to check if the item revision is enabled
490: CURSOR cur_ITEM_VER_ENABLED(v_item_id NUMBER) IS

Line 499: FROM fm_form_mst_b

495: select 1
496: from mtl_item_revisions
497: where inventory_item_id = v_item_id
498: and organization_id =(SELECT owner_organization_id
499: FROM fm_form_mst_b
500: WHERE formula_id = V_form_id)
501: and REVISION = pNew_Version ;
502: l_item_rev_ctl NUMBER;
503: l_rev_access NUMBER := 0;

Line 525: FROM fm_form_mst_b

521: SELECT substitution_id
522: FROM gmd_item_substitution_hdr_b
523: WHERE original_inventory_item_id = vOriginal_item_id
524: AND owner_organization_id = (SELECT owner_organization_id
525: FROM fm_form_mst_b
526: WHERE formula_id = V_form_id) ;
527:
528: -- Cursor to chk if item is an expr item in formula owning orgn
529: CURSOR Cur_experimental_items(V_form_id NUMBER, V_item_id NUMBER) IS

Line 531: FROM fm_form_mst f, mtl_system_items i

527:
528: -- Cursor to chk if item is an expr item in formula owning orgn
529: CURSOR Cur_experimental_items(V_form_id NUMBER, V_item_id NUMBER) IS
530: SELECT COUNT(i.inventory_item_id)
531: FROM fm_form_mst f, mtl_system_items i
532: WHERE f.formula_id = V_form_id
533: AND i.organization_id = f.owner_organization_id
534: AND i.inventory_item_id = V_item_id
535: AND i.eng_item_flag = 'Y';

Line 765: FROM fm_form_mst_b fm

761: -- Get the action flag to decide on update or insert(version control)
762:
763: SELECT fm.owner_organization_id
764: INTO l_orgn_id
765: FROM fm_form_mst_b fm
766: WHERE fm.formula_id = get_object_rec.object_id;
767:
768: -- Get the Formula version control for the entity orgn.
769: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,

Line 912: FROM fm_form_mst_b

908: RAISE No_Update_Exception;
909: ELSE
910: SELECT formula_vers
911: INTO l_object_version
912: FROM fm_form_mst_b
913: WHERE formula_id = l_formula_id;
914: -- Setup message to indicate that a new version
915: -- has been created
916: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_NEW_OBJECT_VERSION');

Line 940: UPDATE fm_form_mst_b

936: END IF;
937:
938: ELSIF (l_action_flag IN ('U')) THEN
939: IF (get_object_rec.replace_type IN ('FORMULA_CLASS','OWNER_ID')) THEN
940: UPDATE fm_form_mst_b
941: SET formula_class = DECODE(get_object_rec.replace_type,'FORMULA_CLASS'
942: ,get_object_rec.new_name
943: ,formula_class),
944: owner_id = DECODE(get_object_rec.replace_type,'OWNER_ID'

Line 2144: 'FORMULA','FM_FORM_MST_B',

2140: WHERE object_select_ind = 1
2141: AND Concurrent_id IS NULL;
2142:
2143: SELECT DECODE(pObject_type,
2144: 'FORMULA','FM_FORM_MST_B',
2145: 'RECIPE','GMD_RECIPES_B',
2146: 'OPERATION','GMD_OPERATIONS_B',
2147: 'ROUTING','GMD_ROUTINGS_B',
2148: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES'),