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_PURGE_VALIDATE_CAPITAL dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 67: pa_expenditure_items_all ei

63: SELECT 'ADJ NOT TRANSFERRED TO AP'
64: FROM dual
65: WHERE EXISTS (SELECT ei.expenditure_item_id
66: FROM pa_cost_distribution_lines_all cdl,
67: pa_expenditure_items_all ei
68: WHERE ei.expenditure_item_id = cdl.expenditure_item_id
69: AND ((cdl.transfer_status_code in ('P','R','X')
70: and ei.system_linkage_function = 'VI') or
71: (cdl.transfer_status_code in ('P','R','X','T')

Line 89: FROM pa_expenditure_items_all ei,

85: CURSOR IsEiNotCosted IS
86: SELECT 'EI NOT COSTED'
87: FROM dual
88: WHERE EXISTS ( SELECT ei.expenditure_item_id
89: FROM pa_expenditure_items_all ei,
90: pa_tasks pt
91: WHERE ei.system_linkage_function in ( 'VI', 'ER' )
92: AND ei.task_id = pt.task_id
93: AND pt.project_id = p_project_id

Line 105: pa_expenditure_items_all pei,

101: SELECT 'EXP ITEM NOT CAPITALIZED'
102: FROM dual
103: WHERE EXISTS ( SELECT pcdl.expenditure_item_id
104: FROM pa_cost_distribution_lines_all pcdl,
105: pa_expenditure_items_all pei,
106: pa_tasks pt,
107: pa_projects pp,
108: pa_project_types ppt
109: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id