DBA Data[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on MTL_CATEGORIES_VL

Line 2093: FROM MTL_CATEGORIES_VL

2089: oe_debug_pub.add('Blanket In validate CAT');
2090: end if;
2091: SELECT 'VALID'
2092: INTO l_dummy
2093: FROM MTL_CATEGORIES_VL
2094: WHERE CATEGORY_ID = p_inventory_item_id
2095: AND ENABLED_FLAG = 'Y';
2096:
2097: ELSE

Line 2159: FROM MTL_CATEGORIES_VL

2155: --bug5220335 moved the query under BEGIN-EXCEPTION-END
2156: BEGIN
2157: SELECT 'VALID'
2158: INTO l_dummy
2159: FROM MTL_CATEGORIES_VL
2160: WHERE CATEGORY_ID = p_inventory_item_id
2161: AND ENABLED_FLAG = 'Y';
2162: EXCEPTION
2163: WHEN OTHERS THEN