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

VIEW: APPS.FV_AR_FIN_CHRG_INV_LINES_V

Object Details
Object Name: FV_AR_FIN_CHRG_INV_LINES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View based on fv_ar_fin_chrg_invoices, fv_ar_fin_chrg_inv_lines, fv_finance_charge_controls, ar_payment_schedules_all, ra_customer_trx_lines


[View Source]

Columns
Name Datatype Length Mandatory Comments
INVOICE_ID NUMBER (15)
Invoice Id
INVOICE_NUMBER VARCHAR2 (20)
Invoice Number
GL_DATE DATE

Gl Date
LINE_NUMBER NUMBER (15)
Line Number
CHARGE_ID NUMBER (15)
Charge Id
LINE_AMOUNT NUMBER

Line Amount
ROOT_INVOICE_ID NUMBER (15)
Root Invoice Id
CREATED_BY NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
ORG_ID NUMBER (15)
Organization Identifier
CHARGE_TYPE VARCHAR2 (20) Yes Finance Charge Type
FINANCE_CHARGES NUMBER

Finance Charges
COLLECTION_AMOUNT NUMBER

Collection Amount
Query Text

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


SELECT INVOICE_ID
,      INVOICE_NUMBER
,      GL_DATE
,      LINE_NUMBER
,      CHARGE_ID
,      LINE_AMOUNT
,      ROOT_INVOICE_ID
,      CREATED_BY
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      CHARGE_TYPE
,      FINANCE_CHARGES
,      COLLECTION_AMOUNT
FROM APPS.FV_AR_FIN_CHRG_INV_LINES_V;

Dependencies

[top of page]

APPS.FV_AR_FIN_CHRG_INV_LINES_V references the following:

SchemaAPPS
SynonymAR_PAYMENT_SCHEDULES_ALL
SynonymFV_AR_FIN_CHRG_INVOICES
SynonymFV_AR_FIN_CHRG_INV_LINES
SynonymFV_FINANCE_CHARGE_CONTROLS
SynonymRA_CUSTOMER_TRX_LINES

APPS.FV_AR_FIN_CHRG_INV_LINES_V is not referenced by any database object