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.XLA_AE_HEADER_PKG dependencies on GL_TRANSACTION_DATES

Line 3399: -- FROM gl_transaction_dates d1

3395: -- SET accounting_date =
3396: -- DECODE(xah.acc_rev_gl_date_option,
3397: -- 'XLA_NEXT_DAY',
3398: -- (SELECT min(transaction_date)
3399: -- FROM gl_transaction_dates d1
3400: -- WHERE d1.business_day_flag = 'Y'
3401: -- AND d1.transaction_date >= xah.accounting_date
3402: -- AND d1.transaction_calendar_id = l_transaction_calendar_id),
3403: -- -- XLA_FIRST_DAY_NEXT_GL_PERIOD, XLA_LAST_DAY_NEXT_GL_PERIOD, NONE

Line 3405: -- FROM (SELECT /+ USE_NL_WITH_INDEX(XAH2, GL_TRANSACTION_DATES_U1) / xah2.ae_header_id

3401: -- AND d1.transaction_date >= xah.accounting_date
3402: -- AND d1.transaction_calendar_id = l_transaction_calendar_id),
3403: -- -- XLA_FIRST_DAY_NEXT_GL_PERIOD, XLA_LAST_DAY_NEXT_GL_PERIOD, NONE
3404: -- (SELECT transaction_date
3405: -- FROM (SELECT /*+ USE_NL_WITH_INDEX(XAH2, GL_TRANSACTION_DATES_U1) */ xah2.ae_header_id
3406: -- , d.transaction_date
3407: -- FROM xla_ae_headers_gt xah2
3408: -- , gl_transaction_dates d
3409: -- WHERE d.transaction_calendar_id = l_transaction_calendar_id

Line 3408: -- , gl_transaction_dates d

3404: -- (SELECT transaction_date
3405: -- FROM (SELECT /*+ USE_NL_WITH_INDEX(XAH2, GL_TRANSACTION_DATES_U1) */ xah2.ae_header_id
3406: -- , d.transaction_date
3407: -- FROM xla_ae_headers_gt xah2
3408: -- , gl_transaction_dates d
3409: -- WHERE d.transaction_calendar_id = l_transaction_calendar_id
3410: -- AND d.business_day_flag = 'Y'
3411: -- AND d.transaction_date >= xah2.period_start_date
3412: -- /* restricting the future dates to a maximum of 6 Months ( 6 * 31 ) for bug9630931 */

Line 3433: FROM gl_transaction_dates d

3429: SET accounting_date =
3430: DECODE(xah.acc_rev_gl_date_option,
3431: 'XLA_NEXT_DAY',
3432: ( SELECT min(transaction_date)
3433: FROM gl_transaction_dates d
3434: WHERE d.business_day_flag = 'Y'
3435: AND d.transaction_date >= xah.accounting_date
3436: AND d.transaction_calendar_id = l_transaction_calendar_id),
3437: -- XLA_FIRST_DAY_NEXT_GL_PERIOD, XLA_LAST_DAY_NEXT_GL_PERIOD, NONE

Line 3439: FROM (SELECT /+ USE_NL(xah2,gps,d) INDEX(d GL_TRANSACTION_DATES_U1) index(xah2 XLA_AE_HEADERS_GT_U1) / xah2.ae_header_id

3435: AND d.transaction_date >= xah.accounting_date
3436: AND d.transaction_calendar_id = l_transaction_calendar_id),
3437: -- XLA_FIRST_DAY_NEXT_GL_PERIOD, XLA_LAST_DAY_NEXT_GL_PERIOD, NONE
3438: ( SELECT transaction_date
3439: FROM (SELECT /*+ USE_NL(xah2,gps,d) INDEX(d GL_TRANSACTION_DATES_U1) index(xah2 XLA_AE_HEADERS_GT_U1) */ xah2.ae_header_id
3440: --added U1 hint for bug#10229047
3441: , d.transaction_date
3442: FROM xla_ae_headers_gt xah2
3443: , gl_transaction_dates d

Line 3443: , gl_transaction_dates d

3439: FROM (SELECT /*+ USE_NL(xah2,gps,d) INDEX(d GL_TRANSACTION_DATES_U1) index(xah2 XLA_AE_HEADERS_GT_U1) */ xah2.ae_header_id
3440: --added U1 hint for bug#10229047
3441: , d.transaction_date
3442: FROM xla_ae_headers_gt xah2
3443: , gl_transaction_dates d
3444: , gl_period_statuses gps
3445: WHERE d.transaction_calendar_id = l_transaction_calendar_id
3446: AND d.business_day_flag = 'Y'
3447: AND d.transaction_date >= xah2.period_start_date