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

Line 622: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204),

618: 0,--inner.budget_requested,
619: 0,--inner.budget_approved,
620: trunc(inner.weekend_date),
621: 'N',
622: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204),
623: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204),
624: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204),
625: inner.booked_orders,
626: inner.booked_orders_amt

Line 623: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204),

619: 0,--inner.budget_approved,
620: trunc(inner.weekend_date),
621: 'N',
622: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204),
623: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204),
624: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204),
625: inner.booked_orders,
626: inner.booked_orders_amt
627: from(SELECT /*+ full(BUDGET1.A) */

Line 624: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204),

620: trunc(inner.weekend_date),
621: 'N',
622: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204),
623: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204),
624: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204),
625: inner.booked_orders,
626: inner.booked_orders_amt
627: from(SELECT /*+ full(BUDGET1.A) */
628: ad.event_header_id header_id,

Line 956: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204),

952: 0,--inner.budget_requested,
953: 0,--inner.budget_approved,
954: trunc(inner.weekend_date),
955: 'N',
956: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204),
957: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204),
958: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204),
959: 0, --booked_orders
960: 0 --booked_orders_amt

Line 957: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204),

953: 0,--inner.budget_approved,
954: trunc(inner.weekend_date),
955: 'N',
956: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204),
957: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204),
958: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204),
959: 0, --booked_orders
960: 0 --booked_orders_amt
961: from (SELECT /*+ full(BUDGET1.A) */

Line 958: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204),

954: trunc(inner.weekend_date),
955: 'N',
956: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204),
957: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204),
958: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204),
959: 0, --booked_orders
960: 0 --booked_orders_amt
961: from (SELECT /*+ full(BUDGET1.A) */
962: ad.event_header_id header_id,

Line 1264: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(INNER.transaction_creation_date, 204),

1260: INNER.currency_code_fc,
1261: INNER.transaction_creation_date,
1262: INNER.weekend_date,
1263: 'N',
1264: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(INNER.transaction_creation_date, 204),
1265: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(INNER.transaction_creation_date, 204),
1266: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(INNER.transaction_creation_date, 204),
1267: 0, --ad.registered,
1268: 0, --ad.cancelled,

Line 1265: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(INNER.transaction_creation_date, 204),

1261: INNER.transaction_creation_date,
1262: INNER.weekend_date,
1263: 'N',
1264: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(INNER.transaction_creation_date, 204),
1265: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(INNER.transaction_creation_date, 204),
1266: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(INNER.transaction_creation_date, 204),
1267: 0, --ad.registered,
1268: 0, --ad.cancelled,
1269: 0, --ad.attended,

Line 1266: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(INNER.transaction_creation_date, 204),

1262: INNER.weekend_date,
1263: 'N',
1264: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(INNER.transaction_creation_date, 204),
1265: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(INNER.transaction_creation_date, 204),
1266: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(INNER.transaction_creation_date, 204),
1267: 0, --ad.registered,
1268: 0, --ad.cancelled,
1269: 0, --ad.attended,
1270: 0, --ad.leads_open,

Line 1577: bim_set_of_books.get_fiscal_month(ad.creation_date, 204),

1573: ,decode(decode(to_char(ad.creation_date,'MM'),to_char(next_day(ad.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
1574: ,'FALSE'
1575: ,last_day(ad.creation_date)))) weekend_date,
1576: 'N',
1577: bim_set_of_books.get_fiscal_month(ad.creation_date, 204),
1578: bim_set_of_books.get_fiscal_qtr(ad.creation_date, 204),
1579: bim_set_of_books.get_fiscal_year(ad.creation_date, 204),
1580: ad.registered,
1581: ad.cancelled,

Line 1578: bim_set_of_books.get_fiscal_qtr(ad.creation_date, 204),

1574: ,'FALSE'
1575: ,last_day(ad.creation_date)))) weekend_date,
1576: 'N',
1577: bim_set_of_books.get_fiscal_month(ad.creation_date, 204),
1578: bim_set_of_books.get_fiscal_qtr(ad.creation_date, 204),
1579: bim_set_of_books.get_fiscal_year(ad.creation_date, 204),
1580: ad.registered,
1581: ad.cancelled,
1582: ad.attended,

Line 1579: bim_set_of_books.get_fiscal_year(ad.creation_date, 204),

1575: ,last_day(ad.creation_date)))) weekend_date,
1576: 'N',
1577: bim_set_of_books.get_fiscal_month(ad.creation_date, 204),
1578: bim_set_of_books.get_fiscal_qtr(ad.creation_date, 204),
1579: bim_set_of_books.get_fiscal_year(ad.creation_date, 204),
1580: ad.registered,
1581: ad.cancelled,
1582: ad.attended,
1583: ad.leads_open,

Line 2027: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204)

2023: ,decode(decode(to_char(inner.transaction_create_date,'MM'),to_char(next_day(inner.transaction_create_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
2024: ,'FALSE'
2025: ,last_day(inner.transaction_create_date)))) --weekend date
2026: ,'N'
2027: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204)
2028: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204)
2029: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204)
2030: ,0 --booked_orders
2031: ,0 --booked_orders_amt

Line 2028: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204)

2024: ,'FALSE'
2025: ,last_day(inner.transaction_create_date)))) --weekend date
2026: ,'N'
2027: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204)
2028: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204)
2029: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204)
2030: ,0 --booked_orders
2031: ,0 --booked_orders_amt
2032: FROM(

Line 2029: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204)

2025: ,last_day(inner.transaction_create_date)))) --weekend date
2026: ,'N'
2027: ,BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204)
2028: ,BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204)
2029: ,BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204)
2030: ,0 --booked_orders
2031: ,0 --booked_orders_amt
2032: FROM(
2033: SELECT

Line 2218: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204),

2214: ,decode(decode(to_char(inner.transaction_create_date,'MM'),to_char(next_day(inner.transaction_create_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
2215: ,'FALSE'
2216: ,last_day(inner.transaction_create_date)))), --weekend date
2217: 'N',
2218: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204),
2219: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204),
2220: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204),
2221: 0, --booked_orders
2222: 0 --booked_orders_amt

Line 2219: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204),

2215: ,'FALSE'
2216: ,last_day(inner.transaction_create_date)))), --weekend date
2217: 'N',
2218: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204),
2219: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204),
2220: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204),
2221: 0, --booked_orders
2222: 0 --booked_orders_amt
2223: from(

Line 2220: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204),

2216: ,last_day(inner.transaction_create_date)))), --weekend date
2217: 'N',
2218: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(inner.transaction_create_date, 204),
2219: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(inner.transaction_create_date, 204),
2220: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(inner.transaction_create_date, 204),
2221: 0, --booked_orders
2222: 0 --booked_orders_amt
2223: from(
2224: SELECT

Line 2916: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(ad.creation_date, 204),

2912: ,decode(decode(to_char(ad.creation_date,'MM'),to_char(next_day(ad.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
2913: ,'FALSE'
2914: ,last_day(ad.creation_date)))) weekend_date,
2915: 'N',
2916: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(ad.creation_date, 204),
2917: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(ad.creation_date, 204),
2918: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(ad.creation_date, 204),
2919: ad.registered,
2920: ad.cancelled,

Line 2917: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(ad.creation_date, 204),

2913: ,'FALSE'
2914: ,last_day(ad.creation_date)))) weekend_date,
2915: 'N',
2916: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(ad.creation_date, 204),
2917: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(ad.creation_date, 204),
2918: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(ad.creation_date, 204),
2919: ad.registered,
2920: ad.cancelled,
2921: ad.attended,

Line 2918: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(ad.creation_date, 204),

2914: ,last_day(ad.creation_date)))) weekend_date,
2915: 'N',
2916: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(ad.creation_date, 204),
2917: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(ad.creation_date, 204),
2918: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(ad.creation_date, 204),
2919: ad.registered,
2920: ad.cancelled,
2921: ad.attended,
2922: ad.leads_open,

Line 3389: bim_set_of_books.get_fiscal_month(ad.creation_date, 204),

3385: ,decode(decode(to_char(ad.creation_date,'MM'),to_char(next_day(ad.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
3386: ,'FALSE'
3387: ,last_day(ad.creation_date)))) weekend_date,
3388: 'N',
3389: bim_set_of_books.get_fiscal_month(ad.creation_date, 204),
3390: bim_set_of_books.get_fiscal_qtr(ad.creation_date, 204),
3391: bim_set_of_books.get_fiscal_year(ad.creation_date, 204),
3392: ad.registered,
3393: ad.cancelled,

Line 3390: bim_set_of_books.get_fiscal_qtr(ad.creation_date, 204),

3386: ,'FALSE'
3387: ,last_day(ad.creation_date)))) weekend_date,
3388: 'N',
3389: bim_set_of_books.get_fiscal_month(ad.creation_date, 204),
3390: bim_set_of_books.get_fiscal_qtr(ad.creation_date, 204),
3391: bim_set_of_books.get_fiscal_year(ad.creation_date, 204),
3392: ad.registered,
3393: ad.cancelled,
3394: ad.attended,

Line 3391: bim_set_of_books.get_fiscal_year(ad.creation_date, 204),

3387: ,last_day(ad.creation_date)))) weekend_date,
3388: 'N',
3389: bim_set_of_books.get_fiscal_month(ad.creation_date, 204),
3390: bim_set_of_books.get_fiscal_qtr(ad.creation_date, 204),
3391: bim_set_of_books.get_fiscal_year(ad.creation_date, 204),
3392: ad.registered,
3393: ad.cancelled,
3394: ad.attended,
3395: ad.leads_open,

Line 3894: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(ad.creation_date, 204),

3890: ,decode(decode(to_char(ad.creation_date,'MM'),to_char(next_day(ad.creation_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
3891: ,'FALSE'
3892: ,last_day(ad.creation_date)))) weekend_date,
3893: 'N',
3894: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(ad.creation_date, 204),
3895: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(ad.creation_date, 204),
3896: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(ad.creation_date, 204),
3897: ad.registered,
3898: ad.cancelled,

Line 3895: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(ad.creation_date, 204),

3891: ,'FALSE'
3892: ,last_day(ad.creation_date)))) weekend_date,
3893: 'N',
3894: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(ad.creation_date, 204),
3895: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(ad.creation_date, 204),
3896: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(ad.creation_date, 204),
3897: ad.registered,
3898: ad.cancelled,
3899: ad.attended,

Line 3896: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(ad.creation_date, 204),

3892: ,last_day(ad.creation_date)))) weekend_date,
3893: 'N',
3894: BIM_SET_OF_BOOKS.GET_FISCAL_MONTH(ad.creation_date, 204),
3895: BIM_SET_OF_BOOKS.GET_FISCAL_QTR(ad.creation_date, 204),
3896: BIM_SET_OF_BOOKS.GET_FISCAL_YEAR(ad.creation_date, 204),
3897: ad.registered,
3898: ad.cancelled,
3899: ad.attended,
3900: ad.leads_open,