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_CAMPAIGN_FACTS dependencies on BIM_SET_OF_BOOKS

Line 757: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year

753: ,'FALSE'
754: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
755: ,'FALSE'
756: ,last_day(inner.creation_date)))) weekend_date
757: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
758: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
759: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
760: ,inner.leads_open leads_open
761: ,inner.leads_closed leads_closed

Line 758: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr

754: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
755: ,'FALSE'
756: ,last_day(inner.creation_date)))) weekend_date
757: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
758: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
759: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
760: ,inner.leads_open leads_open
761: ,inner.leads_closed leads_closed
762: ,inner.leads_open_amt leads_open_amt

Line 759: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month

755: ,'FALSE'
756: ,last_day(inner.creation_date)))) weekend_date
757: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
758: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
759: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
760: ,inner.leads_open leads_open
761: ,inner.leads_closed leads_closed
762: ,inner.leads_open_amt leads_open_amt
763: ,inner.leads_closed_amt leads_closed_amt

Line 1264: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year

1260: ,'FALSE'
1261: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
1262: ,'FALSE'
1263: ,last_day(inner.creation_date)))) weekend_date
1264: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
1265: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
1266: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
1267: ,inner.leads_open leads_open
1268: ,inner.leads_closed leads_closed

Line 1265: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr

1261: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
1262: ,'FALSE'
1263: ,last_day(inner.creation_date)))) weekend_date
1264: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
1265: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
1266: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
1267: ,inner.leads_open leads_open
1268: ,inner.leads_closed leads_closed
1269: ,inner.leads_open_amt leads_open_amt

Line 1266: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month

1262: ,'FALSE'
1263: ,last_day(inner.creation_date)))) weekend_date
1264: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
1265: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
1266: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
1267: ,inner.leads_open leads_open
1268: ,inner.leads_closed leads_closed
1269: ,inner.leads_open_amt leads_open_amt
1270: ,inner.leads_closed_amt leads_closed_amt

Line 1807: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year

1803: ,'FALSE'
1804: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
1805: ,'FALSE'
1806: ,last_day(Inner.creation_date)))) weekend_date
1807: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
1808: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
1809: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
1810: ,0 leads_open
1811: ,0 leads_closed

Line 1808: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr

1804: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
1805: ,'FALSE'
1806: ,last_day(Inner.creation_date)))) weekend_date
1807: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
1808: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
1809: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
1810: ,0 leads_open
1811: ,0 leads_closed
1812: ,0 leads_open_amt

Line 1809: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month

1805: ,'FALSE'
1806: ,last_day(Inner.creation_date)))) weekend_date
1807: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
1808: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
1809: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
1810: ,0 leads_open
1811: ,0 leads_closed
1812: ,0 leads_open_amt
1813: ,0 leads_closed_amt

Line 2079: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year

2075: ,'FALSE'
2076: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
2077: ,'FALSE'
2078: ,last_day(Inner.creation_date)))) weekend_date
2079: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
2080: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
2081: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
2082: ,0 leads_open
2083: ,0 leads_closed

Line 2080: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr

2076: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
2077: ,'FALSE'
2078: ,last_day(Inner.creation_date)))) weekend_date
2079: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
2080: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
2081: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
2082: ,0 leads_open
2083: ,0 leads_closed
2084: ,0 leads_open_amt

Line 2081: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month

2077: ,'FALSE'
2078: ,last_day(Inner.creation_date)))) weekend_date
2079: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
2080: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
2081: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
2082: ,0 leads_open
2083: ,0 leads_closed
2084: ,0 leads_open_amt
2085: ,0 leads_closed_amt

Line 2968: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year

2964: ,'FALSE'
2965: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
2966: ,'FALSE'
2967: ,last_day(inner.creation_date)))) weekend_date
2968: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
2969: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
2970: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
2971: ,inner.leads_open leads_open
2972: ,inner.leads_closed leads_closed

Line 2969: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr

2965: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
2966: ,'FALSE'
2967: ,last_day(inner.creation_date)))) weekend_date
2968: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
2969: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
2970: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
2971: ,inner.leads_open leads_open
2972: ,inner.leads_closed leads_closed
2973: ,inner.leads_open_amt leads_open_amt

Line 2970: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month

2966: ,'FALSE'
2967: ,last_day(inner.creation_date)))) weekend_date
2968: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
2969: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
2970: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
2971: ,inner.leads_open leads_open
2972: ,inner.leads_closed leads_closed
2973: ,inner.leads_open_amt leads_open_amt
2974: ,inner.leads_closed_amt leads_closed_amt

Line 3476: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year

3472: ,'FALSE'
3473: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
3474: ,'FALSE'
3475: ,last_day(inner.creation_date)))) weekend_date
3476: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
3477: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
3478: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
3479: ,inner.leads_open leads_open
3480: ,inner.leads_closed leads_closed

Line 3477: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr

3473: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
3474: ,'FALSE'
3475: ,last_day(inner.creation_date)))) weekend_date
3476: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
3477: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
3478: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
3479: ,inner.leads_open leads_open
3480: ,inner.leads_closed leads_closed
3481: ,inner.leads_open_amt leads_open_amt

Line 3478: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month

3474: ,'FALSE'
3475: ,last_day(inner.creation_date)))) weekend_date
3476: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
3477: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
3478: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
3479: ,inner.leads_open leads_open
3480: ,inner.leads_closed leads_closed
3481: ,inner.leads_open_amt leads_open_amt
3482: ,inner.leads_closed_amt leads_closed_amt

Line 4022: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year

4018: ,'FALSE'
4019: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
4020: ,'FALSE'
4021: ,last_day(Inner.creation_date)))) weekend_date
4022: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
4023: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
4024: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
4025: ,0 leads_open
4026: ,0 leads_closed

Line 4023: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr

4019: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
4020: ,'FALSE'
4021: ,last_day(Inner.creation_date)))) weekend_date
4022: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
4023: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
4024: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
4025: ,0 leads_open
4026: ,0 leads_closed
4027: ,0 leads_open_amt

Line 4024: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month

4020: ,'FALSE'
4021: ,last_day(Inner.creation_date)))) weekend_date
4022: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
4023: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
4024: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
4025: ,0 leads_open
4026: ,0 leads_closed
4027: ,0 leads_open_amt
4028: ,0 leads_closed_amt

Line 4294: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year

4290: ,'FALSE'
4291: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
4292: ,'FALSE'
4293: ,last_day(Inner.creation_date)))) weekend_date
4294: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
4295: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
4296: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
4297: ,0 leads_open
4298: ,0 leads_closed

Line 4295: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr

4291: ,decode(decode(to_char(inner.creation_date,'MM'),to_char(next_day(inner.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
4292: ,'FALSE'
4293: ,last_day(Inner.creation_date)))) weekend_date
4294: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
4295: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
4296: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
4297: ,0 leads_open
4298: ,0 leads_closed
4299: ,0 leads_open_amt

Line 4296: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month

4292: ,'FALSE'
4293: ,last_day(Inner.creation_date)))) weekend_date
4294: ,bim_set_of_books.get_fiscal_year(inner.creation_date,0) year
4295: ,bim_set_of_books.get_fiscal_qtr(inner.creation_date,0) qtr
4296: ,bim_set_of_books.get_fiscal_month(inner.creation_date,0) month
4297: ,0 leads_open
4298: ,0 leads_closed
4299: ,0 leads_open_amt
4300: ,0 leads_closed_amt