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_TIME_DIM_TMP

Line 591: PJI_PMV_TIME_DIM_TMP TIME

587: , null AS P_CHANGE2
588: , null AS P_CHANGE21
589: , null AS P_CHANGE22
590: FROM
591: PJI_PMV_TIME_DIM_TMP TIME
592: , PJI_PMV_ORGZ_DIM_TMP HORG
593: , pji_fp_orgo_f_mv fct
594: , PJI_PMV_ORG_DIM_TMP HOU
595: WHERE

Line 619: PJI_PMV_TIME_DIM_TMP TIME

615: , null AS P_CHANGE2
616: , null AS P_CHANGE21
617: , null AS P_CHANGE22
618: FROM
619: PJI_PMV_TIME_DIM_TMP TIME
620: , PJI_PMV_ORGZ_DIM_TMP HORG
621: , pji_fp_orgo_f_mv fct
622: , PJI_PMV_ORG_DIM_TMP HOU
623:

Line 652: PJI_PMV_TIME_DIM_TMP TIME

648: , null AS P_CHANGE2
649: , null AS P_CHANGE21
650: , null AS P_CHANGE22
651: FROM
652: PJI_PMV_TIME_DIM_TMP TIME
653: , PJI_PMV_ORGZ_DIM_TMP HORG
654: , pji_fp_orgo_f_mv fct
655: , PJI_PMV_ORG_DIM_TMP HOU
656:

Line 685: PJI_PMV_TIME_DIM_TMP TIME

681: , null AS P_CHANGE2
682: , null AS P_CHANGE21
683: , null AS P_CHANGE22
684: FROM
685: PJI_PMV_TIME_DIM_TMP TIME
686: , PJI_PMV_ORGZ_DIM_TMP HORG
687: , pji_fp_orgo_f_mv fct
688: , PJI_PMV_ORG_DIM_TMP HOU
689:

Line 719: PJI_PMV_TIME_DIM_TMP TIME

715: , null AS P_CHANGE2
716: , null AS P_CHANGE21
717: , null AS P_CHANGE22
718: FROM
719: PJI_PMV_TIME_DIM_TMP TIME
720: , PJI_PMV_ORGZ_DIM_TMP HORG
721: , pji_fp_orgo_f_mv fct
722: , PJI_PMV_ORG_DIM_TMP HOU
723: WHERE

Line 751: PJI_PMV_TIME_DIM_TMP TIME

747: , null AS P_CHANGE2
748: , null AS P_CHANGE21
749: , null AS P_CHANGE22
750: FROM
751: PJI_PMV_TIME_DIM_TMP TIME
752: , PJI_PMV_ORGZ_DIM_TMP HORG
753: , pji_fp_orgo_f_mv fct
754: , PJI_PMV_ORG_DIM_TMP HOU
755: WHERE

Line 867: PJI_PMV_TIME_DIM_TMP TIME

863: , null AS P_CHANGE2
864: , null AS P_CHANGE21
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

Line 898: PJI_PMV_TIME_DIM_TMP TIME

894: , null AS P_CHANGE2
895: , null AS P_CHANGE21
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

Line 932: PJI_PMV_TIME_DIM_TMP TIME

928: , null AS P_CHANGE2
929: , null AS P_CHANGE21
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

Line 967: PJI_PMV_TIME_DIM_TMP TIME

963: , null AS P_CHANGE2
964: , null AS P_CHANGE21
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

Line 1001: PJI_PMV_TIME_DIM_TMP TIME

997: , null AS P_CHANGE2
998: , null AS P_CHANGE21
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

Line 1034: FROM PJI_PMV_TIME_DIM_TMP TIME

1030: 'RC', forecast_raw_cost, 0)), 0) AS PY_FORECAST
1031: , null AS P_CHANGE2
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

Line 1151: PJI_PMV_TIME_DIM_TMP TIME

1147: , null AS P_CHANGE2
1148: , null AS P_CHANGE21
1149: , null AS P_CHANGE22
1150: FROM
1151: PJI_PMV_TIME_DIM_TMP TIME
1152: , PJI_PMV_ORGZ_DIM_TMP HORG
1153: , PJI_PMV_ET_RT_DIM_TMP ET
1154: , PJI_FP_ORGO_ET_F_MV fct
1155: , PJI_PMV_ORG_DIM_TMP HOU

