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_COST dependencies on PJI_PMV_TIME_DIM_TMP

Line 430: PJI_PMV_TIME_DIM_TMP TIME

426: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
427: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS NON_BILL_COST
428: , 0 CT_NON_BILL_COST
429: FROM
430: PJI_PMV_TIME_DIM_TMP TIME
431: , PJI_PMV_ORGZ_DIM_TMP HORG
432: , PJI_FP_ORGO_F_MV FCT
433: , PJI_PMV_ORG_DIM_TMP HOU
434: WHERE

Line 575: PJI_PMV_TIME_DIM_TMP TIME

571: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
572: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS NON_BILL_COST
573: , 0 CT_NON_BILL_COST
574: FROM
575: PJI_PMV_TIME_DIM_TMP TIME
576: , PJI_PMV_ORGZ_DIM_TMP HORG
577: , PJI_PMV_CLS_DIM_TMP CLS
578: , PJI_FP_CLSO_F_MV FCT
579: , PJI_PMV_ORG_DIM_TMP HOU

Line 744: PJI_PMV_TIME_DIM_TMP TIME

740: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
741: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS NON_BILL_COST
742: , 0 CT_NON_BILL_COST
743: FROM
744: PJI_PMV_TIME_DIM_TMP TIME
745: , PJI_PMV_ORGZ_DIM_TMP HORG
746: , PJI_PMV_ET_RT_DIM_TMP ET
747: , PJI_FP_ORGO_ET_F_MV FCT
748: , PJI_PMV_ORG_DIM_TMP HOU

Line 913: PJI_PMV_TIME_DIM_TMP TIME

909: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
910: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS NON_BILL_COST
911: , 0 CT_NON_BILL_COST
912: FROM
913: PJI_PMV_TIME_DIM_TMP TIME
914: , PJI_PMV_ORGZ_DIM_TMP HORG
915: , PJI_PMV_WT_DIM_TMP WT
916: , PJI_FP_ORGO_ET_WT_F_MV FCT
917: , PJI_PMV_ORG_DIM_TMP HOU

Line 1081: PJI_PMV_TIME_DIM_TMP TIME

1077: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
1078: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS NON_BILL_COST
1079: , 0 CT_NON_BILL_COST
1080: FROM
1081: PJI_PMV_TIME_DIM_TMP TIME
1082: , PJI_PMV_ORGZ_DIM_TMP HORG
1083: , PJI_PMV_ET_RT_DIM_TMP ET
1084: , PJI_FP_CLSO_ET_F_MV FCT
1085: , PJI_PMV_CLS_DIM_TMP CLS

Line 1268: PJI_PMV_TIME_DIM_TMP TIME

1264: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
1265: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS NON_BILL_COST
1266: , 0 CT_NON_BILL_COST
1267: FROM
1268: PJI_PMV_TIME_DIM_TMP TIME
1269: , PJI_PMV_ORGZ_DIM_TMP HORG
1270: , PJI_PMV_ET_RT_DIM_TMP ET
1271: , PJI_FP_ORGO_ET_WT_F_MV FCT
1272: , PJI_PMV_WT_DIM_TMP WT

Line 1453: PJI_PMV_TIME_DIM_TMP TIME

1449: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
1450: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS NON_BILL_COST
1451: , 0 CT_NON_BILL_COST
1452: FROM
1453: PJI_PMV_TIME_DIM_TMP TIME
1454: , PJI_PMV_ORGZ_DIM_TMP HORG
1455: , PJI_PMV_CLS_DIM_TMP CLS
1456: , PJI_FP_CLSO_ET_WT_F_MV FCT
1457: , PJI_PMV_WT_DIM_TMP WT

Line 1633: PJI_PMV_TIME_DIM_TMP TIME

1629: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
1630: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS NON_BILL_COST
1631: , 0 CT_NON_BILL_COST
1632: FROM
1633: PJI_PMV_TIME_DIM_TMP TIME
1634: , PJI_PMV_ORGZ_DIM_TMP HORG
1635: , PJI_PMV_ET_RT_DIM_TMP ET
1636: , PJI_FP_CLSO_ET_WT_F_MV FCT
1637: , PJI_PMV_CLS_DIM_TMP CLS

Line 2247: PJI_PMV_TIME_DIM_TMP TIME

