DBA Data[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on MTL_CATEGORIES_VL

Line 2235: FROM MTL_CATEGORIES_VL

2231: oe_debug_pub.add('Blanket In validate CAT');
2232: end if;
2233: SELECT 'VALID'
2234: INTO l_dummy
2235: FROM MTL_CATEGORIES_VL
2236: WHERE CATEGORY_ID = p_inventory_item_id
2237: AND ENABLED_FLAG = 'Y';
2238:
2239: ELSE

Line 2301: FROM MTL_CATEGORIES_VL

2297: --bug5220335 moved the query under BEGIN-EXCEPTION-END
2298: BEGIN
2299: SELECT 'VALID'
2300: INTO l_dummy
2301: FROM MTL_CATEGORIES_VL
2302: WHERE CATEGORY_ID = p_inventory_item_id
2303: AND ENABLED_FLAG = 'Y';
2304: EXCEPTION
2305: WHEN OTHERS THEN