APPS.GMD_CONC_REPLACE_PKG dependencies on MTL_SYSTEM_ITEMS_B

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