DBA Data[Home] [Help]

APPS.INV_MMX_WRAPPER_PVT dependencies on MTL_CATEGORY_SETS

Line 362: FROM MTL_CATEGORY_SETS

358: IF P_MCAT_STRUCT IS NULL THEN
359: BEGIN
360: SELECT STRUCTURE_ID
361: INTO l_mcat_struct
362: FROM MTL_CATEGORY_SETS
363: WHERE CATEGORY_SET_ID = P_CAT_SET_ID;
364: EXCEPTION
365: WHEN no_data_found THEN
366: IF G_TRACE_ON = 1 THEN

Line 380: FROM MTL_CATEGORY_SETS CSET,

376: ELSE
377: BEGIN
378: SELECT CSET.CATEGORY_SET_ID, CSET.STRUCTURE_ID
379: INTO l_cat_set_id,l_mcat_struct
380: FROM MTL_CATEGORY_SETS CSET,
381: MTL_DEFAULT_CATEGORY_SETS DEF
382: WHERE DEF.CATEGORY_SET_ID = CSET.CATEGORY_SET_ID
383: AND DEF.FUNCTIONAL_AREA_ID = 1;
384: EXCEPTION