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.

[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 400: PA_RBS_PRJ_ASSIGNMENTS rpa,

396: PJI_PJP_RBS_HEADER rhd,
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

Line 462: PA_RBS_PRJ_ASSIGNMENTS rpa,

458: PJI_PJP_RBS_HEADER rhd,
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

Line 683: , PA_RBS_PRJ_ASSIGNMENTS rpa

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
685: AND ppa.project_id = bv.project_id
686: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.
687: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 2342: , PA_RBS_PRJ_ASSIGNMENTS rpa

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.
2346: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 2774: , PA_RBS_PRJ_ASSIGNMENTS rpa

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
2777: AND bv.fin_plan_type_id IS NOT NULL
2778: AND fpo.project_id = bv.project_id

Line 2829: , PA_RBS_PRJ_ASSIGNMENTS rpa

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
2832: AND bv.fin_plan_type_id IS NOT NULL
2833: AND fpo.project_id = bv.project_id

Line 2886: , PA_RBS_PRJ_ASSIGNMENTS rpa

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
2890: WHERE map.project_id = bv.project_id

Line 2943: , PA_RBS_PRJ_ASSIGNMENTS rpa

2939: , 'N'
2940: ) lp_flag
2941: FROM
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

Line 3232: , pa_rbs_prj_assignments rpa

3228: || fpo.revenue_time_phased_code
3229: , 'G') tptc
3230: FROM pji_pjp_proj_batch_map map
3231: , pa_budget_versions bv
3232: , pa_rbs_prj_assignments rpa
3233: , pa_proj_fp_options fpo
3234: WHERE 1=1
3235: AND fpo.project_id (+)= rpa.project_id
3236: AND fpo.rbs_version_id (+)= rpa.rbs_version_id

Line 3352: , PA_RBS_PRJ_ASSIGNMENTS rpa

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
3355: AND bv.fin_plan_type_id IS NOT NULL
3356: AND fpo.project_id = bv.project_id

Line 3409: , PA_RBS_PRJ_ASSIGNMENTS rpa

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
3413: WHERE map.project_id = bv.project_id

Line 3466: , PA_RBS_PRJ_ASSIGNMENTS rpa

3462: , 'N'
3463: ) lp_flag
3464: FROM
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

Line 3755: , pa_rbs_prj_assignments rpa

3751: || fpo.revenue_time_phased_code
3752: , 'G') tptc
3753: FROM pji_pjp_proj_batch_map map
3754: , pa_budget_versions bv
3755: , pa_rbs_prj_assignments rpa
3756: , pa_proj_fp_options fpo
3757: WHERE 1=1
3758: AND fpo.project_id (+)= rpa.project_id
3759: AND fpo.rbs_version_id (+)= rpa.rbs_version_id

Line 4198: , PA_RBS_PRJ_ASSIGNMENTS rpa

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.
4202: AND bv.fin_plan_type_id is not NULL -- Old budgets model data is not picked up with this condition.

Line 8436: PA_RBS_PRJ_ASSIGNMENTS rpa,

8432: , l_last_update_login
8433: , bv.plan_type_code
8434: FROM
8435: PJI_FM_EXTR_PLNVER4 bv,
8436: PA_RBS_PRJ_ASSIGNMENTS rpa,
8437: PJI_PJP_RBS_HEADER head
8438: WHERE bv.project_id = rpa.project_id
8439: AND bv.worker_id = g_worker_id
8440: AND bv.RBS_STRUCT_VERSION_ID = rpa.RBS_VERSION_ID