eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_AEL_SL_V

Source

View Text - Preformatted


SELECT 540 application_id, aeh.set_of_books_id set_of_books_id, aeh.org_id org_id, aeh.ae_header_id aeh_id, ael.ae_line_id ael_id, aet.Event_Number ACCOUNTING_EVENT_NUMBER, ael.AE_Line_Number ACCOUNTING_LINE_NUMBER, ael.ae_line_type_code ACCT_LINE_TYPE, okl_Accounting_util.get_lookup_meaning('OKL_AE_LINE_TYPE', ael.ae_line_type_code) ACCT_LINE_TYPE_NAME, ael.code_Combination_id CODE_COMBINATION_ID, ael.ACCOUNTED_DR ACCOUNTED_DR, ael.ACCOUNTED_CR ACCOUNTED_CR, tcl.line_number TRX_LINE_NUMBER, tcl.currency_code CURRENCY_CODE, ael.entered_dr ENTERED_DR, ael.entered_cr ENTERED_CR, ael.currency_conversion_rate CURRENCY_CONVERSION_RATE, ael.currency_conversion_date CURRENCY_CONVERSION_DATE, glct.user_conversion_type currency_user_conversion_type, ael.source_id SOURCE_ID, ael.source_table SOURCE_TABLE, avl.name ASSET_DESCRIPTION, aet.event_type_code ACCOUNTING_EVENT_TYPE, okl_accounting_util.get_lookup_meaning('OKL_ACCOUNTING_EVENT_TYPE', aet.event_type_code) ACCOUNTING_EVENT_TYPE_NAME, aeh.accounting_date ACCOUNTING_DATE, aeh.gl_transfer_flag gl_transfer_status, okl_accounting_util.get_lookup_meaning('YES_NO', aeh.gl_transfer_Flag, 0, 0) gl_transfer_status_name, aeh.ae_category JE_CATEGORY, aeh.accounting_error_code AEH_ACCOUNTING_ERROR_CODE, ael.accounting_error_code AEL_ACCOUNTING_ERROR_CODE, jc.user_je_category_name USER_JE_CATEGORY_NAME, ael.last_update_date last_update_date, ael.last_updated_by LAST_UPDATED_BY, ael.creation_date CREATION_DATE, ael.created_by CREATED_BY, ael.last_update_login LAST_UPDATE_LOGIN, ael.request_id REQUEST_ID, ael.program_application_id PROGRAM_APPLICATION_ID, ael.program_id PROGRAM_ID, ael.program_update_date PROGRAM_UPDATE_DATE, tcn.date_transaction_occurred TRX_DATE, try.trx_type_class TRX_CLASS, okl_accounting_util.get_lookup_meaning('OKL_TRANSACTION_TYPE_CLASS', try.trx_type_class) TRX_CLASS_NAME, sty.name COST_ELEMENT_NAME , Okl_Accounting_Util.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE', STY.STREAM_TYPE_PURPOSE) PO_ORDER_NUMBER FROM OKL_ACC_EVENTS_ALL AET,OKL_AE_HEADERS AEH,OKL_AE_LINES_ALL AEL,OKL_TRX_CONTRACTS_ALL TCN,OKL_TXL_CNTRCT_LNS_ALL TCL,OKL_TRX_TYPES_B TRY,OKL_STRM_TYPE_V STY,OKL_AE_TEMPLATES_ALL AVL,GL_JE_CATEGORIES_VL JC,GL_DAILY_CONVERSION_TYPES GLCT WHERE aet.accounting_Event_id = aeh.accounting_Event_id AND aeh.ae_header_id = ael.ae_header_id AND aet.source_id = tcl.ID AND tcn.ID = tcl.tcn_id AND tcn.try_id = try.ID AND jc.je_category_name = aeh.ae_category AND ael.currency_conversion_type = GLCT.conversion_type(+) and ael.reference1 = avl.ID (+) AND TCL.STY_ID = STY.ID (+) UNION ALL SELECT 540 application_id, aeh.set_of_books_id set_of_books_id, aeh.org_id org_id, aeh.ae_header_id aeh_id, ael.ae_line_id ael_id, aet.Event_Number ACCOUNTING_EVENT_NUMBER, ael.AE_Line_Number ACCOUNTING_LINE_NUMBER, ael.ae_line_type_code ACCT_LINE_TYPE, okl_Accounting_util.get_lookup_meaning('OKL_AE_LINE_TYPE', ael.ae_line_type_code) ACCT_LINE_TYPE_NAME, ael.code_Combination_id CODE_COMBINATION_ID, ael.ACCOUNTED_DR ACCOUNTED_DR, ael.ACCOUNTED_CR ACCOUNTED_CR, asl.line_number TRX_LINE_NUMBER, ael.currency_code CURRENCY_CODE, ael.entered_dr ENTERED_DR, ael.entered_cr ENTERED_CR, ael.currency_conversion_rate CURRENCY_CONVERSION_RATE, ael.currency_conversion_date CURRENCY_CONVERSION_DATE, glct.user_conversion_type currency_user_conversion_type, ael.source_id SOURCE_ID, ael.source_table SOURCE_TABLE, avl.name ASSET_DESCRIPTION, aet.event_type_code ACCOUNTING_EVENT_TYPE, okl_accounting_util.get_lookup_meaning('OKL_ACCOUNTING_EVENT_TYPE', aet.event_type_code) ACCOUNTING_EVENT_TYPE_NAME, aeh.accounting_date ACCOUNTING_DATE, aeh.gl_transfer_flag gl_transfer_status, okl_accounting_util.get_lookup_meaning('YES_NO', aeh.gl_transfer_Flag, 0, 0) gl_transfer_status_name, aeh.ae_category JE_CATEGORY, aeh.accounting_error_code AEH_ACCOUNTING_ERROR_CODE, ael.accounting_error_code AEL_ACCOUNTING_ERROR_CODE, jc.user_je_category_name USER_JE_CATEGORY_NAME, ael.last_update_date last_update_date, ael.last_updated_by LAST_UPDATED_BY, ael.creation_date CREATION_DATE, ael.created_by CREATED_BY, ael.last_update_login LAST_UPDATE_LOGIN, ael.request_id REQUEST_ID, ael.program_application_id PROGRAM_APPLICATION_ID, ael.program_id PROGRAM_ID, ael.program_update_date PROGRAM_UPDATE_DATE, ast.date_trans_occurred TRX_DATE, try.trx_type_class TRX_CLASS, okl_accounting_util.get_lookup_meaning('OKL_TRANSACTION_TYPE_CLASS', try.trx_type_class) TRX_CLASS_NAME, sty.name COST_ELEMENT_NAME , Okl_Accounting_Util.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE', STY.STREAM_TYPE_PURPOSE) PO_ORDER_NUMBER FROM okl_acc_events_all aet, OKL_AE_HEADERS aeh, OKL_AE_LINES_ALL ael, OKL_TRX_ASSETS ast, OKL_TXL_ASSETS_B asl, OKL_TRX_TYPES_B try, OKL_STRM_TYPE_V sty, OKL_AE_TEMPLATES_ALL avl, GL_JE_CATEGORIES jc, GL_DAILY_CONVERSION_TYPES GLCT WHERE aet.accounting_Event_id = aeh.accounting_Event_id AND aeh.ae_header_id = ael.ae_header_id AND aet.source_id = asl.ID AND ast.ID = asl.tas_id AND ast.try_id = try.ID AND jc.je_category_name = aeh.ae_category AND ael.currency_conversion_type = GLCT.conversion_type(+) and ael.reference1 = avl.ID (+) AND AVL.STY_ID = STY.ID

