VIEW: FV.FV_AR_FIN_CHRG_INVOICES_ALL#

Source

View Text - Preformatted

select ORG_ID ORG_ID, CUSTOMER_ID CUSTOMER_ID, INVOICE_ID INVOICE_ID, INVOICE_NUMBER INVOICE_NUMBER, INVOICE_DATE INVOICE_DATE, INVOICE_AMOUNT INVOICE_AMOUNT, FINANCE_CHARGES FINANCE_CHARGES, WAIVE_FLAG WAIVE_FLAG, ENABLED_FLAG ENABLED_FLAG, PARENT_INVOICE_ID PARENT_INVOICE_ID, ROOT_INVOICE_ID ROOT_INVOICE_ID, CURRENT_CHILD_INVOICE_ID CURRENT_CHILD_INVOICE_ID, LAST_LINE_NUMBER LAST_LINE_NUMBER, FINANCE_CHARGE_GROUP_HDR_ID FINANCE_CHARGE_GROUP_HDR_ID, FINANCE_CHARGE_GROUP_DTL_ID FINANCE_CHARGE_GROUP_DTL_ID, CHARGE_ID CHARGE_ID, LAST_ACCRUAL_DATE LAST_ACCRUAL_DATE, 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, REQUEST_ID REQUEST_ID from "FV"."FV_AR_FIN_CHRG_INVOICES_ALL"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, CUSTOMER_ID CUSTOMER_ID
, INVOICE_ID INVOICE_ID
, INVOICE_NUMBER INVOICE_NUMBER
, INVOICE_DATE INVOICE_DATE
, INVOICE_AMOUNT INVOICE_AMOUNT
, FINANCE_CHARGES FINANCE_CHARGES
, WAIVE_FLAG WAIVE_FLAG
, ENABLED_FLAG ENABLED_FLAG
, PARENT_INVOICE_ID PARENT_INVOICE_ID
, ROOT_INVOICE_ID ROOT_INVOICE_ID
, CURRENT_CHILD_INVOICE_ID CURRENT_CHILD_INVOICE_ID
, LAST_LINE_NUMBER LAST_LINE_NUMBER
, FINANCE_CHARGE_GROUP_HDR_ID FINANCE_CHARGE_GROUP_HDR_ID
, FINANCE_CHARGE_GROUP_DTL_ID FINANCE_CHARGE_GROUP_DTL_ID
, CHARGE_ID CHARGE_ID
, LAST_ACCRUAL_DATE LAST_ACCRUAL_DATE
, 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
, REQUEST_ID REQUEST_ID
FROM "FV"."FV_AR_FIN_CHRG_INVOICES_ALL"