[Home] [Help]
334: pji_pjp_rbs_header rhd,
335: pa_budget_versions bv,
336: pa_proj_fp_options fpo,
337: pji_pa_proj_events_log pel,
338: pa_projects_all ppa,
339: pa_rbs_versions_b rvb --Added for bug#5728852
340: WHERE 1=1
341: AND ppa.project_id = map.project_id
342: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
397: PA_BUDGET_VERSIONS bv,
398: PA_PROJ_FP_OPTIONS fpo,
399: PJI_PA_PROJ_EVENTS_LOG pel,
400: PA_RBS_PRJ_ASSIGNMENTS rpa,
401: PA_PROJECTS_ALL ppa,
402: PA_RBS_VERSIONS_B rvb --Added for bug#5728852
403: WHERE 1=1
404: AND ppa.project_id = map.project_id
405: AND bv.project_id = map.project_id
459: PA_BUDGET_VERSIONS bv,
460: PA_PROJ_FP_OPTIONS fpo,
461: PJI_PA_PROJ_EVENTS_LOG pel,
462: PA_RBS_PRJ_ASSIGNMENTS rpa,
463: PA_PROJECTS_ALL ppa,
464: PA_RBS_VERSIONS_B rvb,
465: (
466: SELECT -3 pvi FROM dual UNION ALL
467: SELECT -4 pvi FROM dual
592: , 'N'
593: ) lp_flag
594: FROM
595: pji_pjp_proj_batch_map map
596: , pa_projects_all ppa
597: , pa_budget_versions bv
598: , pa_proj_fp_options fpo
599: WHERE 1=1
600: AND ppa.project_id = bv.project_id
676: , 'N'
677: ) lp_flag
678: FROM
679: pji_pjp_proj_batch_map map
680: , pa_projects_all ppa -- @pjdev115 ppa
681: , pa_budget_versions bv -- @pjdev115 bv
682: , pa_proj_fp_options fpo -- @pjdev115 fpo
683: , PA_RBS_PRJ_ASSIGNMENTS rpa
684: WHERE 1=1
786: , 'N' SECONDARY_RBS_FLAG
787: , 'Y' lp_flag
788: FROM
789: pji_pjp_proj_batch_map map,
790: PA_PROJECTS_ALL ppa,
791: PA_BUDGET_VERSIONS pbv,
792: pji_pjp_wbs_header head,
793: PA_PROJ_ELEM_VER_STRUCTURE ppevs,
794: PA_PROJ_FP_OPTIONS fpo
899: , 'N' SECONDARY_RBS_FLAG
900: , 'Y' lp_flag
901: FROM
902: pji_pjp_proj_batch_map map
903: , PA_PROJECTS_ALL ppa
904: , pji_pjp_wbs_header whd
905: , pji_pjp_rbs_header rhd
906: WHERE 1=1
907: AND ppa.project_id = map.project_id
935: , 'N' SECONDARY_RBS_FLAG
936: , 'Y' lp_flag
937: FROM
938: pji_pjp_proj_batch_map map
939: , PA_PROJECTS_ALL ppa
940: , pji_pjp_wbs_header whd
941: , pji_pjp_rbs_header rhd
942: WHERE 1=1
943: AND ppa.project_id = map.project_id
1899: ) lp_flag
1900: FROM
1901: pa_budget_versions bv -- @pjdev115 bv
1902: , pa_proj_fp_options fpo -- @pjdev115 fpo
1903: , pa_projects_all ppa -- @pjdev115 ppa
1904: WHERE 1=1
1905: AND ppa.project_id = bv.project_id
1906: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
1907: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.
1949: ) lp_flag
1950: FROM
1951: pa_budget_versions bv -- @pjdev115 bv
1952: , pa_proj_fp_options fpo -- @pjdev115 fpo
1953: , pa_projects_all ppa -- @pjdev115 ppa
1954: WHERE 1=1
1955: AND ppa.project_id = bv.project_id
1956: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
1957: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.
1996: ) lp_flag
1997: FROM
1998: pa_budget_versions bv -- @pjdev115 bv
1999: , pa_proj_fp_options fpo -- @pjdev115 fpo
2000: , pa_projects_all ppa -- @pjdev115 ppa
2001: WHERE 1=1
2002: AND ppa.project_id = bv.project_id
2003: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
2004: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.
2071: ) lp_flag
2072: FROM
2073: pa_budget_versions bv -- @pjdev115 bv
2074: , pa_proj_fp_options fpo -- @pjdev115 fpo
2075: , pa_projects_all ppa -- @pjdev115 ppa
2076: WHERE 1=1
2077: AND ppa.project_id = bv.project_id
2078: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
2079: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.
2260: ) lp_flag
2261: FROM
2262: pa_budget_versions bv -- @pjdev115 bv
2263: , pa_proj_fp_options fpo -- @pjdev115 fpo
2264: , pa_projects_all ppa -- @pjdev115 ppa
2265: WHERE 1=1
2266: AND ppa.project_id = bv.project_id
2267: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
2268: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.
2337: ) lp_flag
2338: FROM
2339: pa_budget_versions bv -- @pjdev115 bv
2340: , pa_proj_fp_options fpo -- @pjdev115 fpo
2341: , pa_projects_all ppa -- @pjdev115 ppa
2342: , PA_RBS_PRJ_ASSIGNMENTS rpa
2343: WHERE 1=1
2344: AND ppa.project_id = bv.project_id
2345: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
2423: ) lp_flag
2424: FROM
2425: pji_pjp_proj_batch_map map
2426: , pa_budget_versions bv -- @pjdev115 bv
2427: , pa_projects_all ppa -- @pjdev115 ppa
2428: , pa_proj_fp_options fpo -- @pjdev115 fpo
2429: WHERE 1=1
2430: AND ppa.project_id = bv.project_id
2431: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
2475: ) lp_flag
2476: FROM
2477: pji_pjp_proj_batch_map map
2478: , pa_budget_versions bv -- @pjdev115 bv
2479: , pa_projects_all ppa -- @pjdev115 ppa
2480: , pa_proj_fp_options fpo -- @pjdev115 fpo
2481: WHERE 1=1
2482: AND ppa.project_id = bv.project_id
2483: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
2610: ) lp_flag
2611: FROM
2612: pji_pjp_proj_batch_map map
2613: , pa_budget_versions bv -- @pjdev115 bv
2614: , pa_projects_all ppa -- @pjdev115 ppa
2615: , pa_proj_fp_options fpo -- @pjdev115 fpo
2616: WHERE 1=1
2617: AND ppa.project_id = bv.project_id
2618: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
2768: ) lp_flag
2769: FROM
2770: pji_pjp_proj_batch_map map
2771: , pa_budget_versions bv
2772: /* Commented for bug 13030627 , pa_projects_all ppa -- @pjdev115 ppa */
2773: , pa_proj_fp_options fpo
2774: , PA_RBS_PRJ_ASSIGNMENTS rpa
2775: WHERE map.project_id = bv.project_id /* Added for bug 13030627 */
2776: AND bv.version_type IS NOT NULL
2823: ) lp_flag
2824: FROM
2825: pji_pjp_proj_batch_map map
2826: , pa_budget_versions bv -- @pjdev115 bv
2827: , pa_projects_all ppa -- @pjdev115 ppa
2828: , pa_proj_fp_options fpo -- @pjdev115 fpo
2829: , PA_RBS_PRJ_ASSIGNMENTS rpa
2830: WHERE ppa.project_id = bv.project_id
2831: AND bv.version_type IS NOT NULL
2881: pji_pjp_proj_batch_map map
2882: , pji_pa_proj_events_log ev
2883: , pa_budget_versions bv -- @pjdev115 bv
2884: , pa_proj_fp_options fpo -- @pjdev115 fpo
2885: -- , pa_projects_all ppa -- @pjdev115 ppa
2886: , PA_RBS_PRJ_ASSIGNMENTS rpa
2887: , ( SELECT -3 plan_version_id FROM dual
2888: UNION ALL
2889: SELECT -4 plan_version_id FROM dual ) cbco
2942: pji_pa_proj_events_log ev
2943: , PA_RBS_PRJ_ASSIGNMENTS rpa
2944: , pa_budget_versions bv -- @pjdev115 bv
2945: , pa_proj_fp_options fpo -- @pjdev115 fpo
2946: , pa_projects_all ppa -- @pjdev115 ppa
2947: , pji_pjp_proj_batch_map map
2948: WHERE l_RBS_ASSOC_exists = 'Y' /* Added for bug 8708651 */
2949: AND ppa.project_id = bv.project_id
2950: AND bv.version_type IS NOT NULL
3346: ) lp_flag
3347: FROM
3348: pji_pjp_proj_batch_map map -- CHANGE_01 Sridhar Carlson 6919766 changed order of the tables
3349: , pa_budget_versions bv -- @pjdev115 bv
3350: , pa_projects_all ppa -- @pjdev115 ppa
3351: , pa_proj_fp_options fpo -- @pjdev115 fpo
3352: , PA_RBS_PRJ_ASSIGNMENTS rpa
3353: WHERE ppa.project_id = bv.project_id
3354: AND bv.version_type IS NOT NULL
3404: FROM
3405: pji_pjp_proj_batch_map map
3406: , pa_budget_versions bv -- @pjdev115 bv
3407: , pa_proj_fp_options fpo -- @pjdev115 fpo
3408: -- , pa_projects_all ppa -- @pjdev115 ppa
3409: , PA_RBS_PRJ_ASSIGNMENTS rpa
3410: , ( SELECT -3 plan_version_id FROM dual
3411: UNION ALL
3412: SELECT -4 plan_version_id FROM dual ) cbco
3465: pji_pa_proj_events_log ev
3466: , PA_RBS_PRJ_ASSIGNMENTS rpa
3467: , pa_budget_versions bv -- @pjdev115 bv
3468: , pa_proj_fp_options fpo -- @pjdev115 fpo
3469: , pa_projects_all ppa -- @pjdev115 ppa
3470: , pji_pjp_proj_batch_map map
3471: WHERE l_RBS_ASSOC_exists = 'Y' /* Added for bug 8708651 */
3472: AND ppa.project_id = bv.project_id
3473: AND bv.version_type IS NOT NULL
4033: ) lp_flag
4034: FROM
4035: pa_budget_versions bv -- @pjdev115 bv
4036: , pa_proj_fp_options fpo -- @pjdev115 fpo
4037: , pa_projects_all ppa -- @pjdev115 ppa
4038: WHERE 1=1
4039: AND ppa.project_id = bv.project_id
4040: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
4041: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.
4112: ) lp_flag
4113: FROM
4114: pa_budget_versions bv -- @pjdev115 bv
4115: , pa_proj_fp_options fpo -- @pjdev115 fpo
4116: , pa_projects_all ppa -- @pjdev115 ppa
4117: WHERE 1=1
4118: AND ppa.project_id = bv.project_id
4119: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
4120: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.
4193: ) lp_flag
4194: FROM
4195: pa_budget_versions bv -- @pjdev115 bv
4196: , pa_proj_fp_options fpo -- @pjdev115 fpo
4197: , pa_projects_all ppa -- @pjdev115 ppa
4198: , PA_RBS_PRJ_ASSIGNMENTS rpa
4199: WHERE 1=1
4200: AND ppa.project_id = bv.project_id
4201: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
4662: FROM
4663: PJI_FM_EXTR_PLNVER4 ver
4664: , pa_resource_asSIGNments ra
4665: , PA_BUDGET_LINES bl
4666: , pa_projects_all ppa
4667: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4668: WHERE
4669: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
4670: AND ra.project_id = ver.PROJECT_ID
5265: FROM
5266: PJI_FM_EXTR_PLNVER4 ver
5267: , PA_RESOURCE_ASSIGNMENTS ra
5268: , PA_BUDGET_LINES bl
5269: , PA_PROJECTS_ALL ppa
5270: , PA_PROJ_ELEM_VER_STRUCTURE pevs
5271: WHERE
5272: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
5273: AND (
5337: , ver.time_phased_type_code
5338: FROM
5339: PJI_FM_EXTR_PLNVER4 ver
5340: , PJI_FM_EXTR_PLAN_LINES bl
5341: , PA_PROJECTS_ALL ppa
5342: , PA_PROJ_ELEM_VER_STRUCTURE pevs
5343: WHERE 1=1
5344: AND ver.wp_flag = 'Y'
5345: AND bl.project_id = ver.project_id
6132: ) end_date
6133: FROM pa_budget_lines bl
6134: , pji_time_cal_period_v prd
6135: , PJI_FM_EXTR_PLNVER4 ver
6136: , pa_projects_all ppa
6137: ,PJI_ORG_EXTR_INFO inf
6138: WHERE 1=1
6139: AND bl.budget_version_id = ver.plan_version_id
6140: AND ver.time_phased_type_code IN ('P', 'G')
6171: , TO_DATE(NULL)
6172: ) end_date
6173: FROM pa_resource_assignments ra
6174: , PJI_FM_EXTR_PLNVER4 ver
6175: , pa_projects_all ppa
6176: WHERE 1=1
6177: AND ra.budget_version_id = ver.plan_version_id
6178: AND ver.wp_flag = 'N'
6179: AND ver.baselined_flag = 'Y'
9607: FROM
9608: PJI_FM_EXTR_PLNVER4 ver
9609: , pa_resource_asSIGNments ra
9610: , PA_BUDGET_LINES bl
9611: , pa_projects_all ppa
9612: , PJI_ORG_EXTR_INFO oei
9613: , pji_pjp_rbs_header rhdr
9614: , pji_time_cal_period_v prd
9615: , PJI_FM_AGGR_DLY_RATES rates
9919: FROM
9920: PJI_FM_EXTR_PLNVER4 ver
9921: , pa_resource_asSIGNments ra
9922: , PA_BUDGET_LINES bl
9923: , pa_projects_all ppa
9924: , pji_pjp_rbs_header rhdr
9925: , PJI_FM_AGGR_DLY_RATES rates
9926: , pji_fp_txn_accum_header hdr
9927: , pa_rbs_txn_accum_map map
10796: FROM
10797: PJI_FM_EXTR_PLNVER4 ver
10798: , pa_resource_asSIGNments ra
10799: , PA_BUDGET_LINES bl
10800: , pa_projects_all ppa
10801: , PJI_ORG_EXTR_INFO oei
10802: , pji_time_cal_period_v prd
10803: , PJI_FM_AGGR_DLY_RATES rates
10804: , PA_PROJ_ELEM_VER_STRUCTURE pevs
11090: FROM
11091: PJI_FM_EXTR_PLNVER4 ver
11092: , pa_resource_asSIGNments ra
11093: , PA_BUDGET_LINES bl
11094: , pa_projects_all ppa
11095: , PJI_FM_AGGR_DLY_RATES rates
11096: , PA_PROJ_ELEM_VER_STRUCTURE pevs
11097: WHERE 1=1
11098: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
11783: FROM
11784: PJI_FM_EXTR_PLNVER4 ver
11785: , PA_RESOURCE_ASSIGNMENTS ra
11786: , PA_BUDGET_LINES bl
11787: , PA_PROJECTS_ALL ppa
11788: , PA_PROJ_ELEM_VER_STRUCTURE pevs
11789: WHERE
11790: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
11791: AND ra.project_id = ver.PROJECT_ID
12382: , ver.time_phased_type_code
12383: FROM
12384: PJI_FM_EXTR_PLNVER4 ver
12385: , PJI_FM_EXTR_PLAN_LINES bl
12386: , PA_PROJECTS_ALL ppa
12387: , PA_PROJ_ELEM_VER_STRUCTURE pevs
12388: WHERE 1=1
12389: AND ver.wp_flag = 'Y'
12390: AND bl.project_id = ver.project_id