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

VIEW: WMS.WMS_WP_ADVANCED_CRITERIA#

Object Details
Object Name: WMS_WP_ADVANCED_CRITERIA#
Object Type: VIEW
Owner: WMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Yes
RULE_WAVE_HEADER_ID NUMBER
Yes
SEQUENCE_NUMBER NUMBER

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATE_LOGIN NUMBER

LOGICAL_OPERATOR_CODE NUMBER

LOGICAL_OPERATOR_MEANING VARCHAR2 (10)
BRACKET_OPEN VARCHAR2 (10)
OBJECT_ID NUMBER

OBJECT_NAME VARCHAR2 (50)
OBJECT_DESCRIPTION VARCHAR2 (100)
PARAMETER_ID NUMBER

PARAMETER_NAME VARCHAR2 (50)
PARAMETER_DESCRIPTION VARCHAR2 (100)
OPERATOR_CODE NUMBER

OPERATOR_MEANING VARCHAR2 (50)
OPERATOR_DESCRIPTION VARCHAR2 (200)
OPERAND_VALUE VARCHAR2 (4000)
OPERAND_CHAR VARCHAR2 (4000)
BRACKET_CLOSE VARCHAR2 (10)
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# references the following:

SchemaWMS
TableWMS_WP_ADVANCED_CRITERIA
WMS.WMS_WP_ADVANCED_CRITERIA# is referenced by following:

SchemaAPPS
SynonymWMS_WP_ADVANCED_CRITERIA