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_FM_EXTR_PLNVER4

Line 160: INSERT INTO PJI_FM_EXTR_PLNVER4

156: l_plan_type_id := NULL;
157: l_rbs_version_id := p_rbs_version_id;
158:
159:
160: INSERT INTO PJI_FM_EXTR_PLNVER4
161: (
162: WORKER_ID ,
163: PROJECT_ID ,
164: PLAN_VERSION_ID ,

Line 422: INSERT INTO PJI_FM_EXTR_PLNVER4

418: end;
419:
420:
421:
422: INSERT INTO PJI_FM_EXTR_PLNVER4
423: (
424: WORKER_ID ,
425: PROJECT_ID ,
426: PLAN_VERSION_ID ,

Line 627: INSERT INTO PJI_FM_EXTR_PLNVER4

623:
624: ELSIF (p_context IN ( 'INCREMENTAL', 'FULL')) THEN -- Workplans only.
625:
626:
627: INSERT INTO PJI_FM_EXTR_PLNVER4
628: (
629: WORKER_ID ,
630: PROJECT_ID ,
631: PLAN_VERSION_ID ,

Line 742: INSERT INTO PJI_FM_EXTR_PLNVER4

738: l_cb_ver := -3;
739: l_co_ver := -4;
740: END IF;
741:
742: INSERT INTO PJI_FM_EXTR_PLNVER4
743: (
744: WORKER_ID ,
745: PROJECT_ID ,
746: PLAN_VERSION_ID ,

Line 859: FROM pji_fm_extr_plnver4

855: )
856: WHERE (project_id, plan_version_id, NVL(plan_type_id, -1), plan_type_code, rbs_struct_version_id)
857: NOT IN
858: (SELECT project_id, plan_version_id, NVL(plan_type_id, -1), plan_type_code, rbs_struct_version_id
859: FROM pji_fm_extr_plnver4
860: WHERE worker_id = g_worker_id
861: AND plan_version_id in (-1, -3, -4));
862:
863: l_num_rows := l_num_rows + SQL%ROWCOUNT; -- Bug#5208250

Line 1669: INSERT INTO PJI_FM_EXTR_PLNVER4

1665: --#bug 5356051
1666:
1667: IF ( p_slice_type = 'PRI') THEN
1668:
1669: INSERT INTO PJI_FM_EXTR_PLNVER4
1670: (
1671: WORKER_ID ,
1672: PROJECT_ID ,
1673: PLAN_VERSION_ID ,

Line 1744: INSERT INTO PJI_FM_EXTR_PLNVER4

1740: --#bug 5356051
1741: If l_prg_exists = 'Y' then --Programs exist, need to insert -3/-4 for programs as well
1742:
1743:
1744: INSERT INTO PJI_FM_EXTR_PLNVER4
1745: (
1746: WORKER_ID ,
1747: PROJECT_ID ,
1748: PLAN_VERSION_ID ,

Line 1785: pji_fm_extr_plnver4 hd2 -- sub

1781: , DECODE(cbco.plan_version_id, -3, 'Y', 'N') baselined_flag
1782: , 'Y' SECONDARY_RBS_FLAG
1783: , 'Y' lp_flag
1784: FROM
1785: pji_fm_extr_plnver4 hd2 -- sub
1786: , pji_xbs_denorm den
1787: , ( SELECT -3 plan_version_id FROM dual
1788: UNION ALL
1789: SELECT -4 plan_version_id FROM dual ) cbco

Line 1801: INSERT INTO PJI_FM_EXTR_PLNVER4

1797: AND NVL(den.relationship_type, 'WF') IN ('LF', 'WF');
1798:
1799: elsif l_prg_exists = 'N' then
1800:
1801: INSERT INTO PJI_FM_EXTR_PLNVER4
1802: (
1803: WORKER_ID ,
1804: PROJECT_ID ,
1805: PLAN_VERSION_ID ,

Line 1842: pji_fm_extr_plnver4 hd2 -- sub

1838: , DECODE(cbco.plan_version_id, -3, 'Y', 'N') baselined_flag
1839: , 'Y' SECONDARY_RBS_FLAG
1840: , 'Y' lp_flag
1841: FROM
1842: pji_fm_extr_plnver4 hd2 -- sub
1843: , ( SELECT -3 plan_version_id FROM dual
1844: UNION ALL
1845: SELECT -4 plan_version_id FROM dual ) cbco
1846: WHERE

Line 1857: INSERT INTO PJI_FM_EXTR_PLNVER4

1853:
1854:
1855: ELSIF ( p_slice_type = 'SEC') THEN
1856:
1857: INSERT INTO PJI_FM_EXTR_PLNVER4
1858: (
1859: WORKER_ID ,
1860: PROJECT_ID ,
1861: PLAN_VERSION_ID ,

Line 1933: INSERT INTO PJI_FM_EXTR_PLNVER4

1929:
1930:
1931: ELSIF ( p_slice_type = 'SECRBS') THEN
1932:
1933: INSERT INTO PJI_FM_EXTR_PLNVER4
1934: (
1935: WORKER_ID ,
1936: PROJECT_ID ,
1937: PLAN_VERSION_ID ,

Line 2018: INSERT INTO PJI_FM_EXTR_PLNVER4

2014: /*Plans are restricted by the projects chosen by the user*/
2015:
2016: ELSIF ( p_slice_type = 'SEC_PROJ') THEN
2017:
2018: INSERT INTO PJI_FM_EXTR_PLNVER4
2019: (
2020: WORKER_ID ,
2021: PROJECT_ID ,
2022: PLAN_VERSION_ID ,

Line 2152: INSERT INTO PJI_FM_EXTR_PLNVER4

2148: AND NVL(bv.wp_version_flag, 'N') = 'N';
2149:
2150: ELSIF ( p_slice_type = 'SECRBS_PROJ') THEN
2151:
2152: INSERT INTO PJI_FM_EXTR_PLNVER4
2153: (
2154: WORKER_ID ,
2155: PROJECT_ID ,
2156: PLAN_VERSION_ID ,

Line 2660: FROM pji_fm_extr_plnver4 ver3

2656: AND whsub.project_id = map.project_id
2657: /*
2658: AND NOT EXISTS (
2659: SELECT 1
2660: FROM pji_fm_extr_plnver4 ver3
2661: WHERE ver3.project_id = den.sup_project_id
2662: AND ver3.plan_version_id = cbco.plan_version_id
2663: AND ver3.rbs_struct_version_id = fpo.parvi
2664: AND ver3.plan_type_id = whsub.plan_type_id

Line 2679: INSERT INTO PJI_FM_EXTR_PLNVER4

2675:
2676: --#bug 5356051
2677: If l_prg_exists = 'Y' then --Programs exist, need to insert -3/-4 for programs as well
2678:
2679: INSERT INTO PJI_FM_EXTR_PLNVER4
2680: (
2681: WORKER_ID ,
2682: PROJECT_ID ,
2683: PLAN_VERSION_ID ,

Line 2720: pji_fm_extr_plnver4 hd2 -- sub

2716: , DECODE(cbco.plan_version_id, -3, 'Y', 'N') baselined_flag
2717: , 'Y' SECONDARY_RBS_FLAG
2718: , 'Y' lp_flag
2719: FROM
2720: pji_fm_extr_plnver4 hd2 -- sub
2721: , pji_xbs_denorm den
2722: , ( SELECT -3 plan_version_id FROM dual
2723: UNION ALL
2724: SELECT -4 plan_version_id FROM dual ) cbco

Line 2735: FROM pji_fm_extr_plnver4 ver3

2731: AND den.struct_type = 'PRG'
2732: AND NVL(den.relationship_type, 'WF') IN ('LF', 'WF')
2733: AND (den.sup_project_id, cbco.plan_version_id, hd2.plan_type_id,hd2.plan_type_code, hd2.rbs_struct_version_id) NOT IN
2734: ( SELECT project_id, plan_version_id, plan_type_id, plan_type_code,rbs_struct_version_id
2735: FROM pji_fm_extr_plnver4 ver3
2736: WHERE worker_id = g_worker_id );
2737:
2738: elsif l_prg_exists = 'N' then
2739:

Line 2740: INSERT INTO PJI_FM_EXTR_PLNVER4

2736: WHERE worker_id = g_worker_id );
2737:
2738: elsif l_prg_exists = 'N' then
2739:
2740: INSERT INTO PJI_FM_EXTR_PLNVER4
2741: (
2742: WORKER_ID ,
2743: PROJECT_ID ,
2744: PLAN_VERSION_ID ,

Line 2781: pji_fm_extr_plnver4 hd2 -- sub

2777: , DECODE(cbco.plan_version_id, -3, 'Y', 'N') baselined_flag
2778: , 'Y' SECONDARY_RBS_FLAG
2779: , 'Y' lp_flag
2780: FROM
2781: pji_fm_extr_plnver4 hd2 -- sub
2782: , ( SELECT -3 plan_version_id FROM dual
2783: UNION ALL
2784: SELECT -4 plan_version_id FROM dual ) cbco
2785: WHERE hd2.baselined_flag = 'Y'

Line 2791: FROM pji_fm_extr_plnver4 ver3

2787: AND hd2.plan_version_id > 0
2788: AND hd2.worker_id = g_worker_id
2789: AND (hd2.project_id, cbco.plan_version_id, hd2.plan_type_id,hd2.plan_type_code, hd2.rbs_struct_version_id) NOT IN
2790: ( SELECT project_id, plan_version_id, plan_type_id, plan_type_code,rbs_struct_version_id
2791: FROM pji_fm_extr_plnver4 ver3
2792: WHERE worker_id = g_worker_id );
2793:
2794: end if;
2795: --#bug 5356051

Line 2838: INSERT INTO PJI_FM_EXTR_PLNVER4 ver3

2834: IF (p_slice_type = 'PRI') THEN
2835:
2836: FOR I IN 1..p_fp_version_ids.COUNT LOOP
2837:
2838: INSERT INTO PJI_FM_EXTR_PLNVER4 ver3
2839: (
2840: WORKER_ID ,
2841: PROJECT_ID ,
2842: PLAN_VERSION_ID ,

Line 2917: INSERT INTO PJI_FM_EXTR_PLNVER4 ver3

2913: ELSIF (p_slice_type = 'SEC') THEN
2914:
2915: FOR I IN 1..p_fp_version_ids.COUNT LOOP
2916:
2917: INSERT INTO PJI_FM_EXTR_PLNVER4 ver3
2918: (
2919: WORKER_ID ,
2920: PROJECT_ID ,
2921: PLAN_VERSION_ID ,

Line 2998: INSERT INTO PJI_FM_EXTR_PLNVER4 ver3

2994: ELSIF (p_slice_type = 'SECRBS') THEN
2995:
2996: FOR I IN 1..p_fp_version_ids.COUNT LOOP
2997:
2998: INSERT INTO PJI_FM_EXTR_PLNVER4 ver3
2999: (
3000: WORKER_ID ,
3001: PROJECT_ID ,
3002: PLAN_VERSION_ID ,

Line 3511: PJI_FM_EXTR_PLNVER4 ver

3507: , ppa.carrying_out_organization_id project_organization_id
3508: , ver.plan_type_code /*4471527 */
3509: , ver.WP_FLAG
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

Line 3636: FROM pji_fm_extr_plnver4 ver

3632: l_count NUMBER := NULL;
3633:
3634: CURSOR c_lp_struct_ver IS
3635: SELECT ver.project_id, ver.wbs_struct_version_id
3636: FROM pji_fm_extr_plnver4 ver
3637: WHERE ver.wp_flag = 'Y'
3638: AND ver.lp_flag = 'Y'
3639: AND ver.worker_id = g_worker_id;
3640:

Line 3695: FROM pji_fm_extr_plnver4) AND

3691: DELETE FROM pji_fm_extr_plan_lines
3692: WHERE
3693: (PROJECT_ID, PLAN_VERSION_ID) IN
3694: (SELECT DISTINCT project_id, plan_version_id
3695: FROM pji_fm_extr_plnver4) AND
3696: ETC_QUANTITY IS NULL AND
3697: ETC_TXN_BURDENED_COST IS NULL AND
3698: ETC_PRJ_BURDENED_COST IS NULL AND
3699: ETC_PFC_BURDENED_COST IS NULL AND

Line 4095: PJI_FM_EXTR_PLNVER4 ver

4091: , ppa.carrying_out_organization_id project_organization_id
4092: , ver.plan_type_code
4093: , ver.time_phased_type_code
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

Line 4168: PJI_FM_EXTR_PLNVER4 ver

4164: , ppa.carrying_out_organization_id project_organization_id
4165: , ver.plan_type_code
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

Line 4291: FROM pji_fm_extr_plnver4 ver

4287:
4288: DELETE FROM pji_fm_extr_plan_lines
4289: WHERE (project_id, plan_version_id) IN
4290: (SELECT ver.project_id, ver.plan_version_id
4291: FROM pji_fm_extr_plnver4 ver
4292: WHERE ver.worker_id = g_worker_id)
4293: AND txn_currency_code IS NOT NULL
4294: AND prj_currency_code IS NOT NULL
4295: AND pfc_currency_code IS NOT NULL;

Line 4297: --Bug 6047966. In case actuals alone are summarized, pji_fm_extr_plnver4

4293: AND txn_currency_code IS NOT NULL
4294: AND prj_currency_code IS NOT NULL
4295: AND pfc_currency_code IS NOT NULL;
4296:
4297: --Bug 6047966. In case actuals alone are summarized, pji_fm_extr_plnver4
4298: --contains only -1 record. Hence that case should be handled.
4299: IF l_plan_ver_type_code ='ACTUAL' THEN
4300:
4301: DELETE FROM pji_fm_extr_plan_lines

Line 4304: FROM pji_fm_extr_plnver4 ver

4300:
4301: DELETE FROM pji_fm_extr_plan_lines
4302: WHERE (project_id) IN
4303: (SELECT ver.project_id
4304: FROM pji_fm_extr_plnver4 ver
4305: WHERE ver.worker_id = g_worker_id
4306: AND ver.plan_version_id=-1)
4307: AND txn_currency_code IS NOT NULL
4308: AND prj_currency_code IS NOT NULL

Line 4776: INSERT INTO PJI_FM_EXTR_PLNVER4

4772: BEGIN
4773:
4774: print_time('........POPULATE_PLN_VER_TABLE : Begin.' );
4775:
4776: INSERT INTO PJI_FM_EXTR_PLNVER4
4777: (
4778: WORKER_ID ,
4779: PROJECT_ID ,
4780: PLAN_VERSION_ID ,

Line 4835: FROM PJI_FM_EXTR_PLNVER4;

4831:
4832: /*
4833: SELECT COUNT(1)
4834: INTO l_count
4835: FROM PJI_FM_EXTR_PLNVER4;
4836: */
4837:
4838: print_time('count is ... ' || SQL%ROWCOUNT );
4839:

Line 4944: , PJI_FM_EXTR_PLNVER4 ver

4940: , TO_DATE(NULL)
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

Line 4983: , PJI_FM_EXTR_PLNVER4 ver

4979: , ra.planning_end_date
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'

Line 4997: PJI_FM_EXTR_PLNVER4 ver

4993:
4994: PJI_UTILS.g_max_roll_days := NULL; /*5155692 */
4995:
4996: UPDATE /*+ INDEX(prd,pji_time_cal_period_u1) index(rates, PJI_FM_AGGR_DLY_RATES_N1) */
4997: PJI_FM_EXTR_PLNVER4 ver
4998: SET rate_dangling_flag = 'Y'
4999: WHERE (project_id,plan_version_id) IN
5000: ( SELECT project_id,budget_version_id
5001: FROM PA_BUDGET_LINES bl,

Line 5252: UPDATE PJI_FM_EXTR_PLNVER4

5248: updating the plan versions as time dangling so that the plan will be marked as dangling. Not updating
5249: the existing records so that data for the primary calendar is not impacted because of issue in proration to
5250: other calendars */
5251:
5252: UPDATE PJI_FM_EXTR_PLNVER4
5253: SET time_dangling_flag='Y'
5254: WHERE wp_flag='N'
5255: AND baselined_flag = 'Y'
5256: AND worker_id = g_worker_id; -- Not raising any exception as we want the processing to happen properly.

Line 7128: , pji_fm_extr_plnver4 ver3

7124: , fact1.line_type
7125: , g_default_prg_level
7126: , fact1.plan_type_code
7127: FROM pji_fp_aggr_pjp1 fact1
7128: , pji_fm_extr_plnver4 ver3
7129: WHERE
7130: fact1.RBS_AGGR_LEVEL = g_lowest_level
7131: AND fact1.worker_id = g_worker_id
7132: AND ver3.worker_id = g_worker_id

Line 7217: PJI_FM_EXTR_PLNVER4 bv,

7213: , l_created_by
7214: , l_last_update_login
7215: , bv.plan_type_code
7216: FROM
7217: PJI_FM_EXTR_PLNVER4 bv,
7218: PA_RBS_PRJ_ASSIGNMENTS rpa,
7219: PJI_PJP_RBS_HEADER head
7220: WHERE bv.project_id = rpa.project_id
7221: AND bv.worker_id = g_worker_id

Line 7288: FROM PJI_FM_EXTR_PLNVER4 ver

7284: , l_creation_date
7285: , l_created_by
7286: , l_last_update_login
7287: , ver.plan_type_code
7288: FROM PJI_FM_EXTR_PLNVER4 ver
7289: , PJI_PJP_WBS_HEADER whdr
7290: WHERE ver.worker_id = g_worker_id
7291: AND ver.plan_version_id = whdr.plan_version_id (+)
7292: AND ver.plan_type_code = whdr.plan_type_code(+) /*4471527 */

Line 7425: FROM pji_fm_extr_plnver4

7421: ),
7422: record_version_number=nvl(record_version_number,0)+1
7423: WHERE budget_version_id IN
7424: ( SELECT DISTINCT plan_version_id
7425: FROM pji_fm_extr_plnver4
7426: WHERE worker_id = g_worker_id );
7427:
7428: ELSE -- Secondary slice.
7429: /* Modified the logic for bug 4039796 */

Line 7430: UPDATE PJI_FM_EXTR_PLNVER4 ver3

7426: WHERE worker_id = g_worker_id );
7427:
7428: ELSE -- Secondary slice.
7429: /* Modified the logic for bug 4039796 */
7430: UPDATE PJI_FM_EXTR_PLNVER4 ver3
7431: SET time_dangling_flag = 'Y'
7432: WHERE (project_id,plan_version_id,plan_type_code) IN
7433: ( SELECT project_id,plan_version_id,plan_type_code /*4471527 */
7434: FROM pji_fp_aggr_pjp1 pjp1

Line 7446: FROM PJI_FM_EXTR_PLNVER4 ver3

7442: pa_budget_versions bv
7443: SET pji_summarized_flag = 'Y',
7444: record_version_number=nvl(record_version_number,0)+1
7445: WHERE budget_version_id IN (SELECT plan_version_id
7446: FROM PJI_FM_EXTR_PLNVER4 ver3
7447: WHERE ver3.worker_id=g_worker_id
7448: AND ver3.time_dangling_flag IS NULL);
7449:
7450: UPDATE /*+ index( bv , pa_budget_versions_u1 ) */

Line 7455: FROM PJI_FM_EXTR_PLNVER4 ver3

7451: pa_budget_versions bv
7452: SET pji_summarized_flag = 'P',
7453: record_version_number=nvl(record_version_number,0)+1
7454: WHERE budget_version_id IN (SELECT plan_version_id
7455: FROM PJI_FM_EXTR_PLNVER4 ver3
7456: WHERE ver3.worker_id=g_worker_id
7457: AND ver3.time_dangling_flag IS NOT NULL);
7458:
7459: END IF;

Line 7574: DELETE FROM PJI_FM_EXTR_PLNVER4

7570: BEGIN
7571:
7572: print_time('.......CLEANUP_INTERIM_TABLES: Begin. ');
7573:
7574: DELETE FROM PJI_FM_EXTR_PLNVER4
7575: WHERE worker_id = g_worker_id ;
7576:
7577: print_time('.......ver3 rows deleted: #= ' || sql%rowcount);
7578:

Line 8325: PJI_FM_EXTR_PLNVER4 ver

8321: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
8322: ,ver.plan_type_code plan_type_code /*4471527 */
8323: , ver.WP_FLAG
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

Line 8634: PJI_FM_EXTR_PLNVER4 ver

8630: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
8631: , ver.plan_type_code plan_type_code /*4471527 */
8632: , ver.WP_FLAG
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

Line 9489: PJI_FM_EXTR_PLNVER4 ver

9485: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
9486: , ver.plan_type_code plan_type_code /*4471527 */
9487: , ver.WP_FLAG
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

Line 9780: PJI_FM_EXTR_PLNVER4 ver

9776: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
9777: , ver.plan_type_code plan_type_code /*4471527 */
9778: , ver.WP_FLAG
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

Line 10075: pji_fm_extr_plnver4 ver

10071: ,g_default_prg_level PRG_LEVEL
10072: , fact.plan_type_code plan_type_code
10073: FROM
10074: pji_fp_xbs_accum_f fact,
10075: pji_fm_extr_plnver4 ver
10076: WHERE fact.plan_version_id=ver.plan_version_id
10077: AND fact.plan_type_code = ver.plan_type_code /*4471527 */
10078: AND fact.project_id = ver.project_id
10079: AND NVL(ver.rbs_struct_version_id,-1) = fact.rbs_version_id

Line 10452: PJI_FM_EXTR_PLNVER4 ver

10448: , ppa.org_id project_org_id
10449: , ppa.carrying_out_organization_id project_organization_id
10450: , ver.plan_type_code plan_type_code /* 4471527*/
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

Line 11030: PJI_FM_EXTR_PLNVER4 ver

11026: , ppa.carrying_out_organization_id project_organization_id
11027: , ver.plan_type_code plan_type_code /*4471527 */
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