Line 1183: PJI_PMV_TIME_DIM_TMP TIME

1179: , null AS P_CHANGE2
1180: , null AS P_CHANGE21
1181: , null AS P_CHANGE22
1182: FROM
1183: PJI_PMV_TIME_DIM_TMP TIME
1184: , PJI_PMV_ORGZ_DIM_TMP HORG
1185: , PJI_PMV_ET_RT_DIM_TMP ET
1186: , PJI_FP_ORGO_ET_F_MV fct
1187: , PJI_PMV_ORG_DIM_TMP HOU

Line 1216: PJI_PMV_TIME_DIM_TMP TIME

1212: , null AS P_CHANGE2
1213: , null AS P_CHANGE21
1214: , null AS P_CHANGE22
1215: FROM
1216: PJI_PMV_TIME_DIM_TMP TIME
1217: , PJI_PMV_ORGZ_DIM_TMP HORG
1218: , PJI_PMV_ET_RT_DIM_TMP ET
1219: , PJI_FP_ORGO_ET_F_MV fct
1220: , PJI_PMV_ORG_DIM_TMP HOU

Line 1250: PJI_PMV_TIME_DIM_TMP TIME

1246: , null AS P_CHANGE2
1247: , null AS P_CHANGE21
1248: , null AS P_CHANGE22
1249: FROM
1250: PJI_PMV_TIME_DIM_TMP TIME
1251: , PJI_PMV_ORGZ_DIM_TMP HORG
1252: , PJI_PMV_ET_RT_DIM_TMP ET
1253: , PJI_FP_ORGO_ET_F_MV fct
1254: , PJI_PMV_ORG_DIM_TMP HOU

Line 1283: PJI_PMV_TIME_DIM_TMP TIME

1279: , null AS P_CHANGE2
1280: , null AS P_CHANGE21
1281: , null AS P_CHANGE22
1282: FROM
1283: PJI_PMV_TIME_DIM_TMP TIME
1284: , PJI_PMV_ORGZ_DIM_TMP HORG
1285: , PJI_PMV_ET_RT_DIM_TMP ET
1286: , PJI_FP_ORGO_ET_F_MV fct
1287: , PJI_PMV_ORG_DIM_TMP HOU

Line 1315: FROM PJI_PMV_TIME_DIM_TMP TIME

1311: , null AS PY_FORECAST
1312: , null AS P_CHANGE2
1313: , null AS P_CHANGE21
1314: , null AS P_CHANGE22
1315: FROM PJI_PMV_TIME_DIM_TMP TIME
1316: , PJI_PMV_ORGZ_DIM_TMP HORG
1317: , PJI_PMV_ET_RT_DIM_TMP ET
1318: , PJI_FP_ORGO_ET_F_MV fct
1319: , PJI_PMV_ORG_DIM_TMP HOU

Line 1432: PJI_PMV_TIME_DIM_TMP TIME

1428: , null AS P_CHANGE2
1429: , null AS P_CHANGE21
1430: , null AS P_CHANGE22
1431: FROM
1432: PJI_PMV_TIME_DIM_TMP TIME
1433: , PJI_PMV_ORGZ_DIM_TMP HORG
1434: , PJI_PMV_WT_DIM_TMP WT
1435: , PJI_FP_ORGO_ET_WT_F_MV fct
1436: , PJI_PMV_ORG_DIM_TMP HOU

Line 1463: PJI_PMV_TIME_DIM_TMP TIME

1459: , null AS P_CHANGE2
1460: , null AS P_CHANGE21
1461: , null AS P_CHANGE22
1462: FROM
1463: PJI_PMV_TIME_DIM_TMP TIME
1464: , PJI_PMV_ORGZ_DIM_TMP HORG
1465: , PJI_PMV_WT_DIM_TMP WT
1466: , PJI_FP_ORGO_ET_WT_F_MV fct
1467: , PJI_PMV_ORG_DIM_TMP HOU

