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 PJI_PJP_PROJ_BATCH_MAP

Line 333: pji_pjp_proj_batch_map map,

329: , 'N')
330: , 'N'
331: ) lp_flag
332: FROM
333: pji_pjp_proj_batch_map map,
334: pji_pjp_rbs_header rhd,
335: pa_budget_versions bv,
336: pa_proj_fp_options fpo,
337: pji_pa_proj_events_log pel,

Line 395: PJI_PJP_PROJ_BATCH_MAP map,

391: , 'N')
392: , 'N'
393: ) lp_flag
394: FROM
395: PJI_PJP_PROJ_BATCH_MAP map,
396: PJI_PJP_RBS_HEADER rhd,
397: PA_BUDGET_VERSIONS bv,
398: PA_PROJ_FP_OPTIONS fpo,
399: PJI_PA_PROJ_EVENTS_LOG pel,

Line 457: PJI_PJP_PROJ_BATCH_MAP map,

453: , DECODE(pln_ver.pvi, -3, 'Y', -4, 'N') baselined_flag
454: , 'N' SECONDARY_RBS_FLAG
455: , 'Y' lp_flag
456: FROM
457: PJI_PJP_PROJ_BATCH_MAP map,
458: PJI_PJP_RBS_HEADER rhd,
459: PA_BUDGET_VERSIONS bv,
460: PA_PROJ_FP_OPTIONS fpo,
461: PJI_PA_PROJ_EVENTS_LOG pel,

Line 595: pji_pjp_proj_batch_map map

591: , 'N')
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

Line 679: pji_pjp_proj_batch_map map

675: , 'N')
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

Line 789: pji_pjp_proj_batch_map map,

785: , DECODE(Pbv.baselined_date, NULL, 'N', 'Y') baselined_flag
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,

Line 902: pji_pjp_proj_batch_map map

898: , DECODE(whd.plan_version_id, -3, 'Y', -4, 'N') baselined_flag
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

Line 938: pji_pjp_proj_batch_map map

934: , NULL baselined_flag
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

Line 1067: FROM pji_pjp_proj_batch_map map

1063: INTO l_pl_exists
1064: FROM pji_fm_extr_plan_lines epl
1065: WHERE EXISTS (
1066: SELECT 1
1067: FROM pji_pjp_proj_batch_map map
1068: WHERE map.worker_id = g_worker_id
1069: AND epl.project_id = map.project_id
1070: )
1071: AND ROWNUM <= 1;

Line 1093: PJI_PJP_PROJ_BATCH_MAP map,

1089: 'Y'
1090: into
1091: l_dangl_exists
1092: from
1093: PJI_PJP_PROJ_BATCH_MAP map,
1094: PA_BUDGET_VERSIONS bv
1095: where
1096: map.WORKER_ID = g_worker_id and
1097: bv.PROJECT_ID = map.PROJECT_ID and

Line 1269: , pji_pjp_proj_batch_map map

1265: FROM pji_pjp_wbs_header hd
1266: WHERE (project_id, plan_version_id, plan_type_id) IN
1267: ( SELECT hd1.project_id, plan_version_id, plan_type_id
1268: FROM pji_pjp_wbs_header hd1
1269: , pji_pjp_proj_batch_map map
1270: WHERE hd1.project_id = map.project_id
1271: AND map.worker_id = g_worker_id
1272: AND (hd1.plan_version_id > 0 OR hd1.plan_version_id IN (-3, -4))
1273: )

Line 1314: FROM pji_pjp_proj_batch_map map

1310: INSERT INTO pji_fm_extr_plnver3_t
1311: (project_id, plan_version_id, plan_type_id)
1312: SELECT / * + ORDERED * / -- INDEX(HD9, PJI_PJP_WBS_HEADER_N1)
1313: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1314: FROM pji_pjp_proj_batch_map map
1315: , pji_fm_extr_plan_lines epl
1316: , pji_pjp_wbs_header hd2 -- SUB
1317: , pji_xbs_denorm den
1318: , pji_pjp_wbs_header hd9 -- SUP

Line 1353: FROM pji_pjp_proj_batch_map map

