DBA Data[Home] [Help]

APPS.PA_RESOURCE_MAPPING dependencies on PA_PLAN_RES_DEFAULTS

Line 1385: PA_PLAN_RES_DEFAULTS cls,

1381: WHERE typ.EXPENDITURE_TYPE = tmp1.EXPENDITURE_TYPE ) )
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

Line 1404: PA_PLAN_RES_DEFAULTS cls,

1400: UPDATE pa_res_list_map_tmp1 tmp1
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