[Home] [Help] [Dependency Information]
Object Name: | MST_ACT_ADD_REMOVE_LOAD_CM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | FK to mst_plans | |
TRIP_ID | NUMBER | FK to mst_trips | ||
IN_REQUEST_ID | NUMBER | Yes | Primary key | |
OPTION_NUMBER | NUMBER | 1 - keep CM together2 - break CM | ||
LOAD_TYPE | VARCHAR2 | (80) | Load or Empty | |
TRIP_NUMBER | NUMBER | Trip number with in plan | ||
ORIGIN_FACILITY | VARCHAR2 | (60) | Yes | Origin Facility of the trip. |
ORIGIN_CITY | VARCHAR2 | (120) | Origin City of the trip. | |
ORIGIN_STATE | VARCHAR2 | (120) | Origin state of the trip. | |
ORIGIN_ZIP | VARCHAR2 | (60) | Origin zip code of the trip. | |
ORIGIN_COUNTRY | VARCHAR2 | (120) | Origin country of the trip. | |
DESTINATION_CITY | VARCHAR2 | (120) | Destination city of the trip. | |
DESTINATION_STATE | VARCHAR2 | (120) | Destination state of the trip. | |
DESTINATION_ZIP | VARCHAR2 | (60) | Destination zipcode of the trip. | |
DESTINATION_COUNTRY | VARCHAR2 | (120) | Destination country of the trip. | |
DEPARTURE_DATE | DATE | Departure date of the trip from the origin. | ||
DEPARTURE_TIME | VARCHAR2 | (5) | Departure time of the trip in HH:MI format. | |
DEPARTURE_TIME_ZONE | VARCHAR2 | (10) | Time zone in which departure date/time is displayed. | |
ARRIVAL_DATE | DATE | Date of arrival of the trip at the destination. | ||
ARRIVAL_TIME | VARCHAR2 | (5) | Time of arrival of the trip at the destination. | |
ARRIVAL_TIME_ZONE | VARCHAR2 | (10) | Time zone in which arrival date/time is displayed. | |
DISTANCE | NUMBER | Distance | ||
DISTANCE_UOM | VARCHAR2 | (3) | UOM of distance | |
CURRENT_CARRIER | VARCHAR2 | (30) | Yes | Carrier of the trip before manual update |
CURRENT_COST | NUMBER | Cost of the trip before manual update | ||
NEW_CARRIER | VARCHAR2 | (30) | Yes | Carrier of the trip aftermanual update |
NEW_COST | NUMBER | Cost of the trip after manual update | ||
CURRENCY_UOM | VARCHAR2 | (3) | UOM of currency |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, TRIP_ID
, IN_REQUEST_ID
, OPTION_NUMBER
, LOAD_TYPE
, TRIP_NUMBER
, ORIGIN_FACILITY
, ORIGIN_CITY
, ORIGIN_STATE
, ORIGIN_ZIP
, ORIGIN_COUNTRY
, DESTINATION_CITY
, DESTINATION_STATE
, DESTINATION_ZIP
, DESTINATION_COUNTRY
, DEPARTURE_DATE
, DEPARTURE_TIME
, DEPARTURE_TIME_ZONE
, ARRIVAL_DATE
, ARRIVAL_TIME
, ARRIVAL_TIME_ZONE
, DISTANCE
, DISTANCE_UOM
, CURRENT_CARRIER
, CURRENT_COST
, NEW_CARRIER
, NEW_COST
, CURRENCY_UOM
FROM APPS.MST_ACT_ADD_REMOVE_LOAD_CM_V;
APPS.MST_ACT_ADD_REMOVE_LOAD_CM_V is not referenced by any database object
|
|
|