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_PLAN_MAINT_PVT dependencies on PA_PROJECTS_ALL

Line 241: pa_projects_all ppa,

237: pji_pjp_rbs_header rhd,
238: pa_budget_versions bv,
239: pa_proj_fp_options fpo,
240: pji_pa_proj_events_log pel,
241: pa_projects_all ppa,
242: pa_rbs_versions_b rvb --Added for bug#5728852
243: WHERE 1=1
244: AND ppa.project_id = map.project_id
245: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 304: PA_PROJECTS_ALL ppa,

300: PA_BUDGET_VERSIONS bv,
301: PA_PROJ_FP_OPTIONS fpo,
302: PJI_PA_PROJ_EVENTS_LOG pel,
303: PA_RBS_PRJ_ASSIGNMENTS rpa,
304: PA_PROJECTS_ALL ppa,
305: PA_RBS_VERSIONS_B rvb --Added for bug#5728852
306: WHERE 1=1
307: AND ppa.project_id = map.project_id
308: AND bv.project_id = map.project_id

Line 366: PA_PROJECTS_ALL ppa,

362: PA_BUDGET_VERSIONS bv,
363: PA_PROJ_FP_OPTIONS fpo,
364: PJI_PA_PROJ_EVENTS_LOG pel,
365: PA_RBS_PRJ_ASSIGNMENTS rpa,
366: PA_PROJECTS_ALL ppa,
367: PA_RBS_VERSIONS_B rvb,
368: (
369: SELECT -3 pvi FROM dual UNION ALL
370: SELECT -4 pvi FROM dual

Line 499: , pa_projects_all ppa

495: , 'N'
496: ) lp_flag
497: FROM
498: pji_pjp_proj_batch_map map
499: , pa_projects_all ppa
500: , pa_budget_versions bv
501: , pa_proj_fp_options fpo
502: WHERE 1=1
503: AND ppa.project_id = bv.project_id

Line 583: , pa_projects_all ppa -- @pjdev115 ppa

579: , 'N'
580: ) lp_flag
581: FROM
582: pji_pjp_proj_batch_map map
583: , pa_projects_all ppa -- @pjdev115 ppa
584: , pa_budget_versions bv -- @pjdev115 bv
585: , pa_proj_fp_options fpo -- @pjdev115 fpo
586: , PA_RBS_PRJ_ASSIGNMENTS rpa
587: WHERE 1=1

Line 693: PA_PROJECTS_ALL ppa,

689: , 'N' SECONDARY_RBS_FLAG
690: , 'Y' lp_flag
691: FROM
692: pji_pjp_proj_batch_map map,
693: PA_PROJECTS_ALL ppa,
694: PA_BUDGET_VERSIONS pbv,
695: pji_pjp_wbs_header head,
696: PA_PROJ_ELEM_VER_STRUCTURE ppevs,
697: PA_PROJ_FP_OPTIONS fpo

Line 806: , PA_PROJECTS_ALL ppa

802: , 'N' SECONDARY_RBS_FLAG
803: , 'Y' lp_flag
804: FROM
805: pji_pjp_proj_batch_map map
806: , PA_PROJECTS_ALL ppa
807: , pji_pjp_wbs_header whd
808: , pji_pjp_rbs_header rhd
809: WHERE 1=1
810: AND ppa.project_id = map.project_id

Line 842: , PA_PROJECTS_ALL ppa

838: , 'N' SECONDARY_RBS_FLAG
839: , 'Y' lp_flag
840: FROM
841: pji_pjp_proj_batch_map map
842: , PA_PROJECTS_ALL ppa
843: , pji_pjp_wbs_header whd
844: , pji_pjp_rbs_header rhd
845: WHERE 1=1
846: AND ppa.project_id = map.project_id

Line 1728: , pa_projects_all ppa -- @pjdev115 ppa

1724: ) lp_flag
1725: FROM
1726: pa_budget_versions bv -- @pjdev115 bv
1727: , pa_proj_fp_options fpo -- @pjdev115 fpo
1728: , pa_projects_all ppa -- @pjdev115 ppa
1729: WHERE 1=1
1730: AND ppa.project_id = bv.project_id
1731: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
1732: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 1916: , pa_projects_all ppa -- @pjdev115 ppa

1912: ) lp_flag
1913: FROM
1914: pa_budget_versions bv -- @pjdev115 bv
1915: , pa_proj_fp_options fpo -- @pjdev115 fpo
1916: , pa_projects_all ppa -- @pjdev115 ppa
1917: WHERE 1=1
1918: AND ppa.project_id = bv.project_id
1919: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
1920: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 1993: , pa_projects_all ppa -- @pjdev115 ppa

