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_STOP_ORDER_NUMBERS_V

Object Details

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

Information in Tender Notification UI and Tender Notification XML message about Order Details for the stop activity

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORDER_NUMBER	VARCHAR2	(150)		Order Number of the Stop
DELIVERY_NAME	VARCHAR2	(30)	Yes	Delivery Name of the Stop
ACTIVITY	VARCHAR2	(6)		Activity of the Stop.(Load/UnLoad)
STOP_ID	NUMBER			Stop Id
TRIP_ID	NUMBER		Yes	Trip Id

Query Text

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


SELECT ORDER_NUMBER
,      DELIVERY_NAME
,      ACTIVITY
,      STOP_ID
,      TRIP_ID
FROM APPS.FTE_STOP_ORDER_NUMBERS_V;

Dependencies

[top of page]

APPS.FTE_STOP_ORDER_NUMBERS_V references the following:

APPS: WSH_DELIVERY_ASSIGNMENTS; WSH_DELIVERY_DETAILS; WSH_DELIVERY_LEGS; WSH_NEW_DELIVERIES; WSH_TRIP_STOPS

APPS.FTE_STOP_ORDER_NUMBERS_V is not referenced by any database object