DBA Data[Home] [Help]

APPS.PA_RESOURCE_MAPPING dependencies on MTL_ITEM_CATEGORIES

Line 1386: MTL_ITEM_CATEGORIES cat

1382: ,tmp1.ITEM_CATEGORY_ID = nvl(tmp1.ITEM_CATEGORY_ID, (SELECT cat.CATEGORY_ID
1383: FROM
1384: PA_RESOURCE_CLASSES_B classes,
1385: PA_PLAN_RES_DEFAULTS cls,
1386: MTL_ITEM_CATEGORIES cat
1387: WHERE
1388: classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS' and
1389: cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID and
1390: cls.ITEM_CATEGORY_SET_ID = cat.CATEGORY_SET_ID and

Line 1405: MTL_ITEM_CATEGORIES cat

1401: SET tmp1.ITEM_CATEGORY_ID = (SELECT cat.CATEGORY_ID
1402: FROM
1403: PA_RESOURCE_CLASSES_B classes,
1404: PA_PLAN_RES_DEFAULTS cls,
1405: MTL_ITEM_CATEGORIES cat
1406: WHERE
1407: classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS' and
1408: cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID and
1409: cls.ITEM_CATEGORY_SET_ID = cat.CATEGORY_SET_ID and