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_CAPITAL_COST dependencies on PJI_PMV_ORGZ_DIM_TMP

Line 399: , PJI_PMV_ORGZ_DIM_TMP HORG

395: , 0 CT_EXPENSE
396: , 0 EXPENSE_CHANGE_PRCNT
397: from
398: PJI_PMV_TIME_DIM_TMP TIME
399: , PJI_PMV_ORGZ_DIM_TMP HORG
400: , PJI_FP_ORGO_F_MV FCT
401: , PJI_PMV_ORG_DIM_TMP HOU
402: where
403: FCT.ORG_ID = HOU.ID

Line 441: , PJI_PMV_ORGZ_DIM_TMP HORG

437: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) as CT_EXPENSE
438: , 0 EXPENSE_CHANGE_PRCNT
439: from
440: PJI_PMV_TCMP_DIM_TMP TIME
441: , PJI_PMV_ORGZ_DIM_TMP HORG
442: , PJI_FP_ORGO_F_MV FCT
443: , PJI_PMV_ORG_DIM_TMP HOU
444: where
445: FCT.ORG_ID = HOU.ID

Line 493: from PJI_PMV_ORGZ_DIM_TMP HORG

489: , 0 PRCNT_OF_COST_CHANGE
490: , 0 EXPENSE
491: , 0 CT_EXPENSE
492: , 0 EXPENSE_CHANGE_PRCNT
493: from PJI_PMV_ORGZ_DIM_TMP HORG
494: where HORG.NAME <> '-1'
495: ) WHERE 1 = 1
496: group by ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,
497: EXPENDITURE_TYPE_ID, WORK_TYPE_ID;

Line 563: , PJI_PMV_ORGZ_DIM_TMP HORG

559: , 0 CT_EXPENSE
560: , 0 EXPENSE_CHANGE_PRCNT
561: from
562: PJI_PMV_TIME_DIM_TMP TIME
563: , PJI_PMV_ORGZ_DIM_TMP HORG
564: , PJI_PMV_CLS_DIM_TMP CLS
565: , PJI_FP_CLSO_F_MV FCT
566: , PJI_PMV_ORG_DIM_TMP HOU
567: where

Line 607: , PJI_PMV_ORGZ_DIM_TMP HORG

603: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) as CT_EXPENSE
604: , 0 EXPENSE_CHANGE_PRCNT
605: from
606: PJI_PMV_TCMP_DIM_TMP TIME
607: , PJI_PMV_ORGZ_DIM_TMP HORG
608: , PJI_PMV_CLS_DIM_TMP CLS
609: , PJI_FP_CLSO_F_MV FCT
610: , PJI_PMV_ORG_DIM_TMP HOU
611: where

Line 661: from PJI_PMV_ORGZ_DIM_TMP HORG

657: , 0 PRCNT_OF_COST_CHANGE
658: , 0 EXPENSE
659: , 0 CT_EXPENSE
660: , 0 EXPENSE_CHANGE_PRCNT
661: from PJI_PMV_ORGZ_DIM_TMP HORG
662: where HORG.NAME <> '-1'
663: union all -- FORCE Creation of Class Rows
664: select '-1' AS ORG_ID
665: , '-1' AS ORGANIZATION_ID

Line 752: , PJI_PMV_ORGZ_DIM_TMP HORG

748: , 0 CT_EXPENSE
749: , 0 EXPENSE_CHANGE_PRCNT
750: from
751: PJI_PMV_TIME_DIM_TMP TIME
752: , PJI_PMV_ORGZ_DIM_TMP HORG
753: , PJI_PMV_ET_RT_DIM_TMP ET
754: , PJI_FP_ORGO_ET_F_MV FCT
755: , PJI_PMV_ORG_DIM_TMP HOU
756: where

Line 797: , PJI_PMV_ORGZ_DIM_TMP HORG

793: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) as CT_EXPENSE
794: , 0 EXPENSE_CHANGE_PRCNT
795: from
796: PJI_PMV_TCMP_DIM_TMP TIME
797: , PJI_PMV_ORGZ_DIM_TMP HORG
798: , PJI_PMV_ET_RT_DIM_TMP ET
799: , PJI_FP_ORGO_ET_F_MV FCT
800: , PJI_PMV_ORG_DIM_TMP HOU
801: where

