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_FREIGHT_CLASS_V

Object Details

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

Information in Tender Notification UI and Tender Notification XML message about freight class(Commodity Classification) for the stop activity

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRIP_ID	NUMBER		Yes	Trip Id of the Stop
FREIGHT_CLASS	VARCHAR2	(163)		Frieght Class of the Stop
WEIGHT	NUMBER			Weight of the Stop
WEIGHT_UOM_CODE	VARCHAR2	(3)		Weight UOM Code of the Stop
ACTIVITY	VARCHAR2	(6)		Activity of the Stop.(Load/UnLoad)
STOP_ID	NUMBER			Stop Id

Query Text

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


SELECT TRIP_ID
,      FREIGHT_CLASS
,      WEIGHT
,      WEIGHT_UOM_CODE
,      ACTIVITY
,      STOP_ID
FROM APPS.FTE_STOP_FREIGHT_CLASS_V;

Dependencies

[top of page]

APPS.FTE_STOP_FREIGHT_CLASS_V references the following:

APPS: MTL_CATEGORIES_KFV; MTL_CATEGORY_SETS; MTL_ITEM_CATEGORIES; MTL_SYSTEM_ITEMS; MTL_UNITS_OF_MEASURE; WSH_DELIVERY_ASSIGNMENTS; WSH_DELIVERY_DETAILS; WSH_DELIVERY_LEGS; WSH_GLOBAL_PARAMETERS; WSH_TRIP_STOPS; WSH_WV_UTILS - show dependent code

APPS.FTE_STOP_FREIGHT_CLASS_V is not referenced by any database object