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

VIEW: APPS.FII_AR_REV_CUST_WH_V

Object Details
Object Name: FII_AR_REV_CUST_WH_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFII.FII_AR_REV_CUST_WH_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
SOB_ID NUMBER
Yes Foreign key to the Set of Books dimension
ORG_ID NUMBER
Yes Organization identifier
CUSTOMER_ID NUMBER
Yes Foreign key to the Trading Partner dimension
FUNCTIONAL_CURRENCY VARCHAR2 (20)
Functional currency of the given set of books
CYCQ_QTD_REV NUMBER

Total amount of cash received. Amount is in warehouse currency
CYCQ_QTD_INV_COUNT NUMBER

Query Text

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


SELECT SOB_ID
,      ORG_ID
,      CUSTOMER_ID
,      FUNCTIONAL_CURRENCY
,      CYCQ_QTD_REV
,      CYCQ_QTD_INV_COUNT
FROM APPS.FII_AR_REV_CUST_WH_V;

Dependencies

[top of page]

APPS.FII_AR_REV_CUST_WH_V references the following:

SchemaAPPS
SynonymFII_AR_OPER_CUST_SUMMARY_F
PL/SQL PackageFII_TIME_WH_API - show dependent code
SchemaPUBLIC
SynonymDUAL

APPS.FII_AR_REV_CUST_WH_V is not referenced by any database object