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

TABLE: MSC.MSC_COMPANY_USERS

Object Details
Object Name: MSC_COMPANY_USERS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_COMPANY_USERS
Subobject Name:
Status: VALID


This table contains the user company association for Oracle Collaborative planning functionality.
The user_id corresponds to the user identifier in the FND_USER table. The company_id
corresponds to the company identifier in MSC_COMPANIES table.
This table can be populated by the Collections program from Oracle ERP systems or
from flat file loads for data downloaded from legacy systems.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_COMPANY_USERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSER_ID
ColumnCOMPANY_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER
Yes User identifier
COMPANY_ID NUMBER
Yes Company identifier
SR_INSTANCE_ID NUMBER
Yes Source application instance identifier
Query Text

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


SELECT USER_ID
,      COMPANY_ID
,      SR_INSTANCE_ID
FROM MSC.MSC_COMPANY_USERS;

Dependencies

[top of page]

MSC.MSC_COMPANY_USERS does not reference any database object

MSC.MSC_COMPANY_USERS is referenced by following:

SchemaAPPS
SynonymMSC_COMPANY_USERS