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_AL_AP_LOADS_V

Object Details

Object Name:	MST_AL_AP_LOADS_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
TRIP_ID	NUMBER		Yes	Primary key for table
TRIP_NUMBER	NUMBER			Trip number with in plan
CARRIER_ID	NUMBER			Vendor Id providing (trip) service
ORIGIN_LOCATION_ID	NUMBER			location_id of very first facility (first stop) of this trip
DESTINATION_LOCATION_ID	NUMBER			location_id of last facility of this trip
CARRIER_NAME	VARCHAR2	(30)	Yes	Vendor Name providing (trip) service
SERVICE_LEVEL	VARCHAR2	(30)		Service provided by vendor (carrier) for this trip as in mst_trips. It is not translated string
SERVICE_LEVEL_TL	VARCHAR2	(80)	Yes	Service provided by vendor (carrier) for this trip. It is translated string derived from wsh_lookups for lookup_type = 'WSH_SERVICE_LEVEL
MODE_OF_TRANSPORT	VARCHAR2	(30)		Mode of transport provided by vendor (carrier) for this trip as in mst_trips.mode_of_transport. It is not translated string
ORIGIN_COMPANY	VARCHAR2	(80)		Owner company name of very first facility (first stop) of this trip
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	Facility name of very first facility (first stop) of this trip
ORIGIN_FACILITY_DESC	VARCHAR2	(250)		Facility description of very first facility (first stop) of this trip
ORIGIN_CITY	VARCHAR2	(120)		City in which very first facility (first stop) of this trip located
ORIGIN_STATE	VARCHAR2	(120)		State in which very first facility (first stop) of this trip located
ORIGIN_ZIP	VARCHAR2	(60)		Zip in which very first facility (first stop) of this trip located
ORIGIN_COUNTRY	VARCHAR2	(120)		Country in which very first facility (first stop) of this trip located
DESTINATION_COMPANY	VARCHAR2	(80)		Owner company name of very last facility (last stop) of this trip
DESTINATION_FACILITY	VARCHAR2	(60)	Yes	Facility name of very last facility (last stop) of this trip
DESTINATION_FACILITY_DESC	VARCHAR2	(250)		Facility description of very last facility (last stop) of this trip
DESTINATION_CITY	VARCHAR2	(120)		City in which very last facility (last stop) of this trip is located
DESTINATION_STATE	VARCHAR2	(120)		State in which very last facility (last stop) of this trip is located
DESTINATION_ZIP	VARCHAR2	(60)		Zip in which very last facility (last stop) of this trip is located
DESTINATION_COUNTRY	VARCHAR2	(120)		Country in which very last facility (last stop) of this trip is located
TRIP_START_DATE	VARCHAR2	(40)		DateTime of departure of trip from its first stop in its local timezone concatenated with timezone of that stop. It is displayed at UI.
TRIP_END_DATE	VARCHAR2	(40)		DateTime of arrival of trip at its last stop in its local timezone concatenated with timezone of that stop. It is displayed at UI.
TRIP_START_DATE_DT	DATE			DateTime of departure of trip from its first stop in server timezone as in mst_trips. It is hidden at UI and used only for sorting in background when user sort on corresponding visible field at UI.
TRIP_END_DATE_DT	DATE			DateTime of arrival of trip at its last stop in server timezone as in mst_trips. It is hidden at UI and used only for sorting in background when user sort on corresponding visible field at UI.
TOTAL_RATED_COST	NUMBER			Summation of total basic transport cost and total accessorial cost of the current trip
TOTAL_RATED_COST_UOM	VARCHAR2	(3)		currency considered for this plan
TOTAL_WEIGHT	NUMBER			total weight of deliveries carried by trip
TOTAL_CUBES	NUMBER			total volume of deliveries carried by trip
TOTAL_PALLETS	NUMBER			total pallets of deliveries carried by trip
TOTAL_PIECES	NUMBER			total pieces of deliveries carried by trip
TOTAL_ORDERS	NUMBER			Count of original snapshot order lines transported by current trip
WEIGHT_UOM	VARCHAR2	(3)		Unit of measurement of weight as considered for entire plan as in mst_plans
VOLUME_UOM	VARCHAR2	(3)		Unit of measurement of volume as considered for entire plan as in mst_plans
PLANNED_FLAG_NUM	NUMBER		Yes
PLANNED_FLAG	VARCHAR2	(80)	Yes	Translated string of Firm Status of trip derived from mfg_lookups for mst_trips.planned_flag
SELECTED_FOR_RELEASE	VARCHAR2	(80)	Yes	String "Yes"/"No" whether flagged for release or not derived for mst_trips.selected_for_release
RELEASE_STATUS	VARCHAR2	(80)	Yes	Translated string of Release Status of trip derived from mfg_lookups for mst_trips.release_status
RELEASE_DATE	DATE			DateTime of release in server timezone as in mst_trips.release_date. This DateTime is datetime of successful release or datetime of release attempt in case of failed release.
RELEASE_DATE_CH	VARCHAR2	(4000)
AUTO_RELEASE_FLAG	NUMBER			Flag whether this trip was auto-released
FLAGGED_FOR_RELEASE	NUMBER			Flag whether this trip has been flagged for release
RELEASE_STATUS_NUM	NUMBER			It is the release status value which is stored in mst_trips

Query Text

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


SELECT PLAN_ID
,      TRIP_ID
,      TRIP_NUMBER
,      CARRIER_ID
,      ORIGIN_LOCATION_ID
,      DESTINATION_LOCATION_ID
,      CARRIER_NAME
,      SERVICE_LEVEL
,      SERVICE_LEVEL_TL
,      MODE_OF_TRANSPORT
,      ORIGIN_COMPANY
,      ORIGIN_FACILITY
,      ORIGIN_FACILITY_DESC
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_COMPANY
,      DESTINATION_FACILITY
,      DESTINATION_FACILITY_DESC
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      TRIP_START_DATE
,      TRIP_END_DATE
,      TRIP_START_DATE_DT
,      TRIP_END_DATE_DT
,      TOTAL_RATED_COST
,      TOTAL_RATED_COST_UOM
,      TOTAL_WEIGHT
,      TOTAL_CUBES
,      TOTAL_PALLETS
,      TOTAL_PIECES
,      TOTAL_ORDERS
,      WEIGHT_UOM
,      VOLUME_UOM
,      PLANNED_FLAG_NUM
,      PLANNED_FLAG
,      SELECTED_FOR_RELEASE
,      RELEASE_STATUS
,      RELEASE_DATE
,      RELEASE_DATE_CH
,      AUTO_RELEASE_FLAG
,      FLAGGED_FOR_RELEASE
,      RELEASE_STATUS_NUM
FROM APPS.MST_AL_AP_LOADS_V;

Dependencies

[top of page]

APPS.MST_AL_AP_LOADS_V references the following:

APPS: FND_DATE - show dependent code; FTE_LOCATION_PARAMETERS; MFG_LOOKUPS; MST_DELIVERIES; MST_DELIVERY_LEGS; MST_PLANS; MST_TRIPS; MST_WB_UTIL - show dependent code; WSH_CARRIERS; WSH_LOCATIONS; WSH_LOOKUPS

APPS.MST_AL_AP_LOADS_V is not referenced by any database object