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_R_MAS_CARR_LTL_PARC_V

Object Details

Object Name:	MST_R_MAS_CARR_LTL_PARC_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	Plan ID
OWNER_TYPE	NUMBER			Origin Facility Owner
FACILITY_ID	NUMBER		Yes	Origin Facility ID
DEST_FACILITY_ID	NUMBER		Yes	Destination Facility ID
ORAGANIZATION_ID	NUMBER			ship_from_org_id
CUSTOMER_ID	NUMBER			Customer ID whose deliveries are transported by the LTL/Parcel
SUPPLIER_ID	NUMBER			Supplier ID whose deliveries are transported by the LTL/Parcel
CARRIER_ID	NUMBER			Carrier ID of the LTL/Parcel
FREIGHT_CODE	VARCHAR2	(30)	Yes	Carrier Name of the LTL/Parcel
SERVICE_LEVEL	VARCHAR2	(30)		service level of the carrier
TRIP_NUMBER	NUMBER			trip number in the plan
ORIGIN_LOCATION_ID	NUMBER			Origin Location ID
ORIGIN_LOC_ID_CODE	VARCHAR2	(60)		Origin Location Code
ORIGIN_LOC_COMP_NAME	VARCHAR2	(80)		Origin Company Name
ORIGIN_LOC_ADDRESS	VARCHAR2	(240)		Origin Company Address
ORIGIN_LOC_CITY	VARCHAR2	(120)		Origin Company City
ORIGIN_LOC_STATE	VARCHAR2	(120)		Origin Company State
ORIGIN_LOC_ZIP	VARCHAR2	(60)		Origin Company Postal Code
ORIGIN_LOC_CONT_NAME	VARCHAR2	(4000)		Origin Company Contact Name
ORIGIN_LOC_CON_PHONE_NUM	VARCHAR2	(4000)		Origin Company Contact Phone Number
PLAN_PICKUP_DATE	DATE			LTL/Parcel Trip Start Date
PLANNED_DEP_DATE_FRM_ORIG	VARCHAR2	(20)		LTL/Parcel Trip Start Date (translated for display purpose)
PLANNED_ARR_DATE_AT_DEST	VARCHAR2	(20)		LTL/Parcel Trip End Date
DESTINATION_LOCATION_ID	NUMBER			Destination Location ID
DEST_LOC_ID_CODE	VARCHAR2	(60)		Destination Location Code
DEST_LOC_COMP_NAME	VARCHAR2	(80)		Destination Location Company Name
DEST_LOC_ADDRESS	VARCHAR2	(240)		Destination Location Company Address
DEST_LOC_CITY	VARCHAR2	(120)		Destination Location Company City
DEST_LOC_STATE	VARCHAR2	(120)		Destination Location Company State
DEST_LOC_ZIP	VARCHAR2	(60)		Destination Location Company Postal Code
DEST_LOC_CONT_NAME	VARCHAR2	(4000)		Destination Location Company Contact Name
DESC_LOC_CONT_PHONE_NUM	VARCHAR2	(4000)		Destination Location Company Contact Phone Number
EARL_ARRIVAL_DATE_AT_DEST	VARCHAR2	(20)		Earliest Accpetable Date
LATEST_ARRIVAL_DATE_AT_DEST	VARCHAR2	(20)		Latest Acceptable Date
PIECES	NUMBER			Total number of pieces
VOLUME	NUMBER			Total Volume
WEIGHT	NUMBER			Gross weight
COSTS	NUMBER			Total costs incurred
INTERNAL_ORDER_REF_NUM	VARCHAR2	(50)		Customer PO Number, Supplier Sales Order Line NUmber or Shipper's Sales Order Reference to return line
EXTERNAL_ORDER_REF_NUM	VARCHAR2	(150)		The user visible identifier for the header, ex. Order Number
COMMODITY_TYPES	VARCHAR2	(4000)		Freight Class

Query Text

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


SELECT PLAN_ID
,      OWNER_TYPE
,      FACILITY_ID
,      DEST_FACILITY_ID
,      ORAGANIZATION_ID
,      CUSTOMER_ID
,      SUPPLIER_ID
,      CARRIER_ID
,      FREIGHT_CODE
,      SERVICE_LEVEL
,      TRIP_NUMBER
,      ORIGIN_LOCATION_ID
,      ORIGIN_LOC_ID_CODE
,      ORIGIN_LOC_COMP_NAME
,      ORIGIN_LOC_ADDRESS
,      ORIGIN_LOC_CITY
,      ORIGIN_LOC_STATE
,      ORIGIN_LOC_ZIP
,      ORIGIN_LOC_CONT_NAME
,      ORIGIN_LOC_CON_PHONE_NUM
,      PLAN_PICKUP_DATE
,      PLANNED_DEP_DATE_FRM_ORIG
,      PLANNED_ARR_DATE_AT_DEST
,      DESTINATION_LOCATION_ID
,      DEST_LOC_ID_CODE
,      DEST_LOC_COMP_NAME
,      DEST_LOC_ADDRESS
,      DEST_LOC_CITY
,      DEST_LOC_STATE
,      DEST_LOC_ZIP
,      DEST_LOC_CONT_NAME
,      DESC_LOC_CONT_PHONE_NUM
,      EARL_ARRIVAL_DATE_AT_DEST
,      LATEST_ARRIVAL_DATE_AT_DEST
,      PIECES
,      VOLUME
,      WEIGHT
,      COSTS
,      INTERNAL_ORDER_REF_NUM
,      EXTERNAL_ORDER_REF_NUM
,      COMMODITY_TYPES
FROM APPS.MST_R_MAS_CARR_LTL_PARC_V;

Dependencies

[top of page]

APPS.MST_R_MAS_CARR_LTL_PARC_V references the following:

APPS: FTE_LOCATION_PARAMETERS; MST_DELIVERIES; MST_DELIVERY_ASSIGNMENTS; MST_DELIVERY_DETAILS; MST_DELIVERY_LEGS; MST_REPORTS_PKG - show dependent code; MST_TRIPS; MST_WB_UTIL - show dependent code; WSH_CARRIERS; WSH_CARRIER_SERVICES; WSH_LOCATIONS; WSH_LOCATION_OWNERS

APPS.MST_R_MAS_CARR_LTL_PARC_V is not referenced by any database object