2243: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
2244: 'BC', contract_brdn_cost - bill_burdened_cost),0) non_bill_cost
2245: , 0 CT_Non_Bill_Cost
2246: FROM
2247: PJI_PMV_TIME_DIM_TMP TIME
2248: , PJI_PMV_ORGZ_DIM_TMP HORG
2249: , PJI_FP_ORGO_F_MV FCT
2250: , PJI_PMV_ORG_DIM_TMP HOU
2251: WHERE

Line 2279: PJI_PMV_TIME_DIM_TMP TIME

2275: , DECODE(NVL(TIME.amount_type,1),1,
2276: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
2277: 'BC', contract_brdn_cost - bill_burdened_cost),0) CT_Non_Bill_Cost
2278: FROM
2279: PJI_PMV_TIME_DIM_TMP TIME
2280: , PJI_PMV_ORGZ_DIM_TMP HORG
2281: , PJI_FP_ORGO_F_MV FCT
2282: , PJI_PMV_ORG_DIM_TMP HOU
2283: WHERE

Line 2303: FROM pji_pmv_time_dim_tmp

2299: , 0 budget
2300: , 0 CT_BUDGET
2301: , 0 non_bill_cost
2302: , 0 CT_Non_Bill_Cost
2303: FROM pji_pmv_time_dim_tmp
2304: WHERE name <> '-1')
2305: GROUP BY
2306: TIME_KEY
2307: , TIME_ID ORDER BY TIME_KEY ASC;

Line 2360: PJI_PMV_TIME_DIM_TMP TIME

2356: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
2357: 'BC', contract_brdn_cost - bill_burdened_cost),0) non_bill_cost
2358: , 0 CT_Non_Bill_Cost
2359: FROM
2360: PJI_PMV_TIME_DIM_TMP TIME
2361: , PJI_PMV_ORGZ_DIM_TMP HORG
2362: , PJI_PMV_CLS_DIM_TMP CLS
2363: , PJI_FP_CLSO_F_MV FCT
2364: , PJI_PMV_ORG_DIM_TMP HOU

Line 2394: PJI_PMV_TIME_DIM_TMP TIME

2390: , DECODE(NVL(TIME.amount_type,1),1,
2391: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
2392: 'BC', contract_brdn_cost - bill_burdened_cost),0) CT_Non_Bill_Cost
2393: FROM
2394: PJI_PMV_TIME_DIM_TMP TIME
2395: , PJI_PMV_ORGZ_DIM_TMP HORG
2396: , PJI_PMV_CLS_DIM_TMP CLS
2397: , PJI_FP_CLSO_F_MV FCT
2398: , PJI_PMV_ORG_DIM_TMP HOU

Line 2420: FROM pji_pmv_time_dim_tmp

2416: , 0 budget
2417: , 0 CT_BUDGET
2418: , 0 non_bill_cost
2419: , 0 CT_Non_Bill_Cost
2420: FROM pji_pmv_time_dim_tmp
2421: WHERE name <> '-1')
2422: GROUP BY
2423: TIME_KEY
2424: , TIME_ID ORDER BY TIME_KEY ASC;

Line 2476: PJI_PMV_TIME_DIM_TMP TIME

2472: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
2473: 'BC', contract_brdn_cost - bill_burdened_cost),0) non_bill_cost
2474: , 0 CT_Non_Bill_Cost
2475: FROM
2476: PJI_PMV_TIME_DIM_TMP TIME
2477: , PJI_PMV_ORGZ_DIM_TMP HORG
2478: , PJI_PMV_ET_RT_DIM_TMP ET
2479: , PJI_FP_ORGO_ET_F_MV FCT
2480: , PJI_PMV_ORG_DIM_TMP HOU

Line 2509: PJI_PMV_TIME_DIM_TMP TIME

2505: , DECODE(NVL(TIME.amount_type,1),1,
2506: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
2507: 'BC', contract_brdn_cost - bill_burdened_cost),0) CT_Non_Bill_Cost
2508: FROM
2509: PJI_PMV_TIME_DIM_TMP TIME
2510: , PJI_PMV_ORGZ_DIM_TMP HORG
2511: , PJI_PMV_ET_RT_DIM_TMP ET
2512: , PJI_FP_ORGO_ET_F_MV FCT
2513: , PJI_PMV_ORG_DIM_TMP HOU

Line 2536: FROM pji_pmv_time_dim_tmp

