DBA Data[Home] [Help]

APPS.PA_PROJ_STRUCTURE_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1504: ,HZ_CUST_ACCT_SITES_ALL S

1500: ,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
1501: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) Planned_Baseline_Finish -- Added for bug 5090355
1502: FROM pa_proj_elem_ver_structure ppvs
1503: --,ra_addresses_all addr
1504: ,HZ_CUST_ACCT_SITES_ALL S
1505: ,HZ_PARTY_SITES PS
1506: ,HZ_LOCATIONS addr
1507: ,pa_proj_elem_ver_schedule ppvsch
1508: ,per_all_people_f papf

Line 2081: ,HZ_CUST_ACCT_SITES_ALL S

2077: ,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
2078: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) Planned_Baseline_Finish -- Added for bug 5090355
2079: FROM pa_proj_elem_ver_structure ppvs
2080: --,ra_addresses_all addr
2081: ,HZ_CUST_ACCT_SITES_ALL S
2082: ,HZ_PARTY_SITES PS
2083: ,HZ_LOCATIONS addr
2084: ,pa_proj_elem_ver_schedule ppvsch
2085: ,per_all_people_f papf

Line 2903: ,HZ_CUST_ACCT_SITES_ALL S

2899: ,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
2900: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
2901: FROM pa_proj_elem_ver_structure ppvs
2902: --,ra_addresses_all addr
2903: ,HZ_CUST_ACCT_SITES_ALL S
2904: ,HZ_PARTY_SITES PS
2905: ,HZ_LOCATIONS addr
2906: ,pa_proj_elem_ver_schedule ppvsch
2907: ,per_all_people_f papf

Line 3483: ,HZ_CUST_ACCT_SITES_ALL S

3479: ,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
3480: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
3481: FROM pa_proj_elem_ver_structure ppvs
3482: --,ra_addresses_all addr
3483: ,HZ_CUST_ACCT_SITES_ALL S
3484: ,HZ_PARTY_SITES PS
3485: ,HZ_LOCATIONS addr
3486: ,pa_proj_elem_ver_schedule ppvsch
3487: ,per_all_people_f papf

Line 4353: ,HZ_CUST_ACCT_SITES_ALL S

4349: ,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
4350: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
4351: FROM pa_proj_elem_ver_structure ppvs
4352: --,ra_addresses_all addr
4353: ,HZ_CUST_ACCT_SITES_ALL S
4354: ,HZ_PARTY_SITES PS
4355: ,HZ_LOCATIONS addr
4356: ,pa_proj_elem_ver_schedule ppvsch
4357: ,per_all_people_f papf

Line 4928: ,HZ_CUST_ACCT_SITES_ALL S

4924: ,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
4925: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
4926: FROM pa_proj_elem_ver_structure ppvs
4927: --,ra_addresses_all addr
4928: ,HZ_CUST_ACCT_SITES_ALL S
4929: ,HZ_PARTY_SITES PS
4930: ,HZ_LOCATIONS addr
4931: ,pa_proj_elem_ver_schedule ppvsch
4932: ,per_all_people_f papf

Line 5959: ,HZ_CUST_ACCT_SITES_ALL S

5955: ,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
5956: , nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
5957: FROM pa_proj_elem_ver_structure ppvs
5958: --,ra_addresses_all addr
5959: ,HZ_CUST_ACCT_SITES_ALL S
5960: ,HZ_PARTY_SITES PS
5961: ,HZ_LOCATIONS addr
5962: ,pa_proj_elem_ver_schedule ppvsch
5963: ,per_all_people_f papf

Line 6785: ,HZ_CUST_ACCT_SITES_ALL S

6781: ,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
6782: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
6783: FROM pa_proj_elem_ver_structure ppvs
6784: --,ra_addresses_all addr
6785: ,HZ_CUST_ACCT_SITES_ALL S
6786: ,HZ_PARTY_SITES PS
6787: ,HZ_LOCATIONS addr
6788: ,pa_proj_elem_ver_schedule ppvsch
6789: ,per_all_people_f papf

Line 7612: ,HZ_CUST_ACCT_SITES_ALL S

7608: ,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
7609: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
7610: FROM pa_proj_elem_ver_structure ppvs
7611: --,ra_addresses_all addr
7612: ,HZ_CUST_ACCT_SITES_ALL S
7613: ,HZ_PARTY_SITES PS
7614: ,HZ_LOCATIONS addr
7615: ,pa_proj_elem_ver_schedule ppvsch
7616: ,per_all_people_f papf

Line 10383: ,HZ_CUST_ACCT_SITES_ALL S

10379: --+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
10380: ,ppru.PROGRESS_ROLLUP_ID
10381: FROM pa_proj_elem_ver_structure ppvs
10382: --,ra_addresses_all addr
10383: ,HZ_CUST_ACCT_SITES_ALL S
10384: ,HZ_PARTY_SITES PS
10385: ,HZ_LOCATIONS addr
10386: ,pa_proj_elem_ver_schedule ppvsch
10387: ,per_all_people_f papf

Line 11143: ,HZ_CUST_ACCT_SITES_ALL S

11139: --+nvl(ppru.subprj_ppl_act_cost_pc,0)+nvl(ppru.subprj_eqpmt_act_cost_pc,0)), 'WORKING') ETC_Cost
11140: ,ppru.PROGRESS_ROLLUP_ID
11141: FROM pa_proj_elem_ver_structure ppvs
11142: --,ra_addresses_all addr
11143: ,HZ_CUST_ACCT_SITES_ALL S
11144: ,HZ_PARTY_SITES PS
11145: ,HZ_LOCATIONS addr
11146: ,pa_proj_elem_ver_schedule ppvsch
11147: ,per_all_people_f papf