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_TIME_DIM_TMP

Line 398: PJI_PMV_TIME_DIM_TMP TIME

394: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 562: PJI_PMV_TIME_DIM_TMP TIME

558: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 751: PJI_PMV_TIME_DIM_TMP TIME

747: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 942: PJI_PMV_TIME_DIM_TMP TIME

938: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 1130: PJI_PMV_TIME_DIM_TMP TIME

1126: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 1344: PJI_PMV_TIME_DIM_TMP TIME

1340: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 1559: PJI_PMV_TIME_DIM_TMP TIME

1555: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 1770: PJI_PMV_TIME_DIM_TMP TIME

1766: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 2304: PJI_PMV_TIME_DIM_TMP TIME

2300: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 2341: PJI_PMV_TIME_DIM_TMP TIME

2337: 'BC', FCT.CAPITAL_BRDN_COST - FCT.CAPITALIZABLE_BRDN_COST,
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

Line 2369: from pji_pmv_time_dim_tmp time

2365: , 0 PRCNT_OF_COST_CHANGE
2366: , 0 EXPENSE
2367: , 0 CT_EXPENSE
2368: , 0 Expense_CHANGE_PRCNT
2369: from pji_pmv_time_dim_tmp time
2370: where name <> '-1')
2371: group by
2372: TIME_KEY
2373: , TIME_ID ORDER BY TIME_KEY ASC;

Line 2425: PJI_PMV_TIME_DIM_TMP TIME

2421: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 2464: PJI_PMV_TIME_DIM_TMP TIME

2460: 'BC', FCT.CAPITAL_BRDN_COST - FCT.CAPITALIZABLE_BRDN_COST,
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

Line 2494: from pji_pmv_time_dim_tmp time

2490: , 0 PRCNT_OF_COST_CHANGE
2491: , 0 EXPENSE
2492: , 0 CT_EXPENSE
2493: , 0 Expense_CHANGE_PRCNT
2494: from pji_pmv_time_dim_tmp time
2495: where name <> '-1')
2496: group by
2497: TIME_KEY
2498: , TIME_ID ORDER BY TIME_KEY ASC;

Line 2549: PJI_PMV_TIME_DIM_TMP TIME

2545: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 2589: PJI_PMV_TIME_DIM_TMP TIME

2585: 'BC', FCT.CAPITAL_BRDN_COST - FCT.CAPITALIZABLE_BRDN_COST,
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

Line 2620: from pji_pmv_time_dim_tmp time

2616: , 0 PRCNT_OF_COST_CHANGE
2617: , 0 EXPENSE
2618: , 0 CT_EXPENSE
2619: , 0 Expense_CHANGE_PRCNT
2620: from pji_pmv_time_dim_tmp time
2621: where name <> '-1')
2622: group by
2623: TIME_KEY
2624: , TIME_ID ORDER BY TIME_KEY ASC;

Line 2676: PJI_PMV_TIME_DIM_TMP TIME

2672: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 2715: PJI_PMV_TIME_DIM_TMP TIME

2711: 'BC', FCT.CAPITAL_BRDN_COST - FCT.CAPITALIZABLE_BRDN_COST,
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

Line 2745: from pji_pmv_time_dim_tmp time

2741: , 0 PRCNT_OF_COST_CHANGE
2742: , 0 EXPENSE
2743: , 0 CT_EXPENSE
2744: , 0 Expense_CHANGE_PRCNT
2745: from pji_pmv_time_dim_tmp time
2746: where name <> '-1')
2747: group by
2748: TIME_KEY
2749: , TIME_ID ORDER BY TIME_KEY ASC;

Line 2800: PJI_PMV_TIME_DIM_TMP TIME

2796: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 2842: PJI_PMV_TIME_DIM_TMP TIME

2838: 'BC', FCT.CAPITAL_BRDN_COST - FCT.CAPITALIZABLE_BRDN_COST,
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

Line 2875: from pji_pmv_time_dim_tmp time

2871: , 0 PRCNT_OF_COST_CHANGE
2872: , 0 EXPENSE
2873: , 0 CT_EXPENSE
2874: , 0 Expense_CHANGE_PRCNT
2875: from pji_pmv_time_dim_tmp time
2876: where name <> '-1')
2877: group by
2878: TIME_KEY
2879: , TIME_ID ORDER BY TIME_KEY ASC;

Line 2931: PJI_PMV_TIME_DIM_TMP TIME

2927: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 2973: PJI_PMV_TIME_DIM_TMP TIME

2969: 'BC', FCT.CAPITAL_BRDN_COST - FCT.CAPITALIZABLE_BRDN_COST,
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

Line 3006: from pji_pmv_time_dim_tmp time

3002: , 0 PRCNT_OF_COST_CHANGE
3003: , 0 EXPENSE
3004: , 0 CT_EXPENSE
3005: , 0 Expense_CHANGE_PRCNT
3006: from pji_pmv_time_dim_tmp time
3007: where name <> '-1')
3008: group by
3009: TIME_KEY
3010: , TIME_ID ORDER BY TIME_KEY ASC;

Line 3061: PJI_PMV_TIME_DIM_TMP TIME

3057: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 3102: PJI_PMV_TIME_DIM_TMP TIME

3098: 'BC', FCT.CAPITAL_BRDN_COST - FCT.CAPITALIZABLE_BRDN_COST,
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

Line 3134: from pji_pmv_time_dim_tmp time

3130: , 0 PRCNT_OF_COST_CHANGE
3131: , 0 EXPENSE
3132: , 0 CT_EXPENSE
3133: , 0 Expense_CHANGE_PRCNT
3134: from pji_pmv_time_dim_tmp time
3135: where name <> '-1')
3136: group by
3137: TIME_KEY
3138: , TIME_ID ORDER BY TIME_KEY ASC;

