VIEW: APPS.LNS_LOAN_HEADERS_EXT_V

Source

View Text - Preformatted

SELECT XLE.Event_id ,XLEE.ledger_id ,LNH.loan_id ,LNH.LAST_UPDATE_DATE ,LNH.LAST_UPDATED_BY ,LNH.LAST_UPDATE_LOGIN ,LNH.CREATION_DATE ,LNH.CREATED_BY ,LNH.PROGRAM_ID ,LNH.OBJECT_VERSION_NUMBER ,LNH.REQUEST_ID ,LNH.LOAN_NUMBER ,LNH.LOAN_DESCRIPTION ,LNH.INITIAL_LOAN_BALANCE ,LNH.LAST_PAYMENT_DATE ,LNH.LAST_PAYMENT_AMOUNT ,LNH.LOAN_TERM ,LNH.LOAN_TERM_PERIOD ,LNH.LOAN_CURRENCY ,LNH.LOAN_CLASS_CODE ,LTYP.LOAN_TYPE_NAME ,LNH.LOAN_SUBTYPE ,LNH.LOAN_PURPOSE_CODE ,LNH.AMORTIZED_TERM ,LNH.AMORTIZED_TERM_PERIOD ,LNH.LOAN_MATURITY_DATE ,LNH.LOAN_START_DATE ,LNH.LOAN_APPLICATION_DATE ,LNH.LOAN_CLOSING_DATE ,LNH.LAST_BILLED_DATE ,LNH.END_DATE ,LNH.PRODUCT_FLAG ,LNH.CUST_ACCOUNT_ID ,LNH.PRIMARY_BORROWER_ID ,HZ.PARTY_NAME ,LNH.PRODUCT_ID ,LNH.REQUESTED_AMOUNT ,LNH.FUNDED_AMOUNT ,LNH.REFERENCE_AMOUNT ,LNH.REFERENCE_NUMBER ,LNH.REFERENCE_NAME ,LNH.REFERENCE_TYPE ,LNH.REFERENCE_DESCRIPTION ,LNH.LOAN_APPROVAL_DATE ,LNH.LOAN_APPROVED_BY ,LNH.LOAN_STATUS ,LNH.LOAN_ASSIGNED_TO ,LNH.REFERENCE_ID ,LNH.CUSTOM_PAYMENTS_FLAG ,LNH.BILLED_FLAG ,LNH.ORG_ID ,LNH.USSGL_TRANSACTION_CODE ,LNH.ATTRIBUTE_CATEGORY ,LNH.ATTRIBUTE1 ,LNH.ATTRIBUTE2 ,LNH.ATTRIBUTE3 ,LNH.ATTRIBUTE4 ,LNH.ATTRIBUTE5 ,LNH.ATTRIBUTE6 ,LNH.ATTRIBUTE7 ,LNH.ATTRIBUTE8 ,LNH.ATTRIBUTE9 ,LNH.ATTRIBUTE10 ,LNH.ATTRIBUTE11 ,LNH.ATTRIBUTE12 ,LNH.ATTRIBUTE13 ,LNH.ATTRIBUTE14 ,LNH.ATTRIBUTE15 ,LNH.ATTRIBUTE16 ,LNH.ATTRIBUTE17 ,LNH.ATTRIBUTE18 ,LNH.ATTRIBUTE19 ,LNH.ATTRIBUTE20 ,CASE WHEN XLE.EVENT_TYPE_CODE in ('LOAN_ACCRUAL') THEN XLE.EVENT_DATE ELSE LNH.GL_DATE END GL_DATE ,LNH.REFERENCE_TYPE_ID ,LNH.BILL_TO_ACCT_SITE_ID ,LNH.REC_ADJUSTMENT_NUMBER ,LNH.CONTACT_PERS_PARTY_ID ,LNH.CONTACT_REL_PARTY_ID ,LNH.EXCHANGE_RATE_TYPE ,LNH.EXCHANGE_DATE ,LNH.EXCHANGE_RATE ,LNH.collateral_percent ,LNH.credit_review_flag ,LNH.last_payment_number ,LNH.last_amortization_id ,LNH.legal_entity_id ,LNH.open_to_term_flag ,LNH.multiple_funding_flag ,LNH.loan_type_id ,LNH.secondary_status ,LNH.open_to_term_event ,LNH.balloon_payment_type ,LNH.current_phase ,LNH.open_loan_start_date ,LNH.open_loan_term ,LNH.open_loan_term_period ,LNH.open_maturity_date ,LNH.funds_check_date ,LNH.funds_reserved_flag ,nvl(LNH.subsidy_rate, 0) ,nvl(LNH.subsidy_rate, 0) /100 * lnh.requested_amount ,lnh.requested_amount - (nvl(LNH.subsidy_rate,0)/100 * lnh.requested_amount) ,206 ,XLEE.entity_code ENTITY_CODE from LNS_LOAN_HEADERS_ALL_VL LNH ,lns_loan_types_vl LTYP ,HZ_PARTIES HZ ,xla_events XLE ,xla_transaction_entities XLEE WHERE XLE.application_id = 206 and XLE.entity_id = xlee.entity_id and XLEE.source_id_int_1 = lnh.loan_id and xle.event_status_code <> 'P' and HZ.party_id = lnh.primary_borrower_id and lnh.loan_type_id = LTYP.Loan_type_ID

View Text - HTML Formatted