2532: , NULL AS budget
2533: , NULL AS CT_BUDGET
2534: , 0 non_bill_cost
2535: , 0 CT_Non_Bill_Cost
2536: FROM pji_pmv_time_dim_tmp
2537: WHERE name <> '-1')
2538: GROUP BY
2539: TIME_KEY
2540: , TIME_ID ORDER BY TIME_KEY ASC;

Line 2592: PJI_PMV_TIME_DIM_TMP TIME

2588: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
2589: 'BC', contract_brdn_cost - bill_burdened_cost),0) non_bill_cost
2590: , 0 CT_Non_Bill_Cost
2591: FROM
2592: PJI_PMV_TIME_DIM_TMP TIME
2593: , PJI_PMV_ORGZ_DIM_TMP HORG
2594: , PJI_PMV_WT_DIM_TMP WT
2595: , PJI_FP_ORGO_ET_WT_F_MV FCT
2596: , PJI_PMV_ORG_DIM_TMP HOU

Line 2625: PJI_PMV_TIME_DIM_TMP TIME

2621: , DECODE(NVL(TIME.amount_type,1),1,
2622: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
2623: 'BC', contract_brdn_cost - bill_burdened_cost),0) CT_Non_Bill_Cost
2624: FROM
2625: PJI_PMV_TIME_DIM_TMP TIME
2626: , PJI_PMV_ORGZ_DIM_TMP HORG
2627: , PJI_PMV_WT_DIM_TMP WT
2628: , PJI_FP_ORGO_ET_WT_F_MV FCT
2629: , PJI_PMV_ORG_DIM_TMP HOU

Line 2651: FROM pji_pmv_time_dim_tmp

2647: , NULL AS budget
2648: , NULL AS CT_BUDGET
2649: , 0 non_bill_cost
2650: , 0 CT_Non_Bill_Cost
2651: FROM pji_pmv_time_dim_tmp
2652: WHERE name <> '-1')
2653: GROUP BY
2654: TIME_KEY
2655: , TIME_ID ORDER BY TIME_KEY ASC;

Line 2707: PJI_PMV_TIME_DIM_TMP TIME

2703: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
2704: 'BC', contract_brdn_cost - bill_burdened_cost),0) non_bill_cost
2705: , 0 CT_Non_Bill_Cost
2706: FROM
2707: PJI_PMV_TIME_DIM_TMP TIME
2708: , PJI_PMV_ORGZ_DIM_TMP HORG
2709: , PJI_PMV_ET_RT_DIM_TMP ET
2710: , PJI_FP_CLSO_ET_F_MV FCT
2711: , PJI_PMV_CLS_DIM_TMP CLS

Line 2743: PJI_PMV_TIME_DIM_TMP TIME

2739: , DECODE(NVL(TIME.amount_type,1),1,
2740: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
2741: 'BC', contract_brdn_cost - bill_burdened_cost),0) CT_Non_Bill_Cost
2742: FROM
2743: PJI_PMV_TIME_DIM_TMP TIME
2744: , PJI_PMV_ORGZ_DIM_TMP HORG
2745: , PJI_PMV_ET_RT_DIM_TMP ET
2746: , PJI_FP_CLSO_ET_F_MV FCT
2747: , PJI_PMV_CLS_DIM_TMP CLS

Line 2772: FROM pji_pmv_time_dim_tmp

2768: , NULL AS budget
2769: , NULL AS CT_BUDGET
2770: , 0 non_bill_cost
2771: , 0 CT_Non_Bill_Cost
2772: FROM pji_pmv_time_dim_tmp
2773: WHERE name <> '-1')
2774: GROUP BY
2775: TIME_KEY
2776: , TIME_ID ORDER BY TIME_KEY ASC;

Line 2828: PJI_PMV_TIME_DIM_TMP TIME

2824: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
2825: 'BC', contract_brdn_cost - bill_burdened_cost),0) non_bill_cost
2826: , 0 CT_Non_Bill_Cost
2827: FROM
2828: PJI_PMV_TIME_DIM_TMP TIME
2829: , PJI_PMV_ORGZ_DIM_TMP HORG
2830: , PJI_PMV_ET_RT_DIM_TMP ET
2831: , PJI_FP_ORGO_ET_WT_F_MV FCT
2832: , PJI_PMV_WT_DIM_TMP WT

Line 2863: PJI_PMV_TIME_DIM_TMP TIME