Line 852: from PJI_PMV_ORGZ_DIM_TMP HORG

848: , 0 PRCNT_OF_COST_CHANGE
849: , 0 EXPENSE
850: , 0 CT_EXPENSE
851: , 0 EXPENSE_CHANGE_PRCNT
852: from PJI_PMV_ORGZ_DIM_TMP HORG
853: where HORG.NAME <> '-1'
854: union all -- FORCE Creation of Expenditure Type Rows
855: select '-1' as ORG_ID
856: , '-1' as ORGANIZATION_ID

Line 943: , PJI_PMV_ORGZ_DIM_TMP HORG

939: , 0 CT_EXPENSE
940: , 0 EXPENSE_CHANGE_PRCNT
941: from
942: PJI_PMV_TIME_DIM_TMP TIME
943: , PJI_PMV_ORGZ_DIM_TMP HORG
944: , PJI_PMV_WT_DIM_TMP WT
945: , PJI_FP_ORGO_ET_WT_F_MV FCT
946: , PJI_PMV_ORG_DIM_TMP HOU
947: where

Line 987: , PJI_PMV_ORGZ_DIM_TMP HORG

983: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) as CT_EXPENSE
984: , 0 EXPENSE_CHANGE_PRCNT
985: from
986: PJI_PMV_TCMP_DIM_TMP TIME
987: , PJI_PMV_ORGZ_DIM_TMP HORG
988: , PJI_PMV_WT_DIM_TMP WT
989: , PJI_FP_ORGO_ET_WT_F_MV FCT
990: , PJI_PMV_ORG_DIM_TMP HOU
991: where

Line 1041: from PJI_PMV_ORGZ_DIM_TMP HORG

1037: , 0 PRCNT_OF_COST_CHANGE
1038: , 0 EXPENSE
1039: , 0 CT_EXPENSE
1040: , 0 EXPENSE_CHANGE_PRCNT
1041: from PJI_PMV_ORGZ_DIM_TMP HORG
1042: where HORG.NAME <> '-1'
1043: union all -- FORCE Creation of Work Type Rows
1044: select '-1' as ORG_ID
1045: , '-1' as ORGANIZATION_ID

Line 1131: , PJI_PMV_ORGZ_DIM_TMP HORG

1127: , 0 CT_EXPENSE
1128: , 0 EXPENSE_CHANGE_PRCNT
1129: from
1130: PJI_PMV_TIME_DIM_TMP TIME
1131: , PJI_PMV_ORGZ_DIM_TMP HORG
1132: , PJI_PMV_ET_RT_DIM_TMP ET
1133: , PJI_FP_CLSO_ET_F_MV FCT
1134: , PJI_PMV_CLS_DIM_TMP CLS
1135: , PJI_PMV_ORG_DIM_TMP HOU

Line 1177: , PJI_PMV_ORGZ_DIM_TMP HORG

1173: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) as CT_EXPENSE
1174: , 0 EXPENSE_CHANGE_PRCNT
1175: from
1176: PJI_PMV_TCMP_DIM_TMP TIME
1177: , PJI_PMV_ORGZ_DIM_TMP HORG
1178: , PJI_PMV_ET_RT_DIM_TMP ET
1179: , PJI_FP_CLSO_ET_F_MV FCT
1180: , PJI_PMV_CLS_DIM_TMP CLS
1181: , PJI_PMV_ORG_DIM_TMP HOU

Line 1233: from PJI_PMV_ORGZ_DIM_TMP HORG

1229: , 0 PRCNT_OF_COST_CHANGE
1230: , 0 EXPENSE
1231: , 0 CT_EXPENSE
1232: , 0 EXPENSE_CHANGE_PRCNT
1233: from PJI_PMV_ORGZ_DIM_TMP HORG
1234: where HORG.NAME <> '-1'
1235: union all -- FORCE Creation of Project Class Rows
1236: select '-1' as ORG_ID
1237: , '-1' as ORGANIZATION_ID

Line 1345: , PJI_PMV_ORGZ_DIM_TMP HORG

