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

VIEW: MRP.MRP_WORKBENCH_CRITERIA#

Object Details
Object Name: MRP_WORKBENCH_CRITERIA#
Object Type: VIEW
Owner: MRP
Subobject Name:
Status: VALID

[View Source]

Columns
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)
Query Text

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#;

Dependencies

[top of page]

MRP.MRP_WORKBENCH_CRITERIA# references the following:

SchemaMRP
TableMRP_WORKBENCH_CRITERIA
MRP.MRP_WORKBENCH_CRITERIA# is referenced by following:

SchemaAPPS
SynonymMRP_WORKBENCH_CRITERIA