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_RESOURCE_MAPPING dependencies on PA_EXPENDITURE_TYPES

Line 1138: FROM PA_EXPENDITURE_TYPES typ

1134: -- update resource attributes which can be derived but are not present
1135: /* split the below update into two to remove 9i dependencies
1136: UPDATE pa_res_list_map_tmp1 tmp1
1137: SET tmp1.EXPENDITURE_CATEGORY = nvl(tmp1.EXPENDITURE_CATEGORY, (SELECT typ.EXPENDITURE_CATEGORY
1138: FROM PA_EXPENDITURE_TYPES typ
1139: WHERE typ.EXPENDITURE_TYPE = tmp1.EXPENDITURE_TYPE ) )
1140: ,tmp1.ITEM_CATEGORY_ID = nvl(tmp1.ITEM_CATEGORY_ID, (SELECT cat.CATEGORY_ID
1141: FROM
1142: PA_RESOURCE_CLASSES_B classes,

Line 1155: FROM PA_EXPENDITURE_TYPES typ

1151: ) ;
1152: */
1153: UPDATE pa_res_list_map_tmp1 tmp1
1154: SET tmp1.EXPENDITURE_CATEGORY = (SELECT typ.EXPENDITURE_CATEGORY
1155: FROM PA_EXPENDITURE_TYPES typ
1156: WHERE typ.EXPENDITURE_TYPE = tmp1.EXPENDITURE_TYPE )
1157: WHERE tmp1.EXPENDITURE_CATEGORY IS NULL;
1158: UPDATE pa_res_list_map_tmp1 tmp1
1159: SET tmp1.ITEM_CATEGORY_ID = (SELECT cat.CATEGORY_ID

Line 1183: FROM pa_expenditure_types et

1179: AND tmp1.event_type IS NOT NULL;
1180:
1181: UPDATE pa_res_list_map_tmp1 tmp1
1182: SET tmp1.revenue_category = (SELECT et.revenue_category_code
1183: FROM pa_expenditure_types et
1184: WHERE et.expenditure_type=tmp1.expenditure_type)
1185: WHERE tmp1.revenue_category IS NULL
1186: AND tmp1.expenditure_type IS NOT NULL;
1187: