eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MSC.MSC_AMONG_VALUES

Object Details

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

MSC_AMONG_VALUES stores the values entered by
the user in the Planner Workbench Find Windows when choosing
'among' condition. This table is used with MSC_SELECTION_CRITERIA by
the Planner Workbench to filter the data seen in the Items,
Supply, Demand, Supply/Demand and Exception Summary window.
FOLDER_ID identifies the folder that is tied to the criteria.
FIELD_NAME and SEQUENCE identify the field against which the
criteria is specified by the user. OR_VALUES and HIDDEN_VALUES store
the criteria values.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_AMONG_VALUES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FOLDER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FOLDER_ID	NUMBER		Yes	Folder identifier
SEQUENCE	NUMBER		Yes	Criteria sequence
FIELD_NAME	VARCHAR2	(30)	Yes	Field name
OR_VALUES	VARCHAR2	(250)		selected values from 'IN' function
HIDDEN_VALUES	VARCHAR2	(250)		selected values from 'IN' function
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
OBJECT_SEQUENCE	NUMBER			Criteria Object sequence
ORDER_BY_SEQUENCE	NUMBER			Order By Sequence

Query Text

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


SELECT FOLDER_ID
,      SEQUENCE
,      FIELD_NAME
,      OR_VALUES
,      HIDDEN_VALUES
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_SEQUENCE
,      ORDER_BY_SEQUENCE
FROM MSC.MSC_AMONG_VALUES;

Dependencies

[top of page]

MSC.MSC_AMONG_VALUES does not reference any database object

MSC.MSC_AMONG_VALUES is referenced by following:

MSC: MSC_AMONG_VALUES#