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.

[Home] [Help]

View: LNS_AEL_GL_V

Product:	LNS - Loans
Description:	This view contains accounting GL info about loans invoices
Implementation/DBA Data:	APPS.LNS_AEL_GL_V

View Text

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

Columns

Name
APPLICATION_ID
JE_HEADER_ID
JE_CATEGORY
USER_JE_CATEGORY
JE_LINE_NUM
SET_OF_BOOKS_ID
ORG_ID
TRX_CLASS
TRX_CLASS_NAME
TRX_TYPE_NAME
TRX_NUMBER_DISPLAYED
TRX_NUMBER_C
TRX_DATE
COMMENTS
DOC_SEQUENCE_ID
DOC_SEQUENCE_VALUE
TRX_HDR_ID
ACCT_LINE_TYPE
ACCT_LINE_TYPE_NAME
CODE_COMBINATION_ID
CURRENCY_CODE
ENTERED_DR
ENTERED_CR
ACCOUNTED_DR
ACCOUNTED_CR
CURRENCY_CONVERSION_DATE
CURRENCY_CONVERSION_TYPE
CURRENCY_CONVERSION_RATE
CURRENCY_USER_CONVERSION_TYPE
THIRD_PARTY_NUMBER
THIRD_PARTY_NAME
THIRD_PARTY_SUB_ID
ACCOUNTING_DATE
TRX_LINE_NUMBER
TRX_LINE_TYPE
TRX_LINE_TYPE_NAME
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE