VIEW: APPS.AR_LEDGER_H_V

Source

View Text - Preformatted

SELECT /*+INDEX (he ar_xla_lines_extract_n1)*/ sob.accounted_period_type ldg_accounted_period_type ,sob.chart_of_accounts_id ldg_chart_of_accounts_id ,sob.cum_trans_code_combination_id ldg_cum_trans_ccid ,sob.currency_code ldg_currency_code ,sob.daily_translation_rate_type ldg_daily_trans_rate_type ,sob.description ldg_description ,sob.future_enterable_periods_limit ldg_future_enter_periods_limit ,sob.latest_encumbrance_year ldg_latest_encumbrance_year ,sob.latest_opened_period_name ldg_latest_opened_period_name ,sob.name ldg_name ,sob.net_income_code_combination_id ldg_net_income_ccid ,sob.period_set_name ldg_period_set_name ,sob.res_encumb_code_combination_id ldg_res_encumb_ccid ,sob.ret_earn_code_combination_id ldg_ret_earn_ccid ,sob.ledger_id ldg_ledger_id ,sob.short_name ldg_short_name ,sob.ledger_id ledger_id ,he.event_id event_id FROM gl_ledgers sob ,ar_xla_lines_extract he WHERE sob.ledger_id = he.set_of_books_id AND he.level_flag = 'H'

View Text - HTML Formatted

SELECT /*+INDEX (HE AR_XLA_LINES_EXTRACT_N1)*/ SOB.ACCOUNTED_PERIOD_TYPE LDG_ACCOUNTED_PERIOD_TYPE
, SOB.CHART_OF_ACCOUNTS_ID LDG_CHART_OF_ACCOUNTS_ID
, SOB.CUM_TRANS_CODE_COMBINATION_ID LDG_CUM_TRANS_CCID
, SOB.CURRENCY_CODE LDG_CURRENCY_CODE
, SOB.DAILY_TRANSLATION_RATE_TYPE LDG_DAILY_TRANS_RATE_TYPE
, SOB.DESCRIPTION LDG_DESCRIPTION
, SOB.FUTURE_ENTERABLE_PERIODS_LIMIT LDG_FUTURE_ENTER_PERIODS_LIMIT
, SOB.LATEST_ENCUMBRANCE_YEAR LDG_LATEST_ENCUMBRANCE_YEAR
, SOB.LATEST_OPENED_PERIOD_NAME LDG_LATEST_OPENED_PERIOD_NAME
, SOB.NAME LDG_NAME
, SOB.NET_INCOME_CODE_COMBINATION_ID LDG_NET_INCOME_CCID
, SOB.PERIOD_SET_NAME LDG_PERIOD_SET_NAME
, SOB.RES_ENCUMB_CODE_COMBINATION_ID LDG_RES_ENCUMB_CCID
, SOB.RET_EARN_CODE_COMBINATION_ID LDG_RET_EARN_CCID
, SOB.LEDGER_ID LDG_LEDGER_ID
, SOB.SHORT_NAME LDG_SHORT_NAME
, SOB.LEDGER_ID LEDGER_ID
, HE.EVENT_ID EVENT_ID
FROM GL_LEDGERS SOB
, AR_XLA_LINES_EXTRACT HE
WHERE SOB.LEDGER_ID = HE.SET_OF_BOOKS_ID
AND HE.LEVEL_FLAG = 'H'