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_PMV_PROFITABILITY dependencies on PJI_PMV_CLS_DIM_TMP

Line 869: , PJI_PMV_CLS_DIM_TMP CLS

865: , null AS P_CHANGE22
866: FROM
867: PJI_PMV_TIME_DIM_TMP TIME
868: , PJI_PMV_ORGZ_DIM_TMP HORG
869: , PJI_PMV_CLS_DIM_TMP CLS
870: , pji_fp_clso_f_mv fct
871: , PJI_PMV_ORG_DIM_TMP HOU
872:
873: WHERE

Line 900: , PJI_PMV_CLS_DIM_TMP CLS

896: , null AS P_CHANGE22
897: FROM
898: PJI_PMV_TIME_DIM_TMP TIME
899: , PJI_PMV_ORGZ_DIM_TMP HORG
900: , PJI_PMV_CLS_DIM_TMP CLS
901: , pji_fp_clso_f_mv fct
902: , PJI_PMV_ORG_DIM_TMP HOU
903: WHERE
904: FCT.PROJECT_ORG_ID = HOU.ID

Line 934: , PJI_PMV_CLS_DIM_TMP CLS

930: , null AS P_CHANGE22
931: FROM
932: PJI_PMV_TIME_DIM_TMP TIME
933: , PJI_PMV_ORGZ_DIM_TMP HORG
934: , PJI_PMV_CLS_DIM_TMP CLS
935: , pji_fp_clso_f_mv fct
936: , PJI_PMV_ORG_DIM_TMP HOU
937:
938: WHERE

Line 969: , PJI_PMV_CLS_DIM_TMP CLS

965: , null AS P_CHANGE22
966: FROM
967: PJI_PMV_TIME_DIM_TMP TIME
968: , PJI_PMV_ORGZ_DIM_TMP HORG
969: , PJI_PMV_CLS_DIM_TMP CLS
970: , pji_fp_clso_f_mv fct
971: , PJI_PMV_ORG_DIM_TMP HOU
972: WHERE
973: FCT.PROJECT_ORG_ID = HOU.ID

Line 1003: , PJI_PMV_CLS_DIM_TMP CLS

999: , null AS P_CHANGE22
1000: FROM
1001: PJI_PMV_TIME_DIM_TMP TIME
1002: , PJI_PMV_ORGZ_DIM_TMP HORG
1003: , PJI_PMV_CLS_DIM_TMP CLS
1004: , pji_fp_clso_f_mv fct
1005: , PJI_PMV_ORG_DIM_TMP HOU
1006: WHERE
1007: FCT.PROJECT_ORG_ID = HOU.ID

Line 1036: , PJI_PMV_CLS_DIM_TMP CLS

1032: , null AS P_CHANGE21
1033: , null AS P_CHANGE22
1034: FROM PJI_PMV_TIME_DIM_TMP TIME
1035: , PJI_PMV_ORGZ_DIM_TMP HORG
1036: , PJI_PMV_CLS_DIM_TMP CLS
1037: , pji_fp_clso_f_mv fct
1038: , PJI_PMV_ORG_DIM_TMP HOU
1039: WHERE
1040: FCT.PROJECT_ORG_ID = HOU.ID

Line 1706: , PJI_PMV_CLS_DIM_TMP CLS

1702: , null AS P_CHANGE22
1703: FROM
1704: PJI_PMV_TIME_DIM_TMP TIME
1705: , PJI_PMV_ORGZ_DIM_TMP HORG
1706: , PJI_PMV_CLS_DIM_TMP CLS
1707: , PJI_PMV_ET_RT_DIM_TMP ET
1708: , PJI_FP_CLSO_ET_F_MV fct
1709: , PJI_PMV_ORG_DIM_TMP HOU
1710:

Line 1741: , PJI_PMV_CLS_DIM_TMP CLS

