VIEW: LNS.LNS_LOAN_SPLITS#

Source

View Text - Preformatted

select LOAN_SPLIT_ID LOAN_SPLIT_ID, LOAN_ID LOAN_ID, DESCRIPTION DESCRIPTION, STATUS STATUS, APPR_REJECT_DATE APPR_REJECT_DATE, APPR_REJECT_BY APPR_REJECT_BY, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PRODUCT_ID PRODUCT_ID, ORG_ID ORG_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, LOAN_CLASS_CODE LOAN_CLASS_CODE, LOAN_TYPE_ID LOAN_TYPE_ID, LOAN_PURPOSE_CODE LOAN_PURPOSE_CODE, LOAN_DESCRIPTION LOAN_DESCRIPTION, LOAN_APPLICATION_DATE LOAN_APPLICATION_DATE, LOAN_CURRENCY LOAN_CURRENCY, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_RATE EXCHANGE_RATE, LOAN_ASSIGNED_TO LOAN_ASSIGNED_TO, PRIMARY_BORROWER_ID PRIMARY_BORROWER_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, BILL_TO_ACCT_SITE_ID BILL_TO_ACCT_SITE_ID, CONTACT_REL_PARTY_ID CONTACT_REL_PARTY_ID, CONTACT_PERS_PARTY_ID CONTACT_PERS_PARTY_ID, REFERENCE_TYPE_ID REFERENCE_TYPE_ID, REQUESTED_AMOUNT REQUESTED_AMOUNT, LOAN_START_DATE LOAN_START_DATE, LOAN_TERM LOAN_TERM, LOAN_TERM_PERIOD LOAN_TERM_PERIOD, BALLOON_PAYMENT_TYPE BALLOON_PAYMENT_TYPE, BALLOON_PAYMENT_AMOUNT BALLOON_PAYMENT_AMOUNT, BALLOON_TERM BALLOON_TERM, LOAN_SUBTYPE LOAN_SUBTYPE, CREDIT_REVIEW_FLAG CREDIT_REVIEW_FLAG, COLLATERAL_PERCENT COLLATERAL_PERCENT, RATE_TYPE RATE_TYPE, INDEX_RATE_ID INDEX_RATE_ID, PAYMENT_CALC_METHOD PAYMENT_CALC_METHOD, DAY_COUNT_METHOD DAY_COUNT_METHOD, AMORTIZATION_FREQUENCY AMORTIZATION_FREQUENCY, CALCULATION_METHOD CALCULATION_METHOD, INTEREST_COMPOUNDING_FREQ INTEREST_COMPOUNDING_FREQ, PRIN_PAYMENT_FREQUENCY PRIN_PAYMENT_FREQUENCY, TERM_INDEX_DATE TERM_INDEX_DATE, INDEX_RATE INDEX_RATE, SPREAD SPREAD, INT_RATE INT_RATE, CUSTOM_SCHEDULE CUSTOM_SCHEDULE, CUSTOM_CALC_METHOD CUSTOM_CALC_METHOD, PARTY_TYPE PARTY_TYPE, NEW_AM_SCHED_ID NEW_AM_SCHED_ID, NEW_LOAN_ID NEW_LOAN_ID, LOAN_NUMBER LOAN_NUMBER from "LNS"."LNS_LOAN_SPLITS"

View Text - HTML Formatted

SELECT LOAN_SPLIT_ID LOAN_SPLIT_ID
, LOAN_ID LOAN_ID
, DESCRIPTION DESCRIPTION
, STATUS STATUS
, APPR_REJECT_DATE APPR_REJECT_DATE
, APPR_REJECT_BY APPR_REJECT_BY
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PRODUCT_ID PRODUCT_ID
, ORG_ID ORG_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, LOAN_CLASS_CODE LOAN_CLASS_CODE
, LOAN_TYPE_ID LOAN_TYPE_ID
, LOAN_PURPOSE_CODE LOAN_PURPOSE_CODE
, LOAN_DESCRIPTION LOAN_DESCRIPTION
, LOAN_APPLICATION_DATE LOAN_APPLICATION_DATE
, LOAN_CURRENCY LOAN_CURRENCY
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, LOAN_ASSIGNED_TO LOAN_ASSIGNED_TO
, PRIMARY_BORROWER_ID PRIMARY_BORROWER_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, BILL_TO_ACCT_SITE_ID BILL_TO_ACCT_SITE_ID
, CONTACT_REL_PARTY_ID CONTACT_REL_PARTY_ID
, CONTACT_PERS_PARTY_ID CONTACT_PERS_PARTY_ID
, REFERENCE_TYPE_ID REFERENCE_TYPE_ID
, REQUESTED_AMOUNT REQUESTED_AMOUNT
, LOAN_START_DATE LOAN_START_DATE
, LOAN_TERM LOAN_TERM
, LOAN_TERM_PERIOD LOAN_TERM_PERIOD
, BALLOON_PAYMENT_TYPE BALLOON_PAYMENT_TYPE
, BALLOON_PAYMENT_AMOUNT BALLOON_PAYMENT_AMOUNT
, BALLOON_TERM BALLOON_TERM
, LOAN_SUBTYPE LOAN_SUBTYPE
, CREDIT_REVIEW_FLAG CREDIT_REVIEW_FLAG
, COLLATERAL_PERCENT COLLATERAL_PERCENT
, RATE_TYPE RATE_TYPE
, INDEX_RATE_ID INDEX_RATE_ID
, PAYMENT_CALC_METHOD PAYMENT_CALC_METHOD
, DAY_COUNT_METHOD DAY_COUNT_METHOD
, AMORTIZATION_FREQUENCY AMORTIZATION_FREQUENCY
, CALCULATION_METHOD CALCULATION_METHOD
, INTEREST_COMPOUNDING_FREQ INTEREST_COMPOUNDING_FREQ
, PRIN_PAYMENT_FREQUENCY PRIN_PAYMENT_FREQUENCY
, TERM_INDEX_DATE TERM_INDEX_DATE
, INDEX_RATE INDEX_RATE
, SPREAD SPREAD
, INT_RATE INT_RATE
, CUSTOM_SCHEDULE CUSTOM_SCHEDULE
, CUSTOM_CALC_METHOD CUSTOM_CALC_METHOD
, PARTY_TYPE PARTY_TYPE
, NEW_AM_SCHED_ID NEW_AM_SCHED_ID
, NEW_LOAN_ID NEW_LOAN_ID
, LOAN_NUMBER LOAN_NUMBER
FROM "LNS"."LNS_LOAN_SPLITS"