VIEW: APPS.XLA_TACCOUNTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'