Line 1495: PJI_PMV_TIME_DIM_TMP TIME

1491: , null AS P_CHANGE2
1492: , null AS P_CHANGE21
1493: , null AS P_CHANGE22
1494: FROM
1495: PJI_PMV_TIME_DIM_TMP TIME
1496: , PJI_PMV_ORGZ_DIM_TMP HORG
1497: , PJI_PMV_WT_DIM_TMP WT
1498: , PJI_FP_ORGO_ET_WT_F_MV fct
1499: , PJI_PMV_ORG_DIM_TMP HOU

Line 1528: PJI_PMV_TIME_DIM_TMP TIME

1524: , null AS P_CHANGE2
1525: , null AS P_CHANGE21
1526: , null AS P_CHANGE22
1527: FROM
1528: PJI_PMV_TIME_DIM_TMP TIME
1529: , PJI_PMV_ORGZ_DIM_TMP HORG
1530: , PJI_PMV_WT_DIM_TMP WT
1531: , PJI_FP_ORGO_ET_WT_F_MV fct
1532: , PJI_PMV_ORG_DIM_TMP HOU

Line 1558: PJI_PMV_TIME_DIM_TMP TIME

1554: , null AS P_CHANGE2
1555: , null AS P_CHANGE21
1556: , null AS P_CHANGE22
1557: FROM
1558: PJI_PMV_TIME_DIM_TMP TIME
1559: , PJI_PMV_ORGZ_DIM_TMP HORG
1560: , PJI_PMV_WT_DIM_TMP WT
1561: , PJI_FP_ORGO_ET_WT_F_MV fct
1562: , PJI_PMV_ORG_DIM_TMP HOU

Line 1587: FROM PJI_PMV_TIME_DIM_TMP TIME

1583: , null AS PY_FORECAST
1584: , null AS P_CHANGE2
1585: , null AS P_CHANGE21
1586: , null AS P_CHANGE22
1587: FROM PJI_PMV_TIME_DIM_TMP TIME
1588: , PJI_PMV_ORGZ_DIM_TMP HORG
1589: , PJI_PMV_WT_DIM_TMP WT
1590: , PJI_FP_ORGO_ET_WT_F_MV fct
1591: , PJI_PMV_ORG_DIM_TMP HOU

Line 1704: PJI_PMV_TIME_DIM_TMP TIME

1700: , null AS P_CHANGE2
1701: , null AS P_CHANGE21
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

Line 1739: PJI_PMV_TIME_DIM_TMP TIME

1735: , null AS P_CHANGE2
1736: , null AS P_CHANGE21
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

Line 1774: PJI_PMV_TIME_DIM_TMP TIME

1770: , null AS P_CHANGE2
1771: , null AS P_CHANGE21
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

Line 1810: PJI_PMV_TIME_DIM_TMP TIME

1806: , null AS P_CHANGE2
1807: , null AS P_CHANGE21
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

Line 1845: PJI_PMV_TIME_DIM_TMP TIME

1841: , null AS P_CHANGE2
1842: , null AS P_CHANGE21
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

Line 1879: FROM PJI_PMV_TIME_DIM_TMP TIME

1875: , null AS PY_FORECAST
1876: , null AS P_CHANGE2
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

Line 1997: PJI_PMV_TIME_DIM_TMP TIME

1993: , null AS P_CHANGE2
1994: , null AS P_CHANGE21
1995: , null AS P_CHANGE22
1996: FROM
1997: PJI_PMV_TIME_DIM_TMP TIME
1998: , PJI_PMV_ORGZ_DIM_TMP HORG
1999: , PJI_PMV_ET_RT_DIM_TMP ET
2000: , PJI_PMV_WT_DIM_TMP WT
2001: , PJI_FP_ORGO_ET_WT_F_MV fct

Line 2031: PJI_PMV_TIME_DIM_TMP TIME