Line 3186: PJI_PMV_TIME_DIM_TMP TIME

3182: 'RC', FCT.CAPITAL_RAW_COST - FCT.CAPITALIZABLE_RAW_COST),0) EXPENSE
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

Line 3230: PJI_PMV_TIME_DIM_TMP TIME

3226: 'BC', FCT.CAPITAL_BRDN_COST - FCT.CAPITALIZABLE_BRDN_COST,
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

Line 3265: from pji_pmv_time_dim_tmp time

3261: , 0 PRCNT_OF_COST_CHANGE
3262: , 0 EXPENSE
3263: , 0 CT_EXPENSE
3264: , 0 Expense_CHANGE_PRCNT
3265: from pji_pmv_time_dim_tmp time
3266: where name <> '-1')
3267: group by
3268: TIME_KEY
3269: , TIME_ID ORDER BY TIME_KEY ASC;

Line 3520: FROM PJI_PMV_TIME_DIM_TMP TIME

3516: 'RC', fct.capitalizable_raw_cost, 0), 0) AS CAPITAL_COST
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

Line 3572: FROM PJI_PMV_TIME_DIM_TMP TIME

3568: 'RC', fct.capitalizable_raw_cost),0) AS CAPITAL_COST
3569: , DECODE(NVL(TIME.amount_type,1),1,
3570: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3571: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3572: FROM PJI_PMV_TIME_DIM_TMP TIME
3573: , PJI_PMV_PRJ_DIM_TMP PRJ
3574: , PJI_FP_PROJ_F FCT
3575: , PJI_PMV_ORG_DIM_TMP HOU
3576: WHERE 1=1

Line 3626: FROM PJI_PMV_TIME_DIM_TMP TIME

3622: 'RC', fct.capitalizable_raw_cost),0) AS CAPITAL_COST
3623: , DECODE(NVL(TIME.amount_type,1),1,
3624: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3625: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3626: FROM PJI_PMV_TIME_DIM_TMP TIME
3627: , PJI_PMV_PRJ_DIM_TMP PRJ
3628: , PJI_PMV_ET_RT_DIM_TMP ET
3629: , PJI_FP_PROJ_ET_F FCT
3630: , PJI_PMV_ORG_DIM_TMP HOU

Line 3682: FROM PJI_PMV_TIME_DIM_TMP TIME

3678: 'RC', fct.capitalizable_raw_cost),0) AS CAPITAL_COST
3679: , DECODE(NVL(TIME.amount_type,1),1,
3680: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3681: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3682: FROM PJI_PMV_TIME_DIM_TMP TIME
3683: , PJI_PMV_WT_DIM_TMP WT
3684: , PJI_PMV_PRJ_DIM_TMP PRJ
3685: , PJI_FP_PROJ_ET_WT_F FCT
3686: , PJI_PMV_ORG_DIM_TMP HOU

Line 3738: FROM PJI_PMV_TIME_DIM_TMP TIME

3734: 'RC', fct.capitalizable_raw_cost),0) AS CAPITAL_COST
3735: , DECODE(NVL(TIME.amount_type,1),1,
3736: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3737: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3738: FROM PJI_PMV_TIME_DIM_TMP TIME
3739: , PJI_PMV_PRJ_DIM_TMP PRJ
3740: , PJI_PMV_ET_RT_DIM_TMP ET
3741: , PJI_FP_PROJ_ET_F FCT
3742: , PJI_PMV_ORG_DIM_TMP HOU

Line 3794: FROM PJI_PMV_TIME_DIM_TMP TIME

3790: 'RC', fct.capitalizable_raw_cost),0) AS CAPITAL_COST
3791: , DECODE(NVL(TIME.amount_type,1),1,
3792: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3793: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3794: FROM PJI_PMV_TIME_DIM_TMP TIME
3795: , PJI_PMV_ET_RT_DIM_TMP ET
3796: , PJI_PMV_WT_DIM_TMP WT
3797: , PJI_PMV_PRJ_DIM_TMP PRJ
3798: , PJI_FP_PROJ_ET_WT_F FCT

Line 3853: FROM PJI_PMV_TIME_DIM_TMP TIME

3849: 'RC', fct.capitalizable_raw_cost), 0) AS CAPITAL_COST
3850: , DECODE(NVL(TIME.amount_type,1),1,
3851: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3852: 'RC', fct.raw_cost - fct.capitalizable_raw_cost), 0) AS EXPENSE
3853: FROM PJI_PMV_TIME_DIM_TMP TIME
3854: , PJI_PMV_PRJ_DIM_TMP PRJ
3855: , PJI_PMV_WT_DIM_TMP WT
3856: , PJI_FP_PROJ_ET_WT_F FCT
3857: , PJI_PMV_ORG_DIM_TMP HOU

Line 3900: FROM PJI_PMV_TIME_DIM_TMP TIME

3896: 'RC', fct.capitalizable_raw_cost),0) AS CAPITAL_COST
3897: , DECODE(NVL(TIME.amount_type,1),1,
3898: DECODE(G_Report_Cost_Type, 'BC', fct.burdened_cost - fct.capitalizable_brdn_cost,
3899: 'RC', fct.raw_cost - fct.capitalizable_raw_cost),0) AS EXPENSE
3900: FROM PJI_PMV_TIME_DIM_TMP TIME
3901: , PJI_PMV_PRJ_DIM_TMP PRJ
3902: , PJI_PMV_ET_RT_DIM_TMP ET
3903: , PJI_PMV_WT_DIM_TMP WT
3904: , PJI_FP_PROJ_ET_WT_F FCT