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 236: pji_pjp_proj_batch_map map,

232: , 'N')
233: , 'N'
234: ) lp_flag
235: FROM
236: pji_pjp_proj_batch_map map,
237: pji_pjp_rbs_header rhd,
238: pa_budget_versions bv,
239: pa_proj_fp_options fpo,
240: pji_pa_proj_events_log pel,

Line 298: PJI_PJP_PROJ_BATCH_MAP map,

294: , 'N')
295: , 'N'
296: ) lp_flag
297: FROM
298: PJI_PJP_PROJ_BATCH_MAP map,
299: PJI_PJP_RBS_HEADER rhd,
300: PA_BUDGET_VERSIONS bv,
301: PA_PROJ_FP_OPTIONS fpo,
302: PJI_PA_PROJ_EVENTS_LOG pel,

Line 360: PJI_PJP_PROJ_BATCH_MAP map,

356: , DECODE(pln_ver.pvi, -3, 'Y', -4, 'N') baselined_flag
357: , 'N' SECONDARY_RBS_FLAG
358: , 'Y' lp_flag
359: FROM
360: PJI_PJP_PROJ_BATCH_MAP map,
361: PJI_PJP_RBS_HEADER rhd,
362: PA_BUDGET_VERSIONS bv,
363: PA_PROJ_FP_OPTIONS fpo,
364: PJI_PA_PROJ_EVENTS_LOG pel,

Line 498: pji_pjp_proj_batch_map map

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

Line 582: pji_pjp_proj_batch_map map

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

Line 692: pji_pjp_proj_batch_map map,

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

Line 805: pji_pjp_proj_batch_map map

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

Line 841: pji_pjp_proj_batch_map map

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

Line 970: FROM pji_pjp_proj_batch_map map

966: INTO l_pl_exists
967: FROM pji_fm_extr_plan_lines epl
968: WHERE EXISTS (
969: SELECT 1
970: FROM pji_pjp_proj_batch_map map
971: WHERE map.worker_id = g_worker_id
972: AND epl.project_id = map.project_id
973: )
974: AND ROWNUM <= 1;

Line 997: PJI_PJP_PROJ_BATCH_MAP map,

993: 'Y'
994: into
995: l_dangl_exists
996: from
997: PJI_PJP_PROJ_BATCH_MAP map,
998: PA_BUDGET_VERSIONS bv
999: where
1000: map.WORKER_ID = g_worker_id and
1001: bv.PROJECT_ID = map.PROJECT_ID and

Line 1171: , pji_pjp_proj_batch_map map

1167: FROM pji_pjp_wbs_header hd
1168: WHERE (project_id, plan_version_id, plan_type_id) IN
1169: ( SELECT hd1.project_id, plan_version_id, plan_type_id
1170: FROM pji_pjp_wbs_header hd1
1171: , pji_pjp_proj_batch_map map
1172: WHERE hd1.project_id = map.project_id
1173: AND map.worker_id = g_worker_id
1174: AND (hd1.plan_version_id > 0 OR hd1.plan_version_id IN (-3, -4))
1175: )

Line 1216: FROM pji_pjp_proj_batch_map map

1212: INSERT INTO pji_fm_extr_plnver3_t
1213: (project_id, plan_version_id, plan_type_id)
1214: SELECT / * + ORDERED * / -- INDEX(HD9, PJI_PJP_WBS_HEADER_N1)
1215: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1216: FROM pji_pjp_proj_batch_map map
1217: , pji_fm_extr_plan_lines epl
1218: , pji_pjp_wbs_header hd2 -- SUB
1219: , pji_xbs_denorm den
1220: , pji_pjp_wbs_header hd9 -- SUP

Line 1255: FROM pji_pjp_proj_batch_map map

1251: INSERT INTO pji_fm_extr_plnver3_t
1252: (project_id, plan_version_id, plan_type_id)
1253: SELECT /*+ ORDERED */
1254: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1255: FROM pji_pjp_proj_batch_map map
1256: , pji_pjp_wbs_header hd1 -- SUB
1257: , pji_xbs_denorm den
1258: , pji_pjp_wbs_header hd9 -- SUP
1259: WHERE

Line 1282: FROM pji_pjp_proj_batch_map map

1278: INSERT INTO pji_fm_extr_plnver3_t
1279: (project_id, plan_version_id, plan_type_id)
1280: SELECT
1281: DISTINCT bv.project_id, bv.budget_version_id, bv.fin_plan_type_id
1282: FROM pji_pjp_proj_batch_map map
1283: , PA_BUDGET_VERSIONS bv
1284: WHERE
1285: map.worker_id = g_worker_id
1286: AND bv.project_id = map.project_id

Line 1330: pji_pjp_proj_batch_map map

1326: (project_id, plan_version_id, plan_type_id)
1327: SELECT /*+ ordered */
1328: DISTINCT hd2.project_id, hd2.plan_version_id, hd2.plan_type_id
1329: FROM
1330: pji_pjp_proj_batch_map map
1331: , pji_pa_proj_events_log ev
1332: , pji_pjp_wbs_header hd9 -- SUP
1333: , pji_xbs_denorm den
1334: , pji_pjp_wbs_header hd2 -- SUB

Line 1361: FROM pji_pjp_proj_batch_map map

