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_ORG_DIM_TMP

Line 594: , PJI_PMV_ORG_DIM_TMP HOU

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
596: fct.org_id = hou.id
597: AND FCT.ORGANIZATION_ID = HORG.ID
598: AND FCT.TIME_ID = TIME.ID

Line 622: , PJI_PMV_ORG_DIM_TMP HOU

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:
624: WHERE
625: fct.org_id = hou.id
626: AND FCT.ORGANIZATION_ID = HORG.ID

Line 655: , PJI_PMV_ORG_DIM_TMP HOU

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:
657: WHERE
658: fct.org_id = hou.id
659: AND FCT.ORGANIZATION_ID = HORG.ID

Line 688: , PJI_PMV_ORG_DIM_TMP HOU

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:
690: WHERE
691: fct.org_id = hou.id
692: AND FCT.ORGANIZATION_ID = HORG.ID

Line 722: , PJI_PMV_ORG_DIM_TMP HOU

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
724: fct.org_id = hou.id
725: AND FCT.ORGANIZATION_ID = HORG.ID
726: AND FCT.TIME_ID = TIME.ID

Line 754: , PJI_PMV_ORG_DIM_TMP HOU

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
756: fct.org_id = hou.id
757: AND FCT.ORGANIZATION_ID = HORG.ID
758: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 871: , PJI_PMV_ORG_DIM_TMP HOU

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
874: FCT.PROJECT_ORG_ID = HOU.ID
875: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 902: , PJI_PMV_ORG_DIM_TMP HOU

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
905: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
906: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 936: , PJI_PMV_ORG_DIM_TMP HOU

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
939: FCT.PROJECT_ORG_ID = HOU.ID
940: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 971: , PJI_PMV_ORG_DIM_TMP HOU

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
974: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
975: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 1005: , PJI_PMV_ORG_DIM_TMP HOU

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
1008: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1009: AND FCT.TIME_ID = TIME.ID

Line 1038: , PJI_PMV_ORG_DIM_TMP HOU

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
1041: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1042: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 1155: , PJI_PMV_ORG_DIM_TMP HOU

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
1156:
1157: WHERE
1158: FCT.ORG_ID = HOU.ID
1159: AND FCT.ORGANIZATION_ID = HORG.ID

Line 1187: , PJI_PMV_ORG_DIM_TMP HOU

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
1188: WHERE
1189: FCT.ORG_ID = HOU.ID
1190: AND FCT.ORGANIZATION_ID = HORG.ID
1191: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 1220: , PJI_PMV_ORG_DIM_TMP HOU

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
1221:
1222: WHERE
1223: FCT.ORG_ID = HOU.ID
1224: AND FCT.ORGANIZATION_ID = HORG.ID

Line 1254: , PJI_PMV_ORG_DIM_TMP HOU

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
1255: WHERE
1256: FCT.ORG_ID = HOU.ID
1257: AND FCT.ORGANIZATION_ID = HORG.ID
1258: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 1287: , PJI_PMV_ORG_DIM_TMP HOU

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
1288: WHERE
1289: FCT.ORG_ID = HOU.ID
1290: AND FCT.ORGANIZATION_ID = HORG.ID
1291: AND FCT.TIME_ID = TIME.ID

Line 1319: , PJI_PMV_ORG_DIM_TMP HOU

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
1320: WHERE
1321: FCT.ORG_ID = HOU.ID
1322: AND FCT.ORGANIZATION_ID = HORG.ID
1323: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 1436: , PJI_PMV_ORG_DIM_TMP HOU

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
1437:
1438: WHERE
1439: FCT.ORG_ID = HOU.ID
1440: AND FCT.ORGANIZATION_ID = HORG.ID

Line 1467: , PJI_PMV_ORG_DIM_TMP HOU

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
1468: WHERE
1469: FCT.ORG_ID = HOU.ID
1470: AND FCT.ORGANIZATION_ID = HORG.ID
1471: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 1499: , PJI_PMV_ORG_DIM_TMP HOU

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
1500:
1501: WHERE
1502: FCT.ORG_ID = HOU.ID
1503: AND FCT.ORGANIZATION_ID = HORG.ID

