VIEW: FV.FV_INVOICE_FINANCE_CHRGS_ALL#

Source

View Text - Preformatted

select CUSTOMER_TRX_ID CUSTOMER_TRX_ID, CUSTOMER_ID CUSTOMER_ID, CHARGE_ID CHARGE_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WAIVE_FLAG WAIVE_FLAG, ORG_ID ORG_ID, FINANCE_CHARGE_GROUP_HDR_ID FINANCE_CHARGE_GROUP_HDR_ID, FINANCE_CHARGE_GROUP_DTL_ID FINANCE_CHARGE_GROUP_DTL_ID, ENABLED_FLAG ENABLED_FLAG, BASE_CHARGE_ID BASE_CHARGE_ID, REQUEST_ID REQUEST_ID, INVOICE_AMOUNT INVOICE_AMOUNT, FINANCE_CHARGES FINANCE_CHARGES, FINANCE_CHARGES_COLLECTED FINANCE_CHARGES_COLLECTED, FINANCE_CHARGE_INVOICE_ID FINANCE_CHARGE_INVOICE_ID, PARENT_INVOICE_ID PARENT_INVOICE_ID, ROOT_INVOICE_ID ROOT_INVOICE_ID from "FV"."FV_INVOICE_FINANCE_CHRGS_ALL"

View Text - HTML Formatted

SELECT CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, CUSTOMER_ID CUSTOMER_ID
, CHARGE_ID CHARGE_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, WAIVE_FLAG WAIVE_FLAG
, ORG_ID ORG_ID
, FINANCE_CHARGE_GROUP_HDR_ID FINANCE_CHARGE_GROUP_HDR_ID
, FINANCE_CHARGE_GROUP_DTL_ID FINANCE_CHARGE_GROUP_DTL_ID
, ENABLED_FLAG ENABLED_FLAG
, BASE_CHARGE_ID BASE_CHARGE_ID
, REQUEST_ID REQUEST_ID
, INVOICE_AMOUNT INVOICE_AMOUNT
, FINANCE_CHARGES FINANCE_CHARGES
, FINANCE_CHARGES_COLLECTED FINANCE_CHARGES_COLLECTED
, FINANCE_CHARGE_INVOICE_ID FINANCE_CHARGE_INVOICE_ID
, PARENT_INVOICE_ID PARENT_INVOICE_ID
, ROOT_INVOICE_ID ROOT_INVOICE_ID
FROM "FV"."FV_INVOICE_FINANCE_CHRGS_ALL"