View Text - HTML Formatted

SELECT 540 APPLICATION_ID
, AEH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AEH.ORG_ID ORG_ID
, AEH.AE_HEADER_ID AEH_ID
, AEL.AE_LINE_ID AEL_ID
, AET.EVENT_NUMBER ACCOUNTING_EVENT_NUMBER
, AEL.AE_LINE_NUMBER ACCOUNTING_LINE_NUMBER
, AEL.AE_LINE_TYPE_CODE ACCT_LINE_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_AE_LINE_TYPE'
, AEL.AE_LINE_TYPE_CODE) ACCT_LINE_TYPE_NAME
, AEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, AEL.ACCOUNTED_DR ACCOUNTED_DR
, AEL.ACCOUNTED_CR ACCOUNTED_CR
, TCL.LINE_NUMBER TRX_LINE_NUMBER
, TCL.CURRENCY_CODE CURRENCY_CODE
, AEL.ENTERED_DR ENTERED_DR
, AEL.ENTERED_CR ENTERED_CR
, AEL.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, AEL.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, AEL.SOURCE_ID SOURCE_ID
, AEL.SOURCE_TABLE SOURCE_TABLE
, AVL.NAME ASSET_DESCRIPTION
, AET.EVENT_TYPE_CODE ACCOUNTING_EVENT_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCOUNTING_EVENT_TYPE'
, AET.EVENT_TYPE_CODE) ACCOUNTING_EVENT_TYPE_NAME
, AEH.ACCOUNTING_DATE ACCOUNTING_DATE
, AEH.GL_TRANSFER_FLAG GL_TRANSFER_STATUS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, AEH.GL_TRANSFER_FLAG
, 0
, 0) GL_TRANSFER_STATUS_NAME
, AEH.AE_CATEGORY JE_CATEGORY
, AEH.ACCOUNTING_ERROR_CODE AEH_ACCOUNTING_ERROR_CODE
, AEL.ACCOUNTING_ERROR_CODE AEL_ACCOUNTING_ERROR_CODE
, JC.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, AEL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AEL.LAST_UPDATED_BY LAST_UPDATED_BY
, AEL.CREATION_DATE CREATION_DATE
, AEL.CREATED_BY CREATED_BY
, AEL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AEL.REQUEST_ID REQUEST_ID
, AEL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AEL.PROGRAM_ID PROGRAM_ID
, AEL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TCN.DATE_TRANSACTION_OCCURRED TRX_DATE
, TRY.TRX_TYPE_CLASS TRX_CLASS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TRANSACTION_TYPE_CLASS'
, TRY.TRX_TYPE_CLASS) TRX_CLASS_NAME
, STY.NAME COST_ELEMENT_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STY.STREAM_TYPE_PURPOSE) PO_ORDER_NUMBER
FROM OKL_ACC_EVENTS_ALL AET
, OKL_AE_HEADERS AEH
, OKL_AE_LINES_ALL AEL
, OKL_TRX_CONTRACTS_ALL TCN
, OKL_TXL_CNTRCT_LNS_ALL TCL
, OKL_TRX_TYPES_B TRY
, OKL_STRM_TYPE_V STY
, OKL_AE_TEMPLATES_ALL AVL
, GL_JE_CATEGORIES_VL JC
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE AET.ACCOUNTING_EVENT_ID = AEH.ACCOUNTING_EVENT_ID
AND AEH.AE_HEADER_ID = AEL.AE_HEADER_ID
AND AET.SOURCE_ID = TCL.ID
AND TCN.ID = TCL.TCN_ID
AND TCN.TRY_ID = TRY.ID
AND JC.JE_CATEGORY_NAME = AEH.AE_CATEGORY
AND AEL.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE(+)
AND AEL.REFERENCE1 = AVL.ID (+)
AND TCL.STY_ID = STY.ID (+) UNION ALL SELECT 540 APPLICATION_ID
, AEH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AEH.ORG_ID ORG_ID
, AEH.AE_HEADER_ID AEH_ID
, AEL.AE_LINE_ID AEL_ID
, AET.EVENT_NUMBER ACCOUNTING_EVENT_NUMBER
, AEL.AE_LINE_NUMBER ACCOUNTING_LINE_NUMBER
, AEL.AE_LINE_TYPE_CODE ACCT_LINE_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_AE_LINE_TYPE'
, AEL.AE_LINE_TYPE_CODE) ACCT_LINE_TYPE_NAME
, AEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, AEL.ACCOUNTED_DR ACCOUNTED_DR
, AEL.ACCOUNTED_CR ACCOUNTED_CR
, ASL.LINE_NUMBER TRX_LINE_NUMBER
, AEL.CURRENCY_CODE CURRENCY_CODE
, AEL.ENTERED_DR ENTERED_DR
, AEL.ENTERED_CR ENTERED_CR
, AEL.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, AEL.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, AEL.SOURCE_ID SOURCE_ID
, AEL.SOURCE_TABLE SOURCE_TABLE
, AVL.NAME ASSET_DESCRIPTION
, AET.EVENT_TYPE_CODE ACCOUNTING_EVENT_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_ACCOUNTING_EVENT_TYPE'
, AET.EVENT_TYPE_CODE) ACCOUNTING_EVENT_TYPE_NAME
, AEH.ACCOUNTING_DATE ACCOUNTING_DATE
, AEH.GL_TRANSFER_FLAG GL_TRANSFER_STATUS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('YES_NO'
, AEH.GL_TRANSFER_FLAG
, 0
, 0) GL_TRANSFER_STATUS_NAME
, AEH.AE_CATEGORY JE_CATEGORY
, AEH.ACCOUNTING_ERROR_CODE AEH_ACCOUNTING_ERROR_CODE
, AEL.ACCOUNTING_ERROR_CODE AEL_ACCOUNTING_ERROR_CODE
, JC.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, AEL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AEL.LAST_UPDATED_BY LAST_UPDATED_BY
, AEL.CREATION_DATE CREATION_DATE
, AEL.CREATED_BY CREATED_BY
, AEL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AEL.REQUEST_ID REQUEST_ID
, AEL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, AEL.PROGRAM_ID PROGRAM_ID
, AEL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AST.DATE_TRANS_OCCURRED TRX_DATE
, TRY.TRX_TYPE_CLASS TRX_CLASS
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_TRANSACTION_TYPE_CLASS'
, TRY.TRX_TYPE_CLASS) TRX_CLASS_NAME
, STY.NAME COST_ELEMENT_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STY.STREAM_TYPE_PURPOSE) PO_ORDER_NUMBER
FROM OKL_ACC_EVENTS_ALL AET
, OKL_AE_HEADERS AEH
, OKL_AE_LINES_ALL AEL
, OKL_TRX_ASSETS AST
, OKL_TXL_ASSETS_B ASL
, OKL_TRX_TYPES_B TRY
, OKL_STRM_TYPE_V STY
, OKL_AE_TEMPLATES_ALL AVL
, GL_JE_CATEGORIES JC
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE AET.ACCOUNTING_EVENT_ID = AEH.ACCOUNTING_EVENT_ID
AND AEH.AE_HEADER_ID = AEL.AE_HEADER_ID
AND AET.SOURCE_ID = ASL.ID
AND AST.ID = ASL.TAS_ID
AND AST.TRY_ID = TRY.ID
AND JC.JE_CATEGORY_NAME = AEH.AE_CATEGORY
AND AEL.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE(+)
AND AEL.REFERENCE1 = AVL.ID (+)
AND AVL.STY_ID = STY.ID