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_MASTER_ORDER_DET_V

Object Details

Object Name:	MST_R_MASTER_ORDER_DET_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	Comments
PLAN_ID	NUMBER		Primary Key
REPORT_FLAVOR	VARCHAR2	(8)	'FACILITY' -> Facility flavor; 'NORMAL' -> The other flavors of the report
OWNER_TYPE	NUMBER		Facility owner type
FACILITY_ID	NUMBER		Facility ID
CUSTOMER_ID	NUMBER		Customer ID
SUPPLIER_ID	NUMBER		Supplier ID
ORDER_TYPE	VARCHAR2	(240)	Source type of the reference order SO, PO, etc.
HOST_COMP_ORDER_REF	VARCHAR2	(50)	Customer PO Number, Supplier Sales Order Line Number or Shipper's Sales Order reference to return line
SUPP_CUST_ORDER_REF	VARCHAR2	(150)	The user visible identifier for the header, ex. Order number
ORDER_PIECES	NUMBER		Total number of pieces
ORDER_WEIGHT	NUMBER		Gross weight
ORDER_CUBE	NUMBER		Total volume
ORDER_EARL_ALLOW_DATE	VARCHAR2	(20)	Earliest Accepatable Date
ORDER_LATEST_ALLOW_DATE	VARCHAR2	(20)	Latest Accpetable Date
ORDER_TOTAL_TRAN_COST	NUMBER		Total Transport Cost
DEL_ID	NUMBER		Deliver ID
SUBSHIPMENT_ID	NUMBER
DEL_ORIGIN_LOC_CODE	VARCHAR2	(10)	Delivery Origin Location Code
DEL_ORIGIN_LOC_NAME	VARCHAR2	(80)	Delivery Origin Location name
DEL_ORIGIN_LOC_CITY	VARCHAR2	(120)	Delivery Origin Location city
DEL_ORIGIN_LOC_STATE	VARCHAR2	(120)	Delivery Origin Location state
DEL_ORIGIN_LOC_ZIP	VARCHAR2	(60)	Delivery Origin Location postal code
DEL_DEST_LOC_CODE	VARCHAR2	(10)	Delivery Destination Location code
DEL_DEST_LOC_NAME	VARCHAR2	(80)	Delivery Destination Location name
DEL_DEST_LOC_CITY	VARCHAR2	(120)	Delivery Destination Location city
DEL_DEST_LOC_STATE	VARCHAR2	(120)	Delivery Destination Location state
DEL_DEST_LOC_ZIP	VARCHAR2	(60)	Delivery Destination Location postal code
DEL_PIECES	NUMBER		Total number of pieces in the delivery
DEL_WEIGHT	NUMBER		Gross weight of the delivery
DEL_CUBE	NUMBER		Delivery Volume
DEL_DEPART_DATE	VARCHAR2	(40)	Delivery Departure Date
DEL_ARR_DATE	VARCHAR2	(40)	Delivery Arrival Date
DEL_COST	NUMBER		Cost allocated to this delivery
LEG_SEQ_NUM	NUMBER
LEG_ID	NUMBER		Delviery Leg ID
LEG_MODE_OF_TRANS	VARCHAR2	(80)	TL / LTL / Parcel
LEG_CARRIER	VARCHAR2	(30)	Carrier Name
LEG_BOL	NUMBER		Trip Number
LEG_TL_STOP_SEQ_NUM_ORIG	NUMBER
LEG_TL_STOP_SEQ_NUM_DEST	NUMBER
LEG_ORIGIN_NAME	VARCHAR2	(80)	Delivery Leg Origin name
LEG_ORIGIN_POOL_FLAG	VARCHAR2	(4000)	Delivery Leg Origin is pooling location or not
LEG_ORIGIN_CITY	VARCHAR2	(120)	Delivery Leg Origin city
LEG_ORIGIN_STATE	VARCHAR2	(120)	Delivery Leg Origin state
LEG_DEST_NAME	VARCHAR2	(80)	Delivery Leg Destination name
LEG_DEST_POOL_FLAG	VARCHAR2	(4000)	Delivery Leg Destination is pooling location or not
LEG_DEST_CITY	VARCHAR2	(120)	Delivery Leg Destination city
LEG_DEST_STATE	VARCHAR2	(120)	Delivery Leg Destination state
LEG_DEPART_DATE	VARCHAR2	(20)	Departure Date
LEG_ARR_DATE	VARCHAR2	(20)	Arrival Date
LEG_TRANS_COST	NUMBER		Transportation cost allocated to this delivery leg

Query Text

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


SELECT PLAN_ID
,      REPORT_FLAVOR
,      OWNER_TYPE
,      FACILITY_ID
,      CUSTOMER_ID
,      SUPPLIER_ID
,      ORDER_TYPE
,      HOST_COMP_ORDER_REF
,      SUPP_CUST_ORDER_REF
,      ORDER_PIECES
,      ORDER_WEIGHT
,      ORDER_CUBE
,      ORDER_EARL_ALLOW_DATE
,      ORDER_LATEST_ALLOW_DATE
,      ORDER_TOTAL_TRAN_COST
,      DEL_ID
,      SUBSHIPMENT_ID
,      DEL_ORIGIN_LOC_CODE
,      DEL_ORIGIN_LOC_NAME
,      DEL_ORIGIN_LOC_CITY
,      DEL_ORIGIN_LOC_STATE
,      DEL_ORIGIN_LOC_ZIP
,      DEL_DEST_LOC_CODE
,      DEL_DEST_LOC_NAME
,      DEL_DEST_LOC_CITY
,      DEL_DEST_LOC_STATE
,      DEL_DEST_LOC_ZIP
,      DEL_PIECES
,      DEL_WEIGHT
,      DEL_CUBE
,      DEL_DEPART_DATE
,      DEL_ARR_DATE
,      DEL_COST
,      LEG_SEQ_NUM
,      LEG_ID
,      LEG_MODE_OF_TRANS
,      LEG_CARRIER
,      LEG_BOL
,      LEG_TL_STOP_SEQ_NUM_ORIG
,      LEG_TL_STOP_SEQ_NUM_DEST
,      LEG_ORIGIN_NAME
,      LEG_ORIGIN_POOL_FLAG
,      LEG_ORIGIN_CITY
,      LEG_ORIGIN_STATE
,      LEG_DEST_NAME
,      LEG_DEST_POOL_FLAG
,      LEG_DEST_CITY
,      LEG_DEST_STATE
,      LEG_DEPART_DATE
,      LEG_ARR_DATE
,      LEG_TRANS_COST
FROM APPS.MST_R_MASTER_ORDER_DET_V;

Dependencies

[top of page]

APPS.MST_R_MASTER_ORDER_DET_V references the following:

APPS: FTE_LOCATION_PARAMETERS; MST_DELIVERIES; MST_DELIVERY_ASSIGNMENTS; MST_DELIVERY_DETAILS; MST_DELIVERY_LEGS; MST_PLANS; MST_TRIPS; MST_TRIP_STOPS; MST_WB_UTIL - show dependent code; MTL_SYSTEM_ITEMS_KFV; MTL_SYSTEM_ITEMS_TL; WSH_CARRIERS; WSH_LOCATIONS; WSH_LOCATION_OWNERS; WSH_LOOKUPS

APPS.MST_R_MASTER_ORDER_DET_V is not referenced by any database object