1349: INSERT INTO pji_fm_extr_plnver3_t
1350: (project_id, plan_version_id, plan_type_id)
1351: SELECT /*+ ORDERED */
1352: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1353: FROM pji_pjp_proj_batch_map map
1354: , pji_pjp_wbs_header hd1 -- SUB
1355: , pji_xbs_denorm den
1356: , pji_pjp_wbs_header hd9 -- SUP
1357: WHERE

Line 1380: FROM pji_pjp_proj_batch_map map

1376: INSERT INTO pji_fm_extr_plnver3_t
1377: (project_id, plan_version_id, plan_type_id)
1378: SELECT
1379: DISTINCT bv.project_id, bv.budget_version_id, bv.fin_plan_type_id
1380: FROM pji_pjp_proj_batch_map map
1381: , PA_BUDGET_VERSIONS bv
1382: WHERE
1383: map.worker_id = g_worker_id
1384: AND bv.project_id = map.project_id

Line 1428: pji_pjp_proj_batch_map map

1424: (project_id, plan_version_id, plan_type_id)
1425: SELECT /*+ ordered */
1426: DISTINCT hd2.project_id, hd2.plan_version_id, hd2.plan_type_id
1427: FROM
1428: pji_pjp_proj_batch_map map
1429: , pji_pa_proj_events_log ev
1430: , pji_pjp_wbs_header hd9 -- SUP
1431: , pji_xbs_denorm den
1432: , pji_pjp_wbs_header hd2 -- SUB

Line 1460: FROM pji_pjp_proj_batch_map map

1456: INSERT INTO pji_fm_extr_plnver3_t
1457: (project_id, plan_version_id, plan_type_id)
1458: SELECT /*+ LEADING(MAP) */ /* leading hint added for bug 9337307 */
1459: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1460: FROM pji_pjp_proj_batch_map map
1461: , pji_pa_proj_events_log ev
1462: , pji_pjp_wbs_header hd9 -- SUP
1463: WHERE
1464: map.worker_id = g_worker_id

Line 1490: , pji_pjp_proj_batch_map map

1486: (project_id, plan_version_id, plan_type_id)
1487: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1488: FROM pji_xbs_denorm den
1489: , pji_pjp_wbs_header hd1 -- SUB
1490: , pji_pjp_proj_batch_map map
1491: , pji_pa_proj_events_log ev
1492: , pji_pjp_wbs_header hd9 -- SUP
1493: WHERE
1494: den.struct_version_id IS NULL

Line 1527: FROM pji_pjp_proj_batch_map map

1523: INSERT INTO pji_fm_extr_plnver3_t
1524: (project_id, plan_version_id, plan_type_id)
1525: SELECT /*+ ordered */
1526: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1527: FROM pji_pjp_proj_batch_map map
1528: , pji_pa_proj_events_log ev
1529: -- , PA_BUDGET_VERSIONS bv
1530: , pji_xbs_denorm den
1531: , pji_pjp_wbs_header wh1 -- sup

Line 1564: , pji_pjp_proj_batch_map map

1560: (project_id, plan_version_id, plan_type_id)
1561: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1562: FROM pji_xbs_denorm den
1563: , pji_pjp_wbs_header hd2 -- SUB
1564: , pji_pjp_proj_batch_map map
1565: , pji_pa_proj_events_log ev
1566: , pji_pjp_wbs_header hd9 -- SUP
1567: WHERE
1568: den.struct_version_id IS NULL

Line 1593: FROM pji_pjp_proj_batch_map map

1589:
1590: INSERT INTO pji_fm_extr_plnver3_t
1591: (project_id, plan_version_id, plan_type_id)
1592: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1593: FROM pji_pjp_proj_batch_map map
1594: , PA_BUDGET_VERSIONS bv
1595: , pji_pjp_wbs_header hd9 -- SUP
1596: WHERE
1597: map.worker_id = g_worker_id

Line 1618: , pji_pjp_proj_batch_map map

1614: (project_id, plan_version_id, plan_type_id)
1615: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1616: FROM pji_xbs_denorm den
1617: , pji_pjp_wbs_header hd1 -- SUB
1618: , pji_pjp_proj_batch_map map
1619: , pa_budget_versions bv
1620: , pji_pjp_wbs_header hd9 -- SUP
1621: WHERE
1622: den.struct_version_id IS NULL

