FND Design Data [Home] [Help]

View: XLA_TACCOUNTS_V

Product: XLA - Subledger Accounting
Description:
Implementation/DBA Data: ViewAPPS.XLA_TACCOUNTS_V
View Text

SELECT XAH.APPLICATION_ID APPLICATION_ID
, TO_CHAR(NULL) TRX_HDR_TABLE
, XAH.AE_HEADER_ID TRX_HDR_ID
, XAH.LEDGER_ID SET_OF_BOOKS_ID
, XAH.ACCOUNTING_DATE GL_DATE
, L.MEANING ACCT_LINE_TYPE_NAME
, XAH.PERIOD_NAME PERIOD_NAME
, XAH.ACCOUNTING_ENTRY_STATUS_CODE STATUS
, XAL.CURRENCY_CODE CURRENCY_CODE
, L.MEANING||' '||XAL.DISPLAYED_LINE_NUMBER AE_LINE_REFERENCE
, XAL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, XAL.ENTERED_DR ENTERED_DR
, XAL.ENTERED_CR ENTERED_CR
, XAL.ACCOUNTED_DR ACCOUNTED_DR
, XAL.ACCOUNTED_CR ACCOUNTED_CR
, L.LOOKUP_CODE ACCT_LINE_TYPE
, LPAD(XAL.AE_LINE_NUM
, 15
, '0') AE_LINE_REFERENCE_INTERNAL
FROM FND_LOOKUPS L
, XLA_AE_LINES XAL
, XLA_AE_HEADERS XAH
WHERE XAL.AE_HEADER_ID = XAH.AE_HEADER_ID
AND XAL.APPLICATION_ID = XAH.APPLICATION_ID
AND L.LOOKUP_TYPE = 'XLA_VIEW_ACCOUNTING'
AND L.LOOKUP_CODE = 'LINE'

Columns

Name
APPLICATION_ID
TRX_HDR_TABLE
TRX_HDR_ID
SET_OF_BOOKS_ID
GL_DATE
ACCT_LINE_TYPE_NAME
PERIOD_NAME
STATUS
CURRENCY_CODE
AE_LINE_REFERENCE
CODE_COMBINATION_ID
ENTERED_DR
ENTERED_CR
ACCOUNTED_DR
ACCOUNTED_CR
ACCT_LINE_TYPE
AE_LINE_REFERENCE_INTERNAL