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