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


TABLE: FII.FII_AR_REV_ACCTS

Object Details
Object Name: FII_AR_REV_ACCTS
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_AR_REV_ACCTS
Subobject Name:
Status: VALID


Table to store Accounts assigned to Revenue


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_AR_REV_ACCTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnREV_ACCT_ID
ColumnFIN_CAT_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
REV_ACCT_ID NUMBER (15)
Revenue Account Identifier
FIN_CAT_TYPE_CODE VARCHAR2 (30)
Financial Category Type Code
REV_ACCT VARCHAR2 (240)
Revenue Account
Query Text

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


SELECT REV_ACCT_ID
,      FIN_CAT_TYPE_CODE
,      REV_ACCT
FROM FII.FII_AR_REV_ACCTS;

Dependencies

[top of page]

FII.FII_AR_REV_ACCTS does not reference any database object

FII.FII_AR_REV_ACCTS is referenced by following:

SchemaAPPS
SynonymFII_AR_REV_ACCTS