View: OKL_AE_LINES_UPDT_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AE_LINES_UPDT_UV

View Text

SELECT AEL.AE_LINE_ID AE_LINE_ID
, TCN.TRX_NUMBER TRX_NUMBER
, TCL.LINE_NUMBER LINE_NUMBER
, AEL.AE_LINE_TYPE_CODE AE_LINE_TYPE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_AE_LINE_TYPE'
, AEL.AE_LINE_TYPE_CODE) AE_LINE_TYPE_MEANING
, GCCK.CONCATENATED_SEGMENTS ACCOUNT
, OKL_ACCOUNTING_UTIL.GET_CONCATE_DESC(GCCK.CHART_OF_ACCOUNTS_ID
, GCCK.CONCATENATED_SEGMENTS) ACCOUNT_DESC
, AEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, AEL.ENTERED_DR ENTERED_DR
, AEL.ENTERED_CR ENTERED_CR
, AEL.ACCOUNTED_DR ACCOUNTED_DR
, AEL.ACCOUNTED_CR ACCOUNTED_CR
, AEL.CURRENCY_CODE CURRENCY_CODE
, AEL.SOURCE_TABLE SOURCE_TABLE
, AEL.SOURCE_ID SOURCE_ID
, AEH.PERIOD_NAME PERIOD_NAME
, AEH.ACCOUNTING_DATE ACCOUNTING_DATE
, AEH.ACCOUNTING_ERROR_CODE ACCOUNTING_ERROR_CODE
, AET.EVENT_NUMBER EVENT_NUMBER
, AET.EVENT_TYPE_CODE EVENT_TYPE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCOUNTING_EVENT_TYPE'
, AET.EVENT_TYPE_CODE) EVENT_TYPE_CODE_DESC
, AET.EVENT_STATUS_CODE EVENT_STATUS_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCOUNTING_EVENT_STATUS'
, AET.EVENT_STATUS_CODE) EVENT_STATUS_CODE_DESC
FROM GL_CODE_COMBINATIONS_KFV GCCK
, OKL_TRX_CONTRACTS_ALL TCN
, OKL_TXL_CNTRCT_LNS_ALL TCL
, OKL_ACC_EVENTS_ALL AET
, OKL_AE_HEADERS AEH
, OKL_AE_LINES_ALL AEL
WHERE AEL.AE_HEADER_ID = AEH.AE_HEADER_ID
AND AEH.ACCOUNTING_EVENT_ID = AET.ACCOUNTING_EVENT_ID
AND AET.SOURCE_ID = TCL.ID
AND AET.SOURCE_TABLE = 'OKL_TXL_CNTRCT_LNS'
AND TCN.ID = TCL.TCN_ID
AND AEL.ACCOUNTING_ERROR_CODE = 'INVALID_ACCOUNT'
AND AEL.CODE_COMBINATION_ID = GCCK.CODE_COMBINATION_ID (+)

Columns