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