eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MST_LAYOVER_CHARGES_INCUR_V

Object Details

Object Name:	MST_LAYOVER_CHARGES_INCUR_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	FK to mst_plans
EXCEPTION_TYPE	NUMBER		Yes	Lookup code for exception type
EXCEPTION_DETAIL_ID	NUMBER		Yes	FK to mst_exception_details
MODE_OF_TRANSPORT	VARCHAR2	(30)		Truck, LTL, Ocean, Parcel etc
TRIP_ID	NUMBER		Yes	FK to mst_trips
CARRIER_ID	NUMBER		Yes	FK to wsh_carriers
TRIP_NUMBER	NUMBER			Trip number with in plan
CARRIER_NAME	VARCHAR2	(30)	Yes	Carrier name
SERVICE_LEVEL	VARCHAR2	(30)		Service Level eg., D2D, 2 days, Overnight etc.,
SERVICE_LEVEL_TL	VARCHAR2	(80)	Yes	Translated value of service_level
VEHICLE_TYPE	VARCHAR2	(40)		Vehicle type
COST	NUMBER			Trip cost
CURRENCY_UOM	VARCHAR2	(3)		Currency UOM
LAYOVER_CHARGES	NUMBER			Layover cost
LAYOVER_TYPE	VARCHAR2	(80)	Yes	1 = weekday layover charges, 2 = weekend layover charges
STOP_BEFORE_COMPANY	VARCHAR2	(80)		Stop before company
STOP_BEFORE_ADDRESS	VARCHAR2	(240)		Stop before address
STOP_BEFORE_CITY	VARCHAR2	(120)		Stop before city
STOP_BEFORE_STATE	VARCHAR2	(120)		Stop before state
STOP_BEFORE_ZIP	VARCHAR2	(60)		Stop before zipcode
STOP_BEFORE_COUNTRY	VARCHAR2	(120)		Stop before country
STOP_BEFORE_DEPARTURE	VARCHAR2	(40)		Planned Departure Date in local timezone
PLANNED_DEPARTURE_DATE	DATE			Planned Departure Date
STOP_AFTER_ARRIVAL	VARCHAR2	(40)		Planned Arrival Date in local timezone
PLANNED_ARRIVAL_DATE	DATE			Planned Arrival Date
STOP_AFTER_COMPANY	VARCHAR2	(80)		Stop after company
STOP_AFTER_ADDRESS	VARCHAR2	(240)		Stop after address
STOP_AFTER_CITY	VARCHAR2	(120)		Stop after city
STOP_AFTER_STATE	VARCHAR2	(120)		Stop after state
STOP_AFTER_ZIP	VARCHAR2	(60)		Stop after zipcode
STOP_AFTER_COUNTRY	VARCHAR2	(120)		Stop after country
DISTANCE	NUMBER			Miles drove over weekend (valid if layover type = 2)
REQUIRED_DISTANCE	NUMBER			Required miles to avoid layover (valid if layover type = 2)
DISTANCE_UOM	VARCHAR2	(3)		Distance UOM
STATUS	VARCHAR2	(80)	Yes	Exception status
THRESHOLD	VARCHAR2	(20)		Threshold value of exception
WORKFLOW_STATUS	VARCHAR2	(20)		Workflow status

Query Text

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


SELECT PLAN_ID
,      EXCEPTION_TYPE
,      EXCEPTION_DETAIL_ID
,      MODE_OF_TRANSPORT
,      TRIP_ID
,      CARRIER_ID
,      TRIP_NUMBER
,      CARRIER_NAME
,      SERVICE_LEVEL
,      SERVICE_LEVEL_TL
,      VEHICLE_TYPE
,      COST
,      CURRENCY_UOM
,      LAYOVER_CHARGES
,      LAYOVER_TYPE
,      STOP_BEFORE_COMPANY
,      STOP_BEFORE_ADDRESS
,      STOP_BEFORE_CITY
,      STOP_BEFORE_STATE
,      STOP_BEFORE_ZIP
,      STOP_BEFORE_COUNTRY
,      STOP_BEFORE_DEPARTURE
,      PLANNED_DEPARTURE_DATE
,      STOP_AFTER_ARRIVAL
,      PLANNED_ARRIVAL_DATE
,      STOP_AFTER_COMPANY
,      STOP_AFTER_ADDRESS
,      STOP_AFTER_CITY
,      STOP_AFTER_STATE
,      STOP_AFTER_ZIP
,      STOP_AFTER_COUNTRY
,      DISTANCE
,      REQUIRED_DISTANCE
,      DISTANCE_UOM
,      STATUS
,      THRESHOLD
,      WORKFLOW_STATUS
FROM APPS.MST_LAYOVER_CHARGES_INCUR_V;