1341: , 0 CT_EXPENSE
1342: , 0 EXPENSE_CHANGE_PRCNT
1343: from
1344: PJI_PMV_TIME_DIM_TMP TIME
1345: , PJI_PMV_ORGZ_DIM_TMP HORG
1346: , PJI_PMV_ET_RT_DIM_TMP ET
1347: , PJI_FP_ORGO_ET_WT_F_MV FCT
1348: , PJI_PMV_WT_DIM_TMP WT
1349: , PJI_PMV_ORG_DIM_TMP HOU

Line 1391: , PJI_PMV_ORGZ_DIM_TMP HORG

1387: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) as CT_EXPENSE
1388: , 0 EXPENSE_CHANGE_PRCNT
1389: from
1390: PJI_PMV_TCMP_DIM_TMP TIME
1391: , PJI_PMV_ORGZ_DIM_TMP HORG
1392: , PJI_PMV_ET_RT_DIM_TMP ET
1393: , PJI_FP_ORGO_ET_WT_F_MV FCT
1394: , PJI_PMV_WT_DIM_TMP WT
1395: , PJI_PMV_ORG_DIM_TMP HOU

Line 1447: from PJI_PMV_ORGZ_DIM_TMP HORG

1443: , 0 PRCNT_OF_COST_CHANGE
1444: , 0 EXPENSE
1445: , 0 CT_EXPENSE
1446: , 0 EXPENSE_CHANGE_PRCNT
1447: from PJI_PMV_ORGZ_DIM_TMP HORG
1448: where HORG.NAME <> '-1'
1449: union all
1450: select '-1' as ORG_ID
1451: , '-1' as ORGANIZATION_ID

Line 1560: , PJI_PMV_ORGZ_DIM_TMP HORG

1556: , 0 CT_EXPENSE
1557: , 0 EXPENSE_CHANGE_PRCNT
1558: from
1559: PJI_PMV_TIME_DIM_TMP TIME
1560: , PJI_PMV_ORGZ_DIM_TMP HORG
1561: , PJI_PMV_CLS_DIM_TMP CLS
1562: , PJI_FP_CLSO_ET_WT_F_MV FCT
1563: , PJI_PMV_WT_DIM_TMP WT
1564: , PJI_PMV_ORG_DIM_TMP HOU

Line 1606: , PJI_PMV_ORGZ_DIM_TMP HORG

1602: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) as CT_EXPENSE
1603: , 0 EXPENSE_CHANGE_PRCNT
1604: from
1605: PJI_PMV_TCMP_DIM_TMP TIME
1606: , PJI_PMV_ORGZ_DIM_TMP HORG
1607: , PJI_PMV_CLS_DIM_TMP CLS
1608: , PJI_FP_CLSO_ET_WT_F_MV FCT
1609: , PJI_PMV_WT_DIM_TMP WT
1610: , PJI_PMV_ORG_DIM_TMP HOU

Line 1662: from PJI_PMV_ORGZ_DIM_TMP HORG

1658: , 0 PRCNT_OF_COST_CHANGE
1659: , 0 EXPENSE
1660: , 0 CT_EXPENSE
1661: , 0 EXPENSE_CHANGE_PRCNT
1662: from PJI_PMV_ORGZ_DIM_TMP HORG
1663: where HORG.NAME <> '-1'
1664: union all -- FORCE Creation of Org rows
1665: select '-1' AS ORG_ID
1666: , '-1' AS ORGANIZATION_ID

Line 1771: , PJI_PMV_ORGZ_DIM_TMP HORG

1767: , 0 CT_EXPENSE
1768: , 0 EXPENSE_CHANGE_PRCNT
1769: from
1770: PJI_PMV_TIME_DIM_TMP TIME
1771: , PJI_PMV_ORGZ_DIM_TMP HORG
1772: , PJI_PMV_ET_RT_DIM_TMP ET
1773: , PJI_FP_CLSO_ET_WT_F_MV FCT
1774: , PJI_PMV_CLS_DIM_TMP CLS
1775: , PJI_PMV_WT_DIM_TMP WT

Line 1820: , PJI_PMV_ORGZ_DIM_TMP HORG