1357:
1358: INSERT INTO pji_fm_extr_plnver3_t
1359: (project_id, plan_version_id, plan_type_id)
1360: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1361: FROM pji_pjp_proj_batch_map map
1362: , pji_pa_proj_events_log ev
1363: , pji_pjp_wbs_header hd9 -- SUP
1364: WHERE
1365: map.worker_id = g_worker_id

Line 1391: , pji_pjp_proj_batch_map map

1387: (project_id, plan_version_id, plan_type_id)
1388: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1389: FROM pji_xbs_denorm den
1390: , pji_pjp_wbs_header hd1 -- SUB
1391: , pji_pjp_proj_batch_map map
1392: , pji_pa_proj_events_log ev
1393: , pji_pjp_wbs_header hd9 -- SUP
1394: WHERE
1395: den.struct_version_id IS NULL

Line 1428: FROM pji_pjp_proj_batch_map map

1424: INSERT INTO pji_fm_extr_plnver3_t
1425: (project_id, plan_version_id, plan_type_id)
1426: SELECT /*+ ordered */
1427: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1428: FROM pji_pjp_proj_batch_map map
1429: , pji_pa_proj_events_log ev
1430: -- , PA_BUDGET_VERSIONS bv
1431: , pji_xbs_denorm den
1432: , pji_pjp_wbs_header wh1 -- sup

Line 1465: , pji_pjp_proj_batch_map map

1461: (project_id, plan_version_id, plan_type_id)
1462: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1463: FROM pji_xbs_denorm den
1464: , pji_pjp_wbs_header hd2 -- SUB
1465: , pji_pjp_proj_batch_map map
1466: , pji_pa_proj_events_log ev
1467: , pji_pjp_wbs_header hd9 -- SUP
1468: WHERE
1469: den.struct_version_id IS NULL

Line 1494: FROM pji_pjp_proj_batch_map map

1490:
1491: INSERT INTO pji_fm_extr_plnver3_t
1492: (project_id, plan_version_id, plan_type_id)
1493: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1494: FROM pji_pjp_proj_batch_map map
1495: , PA_BUDGET_VERSIONS bv
1496: , pji_pjp_wbs_header hd9 -- SUP
1497: WHERE
1498: map.worker_id = g_worker_id

Line 1519: , pji_pjp_proj_batch_map map

1515: (project_id, plan_version_id, plan_type_id)
1516: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1517: FROM pji_xbs_denorm den
1518: , pji_pjp_wbs_header hd1 -- SUB
1519: , pji_pjp_proj_batch_map map
1520: , pa_budget_versions bv
1521: , pji_pjp_wbs_header hd9 -- SUP
1522: WHERE
1523: den.struct_version_id IS NULL

Line 1584: PJI_PJP_PROJ_BATCH_MAP map

1580: (
1581: select
1582: 1
1583: from
1584: PJI_PJP_PROJ_BATCH_MAP map
1585: where
1586: map.WORKER_ID = g_worker_id and
1587: hd9.PROJECT_ID = map.PROJECT_ID
1588: );

Line 2078: , pji_pjp_proj_batch_map map

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

Line 2132: , pji_pjp_proj_batch_map map

2128: ) lp_flag
2129: FROM
2130: pa_budget_versions bv
2131: , pa_proj_fp_options fpo
2132: , pji_pjp_proj_batch_map map
2133: , ( SELECT -3 plan_version_id FROM dual
2134: UNION ALL
2135: SELECT -4 plan_version_id FROM dual ) cbco
2136: WHERE 1=1

Line 2233: , pji_pjp_proj_batch_map map

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

Line 2290: , pji_pjp_proj_batch_map map

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
2293: SELECT -4 plan_version_id FROM dual ) cbco
2294: WHERE map.project_id = bv.project_id

Line 2353: , pji_pjp_proj_batch_map map

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

Line 2628: , PJI_PJP_PROJ_BATCH_MAP map

2624: , bv.budget_status_code bsc
2625: FROM pa_proj_fp_options fpo
2626: , pa_rbs_prj_assignments rpa
2627: , pa_budget_versions bv
2628: , PJI_PJP_PROJ_BATCH_MAP map
2629: WHERE 1=1
2630: AND fpo.project_id (+)= rpa.project_id
2631: AND fpo.rbs_version_id (+)= rpa.rbs_version_id
2632: AND bv.project_id = rpa.project_id

Line 2639: , pji_pjp_proj_batch_map map

2635: AND map.worker_id = g_worker_id
2636: AND map.project_id = bv.project_id
2637: ) fpo
2638: , pa_xbs_denorm den
2639: , pji_pjp_proj_batch_map map
2640: , pji_pjp_wbs_header whsub
2641: , ( SELECT -3 plan_version_id FROM dual
2642: UNION ALL
2643: SELECT -4 plan_version_id FROM dual ) cbco

Line 10569: FROM pji_pjp_proj_batch_map

10565: BEGIN
10566:
10567: SELECT MAX(project_id)
10568: INTO x_max_project_id
10569: FROM pji_pjp_proj_batch_map
10570: WHERE worker_id = g_worker_id;
10571:
10572: EXCEPTION
10573: WHEN NO_DATA_FOUND THEN