[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MRP_WORKBENCH_CRITERIA |
|---|---|
| Object Type: | TABLE |
| Owner: | MRP |
| FND Design Data: |  MRP.MRP_WORKBENCH_CRITERIA
|
| Subobject Name: | |
| Status: | VALID |
MRP_PLANNER_WORKBENCH_CRITERIA stores criteria selected by a user in
the Planner Workbench form. The table includes a seeded row for each
available criterion, with a QUERY_ID of 0. The criteria will be used
by the user exit MRP_LOAD_WORKBENCH_QUERY to dynamically build the
where clause to select rows from MRP_RECOMMENDATIONS and populate the
temporary table MRP_WORKBENCH_QUERY.
.
CRITERION_TYPE indicates if the criterion is an attribute of an item
or an order. For example, the Standard Cost criterion is an attribute
of an item, but the Order Number criterion is an attribute of an
order.
.
CRITERIA_SET is a user-defined lookup. It is a foreign key to
FND_COMMON_LOOKUPS, with a lookup_type of MRP_CRITERIA_SETS.
.
PRIORITY stores the selectivity of the criterion. It can be used to
build a where clause which will use the most selective index or the
most selective criterion first.
.
QUERY_ID is a unique id assigned to each new query that a user builds
in the form. This allows users to see only the criteria that they
selected.
.
LOOKUP_TYPE, LISTVAL_SQL and FLEXCODE are mutually exclusive columns
which determine what the LOV for the low and high values will
be. If the LOV is based on a lookup, then LOOKUP_TYPE will
store the name of the lookup. If it is based on a foreign key
reference, then LISTVAL_SQL will store the appropriate SQL to be used
in the SQL= token of the FND_FKEY trigger. If the LOV is based
on a flexfield, then FLEXCODE will store the flexfield code defined
for the flexfield.
.
VALUE_TYPE stores the type of the low and high values of a criterion.
This column is used by the user exit to validate the values to the
appropriate type when building the where clause for the criterion.
.
PLANNED_ORDER_CRITERIA, REPETITIVE_SCHEDULE_CRITERIA and
SCHEDULED_RECEIPTS_CRITERIA are flags that determine whether a
criterion is relevant for planned orders, repetitive schedules and
scheduled receipts, respectively.
.
LOW_ID and HIGH_ID are pairs used to build the predicate clause.
There are some cases in which the user will select values in the
VALUE_LOW and VALUE_HIGH columns, but the values aren't stored in the
table; we store the id's of those values instead. In these cases, the
user exit will use the IDs corresponding to VALUE_LOW and VALUE_HIGH
stored in LOW_ID and HIGH_ID, to build the predicate clause.
.
OPERATOR_TYPE stores the operator type the user chooses for a
criterion.
.
WHERE_CLAUSE stores an additional predicate clause to be used in
conjunction with the TABLE_NAME and COLUMN_NAME columns, if they are
populated.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MRP_WORKBENCH_CRITERIA_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CRITERION_ID
QUERY_ID
|
| MRP_WORKBENCH_CRITERIA_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
QUERY_ID
|
| MRP_WORKBENCH_CRITERIA_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CRITERIA_SET
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| QUERY_ID | NUMBER | Yes | Query identifier | |
| CRITERION_ID | NUMBER | Yes | Criterion identifier | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| CRITERIA_SET | VARCHAR2 | (50) | Name of Criteria Set | |
| PRIORITY | NUMBER | Yes | Predicate clause priority | |
| CRITERION | VARCHAR2 | (50) | Yes | Criterion name |
| CRITERION_TYPE | NUMBER | Yes | Criterion type code (item or order) | |
| VALUE_TYPE | NUMBER | Yes | Datatype for Low and High Values | |
| LOOKUP_TYPE | VARCHAR2 | (50) | Lookup Type | |
| LISTVAL_SQL | VARCHAR2 | (240) | SQL for QP | |
| FLEXCODE | VARCHAR2 | (4) | Flexfield code | |
| MINIMUM_VALUE | VARCHAR2 | (50) | Minimum value for criterion | |
| MAXIMUM_VALUE | VARCHAR2 | (50) | Maximum value for criterion | |
| PLANNED_ORDER_CRITERIA | NUMBER | Criterion for planned orders flag | ||
| REPETITIVE_SCHEDULE_CRITERIA | NUMBER | Criterion for repetitive schedules flag | ||
| SCHEDULED_RECEIPTS_CRITERIA | NUMBER | Criterion for scheduled receipts flag | ||
| LOW_ID | NUMBER | Flexfield identifier for the low value | ||
| VALUE_LOW | VARCHAR2 | (80) | Low value | |
| HIGH_ID | NUMBER | Flexfield identifier for the high value | ||
| VALUE_HIGH | VARCHAR2 | (80) | High value | |
| OPERATOR_TYPE | NUMBER | Operator code | ||
| TABLE_NAME | VARCHAR2 | (50) | Table name of foreign key reference | |
| COLUMN_NAME | VARCHAR2 | (50) | Foreign key reference column name | |
| WHERE_CLAUSE | VARCHAR2 | (240) | Additional where clause |
Cut, paste (and edit) the following text to query this object:
SELECT QUERY_ID
, CRITERION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CRITERIA_SET
, PRIORITY
, CRITERION
, CRITERION_TYPE
, VALUE_TYPE
, LOOKUP_TYPE
, LISTVAL_SQL
, FLEXCODE
, MINIMUM_VALUE
, MAXIMUM_VALUE
, PLANNED_ORDER_CRITERIA
, REPETITIVE_SCHEDULE_CRITERIA
, SCHEDULED_RECEIPTS_CRITERIA
, LOW_ID
, VALUE_LOW
, HIGH_ID
, VALUE_HIGH
, OPERATOR_TYPE
, TABLE_NAME
, COLUMN_NAME
, WHERE_CLAUSE
FROM MRP.MRP_WORKBENCH_CRITERIA;
MRP.MRP_WORKBENCH_CRITERIA does not reference any database object
MRP.MRP_WORKBENCH_CRITERIA is referenced by following:
APPS
MRP_WORKBENCH_CRITERIA
|
|
|
|