View: LNS_LOAN_INFO

Product:	LNS - Loans
Description:	Loans Accounting Events Informational View
Implementation/DBA Data:	APPS.LNS_LOAN_INFO

View Text

SELECT TRX.LOAN_ID
, PTY.PARTY_NAME
, CA.ACCOUNT_NUMBER
, TRX.LOAN_NUMBER
, TRX.LOAN_START_DATE
, TRX.FUNDED_AMOUNT
, LNS_UTILITY_PUB.GET_LOOKUP_MEANING('LOAN_STATUS'
, TRX.LOAN_STATUS)
, LNS_UTILITY_PUB.GET_LOOKUP_MEANING('LOAN_CLASS'
, TRX.LOAN_CLASS_CODE)
, TYP.LOAN_TYPE_NAME
, NVL(DISB.DISB_HEADER_ID
, -1)
, LNS_UTILITY_PUB.GET_LOOKUP_MEANING('FUNDING_STATUS'
, DISB.STATUS)
, DISB.DISBURSEMENT_NUMBER
, DISB.PAYMENT_REQUEST_DATE
FROM LNS_LOAN_HEADERS_ALL TRX
, LNS_LOAN_TYPES TYP
, LNS_DISB_HEADERS DISB
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PTY
WHERE TRX.CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID
AND CA.PARTY_ID = PTY.PARTY_ID
AND TRX.LOAN_TYPE_ID = TYP.LOAN_TYPE_ID
AND TRX.LOAN_ID = DISB.LOAN_ID(+)

Columns