1737: , null AS P_CHANGE22
1738: FROM
1739: PJI_PMV_TIME_DIM_TMP TIME
1740: , PJI_PMV_ORGZ_DIM_TMP HORG
1741: , PJI_PMV_CLS_DIM_TMP CLS
1742: , PJI_PMV_ET_RT_DIM_TMP ET
1743: , PJI_FP_CLSO_ET_F_MV fct
1744: , PJI_PMV_ORG_DIM_TMP HOU
1745: WHERE

Line 1776: , PJI_PMV_CLS_DIM_TMP CLS

1772: , null AS P_CHANGE22
1773: FROM
1774: PJI_PMV_TIME_DIM_TMP TIME
1775: , PJI_PMV_ORGZ_DIM_TMP HORG
1776: , PJI_PMV_CLS_DIM_TMP CLS
1777: , PJI_PMV_ET_RT_DIM_TMP ET
1778: , PJI_FP_CLSO_ET_F_MV fct
1779: , PJI_PMV_ORG_DIM_TMP HOU
1780:

Line 1812: , PJI_PMV_CLS_DIM_TMP CLS

1808: , null AS P_CHANGE22
1809: FROM
1810: PJI_PMV_TIME_DIM_TMP TIME
1811: , PJI_PMV_ORGZ_DIM_TMP HORG
1812: , PJI_PMV_CLS_DIM_TMP CLS
1813: , PJI_PMV_ET_RT_DIM_TMP ET
1814: , PJI_FP_CLSO_ET_F_MV fct
1815: , PJI_PMV_ORG_DIM_TMP HOU
1816: WHERE

Line 1847: , PJI_PMV_CLS_DIM_TMP CLS

1843: , null AS P_CHANGE22
1844: FROM
1845: PJI_PMV_TIME_DIM_TMP TIME
1846: , PJI_PMV_ORGZ_DIM_TMP HORG
1847: , PJI_PMV_CLS_DIM_TMP CLS
1848: , PJI_PMV_ET_RT_DIM_TMP ET
1849: , PJI_FP_CLSO_ET_F_MV fct
1850: , PJI_PMV_ORG_DIM_TMP HOU
1851: WHERE

Line 1881: , PJI_PMV_CLS_DIM_TMP CLS

1877: , null AS P_CHANGE21
1878: , null AS P_CHANGE22
1879: FROM PJI_PMV_TIME_DIM_TMP TIME
1880: , PJI_PMV_ORGZ_DIM_TMP HORG
1881: , PJI_PMV_CLS_DIM_TMP CLS
1882: , PJI_PMV_ET_RT_DIM_TMP ET
1883: , PJI_FP_CLSO_ET_F_MV fct
1884: , PJI_PMV_ORG_DIM_TMP HOU
1885: WHERE

Line 2288: , PJI_PMV_CLS_DIM_TMP CLS

2284: , null AS P_CHANGE22
2285: FROM
2286: PJI_PMV_TIME_DIM_TMP TIME
2287: , PJI_PMV_ORGZ_DIM_TMP HORG
2288: , PJI_PMV_CLS_DIM_TMP CLS
2289: , PJI_PMV_WT_DIM_TMP WT
2290: , PJI_FP_CLSO_ET_WT_F_MV fct
2291: , PJI_PMV_ORG_DIM_TMP HOU
2292:

Line 2321: , PJI_PMV_CLS_DIM_TMP CLS

2317: , null AS P_CHANGE22
2318: FROM
2319: PJI_PMV_TIME_DIM_TMP TIME
2320: , PJI_PMV_ORGZ_DIM_TMP HORG
2321: , PJI_PMV_CLS_DIM_TMP CLS
2322: , PJI_PMV_WT_DIM_TMP WT
2323: , PJI_FP_CLSO_ET_WT_F_MV fct
2324: , PJI_PMV_ORG_DIM_TMP HOU
2325: WHERE

Line 2355: , PJI_PMV_CLS_DIM_TMP CLS

