VIEW: LNS.LNS_LOAN_LINES#

Source

View Text - Preformatted

select LOAN_LINE_ID LOAN_LINE_ID, LOAN_ID LOAN_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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, REFERENCE_TYPE REFERENCE_TYPE, REFERENCE_ID REFERENCE_ID, REFERENCE_NUMBER REFERENCE_NUMBER, REFERENCE_DESCRIPTION REFERENCE_DESCRIPTION, REFERENCE_AMOUNT REFERENCE_AMOUNT, REQUESTED_AMOUNT REQUESTED_AMOUNT, REC_ADJUSTMENT_NUMBER REC_ADJUSTMENT_NUMBER, REC_ADJUSTMENT_ID REC_ADJUSTMENT_ID, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, INSTALLMENT_NUMBER INSTALLMENT_NUMBER, END_DATE END_DATE, STATUS STATUS, APPR_REJECT_DATE APPR_REJECT_DATE, APPR_REJECT_BY APPR_REJECT_BY, ADJUSTMENT_DATE ADJUSTMENT_DATE, ORIGINAL_FLAG ORIGINAL_FLAG from "LNS"."LNS_LOAN_LINES"

View Text - HTML Formatted

SELECT LOAN_LINE_ID LOAN_LINE_ID
, LOAN_ID LOAN_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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REFERENCE_TYPE REFERENCE_TYPE
, REFERENCE_ID REFERENCE_ID
, REFERENCE_NUMBER REFERENCE_NUMBER
, REFERENCE_DESCRIPTION REFERENCE_DESCRIPTION
, REFERENCE_AMOUNT REFERENCE_AMOUNT
, REQUESTED_AMOUNT REQUESTED_AMOUNT
, REC_ADJUSTMENT_NUMBER REC_ADJUSTMENT_NUMBER
, REC_ADJUSTMENT_ID REC_ADJUSTMENT_ID
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, INSTALLMENT_NUMBER INSTALLMENT_NUMBER
, END_DATE END_DATE
, STATUS STATUS
, APPR_REJECT_DATE APPR_REJECT_DATE
, APPR_REJECT_BY APPR_REJECT_BY
, ADJUSTMENT_DATE ADJUSTMENT_DATE
, ORIGINAL_FLAG ORIGINAL_FLAG
FROM "LNS"."LNS_LOAN_LINES"