eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_PLAN_RES_DEFAULTS

Line 681: ,PA_PLAN_RES_DEFAULTS cls

677: -- update the default item category
678: UPDATE pa_rbs_plans_in_tmp tmp
679: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
680: FROM PA_RESOURCE_CLASSES_B classes
681: ,PA_PLAN_RES_DEFAULTS cls
682: ,MTL_ITEM_CATEGORIES cat
683: WHERE classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
684: AND cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID
685: AND cls.ITEM_CATEGORY_SET_ID = cat.CATEGORY_SET_ID

Line 1415: ,PA_PLAN_RES_DEFAULTS cls

1411: -- update default item category id if the resource is a inventory item
1412: UPDATE pa_res_list_map_tmp1 tmp
1413: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
1414: FROM PA_RESOURCE_CLASSES_B classes
1415: ,PA_PLAN_RES_DEFAULTS cls
1416: ,MTL_ITEM_CATEGORIES cat
1417: WHERE classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
1418: AND cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID
1419: AND cls.ITEM_CATEGORY_SET_ID = cat.CATEGORY_SET_ID