2351: , null AS P_CHANGE22
2352: FROM
2353: PJI_PMV_TIME_DIM_TMP TIME
2354: , PJI_PMV_ORGZ_DIM_TMP HORG
2355: , PJI_PMV_CLS_DIM_TMP CLS
2356: , PJI_PMV_WT_DIM_TMP WT
2357: , PJI_FP_CLSO_ET_WT_F_MV fct
2358: , PJI_PMV_ORG_DIM_TMP HOU
2359:

Line 2390: , PJI_PMV_CLS_DIM_TMP CLS

2386: , null AS P_CHANGE22
2387: FROM
2388: PJI_PMV_TIME_DIM_TMP TIME
2389: , PJI_PMV_ORGZ_DIM_TMP HORG
2390: , PJI_PMV_CLS_DIM_TMP CLS
2391: , PJI_PMV_WT_DIM_TMP WT
2392: , PJI_FP_CLSO_ET_WT_F_MV fct
2393: , PJI_PMV_ORG_DIM_TMP HOU
2394: WHERE

Line 2422: , PJI_PMV_CLS_DIM_TMP CLS

2418: , null AS P_CHANGE22
2419: FROM
2420: PJI_PMV_TIME_DIM_TMP TIME
2421: , PJI_PMV_ORGZ_DIM_TMP HORG
2422: , PJI_PMV_CLS_DIM_TMP CLS
2423: , PJI_PMV_WT_DIM_TMP WT
2424: , PJI_FP_CLSO_ET_WT_F_MV fct
2425: , PJI_PMV_ORG_DIM_TMP HOU
2426: WHERE

Line 2453: , PJI_PMV_CLS_DIM_TMP CLS

2449: , null AS P_CHANGE21
2450: , null AS P_CHANGE22
2451: FROM PJI_PMV_TIME_DIM_TMP TIME
2452: , PJI_PMV_ORGZ_DIM_TMP HORG
2453: , PJI_PMV_CLS_DIM_TMP CLS
2454: , PJI_PMV_WT_DIM_TMP WT
2455: , PJI_FP_CLSO_ET_WT_F_MV fct
2456: , PJI_PMV_ORG_DIM_TMP HOU
2457: WHERE

Line 2569: , PJI_PMV_CLS_DIM_TMP CLS

2565: , null AS P_CHANGE22
2566: FROM
2567: PJI_PMV_TIME_DIM_TMP TIME
2568: , PJI_PMV_ORGZ_DIM_TMP HORG
2569: , PJI_PMV_CLS_DIM_TMP CLS
2570: , PJI_PMV_ET_RT_DIM_TMP ET
2571: , PJI_PMV_WT_DIM_TMP WT
2572: , PJI_FP_CLSO_ET_WT_F_MV fct
2573: , PJI_PMV_ORG_DIM_TMP HOU

Line 2605: , PJI_PMV_CLS_DIM_TMP CLS

2601: , null AS P_CHANGE22
2602: FROM
2603: PJI_PMV_TIME_DIM_TMP TIME
2604: , PJI_PMV_ORGZ_DIM_TMP HORG
2605: , PJI_PMV_CLS_DIM_TMP CLS
2606: , PJI_PMV_ET_RT_DIM_TMP ET
2607: , PJI_PMV_WT_DIM_TMP WT
2608: , PJI_FP_CLSO_ET_WT_F_MV fct
2609: , PJI_PMV_ORG_DIM_TMP HOU

Line 2642: , PJI_PMV_CLS_DIM_TMP CLS

2638: , null AS P_CHANGE22
2639: FROM
2640: PJI_PMV_TIME_DIM_TMP TIME
2641: , PJI_PMV_ORGZ_DIM_TMP HORG
2642: , PJI_PMV_CLS_DIM_TMP CLS
2643: , PJI_PMV_ET_RT_DIM_TMP ET
2644: , PJI_PMV_WT_DIM_TMP WT
2645: , PJI_FP_CLSO_ET_WT_F_MV fct
2646: , PJI_PMV_ORG_DIM_TMP HOU

Line 2680: , PJI_PMV_CLS_DIM_TMP CLS

