View: LNS_LOAN_SUMMARY_V

Product:	LNS - Loans
Description:	View for Loan Summary Information
Implementation/DBA Data:	APPS.LNS_LOAN_SUMMARY_V

View Text

SELECT LOAN.LOAN_ID
, LOAN.ORG_ID
, LOAN.LOAN_NUMBER
, STATUS.MEANING
, LOAN.LOAN_CURRENCY
, CURR.NAME
, LOAN_TYPE.LOAN_TYPE_NAME
, LOAN_CLASS.MEANING
, LOAN_SUBTYPE.MEANING
, NULL LOAN_PRODUCT
, LOAN.LOAN_DESCRIPTION
, LOAN_PURPOSE.MEANING
, LOAN.REQUESTED_AMOUNT
, LOAN.FUNDED_AMOUNT
, LOAN.CREATION_DATE
, LOAN.LOAN_APPLICATION_DATE
, LOAN.LOAN_APPROVAL_DATE
, LOAN.LOAN_START_DATE
, LOAN.LOAN_MATURITY_DATE
, LOAN.LOAN_CLOSING_DATE
, LNS_FIN_UTILS.GETACTIVERATE(LOAN.LOAN_ID)
, LOAN.LOAN_TERM
, PERIODLKUP.MEANING
, LOAN.AMORTIZED_TERM
, AMORT_PERIODLKUP.MEANING
, LOAN.REFERENCE_ID
, LOAN.REFERENCE_TYPE
, LOAN.REFERENCE_NUMBER
, LOAN.REFERENCE_DESCRIPTION
, LOAN.REFERENCE_TYPE_ID
, LOAN.PRIMARY_BORROWER_ID
, LOAN.CUST_ACCOUNT_ID
, LOAN.BILL_TO_ACCT_SITE_ID
, LOAN.GL_DATE
, LOAN.LOAN_ASSIGNED_TO
, RES.SOURCE_FIRST_NAME
, RES.SOURCE_MIDDLE_NAME
, RES.SOURCE_LAST_NAME
, RES.SOURCE_NAME
, LOAN.END_DATE
, LOAN.ATTRIBUTE_CATEGORY
, LOAN.ATTRIBUTE1
, LOAN.ATTRIBUTE2
, LOAN.ATTRIBUTE3
, LOAN.ATTRIBUTE4
, LOAN.ATTRIBUTE5
, LOAN.ATTRIBUTE6
, LOAN.ATTRIBUTE7
, LOAN.ATTRIBUTE8
, LOAN.ATTRIBUTE9
, LOAN.ATTRIBUTE10
, LOAN.ATTRIBUTE11
, LOAN.ATTRIBUTE12
, LOAN.ATTRIBUTE13
, LOAN.ATTRIBUTE14
, LOAN.ATTRIBUTE15
, LOAN.ATTRIBUTE16
, LOAN.ATTRIBUTE17
, LOAN.ATTRIBUTE18
, LOAN.ATTRIBUTE19
, LOAN.ATTRIBUTE20
, LOAN.CONTACT_REL_PARTY_ID
, LOAN.CONTACT_PERS_PARTY_ID
, CON_PARTY.PARTY_NAME
, LOAN.COLLATERAL_PERCENT
, LOAN.CREDIT_REVIEW_FLAG
, LOAN.EXCHANGE_RATE_TYPE
, LOAN.EXCHANGE_DATE
, LOAN.EXCHANGE_RATE
FROM LNS_LOAN_HEADERS_ALL LOAN
, JTF_RS_RESOURCE_EXTNS RES
, LNS_LOOKUPS STATUS
, LNS_LOAN_TYPES LOAN_TYPE
, LNS_LOOKUPS LOAN_CLASS
, LNS_LOOKUPS LOAN_SUBTYPE
, FND_CURRENCIES_VL CURR
, LNS_LOOKUPS LOAN_PURPOSE
, LNS_LOOKUPS PERIODLKUP
, LNS_LOOKUPS AMORT_PERIODLKUP
, HZ_PARTIES CON_PARTY
WHERE LOAN.LOAN_ASSIGNED_TO = RES.RESOURCE_ID
AND RES.CATEGORY = 'EMPLOYEE'
AND ( (LOAN.END_DATE IS NULL) OR (SYSDATE <= LOAN.END_DATE) )
AND STATUS.LOOKUP_TYPE = 'LOAN_STATUS'
AND STATUS.LOOKUP_CODE = LOAN.LOAN_STATUS
AND LOAN_TYPE.LOAN_TYPE_ID = LOAN.LOAN_TYPE_ID
AND LOAN_CLASS.LOOKUP_TYPE = 'LOAN_CLASS'
AND LOAN_CLASS.LOOKUP_CODE = LOAN.LOAN_CLASS_CODE
AND LOAN_SUBTYPE.LOOKUP_TYPE = 'LOAN_SUBTYPE'
AND LOAN_SUBTYPE.LOOKUP_CODE = LOAN.LOAN_SUBTYPE
AND LOAN_PURPOSE.LOOKUP_TYPE = 'LOAN_PURPOSE'
AND LOAN_PURPOSE.LOOKUP_CODE = LOAN.LOAN_PURPOSE_CODE
AND PERIODLKUP.LOOKUP_TYPE = 'PERIOD'
AND PERIODLKUP.LOOKUP_CODE = LOAN.LOAN_TERM_PERIOD
AND AMORT_PERIODLKUP.LOOKUP_TYPE = 'PERIOD'
AND AMORT_PERIODLKUP.LOOKUP_CODE = LOAN.AMORTIZED_TERM_PERIOD
AND LOAN.LOAN_CURRENCY = CURR.CURRENCY_CODE
AND LOAN.CONTACT_PERS_PARTY_ID = CON_PARTY.PARTY_ID(+)

Columns