2859: , DECODE(NVL(TIME.amount_type,1),1,
2860: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
2861: 'BC', contract_brdn_cost - bill_burdened_cost),0) CT_Non_Bill_Cost
2862: FROM
2863: PJI_PMV_TIME_DIM_TMP TIME
2864: , PJI_PMV_ORGZ_DIM_TMP HORG
2865: , PJI_PMV_ET_RT_DIM_TMP ET
2866: , PJI_FP_ORGO_ET_WT_F_MV FCT
2867: , PJI_PMV_WT_DIM_TMP WT

Line 2892: FROM pji_pmv_time_dim_tmp

2888: , NULL AS budget
2889: , NULL AS CT_BUDGET
2890: , 0 non_bill_cost
2891: , 0 CT_Non_Bill_Cost
2892: FROM pji_pmv_time_dim_tmp
2893: WHERE name <> '-1')
2894: GROUP BY
2895: TIME_KEY
2896: , TIME_ID ORDER BY TIME_KEY ASC;

Line 2947: PJI_PMV_TIME_DIM_TMP TIME

2943: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
2944: 'BC', contract_brdn_cost - bill_burdened_cost),0) non_bill_cost
2945: , 0 CT_Non_Bill_Cost
2946: FROM
2947: PJI_PMV_TIME_DIM_TMP TIME
2948: , PJI_PMV_ORGZ_DIM_TMP HORG
2949: , PJI_PMV_CLS_DIM_TMP CLS
2950: , PJI_FP_CLSO_ET_WT_F_MV FCT
2951: , PJI_PMV_WT_DIM_TMP WT

Line 2981: PJI_PMV_TIME_DIM_TMP TIME

2977: , DECODE(NVL(TIME.amount_type,1),1,
2978: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
2979: 'BC', contract_brdn_cost - bill_burdened_cost),0) CT_Non_Bill_Cost
2980: FROM
2981: PJI_PMV_TIME_DIM_TMP TIME
2982: , PJI_PMV_ORGZ_DIM_TMP HORG
2983: , PJI_PMV_CLS_DIM_TMP CLS
2984: , PJI_FP_CLSO_ET_WT_F_MV FCT
2985: , PJI_PMV_WT_DIM_TMP WT

Line 3009: FROM pji_pmv_time_dim_tmp

3005: , NULL AS budget
3006: , NULL AS CT_BUDGET
3007: , 0 non_bill_cost
3008: , 0 CT_Non_Bill_Cost
3009: FROM pji_pmv_time_dim_tmp
3010: WHERE name <> '-1')
3011: GROUP BY
3012: TIME_KEY
3013: , TIME_ID ORDER BY TIME_KEY ASC;

Line 3062: PJI_PMV_TIME_DIM_TMP TIME

3058: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
3059: 'BC', contract_brdn_cost - bill_burdened_cost),0) non_bill_cost
3060: , 0 CT_Non_Bill_Cost
3061: FROM
3062: PJI_PMV_TIME_DIM_TMP TIME
3063: , PJI_PMV_ORGZ_DIM_TMP HORG
3064: , PJI_PMV_ET_RT_DIM_TMP ET
3065: , PJI_FP_CLSO_ET_WT_F_MV FCT
3066: , PJI_PMV_CLS_DIM_TMP CLS

Line 3099: PJI_PMV_TIME_DIM_TMP TIME

3095: , DECODE(NVL(TIME.amount_type,1),1,
3096: DECODE(l_Report_Cost_Type,'RC', contract_raw_cost - bill_raw_cost,
3097: 'BC', contract_brdn_cost - bill_burdened_cost),0) CT_Non_Bill_Cost
3098: FROM
3099: PJI_PMV_TIME_DIM_TMP TIME
3100: , PJI_PMV_ORGZ_DIM_TMP HORG
3101: , PJI_PMV_ET_RT_DIM_TMP ET
3102: , PJI_FP_CLSO_ET_WT_F_MV FCT
3103: , PJI_PMV_CLS_DIM_TMP CLS

Line 3130: FROM pji_pmv_time_dim_tmp

3126: , NULL AS budget
3127: , NULL AS CT_BUDGET
3128: , 0 non_bill_cost
3129: , 0 CT_Non_Bill_Cost
3130: FROM pji_pmv_time_dim_tmp
3131: WHERE name <> '-1')
3132: GROUP BY
3133: TIME_KEY
3134: , TIME_ID ORDER BY TIME_KEY ASC;

