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

TABLE: WMS.WMS_WP_ADVANCED_CRITERIA

Object Details
Object Name: WMS_WP_ADVANCED_CRITERIA
Object Type: TABLE
Owner: WMS
Subobject Name:
Status: VALID


Stores advanced criteria used in creation of waves in Wave Planning.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WMS_WP_ADVANCED_CRITERIA_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_ID
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Yes rule id
RULE_WAVE_HEADER_ID NUMBER
Yes wave header id associated with rule
SEQUENCE_NUMBER NUMBER

sequence number
LAST_UPDATED_BY NUMBER

last updated by
LAST_UPDATE_DATE DATE

last update date
CREATED_BY NUMBER

created by
CREATION_DATE DATE

creation date
LAST_UPDATE_LOGIN NUMBER

last update login
LOGICAL_OPERATOR_CODE NUMBER

logical operator code
LOGICAL_OPERATOR_MEANING VARCHAR2 (10)
logical operator meaning
BRACKET_OPEN VARCHAR2 (10)
bracket open
OBJECT_ID NUMBER

object id
OBJECT_NAME VARCHAR2 (50)
object name
OBJECT_DESCRIPTION VARCHAR2 (100)
object description
PARAMETER_ID NUMBER

parameter id
PARAMETER_NAME VARCHAR2 (50)
parameter name
PARAMETER_DESCRIPTION VARCHAR2 (100)
parameter description
OPERATOR_CODE NUMBER

operator code
OPERATOR_MEANING VARCHAR2 (50)
operator meaning
OPERATOR_DESCRIPTION VARCHAR2 (200)
operator description
OPERAND_VALUE VARCHAR2 (4000)
operand value
OPERAND_CHAR VARCHAR2 (4000)
operand char
BRACKET_CLOSE VARCHAR2 (10)
bracket close
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RULE_ID
,      RULE_WAVE_HEADER_ID
,      SEQUENCE_NUMBER
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LOGICAL_OPERATOR_CODE
,      LOGICAL_OPERATOR_MEANING
,      BRACKET_OPEN
,      OBJECT_ID
,      OBJECT_NAME
,      OBJECT_DESCRIPTION
,      PARAMETER_ID
,      PARAMETER_NAME
,      PARAMETER_DESCRIPTION
,      OPERATOR_CODE
,      OPERATOR_MEANING
,      OPERATOR_DESCRIPTION
,      OPERAND_VALUE
,      OPERAND_CHAR
,      BRACKET_CLOSE
FROM WMS.WMS_WP_ADVANCED_CRITERIA;

Dependencies

[top of page]

WMS.WMS_WP_ADVANCED_CRITERIA does not reference any database object

WMS.WMS_WP_ADVANCED_CRITERIA is referenced by following:

SchemaWMS
ViewWMS_WP_ADVANCED_CRITERIA#