VIEW: APPS.LNS_AEL_GL_V

Source

View Text - Preformatted

SELECT 206 APPLICATION_ID ,glh.je_header_id JE_HEADER_ID ,glh.JE_CATEGORY JE_CATEGORY ,null USER_JE_CATEGORY ,gll.je_line_num JE_LINE_NUM ,glh.ledger_id SET_OF_BOOKS_ID ,LNH.org_id ORG_ID ,null TRX_CLASS ,lns_utility_pub.get_lookup_meaning('LOAN_CLASS', LNH.LOAN_CLASS_CODE ) TRX_CLASS_NAME ,lns_utility_pub.get_lookup_meaning('LOAN_TYPE', LNH.LOAN_TYPE) TRX_TYPE_NAME ,LNH.LOAN_NUMBER TRX_NUMBER_DISPLAYED ,null TRX_NUMBER_C ,null TRX_DATE ,lnh.loan_description COMMENTS ,null DOC_SEQUENCE_ID ,null DOC_SEQUENCE_VALUE ,LNH.LOAN_id TRX_HDR_ID ,null ACCT_LINE_TYPE ,null ACCT_LINE_TYPE_NAME ,null CODE_COMBINATION_ID ,LNH.loan_currency CURRENCY_CODE ,ael.entered_dr ENTERED_DR ,ael.entered_cr ENTERED_CR ,ael.accounted_dr ACCOUNTED_DR ,ael.accounted_cr ACCOUNTED_CR ,ael.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE ,ael.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE ,ael.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE ,null CURRENCY_USER_CONVERSION_TYPE ,null THIRD_PARTY_NUMBER ,hz.party_name THIRD_PARTY_NAME ,null THIRD_PARTY_SUB_ID ,trunc(lnh.gl_date) ACCOUNTING_DATE ,null TRX_LINE_NUMBER ,null TRX_LINE_TYPE ,null TRX_LINE_TYPE_NAME ,null REQUEST_ID ,null PROGRAM_APPLICATION_ID ,null PROGRAM_ID ,null PROGRAM_UPDATE_DATE From lns_loan_headers_all LNH ,gl_import_references R ,gl_je_headers glh ,gl_je_lines gll ,hz_parties hz ,xla_ae_headers aeh ,xla_ae_lines ael ,xla_transaction_entities xte ,xla_events xev WHERE hz.party_id = LNH.primary_borrower_id AND lnh.loan_id = xte.source_id_int_1 AND xte.entity_id = xev.entity_id AND xev.event_id = aeh.event_id AND aeh.ae_header_id = ael.ae_header_id AND aeh.entity_id = xte.entity_id AND R.je_header_id = glh.je_header_id AND R.je_line_num = gll.je_line_num AND glh.je_header_id = gll.je_header_id AND R.gl_sl_link_id = ael.gl_sl_link_id AND xte.application_id = 206 AND aeh.application_id = 206

View Text - HTML Formatted

SELECT 206 APPLICATION_ID
, GLH.JE_HEADER_ID JE_HEADER_ID
, GLH.JE_CATEGORY JE_CATEGORY
, NULL USER_JE_CATEGORY
, GLL.JE_LINE_NUM JE_LINE_NUM
, GLH.LEDGER_ID SET_OF_BOOKS_ID
, LNH.ORG_ID ORG_ID
, NULL TRX_CLASS
, LNS_UTILITY_PUB.GET_LOOKUP_MEANING('LOAN_CLASS'
, LNH.LOAN_CLASS_CODE ) TRX_CLASS_NAME
, LNS_UTILITY_PUB.GET_LOOKUP_MEANING('LOAN_TYPE'
, LNH.LOAN_TYPE) TRX_TYPE_NAME
, LNH.LOAN_NUMBER TRX_NUMBER_DISPLAYED
, NULL TRX_NUMBER_C
, NULL TRX_DATE
, LNH.LOAN_DESCRIPTION COMMENTS
, NULL DOC_SEQUENCE_ID
, NULL DOC_SEQUENCE_VALUE
, LNH.LOAN_ID TRX_HDR_ID
, NULL ACCT_LINE_TYPE
, NULL ACCT_LINE_TYPE_NAME
, NULL CODE_COMBINATION_ID
, LNH.LOAN_CURRENCY CURRENCY_CODE
, AEL.ENTERED_DR ENTERED_DR
, AEL.ENTERED_CR ENTERED_CR
, AEL.ACCOUNTED_DR ACCOUNTED_DR
, AEL.ACCOUNTED_CR ACCOUNTED_CR
, AEL.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, AEL.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, AEL.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, NULL CURRENCY_USER_CONVERSION_TYPE
, NULL THIRD_PARTY_NUMBER
, HZ.PARTY_NAME THIRD_PARTY_NAME
, NULL THIRD_PARTY_SUB_ID
, TRUNC(LNH.GL_DATE) ACCOUNTING_DATE
, NULL TRX_LINE_NUMBER
, NULL TRX_LINE_TYPE
, NULL TRX_LINE_TYPE_NAME
, NULL REQUEST_ID
, NULL PROGRAM_APPLICATION_ID
, NULL PROGRAM_ID
, NULL PROGRAM_UPDATE_DATE
FROM LNS_LOAN_HEADERS_ALL LNH
, GL_IMPORT_REFERENCES R
, GL_JE_HEADERS GLH
, GL_JE_LINES GLL
, HZ_PARTIES HZ
, XLA_AE_HEADERS AEH
, XLA_AE_LINES AEL
, XLA_TRANSACTION_ENTITIES XTE
, XLA_EVENTS XEV
WHERE HZ.PARTY_ID = LNH.PRIMARY_BORROWER_ID
AND LNH.LOAN_ID = XTE.SOURCE_ID_INT_1
AND XTE.ENTITY_ID = XEV.ENTITY_ID
AND XEV.EVENT_ID = AEH.EVENT_ID
AND AEH.AE_HEADER_ID = AEL.AE_HEADER_ID
AND AEH.ENTITY_ID = XTE.ENTITY_ID
AND R.JE_HEADER_ID = GLH.JE_HEADER_ID
AND R.JE_LINE_NUM = GLL.JE_LINE_NUM
AND GLH.JE_HEADER_ID = GLL.JE_HEADER_ID
AND R.GL_SL_LINK_ID = AEL.GL_SL_LINK_ID
AND XTE.APPLICATION_ID = 206
AND AEH.APPLICATION_ID = 206