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.FTE_TRIP_STOP_ACTIVITIES_V

Object Details

Object Name:	FTE_TRIP_STOP_ACTIVITIES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

Information in Tender Notification UI and Tender Notification XML message about Trip and Stop details for the stop activity

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SEQUENCE_NUMBER	NUMBER			Sequence Number of the Stop
LOCATION	VARCHAR2	(500)		Stop Location Code
LOCATION_OWNER_NAME	VARCHAR2	(360)		Stop Location Owner, 1 if organization else 2 if customer
LOCATION_TYPE	VARCHAR2	(9)		Stop Location Type if Ship From or Ship To
ADDRESS	VARCHAR2	(240)		Stop Location Address
CITY	VARCHAR2	(120)		Stop Location City
STATE	VARCHAR2	(120)		Stop Location State
COUNTRY	VARCHAR2	(120)		Stop Location Country
POSTAL_CODE	VARCHAR2	(60)		Stop Location Postal Code
ARRIVAL_DATE	DATE			Stop Arrival Date
DEPARTURE_DATE	DATE			Stop Departure Date
ACTIVITY	VARCHAR2	(10)		Stop Activity Code either LOAD or UNLOAD or NOACTIVITY
ACTIVITY_MEANING	VARCHAR2	(80)	Yes	Stop Activity Meaning either Load or Unload or No activity
PIECES	NUMBER			Pick up pieces or drop off pieces
STOP_LOCATION_ID	NUMBER			Stop Location Id
STOP_ID	NUMBER			Stop Id
WEIGHT	NUMBER			Stop Weight
WEIGHT_UOM	VARCHAR2	(3)		Stop Weight UOM
VOLUME	NUMBER			Stop Volume
VOLUME_UOM	VARCHAR2	(3)		Stop Volume UOM
TRIP_ID	NUMBER		Yes	Trip Id

Query Text

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


SELECT SEQUENCE_NUMBER
,      LOCATION
,      LOCATION_OWNER_NAME
,      LOCATION_TYPE
,      ADDRESS
,      CITY
,      STATE
,      COUNTRY
,      POSTAL_CODE
,      ARRIVAL_DATE
,      DEPARTURE_DATE
,      ACTIVITY
,      ACTIVITY_MEANING
,      PIECES
,      STOP_LOCATION_ID
,      STOP_ID
,      WEIGHT
,      WEIGHT_UOM
,      VOLUME
,      VOLUME_UOM
,      TRIP_ID
FROM APPS.FTE_TRIP_STOP_ACTIVITIES_V;

Dependencies

[top of page]

APPS.FTE_TRIP_STOP_ACTIVITIES_V references the following:

APPS: FND_LOOKUP_VALUES_VL; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; HZ_PARTIES; ORG_ORGANIZATION_DEFINITIONS; WSH_DELIVERY_ASSIGNMENTS; WSH_DELIVERY_DETAILS; WSH_DELIVERY_LEGS; WSH_LOCATIONS; WSH_LOCATION_OWNERS; WSH_TRIP_STOPS

APPS.FTE_TRIP_STOP_ACTIVITIES_V is not referenced by any database object