[Home] [Help]
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
435: fct.org_id = hou.id
464: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
465: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
466: FROM
467: PJI_PMV_TCMP_DIM_TMP TIME
468: , PJI_PMV_ORGZ_DIM_TMP HORG
469: , PJI_FP_ORGO_F_MV fct
470: , PJI_PMV_ORG_DIM_TMP HOU
471: WHERE
472: fct.org_id = hou.id
507: , 0 AS BUDGET
508: , 0 AS CT_BUDGET
509: , 0 AS NON_BILL_COST
510: , 0 AS CT_NON_BILL_COST
511: FROM PJI_PMV_ORGZ_DIM_TMP HORG
512: WHERE HORG.NAME <> '-1'
513: ) WHERE 1=1
514: GROUP BY ORG_ID, ORGANIZATION_ID, PROJECT_CLASS_ID, EXPENDITURE_CATEGORY,
515: EXPENDITURE_TYPE_ID,WORK_TYPE_ID;
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
580: WHERE
611: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
612: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
613: FROM
614: PJI_PMV_TCMP_DIM_TMP TIME
615: , PJI_PMV_ORGZ_DIM_TMP HORG
616: , PJI_PMV_CLS_DIM_TMP CLS
617: , PJI_FP_CLSO_F_MV FCT
618: , PJI_PMV_ORG_DIM_TMP HOU
619: WHERE
656: , 0 AS BUDGET
657: , 0 AS CT_BUDGET
658: , 0 AS NON_BILL_COST
659: , 0 AS CT_NON_BILL_COST
660: FROM PJI_PMV_ORGZ_DIM_TMP HORG
661: WHERE HORG.NAME <> '-1'
662: UNION ALL
663: SELECT '-1' AS ORG_ID
664: , '-1' AS ORGANIZATION_ID
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
749: WHERE
779: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
780: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
781: FROM
782: PJI_PMV_TCMP_DIM_TMP TIME
783: , PJI_PMV_ORGZ_DIM_TMP HORG
784: , PJI_PMV_ET_RT_DIM_TMP ET
785: , PJI_FP_ORGO_ET_F_MV FCT
786: , PJI_PMV_ORG_DIM_TMP HOU
787: WHERE
825: , 0 AS BUDGET
826: , 0 AS CT_BUDGET
827: , 0 AS NON_BILL_COST
828: , 0 AS CT_NON_BILL_COST
829: FROM PJI_PMV_ORGZ_DIM_TMP HORG
830: WHERE HORG.NAME <> '-1'
831: UNION ALL
832: SELECT '-1' AS ORG_ID
833: , '-1' AS ORGANIZATION_ID
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
918: WHERE
947: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
948: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
949: FROM
950: PJI_PMV_TCMP_DIM_TMP TIME
951: , PJI_PMV_ORGZ_DIM_TMP HORG
952: , PJI_PMV_WT_DIM_TMP WT
953: , PJI_FP_ORGO_ET_WT_F_MV FCT
954: , PJI_PMV_ORG_DIM_TMP HOU
955: WHERE
992: , 0 AS BUDGET
993: , 0 AS CT_BUDGET
994: , 0 AS NON_BILL_COST
995: , 0 AS CT_NON_BILL_COST
996: FROM PJI_PMV_ORGZ_DIM_TMP HORG
997: WHERE HORG.NAME <> '-1'
998: UNION ALL
999: SELECT '-1' AS ORG_ID
1000: , '-1' AS ORGANIZATION_ID
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
1086: , PJI_PMV_ORG_DIM_TMP HOU
1118: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
1119: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
1120: FROM
1121: PJI_PMV_TCMP_DIM_TMP TIME
1122: , PJI_PMV_ORGZ_DIM_TMP HORG
1123: , PJI_PMV_ET_RT_DIM_TMP ET
1124: , PJI_FP_CLSO_ET_F_MV FCT
1125: , PJI_PMV_CLS_DIM_TMP CLS
1126: , PJI_PMV_ORG_DIM_TMP HOU
1166: , 0 AS BUDGET
1167: , 0 AS CT_BUDGET
1168: , 0 AS NON_BILL_COST
1169: , 0 AS CT_NON_BILL_COST
1170: FROM PJI_PMV_ORGZ_DIM_TMP HORG
1171: WHERE HORG.NAME <> '-1'
1172: UNION ALL
1173: SELECT '-1' AS ORG_ID
1174: , '-1' AS ORGANIZATION_ID
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
1273: , PJI_PMV_ORG_DIM_TMP HOU
1305: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
1306: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
1307: FROM
1308: PJI_PMV_TCMP_DIM_TMP TIME
1309: , PJI_PMV_ORGZ_DIM_TMP HORG
1310: , PJI_PMV_ET_RT_DIM_TMP ET
1311: , PJI_FP_ORGO_ET_WT_F_MV FCT
1312: , PJI_PMV_WT_DIM_TMP WT
1313: , PJI_PMV_ORG_DIM_TMP HOU
1353: , 0 AS BUDGET
1354: , 0 AS CT_BUDGET
1355: , 0 AS NON_BILL_COST
1356: , 0 AS CT_NON_BILL_COST
1357: FROM PJI_PMV_ORGZ_DIM_TMP HORG
1358: WHERE HORG.NAME <> '-1'
1359: UNION ALL
1360: SELECT '-1' AS ORG_ID
1361: , '-1' AS ORGANIZATION_ID
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
1458: , PJI_PMV_ORG_DIM_TMP HOU
1489: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
1490: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
1491: FROM
1492: PJI_PMV_TCMP_DIM_TMP TIME
1493: , PJI_PMV_ORGZ_DIM_TMP HORG
1494: , PJI_PMV_CLS_DIM_TMP CLS
1495: , PJI_FP_CLSO_ET_WT_F_MV FCT
1496: , PJI_PMV_WT_DIM_TMP WT
1497: , PJI_PMV_ORG_DIM_TMP HOU
1536: , 0 AS BUDGET
1537: , 0 AS CT_BUDGET
1538: , 0 AS NON_BILL_COST
1539: , 0 AS CT_NON_BILL_COST
1540: FROM PJI_PMV_ORGZ_DIM_TMP HORG
1541: WHERE HORG.NAME <> '-1'
1542: UNION ALL
1543: SELECT '-1' AS ORG_ID
1544: , '-1' AS ORGANIZATION_ID
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
1638: , PJI_PMV_WT_DIM_TMP WT
1672: DECODE(G_Report_Cost_Type, 'BC', FCT.CONTRACT_BRDN_COST - FCT.BILL_BURDENED_COST,
1673: 'RC', FCT.CONTRACT_RAW_COST - FCT.BILL_RAW_COST,0), 0) AS CT_NON_BILL_COST
1674: FROM
1675: PJI_PMV_TCMP_DIM_TMP TIME
1676: , PJI_PMV_ORGZ_DIM_TMP HORG
1677: , PJI_PMV_ET_RT_DIM_TMP ET
1678: , PJI_FP_CLSO_ET_WT_F_MV FCT
1679: , PJI_PMV_CLS_DIM_TMP CLS
1680: , PJI_PMV_WT_DIM_TMP WT
1722: , 0 AS BUDGET
1723: , 0 AS CT_BUDGET
1724: , 0 AS NON_BILL_COST
1725: , 0 AS CT_NON_BILL_COST
1726: FROM PJI_PMV_ORGZ_DIM_TMP HORG
1727: WHERE HORG.NAME <> '-1'
1728: UNION ALL
1729: SELECT '-1' AS ORG_ID
1730: , '-1' AS ORGANIZATION_ID
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
2252: FCT.org_id = HOU.id
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
2284: FCT.org_id = HOU.id
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
2365: WHERE
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
2399: WHERE
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
2481: WHERE
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
2514: WHERE
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
2597: WHERE
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
2630: WHERE
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
2712: , PJI_PMV_ORG_DIM_TMP HOU
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
2748: , PJI_PMV_ORG_DIM_TMP HOU
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
2833: , PJI_PMV_ORG_DIM_TMP HOU
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
2868: , PJI_PMV_ORG_DIM_TMP HOU
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
2952: , PJI_PMV_ORG_DIM_TMP HOU
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
2986: , PJI_PMV_ORG_DIM_TMP HOU
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
3067: , PJI_PMV_WT_DIM_TMP WT
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
3104: , PJI_PMV_WT_DIM_TMP WT
3352: SELECT DISTINCT prj.project_id, '-1' name
3353: FROM
3354: pji_project_classes PJM
3355: , pji_pmv_cls_dim_tmp PTM
3356: , pji_pmv_orgz_dim_tmp org
3357: , pa_projects_all prj
3358: WHERE
3359: pjm.project_class_id = ptm.id
3360: AND prj.project_id = pjm.project_id
3374: , (SELECT project_id
3375: FROM pji_project_classes
3376: WHERE class_category = '$PROJECT_TYPE$CONTRACT') PJC
3377: , pji_pmv_cls_dim_tmp PTM
3378: , pji_pmv_orgz_dim_tmp org
3379: , pa_projects_all prj
3380: WHERE 1=1
3381: AND pjm.project_class_id = ptm.id
3382: AND prj.project_id = pjc.project_id
3386: INSERT INTO pji_pmv_prj_dim_tmp (id, name)
3387: SELECT DISTINCT prj.project_id, '-1' name
3388: FROM
3389: pji_project_classes PJM
3390: , pji_pmv_orgz_dim_tmp org
3391: , pa_projects_all prj
3392: WHERE
3393: prj.project_id = pjm.project_id
3394: AND prj.carrying_out_organization_id = org.ID
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
3447: WHERE 1=1
3448: AND bitand(fct.curr_record_type_id, l_curr_record_type_id) = l_curr_record_type_id