1816: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) as CT_EXPENSE
1817: , 0 EXPENSE_CHANGE_PRCNT
1818: from
1819: PJI_PMV_TCMP_DIM_TMP TIME
1820: , PJI_PMV_ORGZ_DIM_TMP HORG
1821: , PJI_PMV_ET_RT_DIM_TMP ET
1822: , PJI_FP_CLSO_ET_WT_F_MV FCT
1823: , PJI_PMV_CLS_DIM_TMP CLS
1824: , PJI_PMV_WT_DIM_TMP WT

Line 1879: from PJI_PMV_ORGZ_DIM_TMP HORG

1875: , 0 PRCNT_OF_COST_CHANGE
1876: , 0 EXPENSE
1877: , 0 CT_EXPENSE
1878: , 0 EXPENSE_CHANGE_PRCNT
1879: from PJI_PMV_ORGZ_DIM_TMP HORG
1880: where HORG.NAME <> '-1'
1881: union all
1882: select '-1' as ORG_ID
1883: , '-1' AS ORGANIZATION_ID

Line 2305: , PJI_PMV_ORGZ_DIM_TMP HORG

2301: , 0 CT_EXPENSE
2302: , 0 EXPENSE_CHANGE_PRCNT
2303: from
2304: PJI_PMV_TIME_DIM_TMP TIME
2305: , PJI_PMV_ORGZ_DIM_TMP HORG
2306: , PJI_FP_ORGO_F_MV FCT
2307: , PJI_PMV_ORG_DIM_TMP HOU
2308: where
2309: FCT.ORG_ID = HOU.ID

Line 2342: , PJI_PMV_ORGZ_DIM_TMP HORG

2338: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) CT_EXPENSE
2339: , 0 EXPENSE_CHANGE_PRCNT
2340: from
2341: PJI_PMV_TIME_DIM_TMP TIME
2342: , PJI_PMV_ORGZ_DIM_TMP HORG
2343: , PJI_FP_ORGO_F_MV FCT
2344: , PJI_PMV_ORG_DIM_TMP HOU
2345: where
2346: FCT.org_id = HOU.id

Line 2426: , PJI_PMV_ORGZ_DIM_TMP HORG

2422: , 0 CT_EXPENSE
2423: , 0 EXPENSE_CHANGE_PRCNT
2424: from
2425: PJI_PMV_TIME_DIM_TMP TIME
2426: , PJI_PMV_ORGZ_DIM_TMP HORG
2427: , PJI_PMV_CLS_DIM_TMP CLS
2428: , PJI_FP_CLSO_F_MV FCT
2429: , PJI_PMV_ORG_DIM_TMP HOU
2430: where

Line 2465: , PJI_PMV_ORGZ_DIM_TMP HORG

2461: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) CT_EXPENSE
2462: , 0 EXPENSE_CHANGE_PRCNT
2463: from
2464: PJI_PMV_TIME_DIM_TMP TIME
2465: , PJI_PMV_ORGZ_DIM_TMP HORG
2466: , PJI_PMV_CLS_DIM_TMP CLS
2467: , PJI_FP_CLSO_F_MV FCT
2468: , PJI_PMV_ORG_DIM_TMP HOU
2469: where

Line 2550: , PJI_PMV_ORGZ_DIM_TMP HORG

2546: , 0 CT_EXPENSE
2547: , 0 EXPENSE_CHANGE_PRCNT
2548: from
2549: PJI_PMV_TIME_DIM_TMP TIME
2550: , PJI_PMV_ORGZ_DIM_TMP HORG
2551: , PJI_PMV_ET_RT_DIM_TMP ET
2552: , PJI_FP_ORGO_ET_F_MV FCT
2553: , PJI_PMV_ORG_DIM_TMP HOU
2554: where

Line 2590: , PJI_PMV_ORGZ_DIM_TMP HORG

2586: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) CT_EXPENSE
2587: , 0 EXPENSE_CHANGE_PRCNT
2588: from
2589: PJI_PMV_TIME_DIM_TMP TIME
2590: , PJI_PMV_ORGZ_DIM_TMP HORG
2591: , PJI_PMV_ET_RT_DIM_TMP ET
2592: , PJI_FP_ORGO_ET_F_MV FCT
2593: , PJI_PMV_ORG_DIM_TMP HOU
2594: where

