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.PJI_FM_EXTR dependencies on PA_EXPENDITURE_TYPES

Line 1282: , pa_expenditure_types et

1278: And drev.pa_date is not null
1279: ) CnR
1280: , pa_expenditure_items_all ei
1281: , pa_expenditures_all exp
1282: , pa_expenditure_types et
1283: WHERE 1 = 1
1284: And CnR.expenditure_item_id = ei.expenditure_item_id
1285: And exp.expenditure_id = ei.expenditure_id
1286: And ei.expenditure_type = et.expenditure_type

Line 2179: , pa_expenditure_types et

2175: PJI_FM_REXT_CDL scope
2176: , pa_cost_distribution_lines_all cdl
2177: , pa_expenditure_items_all ei
2178: , pa_expenditures_all exp
2179: , pa_expenditure_types et
2180: WHERE
2181: scope.worker_id = p_worker_id
2182: and scope.cdl_rowid = cdl.rowid
2183: and cdl.expenditure_item_id = ei.expenditure_item_id

Line 2281: , pa_expenditure_types et

2277: PJI_FM_REXT_CRDL scope
2278: , pa_cust_rev_dist_lines_all crdl
2279: , pa_expenditure_items_all ei
2280: , pa_expenditures_all exp
2281: , pa_expenditure_types et
2282: WHERE
2283: scope.worker_id = p_worker_id
2284: and scope.crdl_rowid = crdl.rowid
2285: and crdl.function_code NOT IN ('LRL','LRB','URL','URB')