DBA Data[Home] [Help]

APPS.GMDFMVAL_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 2117: mtl_system_items_b i

2113: SELECT 1
2114: FROM SYS.DUAL
2115: WHERE EXISTS (SELECT 1
2116: FROM fm_matl_dtl d,
2117: mtl_system_items_b i
2118: WHERE recipe_enabled_flag ='Y'
2119: AND i.ORGANIZATION_ID = p_org_id
2120: AND d.formula_id = V_formula_id
2121: AND i.inventory_item_id = d.inventory_item_id

Line 2201: mtl_system_items_b i

2197: CURSOR cur_check_inactive IS
2198: SELECT 1
2199: FROM SYS.DUAL
2200: WHERE EXISTS (SELECT 1 FROM fm_matl_dtl d,
2201: mtl_system_items_b i
2202: WHERE d.formula_id = V_formula_id
2203: AND i.inventory_item_id = d.inventory_item_id
2204: AND i.recipe_enabled_flag = 'N'
2205: AND i.organization_id = d.organization_id); -- Bug # 5040915 Kapil M