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 1380: FROM PA_EXPENDITURE_TYPES typ

1376: -- update resource attributes which can be derived but are not present
1377: /* split the below update into two to remove 9i dependencies
1378: UPDATE pa_res_list_map_tmp1 tmp1
1379: SET tmp1.EXPENDITURE_CATEGORY = nvl(tmp1.EXPENDITURE_CATEGORY, (SELECT typ.EXPENDITURE_CATEGORY
1380: FROM PA_EXPENDITURE_TYPES typ
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,

Line 1397: FROM PA_EXPENDITURE_TYPES typ

1393: ) ;
1394: */
1395: UPDATE pa_res_list_map_tmp1 tmp1
1396: SET tmp1.EXPENDITURE_CATEGORY = (SELECT typ.EXPENDITURE_CATEGORY
1397: FROM PA_EXPENDITURE_TYPES typ
1398: WHERE typ.EXPENDITURE_TYPE = tmp1.EXPENDITURE_TYPE )
1399: WHERE tmp1.EXPENDITURE_CATEGORY IS NULL;
1400: UPDATE pa_res_list_map_tmp1 tmp1
1401: SET tmp1.ITEM_CATEGORY_ID = (SELECT cat.CATEGORY_ID

Line 1425: FROM pa_expenditure_types et

1421: AND tmp1.event_type IS NOT NULL;
1422:
1423: UPDATE pa_res_list_map_tmp1 tmp1
1424: SET tmp1.revenue_category = (SELECT et.revenue_category_code
1425: FROM pa_expenditure_types et
1426: WHERE et.expenditure_type=tmp1.expenditure_type)
1427: WHERE tmp1.revenue_category IS NULL
1428: AND tmp1.expenditure_type IS NOT NULL;
1429: