APPS.GMD_CONC_REPLACE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 329: FROM mtl_system_items_b

325: WHERE recipe_validity_rule_id = V_rcp_vldty_rule_id;
326:
327: CURSOR Cur_check_item (V_form_id NUMBER, V_item_id NUMBER) IS
328: SELECT 1
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

Line 339: from mtl_system_items_b

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
338: select REVISION_QTY_CONTROL_CODE
339: from mtl_system_items_b
340: where inventory_item_id = v_item_id;
341: CURSOR cur_item_ver_access(v_form_id NUMBER, v_item_id NUMBER) IS
342: select 1
343: from mtl_item_revisions

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 416: FROM mtl_system_items_kfv

412: FUNCTION get_item_no(vItem_id VARCHAR2) Return VARCHAR2 IS
413:
414: CURSOR get_item(vItem_id VARCHAR2) IS
415: SELECT concatenated_segments
416: FROM mtl_system_items_kfv
417: WHERE inventory_item_id = vItem_id;
418:
419: l_item_no VARCHAR2(2000);
420: BEGIN