AR_LEDGER_H_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
LDG_ACCOUNTED_PERIOD_TYPE LDG_CHART_OF_ACCOUNTS_ID LDG_CUM_TRANS_CCID LDG_CURRENCY_CODE LDG_DAILY_TRANS_RATE_TYPE LDG_DESCRIPTION LDG_FUTURE_ENTER_PERIODS_LIMIT LDG_LATEST_ENCUMBRANCE_YEAR LDG_LATEST_OPENED_PERIOD_NAME LDG_NAME LDG_NET_INCOME_CCID LDG_PERIOD_SET_NAME LDG_RES_ENCUMB_CCID LDG_RET_EARN_CCID LDG_LEDGER_ID LDG_SHORT_NAME LEDGER_ID EVENT_ID

Query

SQL_Statement

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'