1044: inner.currency_code_fc,
1045: 'N',
1046: inner.transaction_create_date,
1047: inner.weekend_date,
1048: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),
1049: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),
1050: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),
1051: inner.business_unit_id
1052: FROM (
1045: 'N',
1046: inner.transaction_create_date,
1047: inner.weekend_date,
1048: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),
1049: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),
1050: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),
1051: inner.business_unit_id
1052: FROM (
1053: SELECT fund_id fund_id,
1046: inner.transaction_create_date,
1047: inner.weekend_date,
1048: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),
1049: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),
1050: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),
1051: inner.business_unit_id
1052: FROM (
1053: SELECT fund_id fund_id,
1054: fund_number fund_number,
1372: inner.currency_code_fc,
1373: 'N',
1374: inner.transaction_create_date,
1375: inner.weekend_date,
1376: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),
1377: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),
1378: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),
1379: inner.business_unit_id
1380: FROM (
1373: 'N',
1374: inner.transaction_create_date,
1375: inner.weekend_date,
1376: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),
1377: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),
1378: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),
1379: inner.business_unit_id
1380: FROM (
1381: SELECT transaction_create_date transaction_create_date,
1374: inner.transaction_create_date,
1375: inner.weekend_date,
1376: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),
1377: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),
1378: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),
1379: inner.business_unit_id
1380: FROM (
1381: SELECT transaction_create_date transaction_create_date,
1382: trunc((decode(decode( to_char(transaction_create_date,'MM') , to_char(next_day(transaction_create_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM') ,'TRUE','FALSE' )
1748: ,'FALSE'
1749: ,last_day(inner.transaction_create_date))))) weekend_date
1750: ,inner.object_id
1751: ,inner.object_type
1752: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)
1753: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)
1754: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)
1755: FROM (SELECT AD.fund_id fund_id,
1756: U.business_unit_id business_unit_id,
1749: ,last_day(inner.transaction_create_date))))) weekend_date
1750: ,inner.object_id
1751: ,inner.object_type
1752: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)
1753: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)
1754: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)
1755: FROM (SELECT AD.fund_id fund_id,
1756: U.business_unit_id business_unit_id,
1757: U.org_id org_id,
1750: ,inner.object_id
1751: ,inner.object_type
1752: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)
1753: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)
1754: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)
1755: FROM (SELECT AD.fund_id fund_id,
1756: U.business_unit_id business_unit_id,
1757: U.org_id org_id,
1758: NVL(AU.standard_discount,0) standard_discount,
1948: ,'FALSE'
1949: ,last_day(inner.transaction_create_date))))) weekend_date
1950: ,inner.object_id
1951: ,inner.object_type
1952: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)
1953: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)
1954: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)
1955: FROM (SELECT AD.fund_id fund_id,
1956: U.business_unit_id business_unit_id,
1949: ,last_day(inner.transaction_create_date))))) weekend_date
1950: ,inner.object_id
1951: ,inner.object_type
1952: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)
1953: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)
1954: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)
1955: FROM (SELECT AD.fund_id fund_id,
1956: U.business_unit_id business_unit_id,
1957: U.org_id org_id,
1950: ,inner.object_id
1951: ,inner.object_type
1952: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)
1953: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)
1954: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)
1955: FROM (SELECT AD.fund_id fund_id,
1956: U.business_unit_id business_unit_id,
1957: U.org_id org_id,
1958: NVL(AU.standard_discount,0) standard_discount,
2275: ,inner.currency_code_fc
2276: ,'N'
2277: ,inner.load_date
2278: ,inner.load_date
2279: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)
2280: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)
2281: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)
2282: ,inner.business_unit_id
2283: FROM(SELECT fund_id fund_id
2276: ,'N'
2277: ,inner.load_date
2278: ,inner.load_date
2279: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)
2280: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)
2281: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)
2282: ,inner.business_unit_id
2283: FROM(SELECT fund_id fund_id
2284: ,parent_fund_id parent_fund_id
2277: ,inner.load_date
2278: ,inner.load_date
2279: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)
2280: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)
2281: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)
2282: ,inner.business_unit_id
2283: FROM(SELECT fund_id fund_id
2284: ,parent_fund_id parent_fund_id
2285: ,fund_number fund_number
2386: ,inner.load_date
2387: ,inner.load_date
2388: ,inner.object_id
2389: ,inner.object_type
2390: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)
2391: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)
2392: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)
2393: FROM
2394: (SELECT fund_id fund_id
2387: ,inner.load_date
2388: ,inner.object_id
2389: ,inner.object_type
2390: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)
2391: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)
2392: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)
2393: FROM
2394: (SELECT fund_id fund_id
2395: ,business_unit_id business_unit_id
2388: ,inner.object_id
2389: ,inner.object_type
2390: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)
2391: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)
2392: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)
2393: FROM
2394: (SELECT fund_id fund_id
2395: ,business_unit_id business_unit_id
2396: ,util_org_id util_org_id
2639: inner.currency_code_fc,
2640: 'N',
2641: inner.transaction_create_date,
2642: inner.weekend_date,
2643: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),
2644: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),
2645: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),
2646: inner.business_unit_id
2647: FROM (
2640: 'N',
2641: inner.transaction_create_date,
2642: inner.weekend_date,
2643: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),
2644: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),
2645: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),
2646: inner.business_unit_id
2647: FROM (
2648: SELECT fund_id fund_id,
2641: inner.transaction_create_date,
2642: inner.weekend_date,
2643: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),
2644: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),
2645: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),
2646: inner.business_unit_id
2647: FROM (
2648: SELECT fund_id fund_id,
2649: fund_number fund_number,
2873: inner.currency_code_fc,
2874: 'N',
2875: inner.transaction_create_date,
2876: inner.weekend_date,
2877: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),
2878: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),
2879: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),
2880: inner.business_unit_id
2881: FROM (
2874: 'N',
2875: inner.transaction_create_date,
2876: inner.weekend_date,
2877: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),
2878: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),
2879: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),
2880: inner.business_unit_id
2881: FROM (
2882: SELECT fund_id fund_id,
2875: inner.transaction_create_date,
2876: inner.weekend_date,
2877: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),
2878: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),
2879: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),
2880: inner.business_unit_id
2881: FROM (
2882: SELECT fund_id fund_id,
2883: fund_number fund_number,
3118: ,'FALSE'
3119: ,decode(decode(to_char(inner.trdate,'MM'),to_char(next_day(inner.trdate,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
3120: ,'FALSE'
3121: ,last_day(inner.trdate))))) ,
3122: BIM_SET_OF_BOOKS.get_fiscal_month(inner.trdate,204),
3123: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.trdate,204),
3124: BIM_SET_OF_BOOKS.get_fiscal_year(inner.trdate,204),
3125: inner.business_unit_id
3126: FROM (
3119: ,decode(decode(to_char(inner.trdate,'MM'),to_char(next_day(inner.trdate,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
3120: ,'FALSE'
3121: ,last_day(inner.trdate))))) ,
3122: BIM_SET_OF_BOOKS.get_fiscal_month(inner.trdate,204),
3123: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.trdate,204),
3124: BIM_SET_OF_BOOKS.get_fiscal_year(inner.trdate,204),
3125: inner.business_unit_id
3126: FROM (
3127: SELECT distinct a.fund_id fund_id,
3120: ,'FALSE'
3121: ,last_day(inner.trdate))))) ,
3122: BIM_SET_OF_BOOKS.get_fiscal_month(inner.trdate,204),
3123: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.trdate,204),
3124: BIM_SET_OF_BOOKS.get_fiscal_year(inner.trdate,204),
3125: inner.business_unit_id
3126: FROM (
3127: SELECT distinct a.fund_id fund_id,
3128: a.fund_number fund_number,
3241: ,'FALSE'
3242: ,decode(decode(to_char(inner.trdate,'MM'),to_char(next_day(inner.trdate,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
3243: ,'FALSE'
3244: ,last_day(inner.trdate))))) ,
3245: BIM_SET_OF_BOOKS.get_fiscal_month(inner.trdate,204),
3246: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.trdate,204),
3247: BIM_SET_OF_BOOKS.get_fiscal_year(inner.trdate,204),
3248: inner.business_unit_id
3249: FROM (
3242: ,decode(decode(to_char(inner.trdate,'MM'),to_char(next_day(inner.trdate,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
3243: ,'FALSE'
3244: ,last_day(inner.trdate))))) ,
3245: BIM_SET_OF_BOOKS.get_fiscal_month(inner.trdate,204),
3246: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.trdate,204),
3247: BIM_SET_OF_BOOKS.get_fiscal_year(inner.trdate,204),
3248: inner.business_unit_id
3249: FROM (
3250: SELECT ad.fund_id fund_id,
3243: ,'FALSE'
3244: ,last_day(inner.trdate))))) ,
3245: BIM_SET_OF_BOOKS.get_fiscal_month(inner.trdate,204),
3246: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.trdate,204),
3247: BIM_SET_OF_BOOKS.get_fiscal_year(inner.trdate,204),
3248: inner.business_unit_id
3249: FROM (
3250: SELECT ad.fund_id fund_id,
3251: ad.fund_number fund_number,
3497: ,'FALSE'
3498: ,last_day(inner.transaction_create_date))))) weekend_date
3499: ,inner.object_id
3500: ,inner.object_type
3501: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)
3502: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)
3503: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)
3504: FROM (SELECT AD.fund_id fund_id,
3505: U.business_unit_id business_unit_id,
3498: ,last_day(inner.transaction_create_date))))) weekend_date
3499: ,inner.object_id
3500: ,inner.object_type
3501: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)
3502: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)
3503: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)
3504: FROM (SELECT AD.fund_id fund_id,
3505: U.business_unit_id business_unit_id,
3506: U.org_id org_id,
3499: ,inner.object_id
3500: ,inner.object_type
3501: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)
3502: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)
3503: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)
3504: FROM (SELECT AD.fund_id fund_id,
3505: U.business_unit_id business_unit_id,
3506: U.org_id org_id,
3507: NVL(AU.standard_discount,0) standard_discount,
3692: ,'FALSE'
3693: ,last_day(inner.transaction_create_date))))) weekend_date
3694: ,inner.object_id
3695: ,inner.object_type
3696: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)
3697: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)
3698: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)
3699: FROM (SELECT AD.fund_id fund_id,
3700: U.business_unit_id business_unit_id,
3693: ,last_day(inner.transaction_create_date))))) weekend_date
3694: ,inner.object_id
3695: ,inner.object_type
3696: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)
3697: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)
3698: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)
3699: FROM (SELECT AD.fund_id fund_id,
3700: U.business_unit_id business_unit_id,
3701: U.org_id org_id,
3694: ,inner.object_id
3695: ,inner.object_type
3696: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)
3697: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)
3698: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)
3699: FROM (SELECT AD.fund_id fund_id,
3700: U.business_unit_id business_unit_id,
3701: U.org_id org_id,
3702: NVL(AU.standard_discount,0) standard_discount,
3887: ,'FALSE'
3888: ,last_day(inner.trdate))))) weekend_date
3889: ,null
3890: ,null
3891: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.trdate,204)
3892: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.trdate,204)
3893: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.trdate,204)
3894: FROM (
3895: SELECT distinct a.fund_id fund_id,
3888: ,last_day(inner.trdate))))) weekend_date
3889: ,null
3890: ,null
3891: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.trdate,204)
3892: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.trdate,204)
3893: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.trdate,204)
3894: FROM (
3895: SELECT distinct a.fund_id fund_id,
3896: TRUNC(b.trdate) trdate
3889: ,null
3890: ,null
3891: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.trdate,204)
3892: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.trdate,204)
3893: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.trdate,204)
3894: FROM (
3895: SELECT distinct a.fund_id fund_id,
3896: TRUNC(b.trdate) trdate
3897: FROM bim_r_fdsp_daily_facts a,
4184: ,inner.currency_code_fc
4185: ,'N'
4186: ,inner.load_date
4187: ,inner.load_date
4188: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)
4189: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)
4190: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)
4191: ,inner.business_unit_id
4192: FROM(SELECT fund_id fund_id
4185: ,'N'
4186: ,inner.load_date
4187: ,inner.load_date
4188: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)
4189: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)
4190: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)
4191: ,inner.business_unit_id
4192: FROM(SELECT fund_id fund_id
4193: ,parent_fund_id parent_fund_id
4186: ,inner.load_date
4187: ,inner.load_date
4188: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)
4189: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)
4190: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)
4191: ,inner.business_unit_id
4192: FROM(SELECT fund_id fund_id
4193: ,parent_fund_id parent_fund_id
4194: ,fund_number fund_number
4298: ,inner.load_date
4299: ,inner.load_date
4300: ,inner.object_id
4301: ,inner.object_type
4302: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)
4303: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)
4304: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)
4305: FROM
4306: (SELECT fund_id fund_id
4299: ,inner.load_date
4300: ,inner.object_id
4301: ,inner.object_type
4302: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)
4303: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)
4304: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)
4305: FROM
4306: (SELECT fund_id fund_id
4307: ,business_unit_id business_unit_id
4300: ,inner.object_id
4301: ,inner.object_type
4302: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)
4303: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)
4304: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)
4305: FROM
4306: (SELECT fund_id fund_id
4307: ,business_unit_id business_unit_id
4308: ,util_org_id util_org_id