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 490: ,PA_PLAN_RES_DEFAULTS cls

486: -- update the default item category
487: UPDATE pa_rbs_plans_in_tmp tmp
488: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
489: FROM PA_RESOURCE_CLASSES_B classes
490: ,PA_PLAN_RES_DEFAULTS cls
491: ,MTL_ITEM_CATEGORIES cat
492: WHERE classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
493: AND cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID
494: AND cls.ITEM_CATEGORY_SET_ID = cat.CATEGORY_SET_ID

Line 1203: ,PA_PLAN_RES_DEFAULTS cls

1199: -- update default item category id if the resource is a inventory item
1200: UPDATE pa_res_list_map_tmp1 tmp
1201: SET tmp.item_category_id = ( SELECT cat.CATEGORY_ID
1202: FROM PA_RESOURCE_CLASSES_B classes
1203: ,PA_PLAN_RES_DEFAULTS cls
1204: ,MTL_ITEM_CATEGORIES cat
1205: WHERE classes.RESOURCE_CLASS_CODE = 'MATERIAL_ITEMS'
1206: AND cls.RESOURCE_CLASS_ID = classes.RESOURCE_CLASS_ID
1207: AND cls.ITEM_CATEGORY_SET_ID = cat.CATEGORY_SET_ID