DBA Data[Home] [Help] [Dependency Information]

VIEW: FV.FV_AR_FIN_CHRG_INVOICES_ALL#

Object Details
Object Name: FV_AR_FIN_CHRG_INVOICES_ALL#
Object Type: VIEW
Owner: FV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15)
CUSTOMER_ID NUMBER (15)
INVOICE_ID NUMBER (15)
INVOICE_NUMBER VARCHAR2 (20)
INVOICE_DATE DATE

INVOICE_AMOUNT NUMBER

FINANCE_CHARGES NUMBER

WAIVE_FLAG VARCHAR2 (1)
ENABLED_FLAG VARCHAR2 (1)
PARENT_INVOICE_ID NUMBER (15)
ROOT_INVOICE_ID NUMBER (15)
CURRENT_CHILD_INVOICE_ID NUMBER (15)
LAST_LINE_NUMBER NUMBER (15)
FINANCE_CHARGE_GROUP_HDR_ID NUMBER (15)
FINANCE_CHARGE_GROUP_DTL_ID NUMBER (15)
CHARGE_ID NUMBER (15)
LAST_ACCRUAL_DATE DATE

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORG_ID
,      CUSTOMER_ID
,      INVOICE_ID
,      INVOICE_NUMBER
,      INVOICE_DATE
,      INVOICE_AMOUNT
,      FINANCE_CHARGES
,      WAIVE_FLAG
,      ENABLED_FLAG
,      PARENT_INVOICE_ID
,      ROOT_INVOICE_ID
,      CURRENT_CHILD_INVOICE_ID
,      LAST_LINE_NUMBER
,      FINANCE_CHARGE_GROUP_HDR_ID
,      FINANCE_CHARGE_GROUP_DTL_ID
,      CHARGE_ID
,      LAST_ACCRUAL_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
FROM FV.FV_AR_FIN_CHRG_INVOICES_ALL#;

Dependencies

[top of page]

FV.FV_AR_FIN_CHRG_INVOICES_ALL# references the following:

SchemaFV
TableFV_AR_FIN_CHRG_INVOICES_ALL
FV.FV_AR_FIN_CHRG_INVOICES_ALL# is referenced by following:

SchemaAPPS
SynonymFV_AR_FIN_CHRG_INVOICES
SynonymFV_AR_FIN_CHRG_INVOICES_ALL