View: OKL_AE_LINES_V

View Text

SELECT AELB.ROWID ROW_ID
, AELB.AE_LINE_ID AE_LINE_ID
, AELB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AELB.ACCOUNT_OVERLAY_SOURCE_ID ACCOUNT_OVERLAY_SOURCE_ID
, AELB.SUBLEDGER_DOC_SEQUENCE_VALUE SUBLEDGER_DOC_SEQUENCE_VALUE
, AELB.TAX_CODE_ID TAX_CODE_ID
, AELB.AE_HEADER_ID AE_HEADER_ID
, AELB.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, AELB.CODE_COMBINATION_ID CODE_COMBINATION_ID
, AELB.ORG_ID ORG_ID
, AELB.AE_LINE_NUMBER AE_LINE_NUMBER
, AELB.AE_LINE_TYPE_CODE AE_LINE_TYPE_CODE
, AELB.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, AELB.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, AELB.ENTERED_DR ENTERED_DR
, AELB.ENTERED_CR ENTERED_CR
, AELB.ACCOUNTED_DR ACCOUNTED_DR
, AELB.ACCOUNTED_CR ACCOUNTED_CR
, AELB.SOURCE_TABLE SOURCE_TABLE
, AELB.SOURCE_ID SOURCE_ID
, AELB.REFERENCE1 REFERENCE1
, AELB.REFERENCE2 REFERENCE2
, AELB.REFERENCE3 REFERENCE3
, AELB.REFERENCE4 REFERENCE4
, AELB.REFERENCE5 REFERENCE5
, AELB.REFERENCE6 REFERENCE6
, AELB.REFERENCE7 REFERENCE7
, AELB.REFERENCE8 REFERENCE8
, AELB.REFERENCE9 REFERENCE9
, AELB.REFERENCE10 REFERENCE10
, AELB.DESCRIPTION DESCRIPTION
, AELB.THIRD_PARTY_ID THIRD_PARTY_ID
, AELB.THIRD_PARTY_SUB_ID THIRD_PARTY_SUB_ID
, AELB.STAT_AMOUNT STAT_AMOUNT
, AELB.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, AELB.SUBLEDGER_DOC_SEQUENCE_ID SUBLEDGER_DOC_SEQUENCE_ID
, AELB.ACCOUNTING_ERROR_CODE ACCOUNTING_ERROR_CODE
, AELB.GL_TRANSFER_ERROR_CODE GL_TRANSFER_ERROR_CODE
, AELB.GL_SL_LINK_ID GL_SL_LINK_ID
, AELB.TAXABLE_ENTERED_DR TAXABLE_ENTERED_DR
, AELB.TAXABLE_ENTERED_CR TAXABLE_ENTERED_CR
, AELB.TAXABLE_ACCOUNTED_DR TAXABLE_ACCOUNTED_DR
, AELB.TAXABLE_ACCOUNTED_CR TAXABLE_ACCOUNTED_CR
, AELB.APPLIED_FROM_TRX_HDR_TABLE APPLIED_FROM_TRX_HDR_TABLE
, AELB.APPLIED_FROM_TRX_HDR_ID APPLIED_FROM_TRX_HDR_ID
, AELB.APPLIED_TO_TRX_HDR_TABLE APPLIED_TO_TRX_HDR_TABLE
, AELB.APPLIED_TO_TRX_HDR_ID APPLIED_TO_TRX_HDR_ID
, AELB.TAX_LINK_ID TAX_LINK_ID
, AELB.CURRENCY_CODE CURR_CODE
, AELB.PROGRAM_ID PROGRAM_ID
, AELB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AELB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AELB.REQUEST_ID REQUEST_ID
, AELB.CREATED_BY CREATED_BY
, AELB.CREATION_DATE CREATION_DATE
, AELB.LAST_UPDATED_BY LAST_UPDATED_BY
, AELB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AELB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_AE_LINES AELB
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns