VIEW: MRP.MRP_WORKBENCH_CRITERIA#

Source

View Text - Preformatted

select QUERY_ID QUERY_ID, CRITERION_ID CRITERION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CRITERIA_SET CRITERIA_SET, PRIORITY PRIORITY, CRITERION CRITERION, CRITERION_TYPE CRITERION_TYPE, VALUE_TYPE VALUE_TYPE, LOOKUP_TYPE LOOKUP_TYPE, LISTVAL_SQL LISTVAL_SQL, FLEXCODE FLEXCODE, MINIMUM_VALUE MINIMUM_VALUE, MAXIMUM_VALUE MAXIMUM_VALUE, PLANNED_ORDER_CRITERIA PLANNED_ORDER_CRITERIA, REPETITIVE_SCHEDULE_CRITERIA REPETITIVE_SCHEDULE_CRITERIA, SCHEDULED_RECEIPTS_CRITERIA SCHEDULED_RECEIPTS_CRITERIA, LOW_ID LOW_ID, VALUE_LOW VALUE_LOW, HIGH_ID HIGH_ID, VALUE_HIGH VALUE_HIGH, OPERATOR_TYPE OPERATOR_TYPE, TABLE_NAME TABLE_NAME, COLUMN_NAME COLUMN_NAME, WHERE_CLAUSE WHERE_CLAUSE from "MRP"."MRP_WORKBENCH_CRITERIA"

View Text - HTML Formatted

SELECT QUERY_ID QUERY_ID
, CRITERION_ID CRITERION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CRITERIA_SET CRITERIA_SET
, PRIORITY PRIORITY
, CRITERION CRITERION
, CRITERION_TYPE CRITERION_TYPE
, VALUE_TYPE VALUE_TYPE
, LOOKUP_TYPE LOOKUP_TYPE
, LISTVAL_SQL LISTVAL_SQL
, FLEXCODE FLEXCODE
, MINIMUM_VALUE MINIMUM_VALUE
, MAXIMUM_VALUE MAXIMUM_VALUE
, PLANNED_ORDER_CRITERIA PLANNED_ORDER_CRITERIA
, REPETITIVE_SCHEDULE_CRITERIA REPETITIVE_SCHEDULE_CRITERIA
, SCHEDULED_RECEIPTS_CRITERIA SCHEDULED_RECEIPTS_CRITERIA
, LOW_ID LOW_ID
, VALUE_LOW VALUE_LOW
, HIGH_ID HIGH_ID
, VALUE_HIGH VALUE_HIGH
, OPERATOR_TYPE OPERATOR_TYPE
, TABLE_NAME TABLE_NAME
, COLUMN_NAME COLUMN_NAME
, WHERE_CLAUSE WHERE_CLAUSE
FROM "MRP"."MRP_WORKBENCH_CRITERIA"