[Home] [Help]
337: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) cost
338: , 0 py_revenue
339: , 0 py_cost
340: FROM
341: pji_pmv_time_dim_tmp TIME
342: , pji_pmv_orgz_dim_tmp HORG
343: , pji_fp_orgo_f_mv FCT
344: , pji_pmv_org_dim_tmp HOU
345: WHERE
358: , 0 cost
359: , revenue py_revenue
360: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
361: FROM
362: pji_pmv_time_dim_tmp TIME
363: , pji_pmv_orgz_dim_tmp HORG
364: , pji_fp_orgo_f_mv FCT
365: , pji_pmv_org_dim_tmp HOU
366: WHERE
378: , 0 revenue
379: , 0 cost
380: , 0 py_revenue
381: , 0 py_cost
382: FROM pji_pmv_time_dim_tmp
383: WHERE name <> '-1')
384: GROUP BY
385: TIME_KEY
386: , TIME_ID ORDER BY TIME_KEY ASC;
417: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) cost
418: , 0 py_revenue
419: , 0 py_cost
420: FROM
421: pji_pmv_time_dim_tmp TIME
422: , pji_pmv_orgz_dim_tmp HORG
423: , pji_pmv_cls_dim_tmp CLS
424: , pji_fp_clso_f_mv FCT
425: , pji_pmv_org_dim_tmp HOU
440: , 0 cost
441: , revenue py_revenue
442: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
443: FROM
444: pji_pmv_time_dim_tmp TIME
445: , pji_pmv_orgz_dim_tmp HORG
446: , pji_pmv_cls_dim_tmp CLS
447: , pji_fp_clso_f_mv FCT
448: , pji_pmv_org_dim_tmp HOU
462: , 0 revenue
463: , 0 cost
464: , 0 py_revenue
465: , 0 py_cost
466: FROM pji_pmv_time_dim_tmp
467: WHERE name <> '-1')
468: GROUP BY
469: TIME_KEY
470: , TIME_ID ORDER BY TIME_KEY ASC;
496: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) cost
497: , 0 py_revenue
498: , 0 py_cost
499: FROM
500: pji_pmv_time_dim_tmp TIME
501: , pji_pmv_orgz_dim_tmp HORG
502: , pji_pmv_et_rt_dim_tmp ET
503: , PJI_FP_ORGO_ET_F_MV FCT
504: , pji_pmv_org_dim_tmp HOU
521: , 0 cost
522: , revenue py_revenue
523: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
524: FROM
525: pji_pmv_time_dim_tmp TIME
526: , pji_pmv_orgz_dim_tmp HORG
527: , pji_pmv_et_rt_dim_tmp ET
528: , PJI_FP_ORGO_ET_F_MV FCT
529: , pji_pmv_org_dim_tmp HOU
544: , 0 revenue
545: , 0 cost
546: , 0 py_revenue
547: , 0 py_cost
548: FROM pji_pmv_time_dim_tmp
549: WHERE name <> '-1')
550: GROUP BY
551: TIME_KEY
552: , TIME_ID ORDER BY TIME_KEY ASC;
579: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) cost
580: , 0 py_revenue
581: , 0 py_cost
582: FROM
583: pji_pmv_time_dim_tmp TIME
584: , pji_pmv_orgz_dim_tmp HORG
585: , pji_pmv_wt_dim_tmp WT
586: , PJI_FP_ORGO_ET_WT_F_MV FCT
587: , pji_pmv_org_dim_tmp HOU
602: , 0 cost
603: , null py_revenue
604: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
605: FROM
606: pji_pmv_time_dim_tmp TIME
607: , pji_pmv_orgz_dim_tmp HORG
608: , pji_pmv_wt_dim_tmp WT
609: , PJI_FP_ORGO_ET_WT_F_MV FCT
610: , pji_pmv_org_dim_tmp HOU
624: , 0 revenue
625: , 0 cost
626: , 0 py_revenue
627: , 0 py_cost
628: FROM pji_pmv_time_dim_tmp
629: WHERE name <> '-1')
630: GROUP BY
631: TIME_KEY
632: , TIME_ID ORDER BY TIME_KEY ASC;
657: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) cost
658: , 0 py_revenue
659: , 0 py_cost
660: FROM
661: pji_pmv_time_dim_tmp TIME
662: , pji_pmv_orgz_dim_tmp HORG
663: , pji_pmv_cls_dim_tmp CLS
664: , pji_pmv_et_rt_dim_tmp ET
665: , PJI_FP_CLSO_ET_F_MV FCT
683: , 0 cost
684: , revenue py_revenue
685: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
686: FROM
687: pji_pmv_time_dim_tmp TIME
688: , pji_pmv_orgz_dim_tmp HORG
689: , pji_pmv_cls_dim_tmp CLS
690: , pji_pmv_et_rt_dim_tmp ET
691: , PJI_FP_CLSO_ET_F_MV FCT
708: , 0 revenue
709: , 0 cost
710: , 0 py_revenue
711: , 0 py_cost
712: FROM pji_pmv_time_dim_tmp
713: WHERE name <> '-1')
714: GROUP BY
715: TIME_KEY
716: , TIME_ID ORDER BY TIME_KEY ASC;
742: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) cost
743: , 0 py_revenue
744: , 0 py_cost
745: FROM
746: pji_pmv_time_dim_tmp TIME
747: , pji_pmv_orgz_dim_tmp HORG
748: , pji_pmv_et_rt_dim_tmp ET
749: , pji_pmv_wt_dim_tmp WT
750: , PJI_FP_ORGO_ET_WT_F_MV FCT
768: , 0 cost
769: , null py_revenue
770: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
771: FROM
772: pji_pmv_time_dim_tmp TIME
773: , pji_pmv_orgz_dim_tmp HORG
774: , pji_pmv_et_rt_dim_tmp ET
775: , pji_pmv_wt_dim_tmp WT
776: , PJI_FP_ORGO_ET_WT_F_MV FCT
793: , 0 revenue
794: , 0 cost
795: , 0 py_revenue
796: , 0 py_cost
797: FROM pji_pmv_time_dim_tmp
798: WHERE name <> '-1')
799: GROUP BY
800: TIME_KEY
801: , TIME_ID ORDER BY TIME_KEY ASC;
828: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) cost
829: , 0 py_revenue
830: , 0 py_cost
831: FROM
832: pji_pmv_time_dim_tmp TIME
833: , pji_pmv_orgz_dim_tmp HORG
834: , pji_pmv_cls_dim_tmp CLS
835: , pji_pmv_wt_dim_tmp WT
836: , PJI_FP_CLSO_ET_WT_F_MV FCT
853: , 0 cost
854: , null py_revenue
855: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
856: FROM
857: pji_pmv_time_dim_tmp TIME
858: , pji_pmv_orgz_dim_tmp HORG
859: , pji_pmv_cls_dim_tmp CLS
860: , pji_pmv_wt_dim_tmp WT
861: , PJI_FP_CLSO_ET_WT_F_MV FCT
877: , 0 revenue
878: , 0 cost
879: , 0 py_revenue
880: , 0 py_cost
881: FROM pji_pmv_time_dim_tmp
882: WHERE name <> '-1')
883: GROUP BY
884: TIME_KEY
885: , TIME_ID ORDER BY TIME_KEY ASC;
909: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) cost
910: , 0 py_revenue
911: , 0 py_cost
912: FROM
913: pji_pmv_time_dim_tmp TIME
914: , pji_pmv_orgz_dim_tmp HORG
915: , pji_pmv_cls_dim_tmp CLS
916: , pji_pmv_et_rt_dim_tmp ET
917: , pji_pmv_wt_dim_tmp WT
937: , 0 cost
938: , null py_revenue
939: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
940: FROM
941: pji_pmv_time_dim_tmp TIME
942: , pji_pmv_orgz_dim_tmp HORG
943: , pji_pmv_cls_dim_tmp CLS
944: , pji_pmv_et_rt_dim_tmp ET
945: , pji_pmv_wt_dim_tmp WT
964: , 0 revenue
965: , 0 cost
966: , 0 py_revenue
967: , 0 py_cost
968: FROM pji_pmv_time_dim_tmp
969: WHERE name <> '-1')
970: GROUP BY
971: TIME_KEY
972: , TIME_ID ORDER BY TIME_KEY ASC;