[Home] [Help] [Dependency Information]

TABLE: MSC.MSC_COMPANIES

Object Details

Object Name:	MSC_COMPANIES
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_COMPANIES
Subobject Name:
Status:	VALID

MSC_COMPANIES contains the list of individual companies which are involved
in inter enterprise collaboration and planning.
This table is populated by Collection programs from Oracle ERP systems or from
XML/Excel Loads of trading partner data downloaded from other systems.
Each company is uniquely identified by the Company name column and has a system generated
identifier. Company identifier 1 is reserved for the company defined in the profile MSC_OPERATOR_COMPANY_NAME.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_COMPANIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMPANY_ID
MSC_COMPANIES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMPANY_NAME
MSC_COMPANIES_N3	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("COMPANY_NAME")

Columns

Query Text

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

SELECT COMPANY_ID
,      COMPANY_NAME
,      DISABLE_DATE
,      REFRESH_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM MSC.MSC_COMPANIES;

Dependencies

[top of page]

MSC.MSC_COMPANIES does not reference any database object

MSC.MSC_COMPANIES is referenced by following:

MSC

MSC_COMPANIES#