[Home] [Help] [Dependency Information]
Object Name: | FII_AR_OLTP_OPEN_INV_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FII.FII_AR_OLTP_OPEN_INV_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSTANCE_CODE | VARCHAR2 | (30) | ||
ORG_ID | NUMBER | (15) | Organization identifier | |
SOB_ID | NUMBER | (15) | ||
CUSTOMER_SITE_ID | NUMBER | (15) | ||
RECEIVABLE_G | NUMBER | |||
RECEIVABLE_B | NUMBER | |||
RECEIVABLE_T | NUMBER | |||
UNAPP_RECEIPT_G | NUMBER | |||
UNAPP_RECEIPT_B | NUMBER | |||
UNAPP_RECEIPT_T | NUMBER | |||
FUNCTIONAL_CURRENCY | VARCHAR2 | (15) | ||
INVOICE_CURRENCY | VARCHAR2 | (15) | ||
INVOICE_NUMBER | VARCHAR2 | (30) | ||
INSTALLMENT_NUMBER | NUMBER | |||
INVOICE_DATE | DATE | |||
DUE_DATE | DATE | |||
TYPE | CHAR | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT INSTANCE_CODE
, ORG_ID
, SOB_ID
, CUSTOMER_SITE_ID
, RECEIVABLE_G
, RECEIVABLE_B
, RECEIVABLE_T
, UNAPP_RECEIPT_G
, UNAPP_RECEIPT_B
, UNAPP_RECEIPT_T
, FUNCTIONAL_CURRENCY
, INVOICE_CURRENCY
, INVOICE_NUMBER
, INSTALLMENT_NUMBER
, INVOICE_DATE
, DUE_DATE
, TYPE
FROM APPS.FII_AR_OLTP_OPEN_INV_V;
APPS.FII_AR_OLTP_OPEN_INV_V is not referenced by any database object
|
|
|