Line 1532: , PJI_PMV_ORG_DIM_TMP HOU

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
1533: WHERE
1534: FCT.ORG_ID = HOU.ID
1535: AND FCT.ORGANIZATION_ID = HORG.ID
1536: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 1562: , PJI_PMV_ORG_DIM_TMP HOU

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
1563: WHERE
1564: FCT.ORG_ID = HOU.ID
1565: AND FCT.ORGANIZATION_ID = HORG.ID
1566: AND FCT.TIME_ID = TIME.ID

Line 1591: , PJI_PMV_ORG_DIM_TMP HOU

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
1592: WHERE
1593: FCT.ORG_ID = HOU.ID
1594: AND FCT.ORGANIZATION_ID = HORG.ID
1595: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 1709: , PJI_PMV_ORG_DIM_TMP HOU

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:
1711: WHERE
1712: FCT.PROJECT_ORG_ID = HOU.ID
1713: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 1744: , PJI_PMV_ORG_DIM_TMP HOU

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
1746: FCT.PROJECT_ORG_ID = HOU.ID
1747: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1748: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 1779: , PJI_PMV_ORG_DIM_TMP HOU

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:
1781: WHERE
1782: FCT.PROJECT_ORG_ID = HOU.ID
1783: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 1815: , PJI_PMV_ORG_DIM_TMP HOU

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
1817: FCT.PROJECT_ORG_ID = HOU.ID
1818: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1819: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 1850: , PJI_PMV_ORG_DIM_TMP HOU

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
1852: FCT.PROJECT_ORG_ID = HOU.ID
1853: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1854: AND FCT.TIME_ID = TIME.ID

Line 1884: , PJI_PMV_ORG_DIM_TMP HOU

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
1886: FCT.PROJECT_ORG_ID = HOU.ID
1887: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
1888: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 2002: , PJI_PMV_ORG_DIM_TMP HOU

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
2002: , PJI_PMV_ORG_DIM_TMP HOU
2003:
2004: WHERE
2005: FCT.ORG_ID = HOU.ID
2006: AND FCT.ORGANIZATION_ID = HORG.ID

Line 2036: , PJI_PMV_ORG_DIM_TMP HOU

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
2036: , PJI_PMV_ORG_DIM_TMP HOU
2037: WHERE
2038: FCT.ORG_ID = HOU.ID
2039: AND FCT.ORGANIZATION_ID = HORG.ID
2040: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 2072: , PJI_PMV_ORG_DIM_TMP HOU

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
2072: , PJI_PMV_ORG_DIM_TMP HOU
2073:
2074: WHERE
2075: FCT.ORG_ID = HOU.ID
2076: AND FCT.ORGANIZATION_ID = HORG.ID

Line 2108: , PJI_PMV_ORG_DIM_TMP HOU

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
2108: , PJI_PMV_ORG_DIM_TMP HOU
2109: WHERE
2110: FCT.ORG_ID = HOU.ID
2111: AND FCT.ORGANIZATION_ID = HORG.ID
2112: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 2141: , PJI_PMV_ORG_DIM_TMP HOU

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
2141: , PJI_PMV_ORG_DIM_TMP HOU
2142: WHERE
2143: FCT.ORG_ID = HOU.ID
2144: AND FCT.ORGANIZATION_ID = HORG.ID
2145: AND FCT.TIME_ID = TIME.ID