2027: , null AS P_CHANGE2
2028: , null AS P_CHANGE21
2029: , null AS P_CHANGE22
2030: FROM
2031: PJI_PMV_TIME_DIM_TMP TIME
2032: , PJI_PMV_ORGZ_DIM_TMP HORG
2033: , PJI_PMV_ET_RT_DIM_TMP ET
2034: , PJI_PMV_WT_DIM_TMP WT
2035: , PJI_FP_ORGO_ET_WT_F_MV fct

Line 2067: PJI_PMV_TIME_DIM_TMP TIME

2063: , null AS P_CHANGE2
2064: , null AS P_CHANGE21
2065: , null AS P_CHANGE22
2066: FROM
2067: PJI_PMV_TIME_DIM_TMP TIME
2068: , PJI_PMV_ORGZ_DIM_TMP HORG
2069: , PJI_PMV_ET_RT_DIM_TMP ET
2070: , PJI_PMV_WT_DIM_TMP WT
2071: , PJI_FP_ORGO_ET_WT_F_MV fct

Line 2103: PJI_PMV_TIME_DIM_TMP TIME

2099: , null AS P_CHANGE2
2100: , null AS P_CHANGE21
2101: , null AS P_CHANGE22
2102: FROM
2103: PJI_PMV_TIME_DIM_TMP TIME
2104: , PJI_PMV_ORGZ_DIM_TMP HORG
2105: , PJI_PMV_ET_RT_DIM_TMP ET
2106: , PJI_PMV_WT_DIM_TMP WT
2107: , PJI_FP_ORGO_ET_WT_F_MV fct

Line 2136: PJI_PMV_TIME_DIM_TMP TIME

2132: , null AS P_CHANGE2
2133: , null AS P_CHANGE21
2134: , null AS P_CHANGE22
2135: FROM
2136: PJI_PMV_TIME_DIM_TMP TIME
2137: , PJI_PMV_ORGZ_DIM_TMP HORG
2138: , PJI_PMV_ET_RT_DIM_TMP ET
2139: , PJI_PMV_WT_DIM_TMP WT
2140: , PJI_FP_ORGO_ET_WT_F_MV fct

Line 2168: FROM PJI_PMV_TIME_DIM_TMP TIME

2164: , null AS PY_FORECAST
2165: , null AS P_CHANGE2
2166: , null AS P_CHANGE21
2167: , null AS P_CHANGE22
2168: FROM PJI_PMV_TIME_DIM_TMP TIME
2169: , PJI_PMV_ORGZ_DIM_TMP HORG
2170: , PJI_PMV_ET_RT_DIM_TMP ET
2171: , PJI_PMV_WT_DIM_TMP WT
2172: , PJI_FP_ORGO_ET_WT_F_MV fct

Line 2286: PJI_PMV_TIME_DIM_TMP TIME

2282: , null AS P_CHANGE2
2283: , null AS P_CHANGE21
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

Line 2319: PJI_PMV_TIME_DIM_TMP TIME

2315: , null AS P_CHANGE2
2316: , null AS P_CHANGE21
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

Line 2353: PJI_PMV_TIME_DIM_TMP TIME

2349: , null AS P_CHANGE2
2350: , null AS P_CHANGE21
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

Line 2388: PJI_PMV_TIME_DIM_TMP TIME

2384: , null AS P_CHANGE2
2385: , null AS P_CHANGE21
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

Line 2420: PJI_PMV_TIME_DIM_TMP TIME

2416: , null AS P_CHANGE2
2417: , null AS P_CHANGE21
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

Line 2451: FROM PJI_PMV_TIME_DIM_TMP TIME

2447: , null AS PY_FORECAST
2448: , null AS P_CHANGE2
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

Line 2567: PJI_PMV_TIME_DIM_TMP TIME

2563: , null AS P_CHANGE2
2564: , null AS P_CHANGE21
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

Line 2603: PJI_PMV_TIME_DIM_TMP TIME

2599: , null AS P_CHANGE2
2600: , null AS P_CHANGE21
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

Line 2640: PJI_PMV_TIME_DIM_TMP TIME

2636: , null AS P_CHANGE2
2637: , null AS P_CHANGE21
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

Line 2678: PJI_PMV_TIME_DIM_TMP TIME

2674: , null AS P_CHANGE2
2675: , null AS P_CHANGE21
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

