VIEW: LNS.LNS_FEE_ASSIGNMENTS#

Source

View Text - Preformatted

select FEE_ASSIGNMENT_ID FEE_ASSIGNMENT_ID, LOAN_ID LOAN_ID, FEE_ID FEE_ID, FEE_TYPE FEE_TYPE, FEE FEE, FEE_BASIS FEE_BASIS, NUMBER_GRACE_DAYS NUMBER_GRACE_DAYS, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, COLLECTED_THIRD_PARTY_FLAG COLLECTED_THIRD_PARTY_FLAG, BILLING_OPTION BILLING_OPTION, RATE_TYPE RATE_TYPE, BEGIN_INSTALLMENT_NUMBER BEGIN_INSTALLMENT_NUMBER, END_INSTALLMENT_NUMBER END_INSTALLMENT_NUMBER, NUMBER_OF_PAYMENTS NUMBER_OF_PAYMENTS, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, DISB_HEADER_ID DISB_HEADER_ID, OPEN_PHASE_FLAG OPEN_PHASE_FLAG, DELETE_DISABLED_FLAG DELETE_DISABLED_FLAG, PHASE PHASE, CUSTOM_PROCEDURE CUSTOM_PROCEDURE from "LNS"."LNS_FEE_ASSIGNMENTS"

View Text - HTML Formatted

SELECT FEE_ASSIGNMENT_ID FEE_ASSIGNMENT_ID
, LOAN_ID LOAN_ID
, FEE_ID FEE_ID
, FEE_TYPE FEE_TYPE
, FEE FEE
, FEE_BASIS FEE_BASIS
, NUMBER_GRACE_DAYS NUMBER_GRACE_DAYS
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, COLLECTED_THIRD_PARTY_FLAG COLLECTED_THIRD_PARTY_FLAG
, BILLING_OPTION BILLING_OPTION
, RATE_TYPE RATE_TYPE
, BEGIN_INSTALLMENT_NUMBER BEGIN_INSTALLMENT_NUMBER
, END_INSTALLMENT_NUMBER END_INSTALLMENT_NUMBER
, NUMBER_OF_PAYMENTS NUMBER_OF_PAYMENTS
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, DISB_HEADER_ID DISB_HEADER_ID
, OPEN_PHASE_FLAG OPEN_PHASE_FLAG
, DELETE_DISABLED_FLAG DELETE_DISABLED_FLAG
, PHASE PHASE
, CUSTOM_PROCEDURE CUSTOM_PROCEDURE
FROM "LNS"."LNS_FEE_ASSIGNMENTS"