DBA Data[Home] [Help]

APPS.PA_RESOURCE_MAPPING dependencies on MTL_ITEM_CATEGORIES

Line 1144: MTL_ITEM_CATEGORIES cat

1140: ,tmp1.ITEM_CATEGORY_ID = nvl(tmp1.ITEM_CATEGORY_ID, (SELECT cat.CATEGORY_ID
1141: FROM
1142: PA_RESOURCE_CLASSES_B classes,
1143: PA_PLAN_RES_DEFAULTS cls,
1144: MTL_ITEM_CATEGORIES cat
1145: WHERE
1146: classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS' and
1147: cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID and
1148: cls.ITEM_CATEGORY_SET_ID = cat.CATEGORY_SET_ID and

Line 1163: MTL_ITEM_CATEGORIES cat

1159: SET tmp1.ITEM_CATEGORY_ID = (SELECT cat.CATEGORY_ID
1160: FROM
1161: PA_RESOURCE_CLASSES_B classes,
1162: PA_PLAN_RES_DEFAULTS cls,
1163: MTL_ITEM_CATEGORIES cat
1164: WHERE
1165: classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS' and
1166: cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID and
1167: cls.ITEM_CATEGORY_SET_ID = cat.CATEGORY_SET_ID and