Line 2713: PJI_PMV_TIME_DIM_TMP TIME

2709: , null AS P_CHANGE2
2710: , null AS P_CHANGE21
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

Line 2747: FROM PJI_PMV_TIME_DIM_TMP TIME

2743: , null AS PY_FORECAST
2744: , null AS P_CHANGE2
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

Line 3346: FROM PJI_PMV_TIME_DIM_TMP TIME

3342: , DECODE(TIME.amount_type,2,FCT.FORECAST_REVENUE, 0) AS FORECAST_REVENUE
3343: , DECODE(TIME.amount_type,2,
3344: DECODE(G_Report_Cost_Type, 'BC', fct.forecast_burdened_cost,
3345: 'RC', fct.forecast_raw_cost, 0), 0) AS FORECAST_BURDENED_COST
3346: FROM PJI_PMV_TIME_DIM_TMP TIME
3347: , PJI_PMV_PRJ_DIM_TMP PRJ
3348: , PJI_PMV_ORGZ_DIM_TMP HORG
3349: , PJI_FP_PROJ_F FCT
3350: , PJI_PMV_ORG_DIM_TMP HOU

Line 3410: FROM PJI_PMV_TIME_DIM_TMP TIME

3406: , DECODE(TIME.amount_type,2,FCT.FORECAST_REVENUE, 0) AS FORECAST_REVENUE
3407: , DECODE(TIME.amount_type,2,
3408: DECODE(G_Report_Cost_Type, 'BC', fct.forecast_burdened_cost,
3409: 'RC', fct.forecast_raw_cost, 0), 0) AS FORECAST_BURDENED_COST
3410: FROM PJI_PMV_TIME_DIM_TMP TIME
3411: , PJI_PMV_PRJ_DIM_TMP PRJ
3412: , PJI_FP_PROJ_F FCT
3413: , PJI_PMV_ORG_DIM_TMP HOU
3414: WHERE 1=1

Line 3466: FROM PJI_PMV_TIME_DIM_TMP TIME

3462: , NULL AS CURR_BGT_REVENUE
3463: , NULL AS CURR_BGT_BURDENED_COST
3464: , NULL AS FORECAST_REVENUE
3465: , NULL AS FORECAST_BURDENED_COST
3466: FROM PJI_PMV_TIME_DIM_TMP TIME
3467: , PJI_PMV_PRJ_DIM_TMP PRJ
3468: , PJI_PMV_ET_RT_DIM_TMP ET
3469: , PJI_FP_PROJ_ET_F FCT
3470: , PJI_PMV_ORG_DIM_TMP HOU

Line 3528: FROM PJI_PMV_TIME_DIM_TMP TIME

3524: , NULL AS CURR_BGT_REVENUE
3525: , NULL AS CURR_BGT_BURDENED_COST
3526: , NULL AS FORECAST_REVENUE
3527: , NULL AS FORECAST_BURDENED_COST
3528: FROM PJI_PMV_TIME_DIM_TMP TIME
3529: , PJI_PMV_PRJ_DIM_TMP PRJ
3530: , PJI_PMV_WT_DIM_TMP WT
3531: , PJI_FP_PROJ_ET_WT_F FCT
3532: , PJI_PMV_ORG_DIM_TMP HOU

Line 3586: FROM PJI_PMV_TIME_DIM_TMP TIME

3582: , NULL AS CURR_BGT_REVENUE
3583: , NULL AS CURR_BGT_BURDENED_COST
3584: , NULL AS FORECAST_REVENUE
3585: , NULL AS FORECAST_BURDENED_COST
3586: FROM PJI_PMV_TIME_DIM_TMP TIME
3587: , PJI_PMV_PRJ_DIM_TMP PRJ
3588: , PJI_PMV_ET_RT_DIM_TMP ET
3589: , PJI_FP_PROJ_ET_F FCT
3590: , PJI_PMV_ORG_DIM_TMP HOU

Line 3647: FROM PJI_PMV_TIME_DIM_TMP TIME