Line 2677: , PJI_PMV_ORGZ_DIM_TMP HORG

2673: , 0 CT_EXPENSE
2674: , 0 EXPENSE_CHANGE_PRCNT
2675: from
2676: PJI_PMV_TIME_DIM_TMP TIME
2677: , PJI_PMV_ORGZ_DIM_TMP HORG
2678: , PJI_PMV_WT_DIM_TMP WT
2679: , PJI_FP_ORGO_ET_WT_F_MV FCT
2680: , PJI_PMV_ORG_DIM_TMP HOU
2681: where

Line 2716: , PJI_PMV_ORGZ_DIM_TMP HORG

2712: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) CT_EXPENSE
2713: , 0 EXPENSE_CHANGE_PRCNT
2714: from
2715: PJI_PMV_TIME_DIM_TMP TIME
2716: , PJI_PMV_ORGZ_DIM_TMP HORG
2717: , PJI_PMV_WT_DIM_TMP WT
2718: , PJI_FP_ORGO_ET_WT_F_MV FCT
2719: , PJI_PMV_ORG_DIM_TMP HOU
2720: where

Line 2801: , PJI_PMV_ORGZ_DIM_TMP HORG

2797: , 0 CT_EXPENSE
2798: , 0 EXPENSE_CHANGE_PRCNT
2799: from
2800: PJI_PMV_TIME_DIM_TMP TIME
2801: , PJI_PMV_ORGZ_DIM_TMP HORG
2802: , PJI_PMV_CLS_DIM_TMP CLS
2803: , PJI_PMV_ET_RT_DIM_TMP ET
2804: , PJI_FP_CLSO_ET_F_MV FCT
2805: , PJI_PMV_ORG_DIM_TMP HOU

Line 2843: , PJI_PMV_ORGZ_DIM_TMP HORG

2839: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) CT_EXPENSE
2840: , 0 EXPENSE_CHANGE_PRCNT
2841: from
2842: PJI_PMV_TIME_DIM_TMP TIME
2843: , PJI_PMV_ORGZ_DIM_TMP HORG
2844: , PJI_PMV_CLS_DIM_TMP CLS
2845: , PJI_PMV_ET_RT_DIM_TMP ET
2846: , PJI_FP_CLSO_ET_F_MV FCT
2847: , PJI_PMV_ORG_DIM_TMP HOU

Line 2932: , PJI_PMV_ORGZ_DIM_TMP HORG

2928: , 0 CT_EXPENSE
2929: , 0 EXPENSE_CHANGE_PRCNT
2930: from
2931: PJI_PMV_TIME_DIM_TMP TIME
2932: , PJI_PMV_ORGZ_DIM_TMP HORG
2933: , PJI_PMV_ET_RT_DIM_TMP ET
2934: , PJI_FP_ORGO_ET_WT_F_MV FCT
2935: , PJI_PMV_WT_DIM_TMP WT
2936: , PJI_PMV_ORG_DIM_TMP HOU

Line 2974: , PJI_PMV_ORGZ_DIM_TMP HORG

2970: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) CT_EXPENSE
2971: , 0 EXPENSE_CHANGE_PRCNT
2972: from
2973: PJI_PMV_TIME_DIM_TMP TIME
2974: , PJI_PMV_ORGZ_DIM_TMP HORG
2975: , PJI_PMV_ET_RT_DIM_TMP ET
2976: , PJI_FP_ORGO_ET_WT_F_MV FCT
2977: , PJI_PMV_WT_DIM_TMP WT
2978: , PJI_PMV_ORG_DIM_TMP HOU

Line 3062: , PJI_PMV_ORGZ_DIM_TMP HORG

3058: , 0 CT_EXPENSE
3059: , 0 EXPENSE_CHANGE_PRCNT
3060: from
3061: PJI_PMV_TIME_DIM_TMP TIME
3062: , PJI_PMV_ORGZ_DIM_TMP HORG
3063: , PJI_PMV_CLS_DIM_TMP CLS
3064: , PJI_FP_CLSO_ET_WT_F_MV FCT
3065: , PJI_PMV_WT_DIM_TMP WT
3066: , PJI_PMV_ORG_DIM_TMP HOU