Line 3442: FROM PJI_PMV_TIME_DIM_TMP TIME

3438: , DECODE(TIME.amount_type,1,
3439: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3440: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3441:
3442: FROM PJI_PMV_TIME_DIM_TMP TIME
3443: , PJI_PMV_PRJ_DIM_TMP PRJ
3444: , PJI_PMV_ORGZ_DIM_TMP HORG
3445: , PJI_FP_PROJ_F FCT
3446: , PJI_PMV_ORG_DIM_TMP HOU

Line 3499: FROM PJI_PMV_TIME_DIM_TMP TIME

3495: , DECODE(TIME.amount_type,1,
3496: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3497: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3498:
3499: FROM PJI_PMV_TIME_DIM_TMP TIME
3500: , PJI_PMV_PRJ_DIM_TMP PRJ
3501: , PJI_FP_PROJ_F FCT
3502: , PJI_PMV_ORG_DIM_TMP HOU
3503: WHERE 1=1

Line 3557: FROM PJI_PMV_TIME_DIM_TMP TIME

3553: , DECODE(TIME.amount_type,1,
3554: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3555: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3556:
3557: FROM PJI_PMV_TIME_DIM_TMP TIME
3558: , PJI_PMV_PRJ_DIM_TMP PRJ
3559: , PJI_PMV_ET_RT_DIM_TMP ET
3560: , PJI_FP_PROJ_ET_F FCT
3561: , PJI_PMV_ORG_DIM_TMP HOU

Line 3616: FROM PJI_PMV_TIME_DIM_TMP TIME

3612: , DECODE(TIME.amount_type,1,
3613: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3614: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3615:
3616: FROM PJI_PMV_TIME_DIM_TMP TIME
3617: , PJI_PMV_PRJ_DIM_TMP PRJ
3618: , PJI_PMV_WT_DIM_TMP WT
3619: , PJI_FP_PROJ_ET_WT_F FCT
3620: , PJI_PMV_ORG_DIM_TMP HOU

Line 3675: FROM PJI_PMV_TIME_DIM_TMP TIME

3671: , DECODE(TIME.amount_type,1,
3672: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3673: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3674:
3675: FROM PJI_PMV_TIME_DIM_TMP TIME
3676: , PJI_PMV_PRJ_DIM_TMP PRJ
3677: , PJI_PMV_ET_RT_DIM_TMP ET
3678: , PJI_FP_PROJ_ET_F FCT
3679: , PJI_PMV_ORG_DIM_TMP HOU

Line 3734: FROM PJI_PMV_TIME_DIM_TMP TIME

3730: , DECODE(TIME.amount_type,1,
3731: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3732: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3733:
3734: FROM PJI_PMV_TIME_DIM_TMP TIME
3735: , PJI_PMV_PRJ_DIM_TMP PRJ
3736: , PJI_PMV_ET_RT_DIM_TMP ET
3737: , PJI_PMV_WT_DIM_TMP WT
3738: , PJI_FP_PROJ_ET_WT_F FCT

Line 3793: FROM PJI_PMV_TIME_DIM_TMP TIME

3789: , DECODE(TIME.amount_type,1,
3790: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3791: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3792:
3793: FROM PJI_PMV_TIME_DIM_TMP TIME
3794: , PJI_PMV_PRJ_DIM_TMP PRJ
3795: , PJI_PMV_WT_DIM_TMP WT
3796: , PJI_FP_PROJ_ET_WT_F FCT
3797: , PJI_PMV_ORG_DIM_TMP HOU

Line 3843: FROM PJI_PMV_TIME_DIM_TMP TIME

3839: , DECODE(TIME.amount_type,1,
3840: DECODE(G_Report_Cost_Type, 'BC', fct.BURDENED_COST - fct.bill_burdened_cost,
3841: 'RC', fct.RAW_COST - fct.bill_raw_cost, 0), 0) AS NON_BILL_COST
3842:
3843: FROM PJI_PMV_TIME_DIM_TMP TIME
3844: , PJI_PMV_PRJ_DIM_TMP PRJ
3845: , PJI_PMV_ET_RT_DIM_TMP ET
3846: , PJI_PMV_WT_DIM_TMP WT
3847: , PJI_FP_PROJ_ET_WT_F FCT