1989: ) lp_flag
1990: FROM
1991: pa_budget_versions bv -- @pjdev115 bv
1992: , pa_proj_fp_options fpo -- @pjdev115 fpo
1993: , pa_projects_all ppa -- @pjdev115 ppa
1994: , PA_RBS_PRJ_ASSIGNMENTS rpa
1995: WHERE 1=1
1996: AND ppa.project_id = bv.project_id
1997: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 2077: , pa_projects_all ppa -- @pjdev115 ppa

2073: ) lp_flag
2074: FROM
2075: pa_budget_versions bv -- @pjdev115 bv
2076: , pa_proj_fp_options fpo -- @pjdev115 fpo
2077: , pa_projects_all ppa -- @pjdev115 ppa
2078: , pji_pjp_proj_batch_map map
2079: WHERE 1=1
2080: AND ppa.project_id = bv.project_id
2081: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 2231: , pa_projects_all ppa -- @pjdev115 ppa

2227: ) lp_flag
2228: FROM
2229: pa_budget_versions bv -- @pjdev115 bv
2230: , pa_proj_fp_options fpo -- @pjdev115 fpo
2231: , pa_projects_all ppa -- @pjdev115 ppa
2232: , PA_RBS_PRJ_ASSIGNMENTS rpa
2233: , pji_pjp_proj_batch_map map
2234: WHERE ppa.project_id = bv.project_id
2235: AND bv.version_type IS NOT NULL

Line 2288: -- , pa_projects_all ppa -- @pjdev115 ppa

2284: ) lp_flag
2285: FROM
2286: pa_budget_versions bv -- @pjdev115 bv
2287: , pa_proj_fp_options fpo -- @pjdev115 fpo
2288: -- , pa_projects_all ppa -- @pjdev115 ppa
2289: , PA_RBS_PRJ_ASSIGNMENTS rpa
2290: , pji_pjp_proj_batch_map map
2291: , ( SELECT -3 plan_version_id FROM dual
2292: UNION ALL

Line 2351: , pa_projects_all ppa -- @pjdev115 ppa

2347: ) lp_flag
2348: FROM
2349: pa_budget_versions bv -- @pjdev115 bv
2350: , pa_proj_fp_options fpo -- @pjdev115 fpo
2351: , pa_projects_all ppa -- @pjdev115 ppa
2352: , PA_RBS_PRJ_ASSIGNMENTS rpa
2353: , pji_pjp_proj_batch_map map
2354: , pji_pa_proj_events_log ev
2355: WHERE ppa.project_id = bv.project_id

Line 2897: , pa_projects_all ppa -- @pjdev115 ppa

2893: ) lp_flag
2894: FROM
2895: pa_budget_versions bv -- @pjdev115 bv
2896: , pa_proj_fp_options fpo -- @pjdev115 fpo
2897: , pa_projects_all ppa -- @pjdev115 ppa
2898: WHERE 1=1
2899: AND ppa.project_id = bv.project_id
2900: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
2901: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 2976: , pa_projects_all ppa -- @pjdev115 ppa

2972: ) lp_flag
2973: FROM
2974: pa_budget_versions bv -- @pjdev115 bv
2975: , pa_proj_fp_options fpo -- @pjdev115 fpo
2976: , pa_projects_all ppa -- @pjdev115 ppa
2977: WHERE 1=1
2978: AND ppa.project_id = bv.project_id
2979: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
2980: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 3057: , pa_projects_all ppa -- @pjdev115 ppa

3053: ) lp_flag
3054: FROM
3055: pa_budget_versions bv -- @pjdev115 bv
3056: , pa_proj_fp_options fpo -- @pjdev115 fpo
3057: , pa_projects_all ppa -- @pjdev115 ppa
3058: , PA_RBS_PRJ_ASSIGNMENTS rpa
3059: WHERE 1=1
3060: AND ppa.project_id = bv.project_id
3061: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 3514: , pa_projects_all ppa

3510: FROM
3511: PJI_FM_EXTR_PLNVER4 ver
3512: , pa_resource_asSIGNments ra
3513: , PA_BUDGET_LINES bl
3514: , pa_projects_all ppa
3515: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3516: WHERE
3517: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
3518: AND ra.project_id = ver.PROJECT_ID

Line 4098: , PA_PROJECTS_ALL ppa

