APPS.GMD_CONC_REPLACE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 482: FROM mtl_system_items_b

478: WHERE recipe_validity_rule_id = V_rcp_vldty_rule_id;
479:
480: CURSOR Cur_check_item (V_form_id NUMBER, V_item_id NUMBER) IS
481: SELECT 1
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

Line 492: from mtl_system_items_b

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
491: select REVISION_QTY_CONTROL_CODE
492: from mtl_system_items_b
493: where inventory_item_id = v_item_id;
494: CURSOR cur_item_ver_access(v_form_id NUMBER, v_item_id NUMBER) IS
495: select 1
496: from mtl_item_revisions

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

565: FUNCTION get_item_no(vItem_id VARCHAR2) Return VARCHAR2 IS
566:
567: CURSOR get_item(vItem_id VARCHAR2) IS
568: SELECT concatenated_segments
569: FROM mtl_system_items_kfv
570: WHERE inventory_item_id = vItem_id;
571:
572: l_item_no VARCHAR2(2000);
573: BEGIN