VIEW: LNS.LNS_LOAN_HEADERS_ALL#

Source

View Text - Preformatted

select LOAN_ID LOAN_ID, LOAN_NUMBER LOAN_NUMBER, LOAN_DESCRIPTION LOAN_DESCRIPTION, INITIAL_LOAN_BALANCE INITIAL_LOAN_BALANCE, LAST_PAYMENT_DATE LAST_PAYMENT_DATE, LAST_PAYMENT_AMOUNT LAST_PAYMENT_AMOUNT, LOAN_TERM LOAN_TERM, LOAN_TERM_PERIOD LOAN_TERM_PERIOD, LOAN_CURRENCY LOAN_CURRENCY, LOAN_CLASS_CODE LOAN_CLASS_CODE, LOAN_TYPE LOAN_TYPE, LOAN_SUBTYPE LOAN_SUBTYPE, LOAN_PURPOSE_CODE LOAN_PURPOSE_CODE, AMORTIZED_TERM AMORTIZED_TERM, AMORTIZED_TERM_PERIOD AMORTIZED_TERM_PERIOD, LOAN_MATURITY_DATE LOAN_MATURITY_DATE, LOAN_START_DATE LOAN_START_DATE, LOAN_APPLICATION_DATE LOAN_APPLICATION_DATE, LOAN_CLOSING_DATE LOAN_CLOSING_DATE, LAST_BILLED_DATE LAST_BILLED_DATE, END_DATE END_DATE, PRODUCT_FLAG PRODUCT_FLAG, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, PRIMARY_BORROWER_ID PRIMARY_BORROWER_ID, PRODUCT_ID PRODUCT_ID, REQUESTED_AMOUNT REQUESTED_AMOUNT, FUNDED_AMOUNT FUNDED_AMOUNT, REFERENCE_AMOUNT REFERENCE_AMOUNT, REFERENCE_NUMBER REFERENCE_NUMBER, REFERENCE_NAME REFERENCE_NAME, REFERENCE_TYPE REFERENCE_TYPE, REFERENCE_DESCRIPTION REFERENCE_DESCRIPTION, LOAN_APPROVAL_DATE LOAN_APPROVAL_DATE, LOAN_APPROVED_BY LOAN_APPROVED_BY, LOAN_STATUS LOAN_STATUS, LOAN_ASSIGNED_TO LOAN_ASSIGNED_TO, REFERENCE_ID REFERENCE_ID, CUSTOM_PAYMENTS_FLAG CUSTOM_PAYMENTS_FLAG, BILLED_FLAG BILLED_FLAG, ORG_ID ORG_ID, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, REQUEST_ID REQUEST_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, PROGRAM_ID PROGRAM_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, GL_DATE GL_DATE, REFERENCE_TYPE_ID REFERENCE_TYPE_ID, BILL_TO_ACCT_SITE_ID BILL_TO_ACCT_SITE_ID, REC_ADJUSTMENT_NUMBER REC_ADJUSTMENT_NUMBER, CONTACT_PERS_PARTY_ID CONTACT_PERS_PARTY_ID, CONTACT_REL_PARTY_ID CONTACT_REL_PARTY_ID, COLLATERAL_PERCENT COLLATERAL_PERCENT, CREDIT_REVIEW_FLAG CREDIT_REVIEW_FLAG, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_RATE EXCHANGE_RATE, LAST_PAYMENT_NUMBER LAST_PAYMENT_NUMBER, LAST_AMORTIZATION_ID LAST_AMORTIZATION_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, OPEN_TO_TERM_FLAG OPEN_TO_TERM_FLAG, MULTIPLE_FUNDING_FLAG MULTIPLE_FUNDING_FLAG, LOAN_TYPE_ID LOAN_TYPE_ID, SECONDARY_STATUS SECONDARY_STATUS, OPEN_TO_TERM_EVENT OPEN_TO_TERM_EVENT, BALLOON_PAYMENT_TYPE BALLOON_PAYMENT_TYPE, BALLOON_PAYMENT_AMOUNT BALLOON_PAYMENT_AMOUNT, OPEN_LOAN_START_DATE OPEN_LOAN_START_DATE, OPEN_LOAN_TERM OPEN_LOAN_TERM, OPEN_LOAN_TERM_PERIOD OPEN_LOAN_TERM_PERIOD, CURRENT_PHASE CURRENT_PHASE, OPEN_MATURITY_DATE OPEN_MATURITY_DATE, FUNDS_RESERVED_FLAG FUNDS_RESERVED_FLAG, FUNDS_CHECK_DATE FUNDS_CHECK_DATE, SUBSIDY_RATE SUBSIDY_RATE, APPLICATION_ID APPLICATION_ID, CREATED_BY_MODULE CREATED_BY_MODULE, PARTY_TYPE PARTY_TYPE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, FORGIVENESS_FLAG FORGIVENESS_FLAG, FORGIVENESS_PERCENT FORGIVENESS_PERCENT, DISABLE_BILLING_FLAG DISABLE_BILLING_FLAG, ADD_REQUESTED_AMOUNT ADD_REQUESTED_AMOUNT, DISABLE_INT_ACCRUAL_FLAG DISABLE_INT_ACCRUAL_FLAG, BILL_ON_APPR_AMOUNT_FLAG BILL_ON_APPR_AMOUNT_FLAG from "LNS"."LNS_LOAN_HEADERS_ALL"

View Text - HTML Formatted

SELECT LOAN_ID LOAN_ID
, LOAN_NUMBER LOAN_NUMBER
, LOAN_DESCRIPTION LOAN_DESCRIPTION
, INITIAL_LOAN_BALANCE INITIAL_LOAN_BALANCE
, LAST_PAYMENT_DATE LAST_PAYMENT_DATE
, LAST_PAYMENT_AMOUNT LAST_PAYMENT_AMOUNT
, LOAN_TERM LOAN_TERM
, LOAN_TERM_PERIOD LOAN_TERM_PERIOD
, LOAN_CURRENCY LOAN_CURRENCY
, LOAN_CLASS_CODE LOAN_CLASS_CODE
, LOAN_TYPE LOAN_TYPE
, LOAN_SUBTYPE LOAN_SUBTYPE
, LOAN_PURPOSE_CODE LOAN_PURPOSE_CODE
, AMORTIZED_TERM AMORTIZED_TERM
, AMORTIZED_TERM_PERIOD AMORTIZED_TERM_PERIOD
, LOAN_MATURITY_DATE LOAN_MATURITY_DATE
, LOAN_START_DATE LOAN_START_DATE
, LOAN_APPLICATION_DATE LOAN_APPLICATION_DATE
, LOAN_CLOSING_DATE LOAN_CLOSING_DATE
, LAST_BILLED_DATE LAST_BILLED_DATE
, END_DATE END_DATE
, PRODUCT_FLAG PRODUCT_FLAG
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, PRIMARY_BORROWER_ID PRIMARY_BORROWER_ID
, PRODUCT_ID PRODUCT_ID
, REQUESTED_AMOUNT REQUESTED_AMOUNT
, FUNDED_AMOUNT FUNDED_AMOUNT
, REFERENCE_AMOUNT REFERENCE_AMOUNT
, REFERENCE_NUMBER REFERENCE_NUMBER
, REFERENCE_NAME REFERENCE_NAME
, REFERENCE_TYPE REFERENCE_TYPE
, REFERENCE_DESCRIPTION REFERENCE_DESCRIPTION
, LOAN_APPROVAL_DATE LOAN_APPROVAL_DATE
, LOAN_APPROVED_BY LOAN_APPROVED_BY
, LOAN_STATUS LOAN_STATUS
, LOAN_ASSIGNED_TO LOAN_ASSIGNED_TO
, REFERENCE_ID REFERENCE_ID
, CUSTOM_PAYMENTS_FLAG CUSTOM_PAYMENTS_FLAG
, BILLED_FLAG BILLED_FLAG
, ORG_ID ORG_ID
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, REQUEST_ID REQUEST_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, PROGRAM_ID PROGRAM_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, GL_DATE GL_DATE
, REFERENCE_TYPE_ID REFERENCE_TYPE_ID
, BILL_TO_ACCT_SITE_ID BILL_TO_ACCT_SITE_ID
, REC_ADJUSTMENT_NUMBER REC_ADJUSTMENT_NUMBER
, CONTACT_PERS_PARTY_ID CONTACT_PERS_PARTY_ID
, CONTACT_REL_PARTY_ID CONTACT_REL_PARTY_ID
, COLLATERAL_PERCENT COLLATERAL_PERCENT
, CREDIT_REVIEW_FLAG CREDIT_REVIEW_FLAG
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, LAST_PAYMENT_NUMBER LAST_PAYMENT_NUMBER
, LAST_AMORTIZATION_ID LAST_AMORTIZATION_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, OPEN_TO_TERM_FLAG OPEN_TO_TERM_FLAG
, MULTIPLE_FUNDING_FLAG MULTIPLE_FUNDING_FLAG
, LOAN_TYPE_ID LOAN_TYPE_ID
, SECONDARY_STATUS SECONDARY_STATUS
, OPEN_TO_TERM_EVENT OPEN_TO_TERM_EVENT
, BALLOON_PAYMENT_TYPE BALLOON_PAYMENT_TYPE
, BALLOON_PAYMENT_AMOUNT BALLOON_PAYMENT_AMOUNT
, OPEN_LOAN_START_DATE OPEN_LOAN_START_DATE
, OPEN_LOAN_TERM OPEN_LOAN_TERM
, OPEN_LOAN_TERM_PERIOD OPEN_LOAN_TERM_PERIOD
, CURRENT_PHASE CURRENT_PHASE
, OPEN_MATURITY_DATE OPEN_MATURITY_DATE
, FUNDS_RESERVED_FLAG FUNDS_RESERVED_FLAG
, FUNDS_CHECK_DATE FUNDS_CHECK_DATE
, SUBSIDY_RATE SUBSIDY_RATE
, APPLICATION_ID APPLICATION_ID
, CREATED_BY_MODULE CREATED_BY_MODULE
, PARTY_TYPE PARTY_TYPE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, FORGIVENESS_FLAG FORGIVENESS_FLAG
, FORGIVENESS_PERCENT FORGIVENESS_PERCENT
, DISABLE_BILLING_FLAG DISABLE_BILLING_FLAG
, ADD_REQUESTED_AMOUNT ADD_REQUESTED_AMOUNT
, DISABLE_INT_ACCRUAL_FLAG DISABLE_INT_ACCRUAL_FLAG
, BILL_ON_APPR_AMOUNT_FLAG BILL_ON_APPR_AMOUNT_FLAG
FROM "LNS"."LNS_LOAN_HEADERS_ALL"