Line 3103: , PJI_PMV_ORGZ_DIM_TMP HORG

3099: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) CT_EXPENSE
3100: , 0 EXPENSE_CHANGE_PRCNT
3101: from
3102: PJI_PMV_TIME_DIM_TMP TIME
3103: , PJI_PMV_ORGZ_DIM_TMP HORG
3104: , PJI_PMV_CLS_DIM_TMP CLS
3105: , PJI_FP_CLSO_ET_WT_F_MV FCT
3106: , PJI_PMV_WT_DIM_TMP WT
3107: , PJI_PMV_ORG_DIM_TMP HOU

Line 3187: , PJI_PMV_ORGZ_DIM_TMP HORG

3183: , 0 CT_EXPENSE
3184: , 0 EXPENSE_CHANGE_PRCNT
3185: from
3186: PJI_PMV_TIME_DIM_TMP TIME
3187: , PJI_PMV_ORGZ_DIM_TMP HORG
3188: , PJI_PMV_ET_RT_DIM_TMP ET
3189: , PJI_FP_CLSO_ET_WT_F_MV FCT
3190: , PJI_PMV_CLS_DIM_TMP CLS
3191: , PJI_PMV_WT_DIM_TMP WT

Line 3231: , PJI_PMV_ORGZ_DIM_TMP HORG

3227: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) CT_EXPENSE
3228: , 0 EXPENSE_CHANGE_PRCNT
3229: from
3230: PJI_PMV_TIME_DIM_TMP TIME
3231: , PJI_PMV_ORGZ_DIM_TMP HORG
3232: , PJI_PMV_ET_RT_DIM_TMP ET
3233: , PJI_FP_CLSO_ET_WT_F_MV FCT
3234: , PJI_PMV_CLS_DIM_TMP CLS
3235: , PJI_PMV_WT_DIM_TMP WT

Line 3433: , pji_pmv_orgz_dim_tmp org

3429: SELECT DISTINCT prj.project_id, '-1' name
3430: FROM
3431: pji_project_classes PJM
3432: , pji_pmv_cls_dim_tmp PTM
3433: , pji_pmv_orgz_dim_tmp org
3434: , pa_projects_all prj
3435: WHERE
3436: pjm.project_class_id = ptm.id
3437: AND prj.project_id = pjm.project_id

Line 3455: , pji_pmv_orgz_dim_tmp org

3451: , (SELECT project_id
3452: FROM pji_project_classes
3453: WHERE class_category = '$PROJECT_TYPE$CAPITAL') PJC
3454: , pji_pmv_cls_dim_tmp PTM
3455: , pji_pmv_orgz_dim_tmp org
3456: , pa_projects_all prj
3457: WHERE 1=1
3458: AND pjm.project_class_id = ptm.id
3459: AND prj.project_id = pjc.project_id

Line 3468: , pji_pmv_orgz_dim_tmp org

3464: INSERT INTO pji_pmv_prj_dim_tmp (id, name)
3465: SELECT DISTINCT prj.project_id, '-1' name
3466: FROM
3467: pji_project_classes PJM
3468: , pji_pmv_orgz_dim_tmp org
3469: , pa_projects_all prj
3470: WHERE
3471: prj.project_id = pjm.project_id
3472: AND prj.carrying_out_organization_id = org.ID

Line 3521: , PJI_PMV_ORGZ_DIM_TMP HORG

3517: , DECODE(NVL(TIME.amount_type,1),1,
3518: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3519: 'RC', fct.raw_cost - fct.capitalizable_raw_cost, 0), 0) AS EXPENSE
3520: FROM PJI_PMV_TIME_DIM_TMP TIME
3521: , PJI_PMV_ORGZ_DIM_TMP HORG
3522: , PJI_PMV_PRJ_DIM_TMP PRJ
3523: , PJI_FP_PROJ_F FCT
3524: , PJI_PMV_ORG_DIM_TMP HOU
3525: WHERE 1=1