VIEW: APPS.OKL_AE_LINES_UPDT_UV

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)