2676: , null AS P_CHANGE22
2677: FROM
2678: PJI_PMV_TIME_DIM_TMP TIME
2679: , PJI_PMV_ORGZ_DIM_TMP HORG
2680: , PJI_PMV_CLS_DIM_TMP CLS
2681: , PJI_PMV_ET_RT_DIM_TMP ET
2682: , PJI_PMV_WT_DIM_TMP WT
2683: , PJI_FP_CLSO_ET_WT_F_MV fct
2684: , PJI_PMV_ORG_DIM_TMP HOU

Line 2715: , PJI_PMV_CLS_DIM_TMP CLS

2711: , null AS P_CHANGE22
2712: FROM
2713: PJI_PMV_TIME_DIM_TMP TIME
2714: , PJI_PMV_ORGZ_DIM_TMP HORG
2715: , PJI_PMV_CLS_DIM_TMP CLS
2716: , PJI_PMV_ET_RT_DIM_TMP ET
2717: , PJI_PMV_WT_DIM_TMP WT
2718: , PJI_FP_CLSO_ET_WT_F_MV fct
2719: , PJI_PMV_ORG_DIM_TMP HOU

Line 2749: , PJI_PMV_CLS_DIM_TMP CLS

2745: , null AS P_CHANGE21
2746: , null AS P_CHANGE22
2747: FROM PJI_PMV_TIME_DIM_TMP TIME
2748: , PJI_PMV_ORGZ_DIM_TMP HORG
2749: , PJI_PMV_CLS_DIM_TMP CLS
2750: , PJI_PMV_ET_RT_DIM_TMP ET
2751: , PJI_PMV_WT_DIM_TMP WT
2752: , PJI_FP_CLSO_ET_WT_F_MV fct
2753: , PJI_PMV_ORG_DIM_TMP HOU

Line 3271: , pji_pmv_cls_dim_tmp PTM

3267: INSERT into pji_pmv_prj_dim_tmp (id, name)
3268: SELECT DISTINCT prj.project_id, '-1' name
3269: FROM
3270: pji_project_classes PJM
3271: , pji_pmv_cls_dim_tmp PTM
3272: , pji_pmv_orgz_dim_tmp org
3273: , pa_projects_all prj
3274: WHERE
3275: pjm.project_class_id = ptm.id

Line 4344: , PJI_PMV_CLS_DIM_TMP CLS

4340: , 0 AS CT_FORECAST_BURDENED_COST
4341: FROM
4342: PJI_PMV_TIME_DIM_TMP TIME
4343: , PJI_PMV_ORGZ_DIM_TMP HORG
4344: , PJI_PMV_CLS_DIM_TMP CLS
4345: , PJI_FP_CLSO_F_MV fct
4346: , PJI_PMV_ORG_DIM_TMP HOU
4347: WHERE
4348: fct.project_org_id = hou.id

Line 4383: , PJI_PMV_CLS_DIM_TMP CLS

4379: CT_FORECAST_BURDENED_COST
4380: FROM
4381: PJI_PMV_TIME_DIM_TMP TIME
4382: , PJI_PMV_ORGZ_DIM_TMP HORG
4383: , PJI_PMV_CLS_DIM_TMP CLS
4384: , PJI_FP_CLSO_F_MV fct
4385: , PJI_PMV_ORG_DIM_TMP HOU
4386: WHERE
4387: fct.project_org_id = hou.id

Line 4423: , PJI_PMV_CLS_DIM_TMP CLS

4419: CT_FORECAST_BURDENED_COST
4420: FROM
4421: PJI_PMV_TCMP_DIM_TMP TIME
4422: , PJI_PMV_ORGZ_DIM_TMP HORG
4423: , PJI_PMV_CLS_DIM_TMP CLS
4424: , PJI_FP_CLSO_F_MV fct
4425: , PJI_PMV_ORG_DIM_TMP HOU
4426: WHERE
4427: fct.project_org_id = hou.id

Line 4491: FROM PJI_PMV_CLS_DIM_TMP HORG

4487: , 0 AS CT_REVENUE
4488: , 0 AS CT_BURDENED_COST
4489: , 0 AS CT_FORECAST_REVENUE
4490: , 0 AS CT_FORECAST_BURDENED_COST
4491: FROM PJI_PMV_CLS_DIM_TMP HORG
4492: WHERE HORG.NAME <> '-1'
4493: )
4494: WHERE 1 = 1
4495: GROUP BY ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,EXPENDITURE_TYPE_ID,REVENUE_CATEGORY,

Line 4954: , PJI_PMV_CLS_DIM_TMP CLS

4950: , NULL AS CT_FORECAST_BURDENED_COST
4951: FROM
4952: PJI_PMV_TIME_DIM_TMP TIME
4953: , PJI_PMV_ORGZ_DIM_TMP HORG
4954: , PJI_PMV_CLS_DIM_TMP CLS
4955: , PJI_PMV_ET_RT_DIM_TMP ET
4956: , PJI_FP_CLSO_ET_F_MV fct
4957: , PJI_PMV_ORG_DIM_TMP HOU
4958: WHERE

Line 4990: , PJI_PMV_CLS_DIM_TMP CLS

4986: , NULL AS CT_FORECAST_BURDENED_COST
4987: FROM
4988: PJI_PMV_TIME_DIM_TMP TIME
4989: , PJI_PMV_ORGZ_DIM_TMP HORG
4990: , PJI_PMV_CLS_DIM_TMP CLS
4991: , PJI_PMV_ET_RT_DIM_TMP ET
4992: , PJI_FP_CLSO_ET_F_MV fct
4993: , PJI_PMV_ORG_DIM_TMP HOU
4994: WHERE

Line 5029: , PJI_PMV_CLS_DIM_TMP CLS

5025: , NULL AS CT_FORECAST_BURDENED_COST
5026: FROM
5027: PJI_PMV_TCMP_DIM_TMP TIME
5028: , PJI_PMV_ORGZ_DIM_TMP HORG
5029: , PJI_PMV_CLS_DIM_TMP CLS
5030: , PJI_PMV_ET_RT_DIM_TMP ET
5031: , PJI_FP_CLSO_ET_F_MV fct
5032: , PJI_PMV_ORG_DIM_TMP HOU
5033: WHERE

Line 5100: FROM PJI_PMV_CLS_DIM_TMP CLS

5096: , 0 AS CT_REVENUE
5097: , 0 AS CT_BURDENED_COST
5098: , 0 AS CT_FORECAST_REVENUE
5099: , 0 AS CT_FORECAST_BURDENED_COST
5100: FROM PJI_PMV_CLS_DIM_TMP CLS
5101: WHERE CLS.NAME <> '-1'
5102: UNION ALL -- FORCE Creation of Expenditure Category/Type Rows
5103: SELECT '-1' AS ORG_ID
5104: , '-1' AS ORGANIZATION_ID

Line 5410: , PJI_PMV_CLS_DIM_TMP CLS

5406: , NULL AS CT_FORECAST_BURDENED_COST
5407: FROM
5408: PJI_PMV_TIME_DIM_TMP TIME
5409: , PJI_PMV_ORGZ_DIM_TMP HORG
5410: , PJI_PMV_CLS_DIM_TMP CLS
5411: , PJI_PMV_WT_DIM_TMP WT
5412: , PJI_FP_CLSO_ET_WT_F_MV fct
5413: , PJI_PMV_ORG_DIM_TMP HOU
5414: WHERE

Line 5445: , PJI_PMV_CLS_DIM_TMP CLS

5441: , NULL AS CT_FORECAST_BURDENED_COST
5442: FROM
5443: PJI_PMV_TIME_DIM_TMP TIME
5444: , PJI_PMV_ORGZ_DIM_TMP HORG
5445: , PJI_PMV_CLS_DIM_TMP CLS
5446: , PJI_PMV_WT_DIM_TMP WT
5447: , PJI_FP_CLSO_ET_WT_F_MV fct
5448: , PJI_PMV_ORG_DIM_TMP HOU
5449: WHERE

