VIEW: LNS.LNS_FEES_ALL#

Source

View Text - Preformatted

select FEE_ID FEE_ID, FEE_NAME FEE_NAME, FEE_DESCRIPTION FEE_DESCRIPTION, FEE_CATEGORY FEE_CATEGORY, FEE_TYPE FEE_TYPE, FEE FEE, FEE_BASIS FEE_BASIS, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, 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, RATE_TYPE RATE_TYPE, BILLING_OPTION BILLING_OPTION, COLLECTED_THIRD_PARTY_FLAG COLLECTED_THIRD_PARTY_FLAG, CURRENCY_CODE CURRENCY_CODE, MINIMUM_OVERDUE_AMOUNT MINIMUM_OVERDUE_AMOUNT, FEE_BASIS_RULE FEE_BASIS_RULE, FEE_WAIVABLE_FLAG FEE_WAIVABLE_FLAG, FEE_EDITABLE_FLAG FEE_EDITABLE_FLAG, ORG_ID ORG_ID, CUSTOM_PROCEDURE CUSTOM_PROCEDURE from "LNS"."LNS_FEES_ALL"

View Text - HTML Formatted

SELECT FEE_ID FEE_ID
, FEE_NAME FEE_NAME
, FEE_DESCRIPTION FEE_DESCRIPTION
, FEE_CATEGORY FEE_CATEGORY
, FEE_TYPE FEE_TYPE
, FEE FEE
, FEE_BASIS FEE_BASIS
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, 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
, RATE_TYPE RATE_TYPE
, BILLING_OPTION BILLING_OPTION
, COLLECTED_THIRD_PARTY_FLAG COLLECTED_THIRD_PARTY_FLAG
, CURRENCY_CODE CURRENCY_CODE
, MINIMUM_OVERDUE_AMOUNT MINIMUM_OVERDUE_AMOUNT
, FEE_BASIS_RULE FEE_BASIS_RULE
, FEE_WAIVABLE_FLAG FEE_WAIVABLE_FLAG
, FEE_EDITABLE_FLAG FEE_EDITABLE_FLAG
, ORG_ID ORG_ID
, CUSTOM_PROCEDURE CUSTOM_PROCEDURE
FROM "LNS"."LNS_FEES_ALL"