4094: FROM
4095: PJI_FM_EXTR_PLNVER4 ver
4096: , PA_RESOURCE_ASSIGNMENTS ra
4097: , PA_BUDGET_LINES bl
4098: , PA_PROJECTS_ALL ppa
4099: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4100: WHERE
4101: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
4102: AND (

Line 4170: , PA_PROJECTS_ALL ppa

4166: , ver.time_phased_type_code
4167: FROM
4168: PJI_FM_EXTR_PLNVER4 ver
4169: , PJI_FM_EXTR_PLAN_LINES bl
4170: , PA_PROJECTS_ALL ppa
4171: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4172: WHERE 1=1
4173: AND ver.wp_flag = 'Y'
4174: AND bl.project_id = ver.project_id

Line 4945: , pa_projects_all ppa

4941: ) end_date
4942: FROM pa_budget_lines bl
4943: , pji_time_cal_period_v prd
4944: , PJI_FM_EXTR_PLNVER4 ver
4945: , pa_projects_all ppa
4946: ,PJI_ORG_EXTR_INFO inf
4947: WHERE 1=1
4948: AND bl.budget_version_id = ver.plan_version_id
4949: AND ver.time_phased_type_code IN ('P', 'G')

Line 4984: , pa_projects_all ppa

4980: , TO_DATE(NULL)
4981: ) end_date
4982: FROM pa_resource_assignments ra
4983: , PJI_FM_EXTR_PLNVER4 ver
4984: , pa_projects_all ppa
4985: WHERE 1=1
4986: AND ra.budget_version_id = ver.plan_version_id
4987: AND ver.wp_flag = 'N'
4988: AND ver.baselined_flag = 'Y'

Line 8328: , pa_projects_all ppa

8324: FROM
8325: PJI_FM_EXTR_PLNVER4 ver
8326: , pa_resource_asSIGNments ra
8327: , PA_BUDGET_LINES bl
8328: , pa_projects_all ppa
8329: , PJI_ORG_EXTR_INFO oei
8330: , pji_pjp_rbs_header rhdr
8331: , pji_time_cal_period_v prd
8332: , PJI_FM_AGGR_DLY_RATES rates

Line 8637: , pa_projects_all ppa

8633: FROM
8634: PJI_FM_EXTR_PLNVER4 ver
8635: , pa_resource_asSIGNments ra
8636: , PA_BUDGET_LINES bl
8637: , pa_projects_all ppa
8638: , pji_pjp_rbs_header rhdr
8639: , PJI_FM_AGGR_DLY_RATES rates
8640: , pji_fp_txn_accum_header hdr
8641: , pa_rbs_txn_accum_map map

Line 9492: , pa_projects_all ppa

9488: FROM
9489: PJI_FM_EXTR_PLNVER4 ver
9490: , pa_resource_asSIGNments ra
9491: , PA_BUDGET_LINES bl
9492: , pa_projects_all ppa
9493: , PJI_ORG_EXTR_INFO oei
9494: , pji_time_cal_period_v prd
9495: , PJI_FM_AGGR_DLY_RATES rates
9496: , PA_PROJ_ELEM_VER_STRUCTURE pevs

Line 9783: , pa_projects_all ppa

9779: FROM
9780: PJI_FM_EXTR_PLNVER4 ver
9781: , pa_resource_asSIGNments ra
9782: , PA_BUDGET_LINES bl
9783: , pa_projects_all ppa
9784: , PJI_FM_AGGR_DLY_RATES rates
9785: , PA_PROJ_ELEM_VER_STRUCTURE pevs
9786: WHERE 1=1
9787: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id

Line 10455: , PA_PROJECTS_ALL ppa

10451: FROM
10452: PJI_FM_EXTR_PLNVER4 ver
10453: , PA_RESOURCE_ASSIGNMENTS ra
10454: , PA_BUDGET_LINES bl
10455: , PA_PROJECTS_ALL ppa
10456: , PA_PROJ_ELEM_VER_STRUCTURE pevs
10457: WHERE
10458: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
10459: AND ra.project_id = ver.PROJECT_ID

Line 11032: , PA_PROJECTS_ALL ppa

11028: , ver.time_phased_type_code
11029: FROM
11030: PJI_FM_EXTR_PLNVER4 ver
11031: , PJI_FM_EXTR_PLAN_LINES bl
11032: , PA_PROJECTS_ALL ppa
11033: , PA_PROJ_ELEM_VER_STRUCTURE pevs
11034: WHERE 1=1
11035: AND ver.wp_flag = 'Y'
11036: AND bl.project_id = ver.project_id