[Home] [Help] [Dependency Information]
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
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 |
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;
APPS.FTE_STOP_HAZARD_CLASS_V is not referenced by any database object
|
|
|