[Home] [Help]
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
Name |
LOAN_ID |
CUSTOMER_NAME |
CUSTOMER_NUMBER |
LOAN_NUMBER |
LOAN_START_DATE |
FUNDED_AMOUNT |
LOAN_STATUS |
LOAN_CLASS |
LOAN_TYPE |
DISB_HEADER_ID |
DISBURSEMENT_STATUS |
DISBURSEMENT_NUMBER |
DISBURSEMENT_REQUEST_DATE |