VIEW: LNS.LNS_LOAN_CANCEL_DETAILS#

Source

View Text - Preformatted

select LOAN_CANCEL_DETAIL_ID LOAN_CANCEL_DETAIL_ID, LOAN_CANCELLATION_ID LOAN_CANCELLATION_ID, LOAN_ID LOAN_ID, PURPOSE_CODE PURPOSE_CODE, PURPOSE_DESC PURPOSE_DESC, AMOUNT_DUE AMOUNT_DUE, PERCENT_TO_PROCESS PERCENT_TO_PROCESS, AMOUNT_TO_PROCESS AMOUNT_TO_PROCESS, DUE_DATE DUE_DATE, BILLED_FLAG BILLED_FLAG, ACTION ACTION, LOAN_LINE_ID LOAN_LINE_ID, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, CUST_TRX_ID CUST_TRX_ID, ADJUSTMENT_NUMBER ADJUSTMENT_NUMBER, ADJUSTMENT_ID ADJUSTMENT_ID, 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, INVOICE_NUMBER INVOICE_NUMBER, INSTALLMENT_NUMBER INSTALLMENT_NUMBER, TRANSACTION_TYPE TRANSACTION_TYPE, GL_DATE GL_DATE, TRX_DATE TRX_DATE from "LNS"."LNS_LOAN_CANCEL_DETAILS"

View Text - HTML Formatted

SELECT LOAN_CANCEL_DETAIL_ID LOAN_CANCEL_DETAIL_ID
, LOAN_CANCELLATION_ID LOAN_CANCELLATION_ID
, LOAN_ID LOAN_ID
, PURPOSE_CODE PURPOSE_CODE
, PURPOSE_DESC PURPOSE_DESC
, AMOUNT_DUE AMOUNT_DUE
, PERCENT_TO_PROCESS PERCENT_TO_PROCESS
, AMOUNT_TO_PROCESS AMOUNT_TO_PROCESS
, DUE_DATE DUE_DATE
, BILLED_FLAG BILLED_FLAG
, ACTION ACTION
, LOAN_LINE_ID LOAN_LINE_ID
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, CUST_TRX_ID CUST_TRX_ID
, ADJUSTMENT_NUMBER ADJUSTMENT_NUMBER
, ADJUSTMENT_ID ADJUSTMENT_ID
, 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
, INVOICE_NUMBER INVOICE_NUMBER
, INSTALLMENT_NUMBER INSTALLMENT_NUMBER
, TRANSACTION_TYPE TRANSACTION_TYPE
, GL_DATE GL_DATE
, TRX_DATE TRX_DATE
FROM "LNS"."LNS_LOAN_CANCEL_DETAILS"