Line 2173: , PJI_PMV_ORG_DIM_TMP HOU

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
2173: , PJI_PMV_ORG_DIM_TMP HOU
2174: WHERE
2175: FCT.ORG_ID = HOU.ID
2176: AND FCT.ORGANIZATION_ID = HORG.ID
2177: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 2291: , PJI_PMV_ORG_DIM_TMP HOU

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:
2293: WHERE
2294: FCT.PROJECT_ORG_ID = HOU.ID
2295: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 2324: , PJI_PMV_ORG_DIM_TMP HOU

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
2326: FCT.PROJECT_ORG_ID = HOU.ID
2327: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
2328: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 2358: , PJI_PMV_ORG_DIM_TMP HOU

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:
2360: WHERE
2361: FCT.PROJECT_ORG_ID = HOU.ID
2362: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 2393: , PJI_PMV_ORG_DIM_TMP HOU

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
2395: FCT.PROJECT_ORG_ID = HOU.ID
2396: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
2397: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 2425: , PJI_PMV_ORG_DIM_TMP HOU

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
2427: FCT.PROJECT_ORG_ID = HOU.ID
2428: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
2429: AND FCT.TIME_ID = TIME.ID

Line 2456: , PJI_PMV_ORG_DIM_TMP HOU

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
2458: FCT.PROJECT_ORG_ID = HOU.ID
2459: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
2460: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 2573: , PJI_PMV_ORG_DIM_TMP HOU

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
2574:
2575: WHERE
2576: FCT.PROJECT_ORG_ID = HOU.ID
2577: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 2609: , PJI_PMV_ORG_DIM_TMP HOU

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
2610: WHERE
2611: FCT.PROJECT_ORG_ID = HOU.ID
2612: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
2613: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 2646: , PJI_PMV_ORG_DIM_TMP HOU

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
2647:
2648: WHERE
2649: FCT.PROJECT_ORG_ID = HOU.ID
2650: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID

Line 2684: , PJI_PMV_ORG_DIM_TMP HOU

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
2685: WHERE
2686: FCT.PROJECT_ORG_ID = HOU.ID
2687: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
2688: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 2719: , PJI_PMV_ORG_DIM_TMP HOU

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
2720: WHERE
2721: FCT.PROJECT_ORG_ID = HOU.ID
2722: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
2723: AND FCT.TIME_ID = TIME.ID

Line 2753: , PJI_PMV_ORG_DIM_TMP HOU

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
2754: WHERE
2755: FCT.PROJECT_ORG_ID = HOU.ID
2756: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
2757: AND FCT.TIME_ID = TIME.PRIOR_ID

Line 3350: , PJI_PMV_ORG_DIM_TMP HOU

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
3351: WHERE 1=1
3352: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3353: AND FCT.PROJECT_ID = PRJ.ID
3354: AND FCT.PROJECT_ORG_ID = HOU.ID

Line 3413: , PJI_PMV_ORG_DIM_TMP HOU

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
3415: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3416: AND FCT.PROJECT_ID = PRJ.ID
3417: AND FCT.PROJECT_ORG_ID = HOU.ID

Line 3470: , PJI_PMV_ORG_DIM_TMP HOU

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
3471: WHERE 1=1
3472: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3473: AND FCT.PROJECT_ID = PRJ.ID
3474: AND FCT.EXP_EVT_TYPE_ID = ET.ID

Line 3532: , PJI_PMV_ORG_DIM_TMP HOU

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
3533: WHERE 1=1
3534: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3535: AND FCT.PROJECT_ID = PRJ.ID
3536: AND FCT.WORK_TYPE_ID = WT.ID

Line 3590: , PJI_PMV_ORG_DIM_TMP HOU

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
3591: WHERE 1=1
3592: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3593: AND FCT.PROJECT_ID = PRJ.ID
3594: AND FCT.EXP_EVT_TYPE_ID = ET.ID

Line 3652: , PJI_PMV_ORG_DIM_TMP HOU

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
3652: , PJI_PMV_ORG_DIM_TMP HOU
3653: WHERE 1=1
3654: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3655: AND FCT.PROJECT_ID = PRJ.ID
3656: AND FCT.EXP_EVT_TYPE_ID = ET.ID

Line 3715: , PJI_PMV_ORG_DIM_TMP HOU

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
3716: WHERE 1=1
3717: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3718: AND FCT.PROJECT_ID = PRJ.ID
3719: AND FCT.WORK_TYPE_ID = WT.ID