SELECT XLE.EVENT_ID
, XLEE.LEDGER_ID
, LNH.LOAN_ID
, LNH.LAST_UPDATE_DATE
, LNH.LAST_UPDATED_BY
, LNH.LAST_UPDATE_LOGIN
, LNH.CREATION_DATE
, LNH.CREATED_BY
, LNH.PROGRAM_ID
, LNH.OBJECT_VERSION_NUMBER
, LNH.REQUEST_ID
, LNH.LOAN_NUMBER
, LNH.LOAN_DESCRIPTION
, LNH.INITIAL_LOAN_BALANCE
, LNH.LAST_PAYMENT_DATE
, LNH.LAST_PAYMENT_AMOUNT
, LNH.LOAN_TERM
, LNH.LOAN_TERM_PERIOD
, LNH.LOAN_CURRENCY
, LNH.LOAN_CLASS_CODE
, LTYP.LOAN_TYPE_NAME
, LNH.LOAN_SUBTYPE
, LNH.LOAN_PURPOSE_CODE
, LNH.AMORTIZED_TERM
, LNH.AMORTIZED_TERM_PERIOD
, LNH.LOAN_MATURITY_DATE
, LNH.LOAN_START_DATE
, LNH.LOAN_APPLICATION_DATE
, LNH.LOAN_CLOSING_DATE
, LNH.LAST_BILLED_DATE
, LNH.END_DATE
, LNH.PRODUCT_FLAG
, LNH.CUST_ACCOUNT_ID
, LNH.PRIMARY_BORROWER_ID
, HZ.PARTY_NAME
, LNH.PRODUCT_ID
, LNH.REQUESTED_AMOUNT
, LNH.FUNDED_AMOUNT
, LNH.REFERENCE_AMOUNT
, LNH.REFERENCE_NUMBER
, LNH.REFERENCE_NAME
, LNH.REFERENCE_TYPE
, LNH.REFERENCE_DESCRIPTION
, LNH.LOAN_APPROVAL_DATE
, LNH.LOAN_APPROVED_BY
, LNH.LOAN_STATUS
, LNH.LOAN_ASSIGNED_TO
, LNH.REFERENCE_ID
, LNH.CUSTOM_PAYMENTS_FLAG
, LNH.BILLED_FLAG
, LNH.ORG_ID
, LNH.USSGL_TRANSACTION_CODE
, LNH.ATTRIBUTE_CATEGORY
, LNH.ATTRIBUTE1
, LNH.ATTRIBUTE2
, LNH.ATTRIBUTE3
, LNH.ATTRIBUTE4
, LNH.ATTRIBUTE5
, LNH.ATTRIBUTE6
, LNH.ATTRIBUTE7
, LNH.ATTRIBUTE8
, LNH.ATTRIBUTE9
, LNH.ATTRIBUTE10
, LNH.ATTRIBUTE11
, LNH.ATTRIBUTE12
, LNH.ATTRIBUTE13
, LNH.ATTRIBUTE14
, LNH.ATTRIBUTE15
, LNH.ATTRIBUTE16
, LNH.ATTRIBUTE17
, LNH.ATTRIBUTE18
, LNH.ATTRIBUTE19
, LNH.ATTRIBUTE20
, CASE WHEN XLE.EVENT_TYPE_CODE IN ('LOAN_ACCRUAL') THEN XLE.EVENT_DATE ELSE LNH.GL_DATE END GL_DATE
, LNH.REFERENCE_TYPE_ID
, LNH.BILL_TO_ACCT_SITE_ID
, LNH.REC_ADJUSTMENT_NUMBER
, LNH.CONTACT_PERS_PARTY_ID
, LNH.CONTACT_REL_PARTY_ID
, LNH.EXCHANGE_RATE_TYPE
, LNH.EXCHANGE_DATE
, LNH.EXCHANGE_RATE
, LNH.COLLATERAL_PERCENT
, LNH.CREDIT_REVIEW_FLAG
, LNH.LAST_PAYMENT_NUMBER
, LNH.LAST_AMORTIZATION_ID
, LNH.LEGAL_ENTITY_ID
, LNH.OPEN_TO_TERM_FLAG
, LNH.MULTIPLE_FUNDING_FLAG
, LNH.LOAN_TYPE_ID
, LNH.SECONDARY_STATUS
, LNH.OPEN_TO_TERM_EVENT
, LNH.BALLOON_PAYMENT_TYPE
, LNH.CURRENT_PHASE
, LNH.OPEN_LOAN_START_DATE
, LNH.OPEN_LOAN_TERM
, LNH.OPEN_LOAN_TERM_PERIOD
, LNH.OPEN_MATURITY_DATE
, LNH.FUNDS_CHECK_DATE
, LNH.FUNDS_RESERVED_FLAG
, NVL(LNH.SUBSIDY_RATE
, 0)
, NVL(LNH.SUBSIDY_RATE
, 0) /100 * LNH.REQUESTED_AMOUNT
, LNH.REQUESTED_AMOUNT - (NVL(LNH.SUBSIDY_RATE
, 0)/100 * LNH.REQUESTED_AMOUNT)
, 206
, XLEE.ENTITY_CODE ENTITY_CODE
FROM LNS_LOAN_HEADERS_ALL_VL LNH
, LNS_LOAN_TYPES_VL LTYP
, HZ_PARTIES HZ
, XLA_EVENTS XLE
, XLA_TRANSACTION_ENTITIES XLEE
WHERE XLE.APPLICATION_ID = 206
AND XLE.ENTITY_ID = XLEE.ENTITY_ID
AND XLEE.SOURCE_ID_INT_1 = LNH.LOAN_ID
AND XLE.EVENT_STATUS_CODE <> 'P'
AND HZ.PARTY_ID = LNH.PRIMARY_BORROWER_ID
AND LNH.LOAN_TYPE_ID = LTYP.LOAN_TYPE_ID