Untitled diff
10 removals
28 lines
10 additions
28 lines
SELECT T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 2 DEGER_TIPI, T4.ISBIRIMI_SEC_ID ORG_ID, 9 SEVIYE_ID, T4.MIY_SEGMENT_KODU, -1 MBB_SEGMENT_KODU, 2 PARA_BIRIMI, SUM( General Information.Convert_To_TL_AVG ( T1.TARIH, T1.DOVIZ_KODU,( NVL (T1.ORTALAMA_TUTARI, 0)))) AS GERC_MAL_TL
SELECT T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 1 DEGER_TIPI, T4.ISBIRIMI_SEC_ID ORG_ID, 9 SEVIYE_ID, T4.MIY_SEGMENT_KODU, -1 MBB_SEGMENT_KODU, 2 PARA_BIRIMI, SUM( General Information.Convert_To_TL ( T1.TARIH, T1.DOVIZ_KODU,( NVL (T1.NOKTA_BAKIYE_TUMU, 0)))) AS GERC_MAL_TL
FROM PARG.ARG_TISTATISTIK_GUNLUK_HSP_MAL T1, PARG.ARG_THESAP_MAL T2, PARG.ARG_TURUN_AGAC_FLAT T3, (SELECT DISTINCT
FROM PARG.ARG_TISTATISTIK_GUNLUK_HSP_MAL T1, PARG.ARG_THESAP_MAL T2, PARG.ARG_TURUN_AGAC_FLAT T3, (SELECT DISTINCT
ISBIRIMI_SEC_ID, MIY_SEGMENT_KODU
ISBIRIMI_SEC_ID, MIY_SEGMENT_KODU
FROM PARG_MART.DIM_ORGANIZASYON_HIYERARSI
FROM PARG_MART.DIM_ORGANIZASYON_HIYERARSI
WHERE 'p_Last_Day_of_Month' BETWEEN BASLANGIC_TARIHI AND BITIS_TARIHI) T4
WHERE 'p_Last_Day_of_Month' BETWEEN BASLANGIC_TARIHI AND BITIS_TARIHI) T4
WHERE T1.HESAP_ID = T2.HESAP_ID
WHERE T1.HESAP_ID = T2.HESAP_ID
AND T1.URUN_ID = T3.URUN_ID
AND T1.URUN_ID = T3.URUN_ID
AND (case when T2.MIY_SEGMENT_KODU IN (100,200,800) then T2.MIY_SEGMENT_KODU else 600 end )= T4.MIY_SEGMENT_KODU
AND (case when T2.MIY_SEGMENT_KODU IN (100,200,800) then T2.MIY_SEGMENT_KODU else 600 end )= T4.MIY_SEGMENT_KODU
AND T4.MIY_SEGMENT_KODU IN (100,200,800,600)
AND T4.MIY_SEGMENT_KODU IN (100,200,800,600)
AND T3.URUN_SEVIYE4_ID IN '&PDWH URUN_ID'
AND T3.URUN_SEVIYE4_ID IN '&PDWH URUN_ID'
AND T1.FREKANS_ID = 3
AND T1.FREKANS_ID = 1
AND T1.TARIH = 'p_Last_Day_of_Month'
AND T1.TARIH = 'p_Last_Day_of_Month'
GROUP BY T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 2, T4.ISBIRIMI_SEC_ID, 9 , T4.MIY_SEGMENT_KODU, -1, 1
GROUP BY T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 1, T4.ISBIRIMI_SEC_ID, 9 , T4.MIY_SEGMENT_KODU, -1, 1
UNION
UNION
SELECT T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 2 DEGER_TIPI, T4.ISBIRIMI_SEC_ID ORG_ID, 9 SEVIYE_ID, T4.MIY_SEGMENT_KODU, -1 MBB_SEGMENT_KODU, 2 PARA_BIRIMI, SUM( General Information.Convert_To_TL_AVG ( T1.TARIH, T1.DOVIZ_KODU,( NVL (T1.ORTALAMA_TUTARI, 0)))) AS GERC_MAL_TL
SELECT T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 1 DEGER_TIPI, T4.ISBIRIMI_SEC_ID ORG_ID, 9 SEVIYE_ID, T4.MIY_SEGMENT_KODU, -1 MBB_SEGMENT_KODU, 2 PARA_BIRIMI, SUM( General Information.Convert_To_TL ( T1.TARIH, T1.DOVIZ_KODU,( NVL (T1.NOKTA_BAKIYE_TUMU, 0)))) AS GERC_MAL_TL
FROM PARG.ARG_TISTATISTIK_GUNLUK_HSP_DWH T1, PARG.ARG_THESAP_DWH T2, PARG.ARG_TURUN_AGAC_FLAT T3, (SELECT DISTINCT
FROM PARG.ARG_TISTATISTIK_GUNLUK_HSP_DWH T1, PARG.ARG_THESAP_DWH T2, PARG.ARG_TURUN_AGAC_FLAT T3, (SELECT DISTINCT
ISBIRIMI_SEC_ID, MIY_SEGMENT_KODU
ISBIRIMI_SEC_ID, MIY_SEGMENT_KODU
FROM PARG_MART.DIM_ORGANIZASYON_HIYERARSI
FROM PARG_MART.DIM_ORGANIZASYON_HIYERARSI
WHERE 'p_Last_Day_of_Month' BETWEEN BASLANGIC_TARIHI AND BITIS_TARIHI) T4
WHERE 'p_Last_Day_of_Month' BETWEEN BASLANGIC_TARIHI AND BITIS_TARIHI) T4
WHERE T1.HESAP_ID = T2.HESAP_ID
WHERE T1.HESAP_ID = T2.HESAP_ID
AND T1.URUN_ID = T3.URUN_ID
AND T1.URUN_ID = T3.URUN_ID
AND (case when T2.MIY_SEGMENT_KODU IN (100,200,800) then T2.MIY_SEGMENT_KODU else 600 end )= T4.MIY_SEGMENT_KODU
AND (case when T2.MIY_SEGMENT_KODU IN (100,200,800) then T2.MIY_SEGMENT_KODU else 600 end )= T4.MIY_SEGMENT_KODU
AND T4.MIY_SEGMENT_KODU IN (100,200,800,600)
AND T4.MIY_SEGMENT_KODU IN (100,200,800,600)
AND T3.URUN_SEVIYE4_ID IN '&PDWH URUN_ID'
AND T3.URUN_SEVIYE4_ID IN '&PDWH URUN_ID'
AND T1.FREKANS_ID = 3
AND T1.FREKANS_ID = 1
AND T1.TARIH = 'p_Last_Day_of_Month'
AND T1.TARIH = 'p_Last_Day_of_Month'
AND T2.HESAP_ACILIS_SUBE_ALT_KANAL_ID=649
AND T2.HESAP_ACILIS_SUBE_ALT_KANAL_ID=649
GROUP BY T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 2, T4.ISBIRIMI_SEC_ID, 9 , T4.MIY_SEGMENT_KODU, -1, 1
GROUP BY T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 1, T4.ISBIRIMI_SEC_ID, 9 , T4.MIY_SEGMENT_KODU, -1, 1