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.BIM_FUND_FACTS dependencies on BIM_SET_OF_BOOKS

Line 1048: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),

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 (

Line 1049: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),

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,

Line 1050: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),

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,

Line 1376: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),

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 (

Line 1377: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),

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,

Line 1378: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),

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' )

Line 1752: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)

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,

Line 1753: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)

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,

Line 1754: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)

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,

Line 1952: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)

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,

Line 1953: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)

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,

Line 1954: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)

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,

Line 2279: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)

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

Line 2280: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)

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

Line 2281: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)

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

Line 2390: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)

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

Line 2391: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)

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

Line 2392: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)

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

Line 2643: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),

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 (

Line 2644: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),

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,

Line 2645: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),

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,

Line 2877: BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204),

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 (

Line 2878: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204),

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,

Line 2879: BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204),

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,

Line 3122: BIM_SET_OF_BOOKS.get_fiscal_month(inner.trdate,204),

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 (

Line 3123: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.trdate,204),

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,

Line 3124: BIM_SET_OF_BOOKS.get_fiscal_year(inner.trdate,204),

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,

Line 3245: BIM_SET_OF_BOOKS.get_fiscal_month(inner.trdate,204),

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 (

Line 3246: BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.trdate,204),

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,

Line 3247: BIM_SET_OF_BOOKS.get_fiscal_year(inner.trdate,204),

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,

Line 3501: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)

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,

Line 3502: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)

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,

Line 3503: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)

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,

Line 3696: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.transaction_create_date,204)

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,

Line 3697: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.transaction_create_date,204)

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,

Line 3698: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.transaction_create_date,204)

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,

Line 3891: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.trdate,204)

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,

Line 3892: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.trdate,204)

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

Line 3893: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.trdate,204)

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,

Line 4188: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)

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

Line 4189: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)

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

Line 4190: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)

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

Line 4302: ,BIM_SET_OF_BOOKS.get_fiscal_month(inner.load_date,204)

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

Line 4303: ,BIM_SET_OF_BOOKS.get_fiscal_qtr(inner.load_date,204)

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

Line 4304: ,BIM_SET_OF_BOOKS.get_fiscal_year(inner.load_date,204)

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