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

VIEW: WSH.WSH_DELIVERY_LEG_DETAILS#

Object Details
Object Name: WSH_DELIVERY_LEG_DETAILS#
Object Type: VIEW
Owner: WSH
Subobject Name:
Status: VALID

[View Source]

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

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

DELIVERED_QUANTITY NUMBER

LOADED_QUANTITY NUMBER

RECEIVED_QUANTITY NUMBER

ACTUAL_ARRIVAL_DATE DATE

ACTUAL_DEPARTURE_DATE DATE

ACTUAL_RECEIPT_DATE DATE

STATUS_CODE VARCHAR2 (240)
TRACKING_REMARKS VARCHAR2 (240)
CARRIER_EST_DEPARTURE_DATE DATE

CARRIER_EST_ARRIVAL_DATE DATE

LOADING_START_DATETIME DATE

LOADING_END_DATETIME DATE

UNLOADING_START_DATETIME DATE

UNLOADING_END_DATETIME DATE

Query Text

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


SELECT DELIVERY_LEG_ID
,      DELIVERY_DETAIL_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      DELIVERED_QUANTITY
,      LOADED_QUANTITY
,      RECEIVED_QUANTITY
,      ACTUAL_ARRIVAL_DATE
,      ACTUAL_DEPARTURE_DATE
,      ACTUAL_RECEIPT_DATE
,      STATUS_CODE
,      TRACKING_REMARKS
,      CARRIER_EST_DEPARTURE_DATE
,      CARRIER_EST_ARRIVAL_DATE
,      LOADING_START_DATETIME
,      LOADING_END_DATETIME
,      UNLOADING_START_DATETIME
,      UNLOADING_END_DATETIME
FROM WSH.WSH_DELIVERY_LEG_DETAILS#;

Dependencies

[top of page]

WSH.WSH_DELIVERY_LEG_DETAILS# references the following:

SchemaWSH
TableWSH_DELIVERY_LEG_DETAILS
WSH.WSH_DELIVERY_LEG_DETAILS# is referenced by following:

SchemaAPPS
SynonymWSH_DELIVERY_LEG_DETAILS