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

VIEW: APPS.WSHFV_DELIVERY_LEGS

Object Details
Object Name: WSHFV_DELIVERY_LEGS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSHFV_DELIVERY_LEGS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
DELIVERY_LEG_ID NUMBER
Yes
DELIVERY_ID NUMBER
Yes
DELIVERY_NAME VARCHAR2 (30) Yes Delivery Name
SEQUENCE_NUMBER NUMBER
Yes
LOADING_ORDER_FLAG VARCHAR2 (2)
PICK_UP_STOP_ID NUMBER
Yes
PICK_UP_STOP_LOCATION VARCHAR2 (500)
Pickup Stop Location
DROP_OFF_STOP_ID NUMBER
Yes
DROP_OFF_STOP_LOCATION VARCHAR2 (500)
Dropoff Stop Location
GROSS_WEIGHT NUMBER

NET_WEIGHT NUMBER

WEIGHT_UOM_CODE VARCHAR2 (3)
VOLUME NUMBER

VOLUME_UOM_CODE VARCHAR2 (3)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
_LA:LOAD_TENDER_STATUS CHAR (65)
Load Tender Status
Query Text

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


SELECT DELIVERY_LEG_ID
,      DELIVERY_ID
,      DELIVERY_NAME
,      SEQUENCE_NUMBER
,      LOADING_ORDER_FLAG
,      PICK_UP_STOP_ID
,      PICK_UP_STOP_LOCATION
,      DROP_OFF_STOP_ID
,      DROP_OFF_STOP_LOCATION
,      GROSS_WEIGHT
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      VOLUME
,      VOLUME_UOM_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      _LA:LOAD_TENDER_STATUS
FROM APPS.WSHFV_DELIVERY_LEGS;

Dependencies

[top of page]

APPS.WSHFV_DELIVERY_LEGS references the following:

SchemaAPPS
SynonymWSH_DELIVERY_LEGS
SynonymWSH_LOCATIONS
SynonymWSH_NEW_DELIVERIES
SynonymWSH_TRIP_STOPS

APPS.WSHFV_DELIVERY_LEGS is not referenced by any database object