Line 5483: , PJI_PMV_CLS_DIM_TMP CLS

5479: , NULL AS CT_FORECAST_BURDENED_COST
5480: FROM
5481: PJI_PMV_TCMP_DIM_TMP TIME
5482: , PJI_PMV_ORGZ_DIM_TMP HORG
5483: , PJI_PMV_CLS_DIM_TMP CLS
5484: , PJI_PMV_WT_DIM_TMP WT
5485: , PJI_FP_CLSO_ET_WT_F_MV fct
5486: , PJI_PMV_ORG_DIM_TMP HOU
5487: WHERE

Line 5553: FROM PJI_PMV_CLS_DIM_TMP CLS

5549: , 0 AS CT_REVENUE
5550: , 0 AS CT_BURDENED_COST
5551: , 0 AS CT_FORECAST_REVENUE
5552: , 0 AS CT_FORECAST_BURDENED_COST
5553: FROM PJI_PMV_CLS_DIM_TMP CLS
5554: WHERE CLS.NAME <> '-1'
5555: UNION ALL -- FORCE Creation of Work Type Rows
5556: SELECT '-1' AS ORG_ID
5557: , '-1' AS ORGANIZATION_ID

Line 5634: , PJI_PMV_CLS_DIM_TMP CLS

5630: , NULL AS CT_FORECAST_BURDENED_COST
5631: FROM
5632: PJI_PMV_TIME_DIM_TMP TIME
5633: , PJI_PMV_ORGZ_DIM_TMP HORG
5634: , PJI_PMV_CLS_DIM_TMP CLS
5635: , PJI_PMV_ET_RT_DIM_TMP ET
5636: , PJI_PMV_WT_DIM_TMP WT
5637: , PJI_FP_CLSO_ET_WT_F_MV fct
5638: , PJI_PMV_ORG_DIM_TMP HOU

Line 5672: , PJI_PMV_CLS_DIM_TMP CLS

5668: , NULL AS CT_FORECAST_BURDENED_COST
5669: FROM
5670: PJI_PMV_TIME_DIM_TMP TIME
5671: , PJI_PMV_ORGZ_DIM_TMP HORG
5672: , PJI_PMV_CLS_DIM_TMP CLS
5673: , PJI_PMV_ET_RT_DIM_TMP ET
5674: , PJI_PMV_WT_DIM_TMP WT
5675: , PJI_FP_CLSO_ET_WT_F_MV fct
5676: , PJI_PMV_ORG_DIM_TMP HOU

Line 5713: , PJI_PMV_CLS_DIM_TMP CLS

5709: , NULL AS CT_FORECAST_BURDENED_COST
5710: FROM
5711: PJI_PMV_TCMP_DIM_TMP TIME
5712: , PJI_PMV_ORGZ_DIM_TMP HORG
5713: , PJI_PMV_CLS_DIM_TMP CLS
5714: , PJI_PMV_ET_RT_DIM_TMP ET
5715: , PJI_PMV_WT_DIM_TMP WT
5716: , PJI_FP_CLSO_ET_WT_F_MV fct
5717: , PJI_PMV_ORG_DIM_TMP HOU

Line 5786: FROM PJI_PMV_CLS_DIM_TMP CLS

5782: , 0 AS CT_REVENUE
5783: , 0 AS CT_BURDENED_COST
5784: , 0 AS CT_FORECAST_REVENUE
5785: , 0 AS CT_FORECAST_BURDENED_COST
5786: FROM PJI_PMV_CLS_DIM_TMP CLS
5787: WHERE CLS.NAME <> '-1'
5788: UNION ALL -- FORCE Creation of Expenditure Category/Type Rows
5789: SELECT '-1' AS ORG_ID
5790: , '-1' AS ORGANIZATION_ID