DBA Data[Home] [Help]

APPS.GMDFMVAL_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 2278: FROM fm_matl_dtl d, mtl_system_items_b i

2274: CURSOR cur_check_expr(p_org_id NUMBER) IS
2275: SELECT 1
2276: FROM SYS.DUAL
2277: WHERE EXISTS (SELECT 1
2278: FROM fm_matl_dtl d, mtl_system_items_b i
2279: WHERE recipe_enabled_flag = 'Y'
2280: AND i.ORGANIZATION_ID = p_org_id
2281: AND d.formula_id = V_formula_id
2282: AND i.inventory_item_id = d.inventory_item_id

Line 2364: FROM fm_matl_dtl d, mtl_system_items_b i

2360: CURSOR cur_check_inactive IS
2361: SELECT 1
2362: FROM SYS.DUAL
2363: WHERE EXISTS (SELECT 1
2364: FROM fm_matl_dtl d, mtl_system_items_b i
2365: WHERE d.formula_id = V_formula_id
2366: AND i.inventory_item_id = d.inventory_item_id
2367: AND i.recipe_enabled_flag = 'N'
2368: AND i.organization_id = d.organization_id); -- Bug # 5040915 Kapil M