Line 3772: , PJI_PMV_ORG_DIM_TMP HOU

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
3772: , PJI_PMV_ORG_DIM_TMP HOU
3773: WHERE 1=1
3774: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id
3775: AND FCT.PROJECT_ID = PRJ.ID
3776: AND FCT.EXP_EVT_TYPE_ID = ET.ID

Line 4154: , PJI_PMV_ORG_DIM_TMP HOU

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:
4156: WHERE
4157: fct.org_id = hou.id
4158: AND FCT.ORGANIZATION_ID = HORG.ID

Line 4192: , PJI_PMV_ORG_DIM_TMP HOU

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
4194: fct.org_id = hou.id
4195: AND FCT.ORGANIZATION_ID = HORG.ID
4196: AND FCT.TIME_ID = TIME.ID

Line 4228: , PJI_PMV_ORG_DIM_TMP HOU

4224: FROM
4225: PJI_PMV_TCMP_DIM_TMP TIME
4226: , PJI_PMV_ORGZ_DIM_TMP HORG
4227: , PJI_FP_ORGO_F_MV fct
4228: , PJI_PMV_ORG_DIM_TMP HOU
4229: WHERE
4230: fct.org_id = hou.id
4231: AND FCT.ORGANIZATION_ID = HORG.ID
4232: AND FCT.TIME_ID = TIME.ID

Line 4255: FROM PJI_PMV_ORG_DIM_TMP HOU

4251: , 0 AS CT_REVENUE
4252: , 0 AS CT_BURDENED_COST
4253: , 0 AS CT_FORECAST_REVENUE
4254: , 0 AS CT_FORECAST_BURDENED_COST
4255: FROM PJI_PMV_ORG_DIM_TMP HOU
4256: WHERE HOU.NAME <> '-1'
4257: UNION ALL -- FORCE Creation of Organization Rows
4258: SELECT '-1' AS ORG_ID
4259: , HORG.NAME AS ORGANIZATION_ID

Line 4346: , PJI_PMV_ORG_DIM_TMP HOU

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
4349: AND FCT.project_ORGANIZATION_ID = HORG.ID
4350: AND FCT.TIME_ID = TIME.ID

Line 4385: , PJI_PMV_ORG_DIM_TMP HOU

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
4388: AND FCT.project_ORGANIZATION_ID = HORG.ID
4389: AND FCT.TIME_ID = TIME.ID

Line 4425: , PJI_PMV_ORG_DIM_TMP HOU

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
4428: AND FCT.project_ORGANIZATION_ID = HORG.ID
4429: AND FCT.TIME_ID = TIME.ID

Line 4453: FROM PJI_PMV_ORG_DIM_TMP HOU

4449: , 0 AS CT_REVENUE
4450: , 0 AS CT_BURDENED_COST
4451: , 0 AS CT_FORECAST_REVENUE
4452: , 0 AS CT_FORECAST_BURDENED_COST
4453: FROM PJI_PMV_ORG_DIM_TMP HOU
4454: WHERE HOU.NAME <> '-1'
4455: UNION ALL -- FORCE Creation of Organization Rows
4456: SELECT '-1' AS ORG_ID
4457: , HORG.NAME AS ORGANIZATION_ID

Line 4555: , PJI_PMV_ORG_DIM_TMP HOU

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
4556: WHERE
4557: fct.org_id = hou.id
4558: AND FCT.ORGANIZATION_ID = HORG.ID
4559: AND FCT.TIME_ID = TIME.ID

Line 4589: , PJI_PMV_ORG_DIM_TMP HOU

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
4590: WHERE
4591: fct.org_id = hou.id
4592: AND FCT.ORGANIZATION_ID = HORG.ID
4593: AND FCT.TIME_ID = TIME.ID

Line 4626: , PJI_PMV_ORG_DIM_TMP HOU

4622: PJI_PMV_TCMP_DIM_TMP TIME
4623: , PJI_PMV_ORGZ_DIM_TMP HORG
4624: , PJI_PMV_ET_RT_DIM_TMP ET
4625: , PJI_FP_ORGO_ET_F_MV fct
4626: , PJI_PMV_ORG_DIM_TMP HOU
4627: WHERE
4628: fct.org_id = hou.id
4629: AND FCT.ORGANIZATION_ID = HORG.ID
4630: AND FCT.TIME_ID = TIME.ID

