VIEW: APPS.LNS_LOAN_SUMMARY_V

Source

View Text - Preformatted

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 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(+)

View Text - HTML Formatted

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 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(+)