DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.MST_REL_TL_V

Object Details
Object Name: MST_REL_TL_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Unique identifier for plan
EXCEPTIONS VARCHAR2 (12)
jtfgnull.gif - no exceptions for trip, jtfuwnac.gif - trip has exceptions
TRIP_ID NUMBER
Yes FK to mst_trips
MODE_OF_TRANSPORT VARCHAR2 (30)
TRUCK, LTL, PARCEL
TRIP_NUMBER NUMBER

Trip number within the plan
CONTINUOUS_MOVE_ID NUMBER

FK to mst_cm_trips
CARRIER_ID NUMBER

FK to wsh_carriers
CARRIER_SERVICE_ID NUMBER

FK to wsh_carrier_services
ORIGIN_LOCATION_ID NUMBER

FK to wsh_locations
DESTINATION_LOCATION_ID NUMBER

FK to wsh_locations
CARRIER_NAME VARCHAR2 (30) Yes Carrier name
SERVICE_LEVEL VARCHAR2 (30)
Service level; D2D, Overnight etc.,
SERVICE_LEVEL_TL VARCHAR2 (80) Yes Translated value of service level
VEHICLE_TYPE VARCHAR2 (40)
Vehicle type
ORIGIN_COMPANY VARCHAR2 (80)
Origin Company
ORIGIN_FACILITY_ID NUMBER
Yes FK to fte_location_parameters
ORIGIN_FACILITY VARCHAR2 (60) Yes Origin facility
ORIGIN_FACILITY_DESC VARCHAR2 (250)
Origin facility description
ORIGIN_CITY VARCHAR2 (120)
Origin City
ORIGIN_STATE VARCHAR2 (120)
Origin State
ORIGIN_ZIP VARCHAR2 (60)
Origin zipcode
ORIGIN_COUNTRY VARCHAR2 (120)
Origin country
DESTINATION_COMPANY VARCHAR2 (80)
Destination Company
DESTINATION_FACILITY_ID NUMBER
Yes FK to fte_location_parameters
DESTINATION_FACILITY VARCHAR2 (60) Yes Destination facility
DESTINATION_FACILITY_DESC VARCHAR2 (250)
Destination facility description
DESTINATION_CITY VARCHAR2 (120)
Destination City
DESTINATION_STATE VARCHAR2 (120)
Destination State
DESTINATION_ZIP VARCHAR2 (60)
Destination zipcode
DESTINATION_COUNTRY VARCHAR2 (120)
Destination country
TOTAL_WEIGHT NUMBER

Total weight
TOTAL_VOLUME NUMBER

Total volume
TOTAL_PALLETS NUMBER

No. of pallets in trip
TOTAL_PIECES NUMBER

No. of pieces in trip
TOTAL_ORDERS NUMBER

No. of orders in trip
TOTAL_TRIP_COST NUMBER

Total cost of trip
CURRENCY_UOM VARCHAR2 (3)
Currency UOM
TRIP_UTILIZATION NUMBER

Max. utilization of trip
TRIP_CIRCUITY NUMBER

Trip circuity
TOTAL_TRIP_DISTANCE NUMBER

Total trip distance
TOTAL_STOPS NUMBER

No. of stops in trip
TIME_LEFT VARCHAR2 (80)
Time left for start of trip (string)
TIME_LEFT_NUM NUMBER

Time left for start of trip (number)
PLANNED_FLAG VARCHAR2 (80) Yes 1 => Routing and contents Firm, 2 => Routing Firm, 3 => Not Firm
SELECTED_FOR_RELEASE VARCHAR2 (80) Yes flagged for release - Yes, No
RELEASE_STATUS VARCHAR2 (80) Yes Status of release
RELEASE_DATE DATE

Date/time of release
RELEASE_DATE_CH VARCHAR2 (4000)
FLAGGED_FOR_RELEASE NUMBER

1 - Yes, 2 - No
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PLAN_ID
,      EXCEPTIONS
,      TRIP_ID
,      MODE_OF_TRANSPORT
,      TRIP_NUMBER
,      CONTINUOUS_MOVE_ID
,      CARRIER_ID
,      CARRIER_SERVICE_ID
,      ORIGIN_LOCATION_ID
,      DESTINATION_LOCATION_ID
,      CARRIER_NAME
,      SERVICE_LEVEL
,      SERVICE_LEVEL_TL
,      VEHICLE_TYPE
,      ORIGIN_COMPANY
,      ORIGIN_FACILITY_ID
,      ORIGIN_FACILITY
,      ORIGIN_FACILITY_DESC
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_COMPANY
,      DESTINATION_FACILITY_ID
,      DESTINATION_FACILITY
,      DESTINATION_FACILITY_DESC
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      TOTAL_WEIGHT
,      TOTAL_VOLUME
,      TOTAL_PALLETS
,      TOTAL_PIECES
,      TOTAL_ORDERS
,      TOTAL_TRIP_COST
,      CURRENCY_UOM
,      TRIP_UTILIZATION
,      TRIP_CIRCUITY
,      TOTAL_TRIP_DISTANCE
,      TOTAL_STOPS
,      TIME_LEFT
,      TIME_LEFT_NUM
,      PLANNED_FLAG
,      SELECTED_FOR_RELEASE
,      RELEASE_STATUS
,      RELEASE_DATE
,      RELEASE_DATE_CH
,      FLAGGED_FOR_RELEASE
FROM APPS.MST_REL_TL_V;

Dependencies

[top of page]

APPS.MST_REL_TL_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
SynonymFTE_LOCATION_PARAMETERS
SynonymFTE_VEHICLE_TYPES
ViewMFG_LOOKUPS
PL/SQL PackageMST_AGG_PKG - show dependent code
SynonymMST_PLANS
SynonymMST_TRIPS
PL/SQL PackageMST_WB_UTIL - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymWSH_CARRIERS
SynonymWSH_LOCATIONS
ViewWSH_LOOKUPS

APPS.MST_REL_TL_V is not referenced by any database object