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

Line 549: ,pa_expenditure_items_all ei

545: ,0 prov_wghtd_hrs_people
546: ,'Y' delete_flag
547: FROM
548: pa_expenditures_all exp
549: ,pa_expenditure_items_all ei
550: ,pa_cost_distribution_lines_all cdl
551: ,gl_periods pglp
552: ,pa_work_types_b wt
553: ,pa_resources_denorm res

Line 659: ,pa_expenditure_items_all ei

655: ,0 prov_wghtd_hrs_people
656: ,'Y' delete_flag
657: FROM
658: pa_expenditures_all exp
659: ,pa_expenditure_items_all ei
660: ,pa_cost_distribution_lines_all cdl
661: ,gl_periods gglp
662: ,pa_work_types_b wt
663: ,pa_resources_denorm res

Line 772: ,pa_expenditure_items_all ei

768: ,gl_periods gglp
769: ,pa_work_types_b wt
770: ,pa_resources_denorm res
771: ,pa_expenditures_all exp
772: ,pa_expenditure_items_all ei
773: ,pa_cost_distribution_lines_all cdl
774: WHERE NVL(cdl.org_id, -99) = NVL(ei.org_id, -99)
775: AND NVL(exp.org_id, -99) = NVL(ei.org_id, -99)
776: -- AND pglp.period_set_name = l_period_set_name

Line 886: ,pa_expenditure_items_all ei

882: ,0 prov_wghtd_hrs_people
883: ,'Y' delete_flag
884: FROM
885: pa_expenditures_all exp
886: ,pa_expenditure_items_all ei
887: ,pa_cost_distribution_lines_all cdl
888: ,gl_periods pglp
889: ,pa_work_types_b wt
890: ,pa_resources_denorm res

Line 1002: ,pa_expenditure_items_all ei

998: FROM
999: pa_work_types_b wt
1000: ,pa_resources_denorm res
1001: ,pa_expenditures_all exp
1002: ,pa_expenditure_items_all ei
1003: ,pa_cost_distribution_lines_all cdl
1004: WHERE NVL(cdl.org_id, -99) = NVL(ei.org_id, -99)
1005: AND NVL(exp.org_id, -99) = NVL(exp.org_id, -99)
1006: AND ei.expenditure_item_date BETWEEN l_ac_start_date AND TRUNC(l_ac_end_date)+0.99999 /* BUG# 3118592 */

Line 1115: ,pa_expenditure_items_all ei

1111: ,gl_periods gglp
1112: ,pa_work_types_b wt
1113: ,pa_resources_denorm res
1114: ,pa_expenditures_all exp
1115: ,pa_expenditure_items_all ei
1116: ,pa_cost_distribution_lines_all cdl
1117: WHERE NVL(cdl.org_id, -99) = NVL(ei.org_id, -99)
1118: AND NVL(exp.org_id, -99) = NVL(ei.org_id, -99)
1119: -- AND pglp.period_set_name = l_period_set_name

Line 1232: ,pa_expenditure_items_all ei

1228: gl_periods gglp
1229: ,pa_work_types_b wt
1230: ,pa_resources_denorm res
1231: ,pa_expenditures_all exp
1232: ,pa_expenditure_items_all ei
1233: ,pa_cost_distribution_lines_all cdl
1234: WHERE NVL(cdl.org_id, -99) = NVL(ei.org_id, -99)
1235: AND NVL(exp.org_id, -99) = NVL(ei.org_id, -99)
1236: -- AND gglp.period_set_name = l_period_set_name