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_PROJ_STRUCTURE_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1503: ,HZ_CUST_ACCT_SITES_ALL S

1499: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
1500: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) Planned_Baseline_Finish -- Added for bug 5090355
1501: FROM pa_proj_elem_ver_structure ppvs
1502: --,ra_addresses_all addr
1503: ,HZ_CUST_ACCT_SITES_ALL S
1504: ,HZ_PARTY_SITES PS
1505: ,HZ_LOCATIONS addr
1506: ,pa_proj_elem_ver_schedule ppvsch
1507: ,per_all_people_f papf

Line 2318: ,HZ_CUST_ACCT_SITES_ALL S

2314: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
2315: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
2316: FROM pa_proj_elem_ver_structure ppvs
2317: --,ra_addresses_all addr
2318: ,HZ_CUST_ACCT_SITES_ALL S
2319: ,HZ_PARTY_SITES PS
2320: ,HZ_LOCATIONS addr
2321: ,pa_proj_elem_ver_schedule ppvsch
2322: ,per_all_people_f papf

Line 3176: ,HZ_CUST_ACCT_SITES_ALL S

3172: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
3173: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
3174: FROM pa_proj_elem_ver_structure ppvs
3175: --,ra_addresses_all addr
3176: ,HZ_CUST_ACCT_SITES_ALL S
3177: ,HZ_PARTY_SITES PS
3178: ,HZ_LOCATIONS addr
3179: ,pa_proj_elem_ver_schedule ppvsch
3180: ,per_all_people_f papf

Line 4147: ,HZ_CUST_ACCT_SITES_ALL S

4143: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
4144: , nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
4145: FROM pa_proj_elem_ver_structure ppvs
4146: --,ra_addresses_all addr
4147: ,HZ_CUST_ACCT_SITES_ALL S
4148: ,HZ_PARTY_SITES PS
4149: ,HZ_LOCATIONS addr
4150: ,pa_proj_elem_ver_schedule ppvsch
4151: ,per_all_people_f papf

Line 4972: ,HZ_CUST_ACCT_SITES_ALL S

4968: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) -(nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
4969: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
4970: FROM pa_proj_elem_ver_structure ppvs
4971: --,ra_addresses_all addr
4972: ,HZ_CUST_ACCT_SITES_ALL S
4973: ,HZ_PARTY_SITES PS
4974: ,HZ_LOCATIONS addr
4975: ,pa_proj_elem_ver_schedule ppvsch
4976: ,per_all_people_f papf

Line 5798: ,HZ_CUST_ACCT_SITES_ALL S

5794: ,nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0) - (nvl(pfxat.base_labor_hours,0)+nvl(pfxat.base_equip_hours,0)) PLANNED_BASELINE_EFFORT_VAR -- Added for bug 5090355
5795: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
5796: FROM pa_proj_elem_ver_structure ppvs
5797: --,ra_addresses_all addr
5798: ,HZ_CUST_ACCT_SITES_ALL S
5799: ,HZ_PARTY_SITES PS
5800: ,HZ_LOCATIONS addr
5801: ,pa_proj_elem_ver_schedule ppvsch
5802: ,per_all_people_f papf

Line 8053: ,HZ_CUST_ACCT_SITES_ALL S

8049: --+nvl(ppru.subprj_ppl_act_cost_pc,0)+nvl(ppru.subprj_eqpmt_act_cost_pc,0)), decode(ppwa.wp_enable_version_flag,'Y','PUBLISH','WORKING')) ETC_Cost
8050: ,ppru.PROGRESS_ROLLUP_ID
8051: FROM pa_proj_elem_ver_structure ppvs
8052: --,ra_addresses_all addr
8053: ,HZ_CUST_ACCT_SITES_ALL S
8054: ,HZ_PARTY_SITES PS
8055: ,HZ_LOCATIONS addr
8056: ,pa_proj_elem_ver_schedule ppvsch
8057: ,per_all_people_f papf

Line 8813: ,HZ_CUST_ACCT_SITES_ALL S

8809: --+nvl(ppru.subprj_ppl_act_cost_pc,0)+nvl(ppru.subprj_eqpmt_act_cost_pc,0)), 'WORKING') ETC_Cost
8810: ,ppru.PROGRESS_ROLLUP_ID
8811: FROM pa_proj_elem_ver_structure ppvs
8812: --,ra_addresses_all addr
8813: ,HZ_CUST_ACCT_SITES_ALL S
8814: ,HZ_PARTY_SITES PS
8815: ,HZ_LOCATIONS addr
8816: ,pa_proj_elem_ver_schedule ppvsch
8817: ,per_all_people_f papf