[Home] [Help] [Dependency Information]
Object Name: | MRP_WORKBENCH_CRITERIA# |
---|---|
Object Type: | VIEW |
Owner: | MRP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUERY_ID | NUMBER | Yes | ||
CRITERION_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
CRITERIA_SET | VARCHAR2 | (50) | ||
PRIORITY | NUMBER | Yes | ||
CRITERION | VARCHAR2 | (50) | Yes | |
CRITERION_TYPE | NUMBER | Yes | ||
VALUE_TYPE | NUMBER | Yes | ||
LOOKUP_TYPE | VARCHAR2 | (50) | ||
LISTVAL_SQL | VARCHAR2 | (240) | ||
FLEXCODE | VARCHAR2 | (4) | ||
MINIMUM_VALUE | VARCHAR2 | (50) | ||
MAXIMUM_VALUE | VARCHAR2 | (50) | ||
PLANNED_ORDER_CRITERIA | NUMBER | |||
REPETITIVE_SCHEDULE_CRITERIA | NUMBER | |||
SCHEDULED_RECEIPTS_CRITERIA | NUMBER | |||
LOW_ID | NUMBER | |||
VALUE_LOW | VARCHAR2 | (80) | ||
HIGH_ID | NUMBER | |||
VALUE_HIGH | VARCHAR2 | (80) | ||
OPERATOR_TYPE | NUMBER | |||
TABLE_NAME | VARCHAR2 | (50) | ||
COLUMN_NAME | VARCHAR2 | (50) | ||
WHERE_CLAUSE | VARCHAR2 | (240) |
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#;
|
|
|