DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_OI dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 378: FROM MTL_DEFAULT_CATEGORY_SETS

374: DECODE(FUNCTIONAL_AREA_ID,12,CATEGORY_SET_ID,0)) udex_catalog
375: ,SUM(
376: DECODE(FUNCTIONAL_AREA_ID,21,CATEGORY_SET_ID,0)) gpc_catalog
377: INTO l_udex_catalog_id , l_gpc_catalog_id
378: FROM MTL_DEFAULT_CATEGORY_SETS
379: WHERE FUNCTIONAL_AREA_ID IN (12,21); --Bug 5517473 added functional area 21
380: EXCEPTION
381: WHEN OTHERS THEN
382: l_udex_catalog_id := NULL;