eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.WSHFV_TRIP_STOPS

Object Details

Object Name:	WSHFV_TRIP_STOPS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSHFV_TRIP_STOPS
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
STOP_ID	NUMBER		Yes	Stop Id
TRIP_ID	NUMBER		Yes	Trip Id
TRIP_NAME	VARCHAR2	(30)	Yes	Trip Name
STOP_LOCATION_ID	NUMBER			Stop Location Id
LOCATION_DESCRIPTION	VARCHAR2	(500)		Location Description
_LA:STATUS_CODE	CHAR	(57)		Lookup - Status Code
STOP_SEQUENCE_NUMBER	NUMBER		Yes	Stop Sequence Number
PLANNED_ARRIVAL_DATE	DATE			Planned Arrival Date
ACTUAL_ARRIVAL_DATE	DATE			Actual Arrival Date
PLANNED_DEPARTURE_DATE	DATE			Planned Departure Date
ACTUAL_DEPARTURE_DATE	DATE			Actual Departure Date
DEPARTURE_GROSS_WEIGHT	NUMBER			Departure Gross Weight
DEPARTURE_NET_WEIGHT	NUMBER			Departure Net Weight
WEIGHT_UOM_CODE	VARCHAR2	(3)		Weight UOM Code
DEPARTURE_VOLUME	NUMBER			Departure Volume
VOLUME_UOM_CODE	VARCHAR2	(3)		Volume UOM Code
DEPARTURE_SEAL_CODE	VARCHAR2	(30)		Departure Seal Code
DEPARTURE_FILL_PERCENT	NUMBER			Departure Fill Percent
_LA:PENDING_INTERFACE_FLAG	CHAR	(58)		Lookup - Pending Interface Flag
_DF:STOP	CHAR	(27)		Descriptive Flexfield - Stops
_DF:AUTOMOTIVE	CHAR	(31)		Descriptive Flexfield - Automotive
CREATION_DATE	DATE		Yes	Creation Date
CREATED_BY	NUMBER		Yes	Created By
LAST_UPDATE_DATE	DATE		Yes	Last Update Date
LAST_UPDATED_BY	NUMBER		Yes	Last Updated By
LAST_UPDATE_LOGIN	NUMBER			Last Update Login
SHIPMENTS_TYPE_FLAG	VARCHAR2	(30)

Query Text

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


SELECT STOP_ID
,      TRIP_ID
,      TRIP_NAME
,      STOP_LOCATION_ID
,      LOCATION_DESCRIPTION
,      _LA:STATUS_CODE
,      STOP_SEQUENCE_NUMBER
,      PLANNED_ARRIVAL_DATE
,      ACTUAL_ARRIVAL_DATE
,      PLANNED_DEPARTURE_DATE
,      ACTUAL_DEPARTURE_DATE
,      DEPARTURE_GROSS_WEIGHT
,      DEPARTURE_NET_WEIGHT
,      WEIGHT_UOM_CODE
,      DEPARTURE_VOLUME
,      VOLUME_UOM_CODE
,      DEPARTURE_SEAL_CODE
,      DEPARTURE_FILL_PERCENT
,      _LA:PENDING_INTERFACE_FLAG
,      _DF:STOP
,      _DF:AUTOMOTIVE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SHIPMENTS_TYPE_FLAG
FROM APPS.WSHFV_TRIP_STOPS;

Dependencies

[top of page]

APPS.WSHFV_TRIP_STOPS references the following:

APPS: WSH_LOCATIONS; WSH_TRIPS; WSH_TRIP_STOPS

APPS.WSHFV_TRIP_STOPS is not referenced by any database object