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: MRP.MRP_SELECTION_CRITERIA

Object Details

Object Name:	MRP_SELECTION_CRITERIA
Object Type:	TABLE
Owner:	MRP
FND Design Data:	MRP.MRP_SELECTION_CRITERIA
Subobject Name:
Status:	VALID

MRP_SELECTION_CRITERIA stores the folder criteria entered by
the user in the Planner Workbench Find Windows. This table is
used by the Planner Workbench to filter the data seen in the Items,
Supply, Demand, and Supply/Demand window.
FOLDER_ID identifies the folder that is tied to the criteria.
FIELD_NAME and FIELD_TYPE identify the field against which the
criteria is specified by the user. FROM_FIELD and TO_FIELD store the
criteria values and CONDITION stores the operator. FOLDER_OBJECT
identifies the window against which the criteria is defined.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_SELECTION_CRITERIA_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FOLDER_ID FOLDER_OBJECT FIELD_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
SEQUENCE	NUMBER		Yes	Criteria sequence
FOLDER_ID	NUMBER		Yes	Folder identifier
FIELD_NAME	VARCHAR2	(30)	Yes	Field name
FIELD_TYPE	VARCHAR2	(10)	Yes	Field type
HIDDEN_FROM_FIELD	VARCHAR2	(250)		From field value
CONDITION	NUMBER			Condition
FROM_FIELD	VARCHAR2	(250)		From field value
TO_FIELD	VARCHAR2	(250)		To field value
FOLDER_OBJECT	VARCHAR2	(30)	Yes	Folder object identifier
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
AND_OR	NUMBER			Not currently used
COUNT_BY	NUMBER			Store checkbox 'display message count' for find exceptions block

Query Text

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


SELECT SEQUENCE
,      FOLDER_ID
,      FIELD_NAME
,      FIELD_TYPE
,      HIDDEN_FROM_FIELD
,      CONDITION
,      FROM_FIELD
,      TO_FIELD
,      FOLDER_OBJECT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      AND_OR
,      COUNT_BY
FROM MRP.MRP_SELECTION_CRITERIA;

Dependencies

[top of page]

MRP.MRP_SELECTION_CRITERIA does not reference any database object

MRP.MRP_SELECTION_CRITERIA is referenced by following:

APPS: MRP_SELECTION_CRITERIA