Product: | AR - Receivables |
---|---|
Description: | ledger extract |
Implementation/DBA Data: |
![]() |
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'