DBA Data[Home] [Help]

APPS.INV_MMX_WRAPPER_PVT dependencies on MTL_CATEGORY_SETS

Line 358: FROM MTL_CATEGORY_SETS

354: IF P_MCAT_STRUCT IS NULL THEN
355: BEGIN
356: SELECT STRUCTURE_ID
357: INTO l_mcat_struct
358: FROM MTL_CATEGORY_SETS
359: WHERE CATEGORY_SET_ID = P_CAT_SET_ID;
360: EXCEPTION
361: WHEN no_data_found THEN
362: IF G_TRACE_ON = 1 THEN

Line 376: FROM MTL_CATEGORY_SETS CSET,

372: ELSE
373: BEGIN
374: SELECT CSET.CATEGORY_SET_ID, CSET.STRUCTURE_ID
375: INTO l_cat_set_id,l_mcat_struct
376: FROM MTL_CATEGORY_SETS CSET,
377: MTL_DEFAULT_CATEGORY_SETS DEF
378: WHERE DEF.CATEGORY_SET_ID = CSET.CATEGORY_SET_ID
379: AND DEF.FUNCTIONAL_AREA_ID = 1;
380: EXCEPTION