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

TABLE: MRP.MRP_AMONG_VALUES

Object Details
Object Name: MRP_AMONG_VALUES
Object Type: TABLE
Owner: MRP
FND Design Data: TableMRP.MRP_AMONG_VALUES
Subobject Name:
Status: VALID


MRP_AMONG_VALUES stores the values entered by
the user in the Planner Workbench Find Windows when choosing
'among' condition. This table is used with MRP_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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_AMONG_VALUES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFOLDER_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
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
FROM MRP.MRP_AMONG_VALUES;

Dependencies

[top of page]

MRP.MRP_AMONG_VALUES does not reference any database object

MRP.MRP_AMONG_VALUES is referenced by following:

SchemaMRP
ViewMRP_AMONG_VALUES#