[Home] [Help] [Dependency Information]
Object Name: | FV_AR_FIN_CHRG_INV_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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
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 |
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;
APPS.FV_AR_FIN_CHRG_INV_LINES_V is not referenced by any database object
|
|
|