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

VIEW: WMS.WMS_CROSSDOCK_CRITERIA_B#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
CRITERION_ID NUMBER
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

CRITERION_TYPE NUMBER
Yes
WINDOW_INTERVAL NUMBER
Yes
WINDOW_UOM VARCHAR2 (10) Yes
BUFFER_INTERVAL NUMBER

BUFFER_UOM VARCHAR2 (10)
PROCESSING_INTERVAL NUMBER

PROCESSING_UOM VARCHAR2 (10)
PAST_DUE_INTERVAL NUMBER

PAST_DUE_UOM VARCHAR2 (10)
CROSSDOCK_GOAL NUMBER
Yes
PRIORITIZE_DOCUMENTS_FLAG NUMBER
Yes
ALLOW_SUPPLY_RESCHEDULE_FLAG NUMBER
Yes
ALLOW_DEMAND_RESCHEDULE_FLAG NUMBER
Yes
SUPPLY_SCHEDULE_METHOD NUMBER
Yes
DEMAND_SCHEDULE_METHOD NUMBER
Yes
UOM_INTEGRITY_FLAG NUMBER
Yes
Query Text

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


SELECT CRITERION_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      CRITERION_TYPE
,      WINDOW_INTERVAL
,      WINDOW_UOM
,      BUFFER_INTERVAL
,      BUFFER_UOM
,      PROCESSING_INTERVAL
,      PROCESSING_UOM
,      PAST_DUE_INTERVAL
,      PAST_DUE_UOM
,      CROSSDOCK_GOAL
,      PRIORITIZE_DOCUMENTS_FLAG
,      ALLOW_SUPPLY_RESCHEDULE_FLAG
,      ALLOW_DEMAND_RESCHEDULE_FLAG
,      SUPPLY_SCHEDULE_METHOD
,      DEMAND_SCHEDULE_METHOD
,      UOM_INTEGRITY_FLAG
FROM WMS.WMS_CROSSDOCK_CRITERIA_B#;

Dependencies

[top of page]

WMS.WMS_CROSSDOCK_CRITERIA_B# references the following:

SchemaWMS
TableWMS_CROSSDOCK_CRITERIA_B
WMS.WMS_CROSSDOCK_CRITERIA_B# is referenced by following:

SchemaAPPS
SynonymWMS_CROSSDOCK_CRITERIA
SynonymWMS_CROSSDOCK_CRITERIA_B