3643: , NULL AS CURR_BGT_REVENUE
3644: , NULL AS CURR_BGT_BURDENED_COST
3645: , NULL AS FORECAST_REVENUE
3646: , NULL AS FORECAST_BURDENED_COST
3647: FROM PJI_PMV_TIME_DIM_TMP TIME
3648: , PJI_PMV_PRJ_DIM_TMP PRJ
3649: , PJI_PMV_ET_RT_DIM_TMP ET
3650: , PJI_PMV_WT_DIM_TMP WT
3651: , PJI_FP_PROJ_ET_WT_F FCT

Line 3711: FROM PJI_PMV_TIME_DIM_TMP TIME

3707: , NULL AS CURR_BGT_REVENUE
3708: , NULL AS CURR_BGT_BURDENED_COST
3709: , NULL AS FORECAST_REVENUE
3710: , NULL AS FORECAST_BURDENED_COST
3711: FROM PJI_PMV_TIME_DIM_TMP TIME
3712: , PJI_PMV_PRJ_DIM_TMP PRJ
3713: , PJI_PMV_WT_DIM_TMP WT
3714: , PJI_FP_PROJ_ET_WT_F FCT
3715: , PJI_PMV_ORG_DIM_TMP HOU

Line 3767: FROM PJI_PMV_TIME_DIM_TMP TIME

3763: , NULL AS CURR_BGT_REVENUE
3764: , NULL AS CURR_BGT_BURDENED_COST
3765: , NULL AS FORECAST_REVENUE
3766: , NULL AS FORECAST_BURDENED_COST
3767: FROM PJI_PMV_TIME_DIM_TMP TIME
3768: , PJI_PMV_PRJ_DIM_TMP PRJ
3769: , PJI_PMV_ET_RT_DIM_TMP ET
3770: , PJI_PMV_WT_DIM_TMP WT
3771: , PJI_FP_PROJ_ET_WT_F FCT

Line 4151: PJI_PMV_TIME_DIM_TMP TIME

4147: , 0 AS CT_BURDENED_COST
4148: , 0 AS CT_FORECAST_REVENUE
4149: , 0 AS CT_FORECAST_BURDENED_COST
4150: FROM
4151: PJI_PMV_TIME_DIM_TMP TIME
4152: , PJI_PMV_ORGZ_DIM_TMP HORG
4153: , PJI_FP_ORGO_F_MV fct
4154: , PJI_PMV_ORG_DIM_TMP HOU
4155:

Line 4189: PJI_PMV_TIME_DIM_TMP TIME

4185: DECODE(G_Report_Cost_Type, 'BC', fct.curr_bgt_burdened_cost,
4186: 'RC', fct.curr_bgt_raw_cost, 0)
4187: ,0) AS CT_FORECAST_BURDENED_COST
4188: FROM
4189: PJI_PMV_TIME_DIM_TMP TIME
4190: , PJI_PMV_ORGZ_DIM_TMP HORG
4191: , PJI_FP_ORGO_F_MV fct
4192: , PJI_PMV_ORG_DIM_TMP HOU
4193: WHERE

Line 4342: PJI_PMV_TIME_DIM_TMP TIME

4338: , 0 AS CT_BURDENED_COST
4339: , 0 AS CT_FORECAST_REVENUE
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

Line 4381: PJI_PMV_TIME_DIM_TMP TIME

4377: 'RC', fct.curr_bgt_raw_cost, 0), 0) AS
4378:
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

Line 4551: PJI_PMV_TIME_DIM_TMP TIME

4547: , 0 AS CT_BURDENED_COST
4548: , NULL AS CT_FORECAST_REVENUE
4549: , NULL AS CT_FORECAST_BURDENED_COST
4550: FROM
4551: PJI_PMV_TIME_DIM_TMP TIME
4552: , PJI_PMV_ORGZ_DIM_TMP HORG
4553: , PJI_PMV_ET_RT_DIM_TMP ET
4554: , PJI_FP_ORGO_ET_F_MV fct
4555: , PJI_PMV_ORG_DIM_TMP HOU

Line 4585: PJI_PMV_TIME_DIM_TMP TIME

