APPS.GMD_CONC_REPLACE_PKG dependencies on MTL_SYSTEM_ITEMS_B

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