Line 4655: FROM PJI_PMV_ORG_DIM_TMP HOU

4651: , 0 AS CT_REVENUE
4652: , 0 AS CT_BURDENED_COST
4653: , 0 AS CT_FORECAST_REVENUE
4654: , 0 AS CT_FORECAST_BURDENED_COST
4655: FROM PJI_PMV_ORG_DIM_TMP HOU
4656: WHERE HOU.NAME <> '-1'
4657: UNION ALL -- FORCE Creation of Organization Rows
4658: SELECT '-1' AS ORG_ID
4659: , HORG.NAME AS ORGANIZATION_ID

Line 4758: , PJI_PMV_ORG_DIM_TMP HOU

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
4759: WHERE
4760: fct.org_id = hou.id
4761: AND FCT.ORGANIZATION_ID = HORG.ID
4762: AND FCT.TIME_ID = TIME.ID

Line 4791: , PJI_PMV_ORG_DIM_TMP HOU

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
4792: WHERE
4793: fct.org_id = hou.id
4794: AND FCT.ORGANIZATION_ID = HORG.ID
4795: AND FCT.TIME_ID = TIME.ID

Line 4827: , PJI_PMV_ORG_DIM_TMP HOU

4823: PJI_PMV_TCMP_DIM_TMP TIME
4824: , PJI_PMV_ORGZ_DIM_TMP HORG
4825: , PJI_PMV_WT_DIM_TMP WT
4826: , PJI_FP_ORGO_ET_WT_F_MV fct
4827: , PJI_PMV_ORG_DIM_TMP HOU
4828: WHERE
4829: fct.org_id = hou.id
4830: AND FCT.ORGANIZATION_ID = HORG.ID
4831: AND FCT.TIME_ID = TIME.ID

Line 4855: FROM PJI_PMV_ORG_DIM_TMP HOU

4851: , 0 AS CT_REVENUE
4852: , 0 AS CT_BURDENED_COST
4853: , 0 AS CT_FORECAST_REVENUE
4854: , 0 AS CT_FORECAST_BURDENED_COST
4855: FROM PJI_PMV_ORG_DIM_TMP HOU
4856: WHERE HOU.NAME <> '-1'
4857: UNION ALL -- FORCE Creation of Organization Rows
4858: SELECT '-1' AS ORG_ID
4859: , HORG.NAME AS ORGANIZATION_ID

Line 4957: , PJI_PMV_ORG_DIM_TMP HOU

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
4959: fct.project_org_id = hou.id
4960: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
4961: AND FCT.TIME_ID = TIME.ID

Line 4993: , PJI_PMV_ORG_DIM_TMP HOU

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
4995: fct.project_org_id = hou.id
4996: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
4997: AND FCT.TIME_ID = TIME.ID

Line 5032: , PJI_PMV_ORG_DIM_TMP HOU

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
5034: fct.project_org_id = hou.id
5035: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
5036: AND FCT.TIME_ID = TIME.ID

Line 5062: FROM PJI_PMV_ORG_DIM_TMP HOU

5058: , 0 AS CT_REVENUE
5059: , 0 AS CT_BURDENED_COST
5060: , 0 AS CT_FORECAST_REVENUE
5061: , 0 AS CT_FORECAST_BURDENED_COST
5062: FROM PJI_PMV_ORG_DIM_TMP HOU
5063: WHERE HOU.NAME <> '-1'
5064: UNION ALL -- FORCE Creation of Organization Rows
5065: SELECT '-1' AS ORG_ID
5066: , HORG.NAME AS ORGANIZATION_ID

Line 5184: , PJI_PMV_ORG_DIM_TMP HOU

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
5184: , PJI_PMV_ORG_DIM_TMP HOU
5185: WHERE
5186: fct.org_id = hou.id
5187: AND FCT.ORGANIZATION_ID = HORG.ID
5188: AND FCT.TIME_ID = TIME.ID