Line 1683: PJI_PJP_PROJ_BATCH_MAP map

1679: (
1680: select
1681: 1
1682: from
1683: PJI_PJP_PROJ_BATCH_MAP map
1684: where
1685: map.WORKER_ID = g_worker_id and
1686: hd9.PROJECT_ID = map.PROJECT_ID
1687: );

Line 2425: pji_pjp_proj_batch_map map

2421: , 'N')
2422: , 'N'
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

Line 2477: pji_pjp_proj_batch_map map

2473: , 'N')
2474: , 'N'
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

Line 2533: pji_pjp_proj_batch_map map

2529: , 'N')
2530: , 'N'
2531: ) lp_flag
2532: FROM
2533: pji_pjp_proj_batch_map map
2534: , pa_budget_versions bv
2535: , pa_proj_fp_options fpo
2536: , ( SELECT -3 plan_version_id FROM dual
2537: UNION ALL

Line 2612: pji_pjp_proj_batch_map map

2608: , 'N')
2609: , 'N'
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

Line 2667: pji_pjp_proj_batch_map map

2663: , 'N')
2664: , 'N'
2665: ) lp_flag
2666: FROM
2667: pji_pjp_proj_batch_map map
2668: , pa_budget_versions bv
2669: , pa_proj_fp_options fpo
2670: , ( SELECT -3 plan_version_id FROM dual
2671: UNION ALL

Line 2770: pji_pjp_proj_batch_map map

2766: , 'N')
2767: , 'N'
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

Line 2825: pji_pjp_proj_batch_map map

2821: , 'N')
2822: , 'N'
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

Line 2881: pji_pjp_proj_batch_map map

2877: , 'N')
2878: , 'N'
2879: ) lp_flag
2880: FROM
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

Line 2947: , pji_pjp_proj_batch_map map

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
2951: AND bv.fin_plan_type_id IS NOT NULL

Line 3230: FROM pji_pjp_proj_batch_map map

3226: , NVL( fpo.all_time_phased_code
3227: || fpo.cost_time_phased_code
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

Line 3243: , pji_pjp_proj_batch_map map

3239: AND bv.budget_status_code = 'B' -- Don't care if dangling plan.
3240: AND map.worker_id = g_worker_id
3241: AND map.project_id = bv.project_id
3242: ) fpo
3243: , pji_pjp_proj_batch_map map
3244: , pji_pjp_wbs_header whsub
3245: , pa_xbs_denorm den
3246: , ( SELECT -3 plan_version_id FROM dual
3247: UNION ALL

Line 3348: pji_pjp_proj_batch_map map -- CHANGE_01 Sridhar Carlson 6919766 changed order of the tables

3344: , 'N')
3345: , 'N'
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

Line 3405: pji_pjp_proj_batch_map map

3401: , 'N')
3402: , 'N'
3403: ) lp_flag
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

Line 3470: , pji_pjp_proj_batch_map map

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
3474: AND bv.fin_plan_type_id IS NOT NULL

Line 3753: FROM pji_pjp_proj_batch_map map

3749: , NVL( fpo.all_time_phased_code
3750: || fpo.cost_time_phased_code
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

Line 3766: , pji_pjp_proj_batch_map map

3762: AND bv.budget_status_code = 'B' -- Don't care if dangling plan.
3763: AND map.worker_id = g_worker_id
3764: AND map.project_id = bv.project_id
3765: ) fpo
3766: , pji_pjp_proj_batch_map map
3767: , pji_pjp_wbs_header whsub
3768: , pa_xbs_denorm den
3769: , ( SELECT -3 plan_version_id FROM dual
3770: UNION ALL

Line 11902: FROM pji_pjp_proj_batch_map

11898: BEGIN
11899:
11900: SELECT MAX(project_id)
11901: INTO x_max_project_id
11902: FROM pji_pjp_proj_batch_map
11903: WHERE worker_id = g_worker_id;
11904:
11905: EXCEPTION
11906: WHEN NO_DATA_FOUND THEN