4581: , 0 AS CT_BURDENED_COST
4582: , NULL AS CT_FORECAST_REVENUE
4583: , NULL AS CT_FORECAST_BURDENED_COST
4584: FROM
4585: PJI_PMV_TIME_DIM_TMP TIME
4586: , PJI_PMV_ORGZ_DIM_TMP HORG
4587: , PJI_PMV_ET_RT_DIM_TMP ET
4588: , PJI_FP_ORGO_ET_F_MV fct
4589: , PJI_PMV_ORG_DIM_TMP HOU

Line 4754: PJI_PMV_TIME_DIM_TMP TIME

4750: , 0 AS CT_BURDENED_COST
4751: , NULL AS CT_FORECAST_REVENUE
4752: , NULL AS CT_FORECAST_BURDENED_COST
4753: FROM
4754: PJI_PMV_TIME_DIM_TMP TIME
4755: , PJI_PMV_ORGZ_DIM_TMP HORG
4756: , PJI_PMV_WT_DIM_TMP WT
4757: , PJI_FP_ORGO_ET_WT_F_MV fct
4758: , PJI_PMV_ORG_DIM_TMP HOU

Line 4787: PJI_PMV_TIME_DIM_TMP TIME

4783: , 0 AS CT_BURDENED_COST
4784: , NULL AS CT_FORECAST_REVENUE
4785: , NULL AS CT_FORECAST_BURDENED_COST
4786: FROM
4787: PJI_PMV_TIME_DIM_TMP TIME
4788: , PJI_PMV_ORGZ_DIM_TMP HORG
4789: , PJI_PMV_WT_DIM_TMP WT
4790: , PJI_FP_ORGO_ET_WT_F_MV fct
4791: , PJI_PMV_ORG_DIM_TMP HOU

Line 4952: PJI_PMV_TIME_DIM_TMP TIME

4948: , 0 AS CT_BURDENED_COST
4949: , NULL AS CT_FORECAST_REVENUE
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

Line 4988: PJI_PMV_TIME_DIM_TMP TIME

4984: , 0 AS CT_BURDENED_COST
4985: , NULL AS CT_FORECAST_REVENUE
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

Line 5179: PJI_PMV_TIME_DIM_TMP TIME

5175: , 0 AS CT_BURDENED_COST
5176: , NULL AS CT_FORECAST_REVENUE
5177: , NULL AS CT_FORECAST_BURDENED_COST
5178: FROM
5179: PJI_PMV_TIME_DIM_TMP TIME
5180: , PJI_PMV_ORGZ_DIM_TMP HORG
5181: , PJI_PMV_ET_RT_DIM_TMP ET
5182: , PJI_PMV_WT_DIM_TMP WT
5183: , PJI_FP_ORGO_ET_WT_F_MV fct

Line 5215: PJI_PMV_TIME_DIM_TMP TIME

5211: , 0 AS CT_BURDENED_COST
5212: , NULL AS CT_FORECAST_REVENUE
5213: , NULL AS CT_FORECAST_BURDENED_COST
5214: FROM
5215: PJI_PMV_TIME_DIM_TMP TIME
5216: , PJI_PMV_ORGZ_DIM_TMP HORG
5217: , PJI_PMV_ET_RT_DIM_TMP ET
5218: , PJI_PMV_WT_DIM_TMP WT
5219: , PJI_FP_ORGO_ET_WT_F_MV fct

Line 5408: PJI_PMV_TIME_DIM_TMP TIME

5404: , 0 AS CT_BURDENED_COST
5405: , NULL AS CT_FORECAST_REVENUE
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

Line 5443: PJI_PMV_TIME_DIM_TMP TIME

5439: , 0 AS CT_BURDENED_COST
5440: , NULL AS CT_FORECAST_REVENUE
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

Line 5632: PJI_PMV_TIME_DIM_TMP TIME

5628: , 0 AS CT_BURDENED_COST
5629: , NULL AS CT_FORECAST_REVENUE
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

Line 5670: PJI_PMV_TIME_DIM_TMP TIME

5666: , 0 AS CT_BURDENED_COST
5667: , NULL AS CT_FORECAST_REVENUE
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