Line 5220: , PJI_PMV_ORG_DIM_TMP HOU

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
5220: , PJI_PMV_ORG_DIM_TMP HOU
5221: WHERE
5222: fct.org_id = hou.id
5223: AND FCT.ORGANIZATION_ID = HORG.ID
5224: AND FCT.TIME_ID = TIME.ID

Line 5259: , PJI_PMV_ORG_DIM_TMP HOU

5255: , PJI_PMV_ORGZ_DIM_TMP HORG
5256: , PJI_PMV_ET_RT_DIM_TMP ET
5257: , PJI_PMV_WT_DIM_TMP WT
5258: , PJI_FP_ORGO_ET_WT_F_MV fct
5259: , PJI_PMV_ORG_DIM_TMP HOU
5260: WHERE
5261: fct.org_id = hou.id
5262: AND FCT.ORGANIZATION_ID = HORG.ID
5263: AND FCT.TIME_ID = TIME.ID

Line 5289: FROM PJI_PMV_ORG_DIM_TMP HOU

5285: , 0 AS CT_REVENUE
5286: , 0 AS CT_BURDENED_COST
5287: , 0 AS CT_FORECAST_REVENUE
5288: , 0 AS CT_FORECAST_BURDENED_COST
5289: FROM PJI_PMV_ORG_DIM_TMP HOU
5290: WHERE HOU.NAME <> '-1'
5291: UNION ALL -- FORCE Creation of Organization Rows
5292: SELECT '-1' AS ORG_ID
5293: , HORG.NAME AS ORGANIZATION_ID

Line 5413: , PJI_PMV_ORG_DIM_TMP HOU

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
5415: fct.project_org_id = hou.id
5416: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
5417: AND FCT.TIME_ID = TIME.ID

Line 5448: , PJI_PMV_ORG_DIM_TMP HOU

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
5450: fct.project_org_id = hou.id
5451: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
5452: AND FCT.TIME_ID = TIME.ID

Line 5486: , PJI_PMV_ORG_DIM_TMP HOU

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
5488: fct.project_org_id = hou.id
5489: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
5490: AND FCT.TIME_ID = TIME.ID

Line 5515: FROM PJI_PMV_ORG_DIM_TMP HOU

5511: , 0 AS CT_REVENUE
5512: , 0 AS CT_BURDENED_COST
5513: , 0 AS CT_FORECAST_REVENUE
5514: , 0 AS CT_FORECAST_BURDENED_COST
5515: FROM PJI_PMV_ORG_DIM_TMP HOU
5516: WHERE HOU.NAME <> '-1'
5517: UNION ALL -- FORCE Creation of Organization Rows
5518: SELECT '-1' AS ORG_ID
5519: , HORG.NAME AS ORGANIZATION_ID

Line 5638: , PJI_PMV_ORG_DIM_TMP HOU

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
5639: WHERE
5640: fct.project_org_id = hou.id
5641: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
5642: AND FCT.TIME_ID = TIME.ID

Line 5676: , PJI_PMV_ORG_DIM_TMP HOU

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
5677: WHERE
5678: fct.project_org_id = hou.id
5679: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
5680: AND FCT.TIME_ID = TIME.ID

Line 5717: , PJI_PMV_ORG_DIM_TMP HOU

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
5718: WHERE
5719: fct.project_org_id = hou.id
5720: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
5721: AND FCT.TIME_ID = TIME.ID

Line 5748: FROM PJI_PMV_ORG_DIM_TMP HOU

5744: , 0 AS CT_REVENUE
5745: , 0 AS CT_BURDENED_COST
5746: , 0 AS CT_FORECAST_REVENUE
5747: , 0 AS CT_FORECAST_BURDENED_COST
5748: FROM PJI_PMV_ORG_DIM_TMP HOU
5749: WHERE HOU.NAME <> '-1'
5750: UNION ALL -- FORCE Creation of Organization Rows
5751: SELECT '-1' AS ORG_ID
5752: , HORG.NAME AS ORGANIZATION_ID