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_HAZARD_CLASS_V

Object Details

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

Information in Tender Notification UI and Tender Notification XML message about Hazardous Material Information for the stop activity

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
HAZARD_CLASS	VARCHAR2	(40)	Yes	Hazard Class
HAZARD_CLASS_DESCRIPTION	VARCHAR2	(240)		Hazard Class Description
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 HAZARD_CLASS
,      HAZARD_CLASS_DESCRIPTION
,      ACTIVITY
,      STOP_ID
,      TRIP_ID
FROM APPS.FTE_STOP_HAZARD_CLASS_V;

Dependencies

[top of page]

APPS.FTE_STOP_HAZARD_CLASS_V references the following:

APPS: PO_HAZARD_CLASSES_VL; WSH_DELIVERY_ASSIGNMENTS; WSH_DELIVERY_DETAILS; WSH_DELIVERY_LEGS; WSH_TRIP_STOPS

APPS.FTE_STOP_HAZARD_CLASS_V is not referenced by any database object