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_ORG_ORDERS_V

Object Details

Object Name:	MST_ORG_ORDERS_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		FK to PLAN_ID of MST_PLANS.
FACILITY_ID	NUMBER		ID of facility related to Orders.
SOURCE_CODE	VARCHAR2	(30)	Order Source code.
SOURCE_HEADER_NUMBER	VARCHAR2	(150)	Order Number.
TP_REFER_HEADER_NUMBER	VARCHAR2	(50)	TP reference Number for the order.
REFERENCE_SOURCE_TYPE	VARCHAR2	(240)	Source type of reference Order.
COST	NUMBER		Cost related to Order.
WEIGHT	NUMBER		Weight related to Order.
CUBE	NUMBER		Cube related to Order.
PALLETS	NUMBER		Pallets related to Order.
PIECES	NUMBER		Pieces related to Order.
CURRENCY_UOM	VARCHAR2	(3)	Unit of Measure for Cost.
WEIGHT_UOM	VARCHAR2	(3)	Unit of Measure for Weight.
VOLUME_UOM	VARCHAR2	(3)	Unit of Measure for Volume.
ORIGIN_COMPANY	CHAR	(11)	Company Name of Origin Facility for the order.
ORG_FACILITY_ID	NUMBER		ID of Org. Facility.
ORIGIN_FACILITY	CHAR	(11)	Name of Org. Facility.
ORIGIN_CITY	CHAR	(11)	Origin City for the order.
ORIGIN_STATE	CHAR	(11)	Origin State for the order.
ORIGIN_COUNTRY	CHAR	(11)	Origin Country for the order.
ORIGIN_ZIP	CHAR	(11)	Origin Postal Code for the order.
DESTINATION_COMPANY	CHAR	(11)	Company Name of Destination Facility for the Order.
DEST_FACILITY_ID	NUMBER		ID of Destination Facility for the Order.
DESTINATION_FACILITY	CHAR	(11)	Name of Destination Facility for the Order.
DESTINATION_CITY	CHAR	(11)	Destination City for the Order.
DESTINATION_STATE	CHAR	(11)	Destination State for the Order.
DESTINATION_COUNTRY	CHAR	(11)	Destination Country for the Order.
DESTINATION_ZIP	CHAR	(11)	Destination Postal Code for the Order.
EARLIEST_PICKUP_DATE	CHAR	(11)	Early Pickup date for the Order.
LATEST_PICKUP_DATE	CHAR	(11)	Latest Pickup date for the Order.
EARLIEST_ACCEPTABLE_DATE	CHAR	(11)	Early Delivery date for the Order.
LATEST_ACCEPTABLE_DATE	CHAR	(11)	Latest delivery date for the Order.

Query Text

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


SELECT PLAN_ID
,      FACILITY_ID
,      SOURCE_CODE
,      SOURCE_HEADER_NUMBER
,      TP_REFER_HEADER_NUMBER
,      REFERENCE_SOURCE_TYPE
,      COST
,      WEIGHT
,      CUBE
,      PALLETS
,      PIECES
,      CURRENCY_UOM
,      WEIGHT_UOM
,      VOLUME_UOM
,      ORIGIN_COMPANY
,      ORG_FACILITY_ID
,      ORIGIN_FACILITY
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_COUNTRY
,      ORIGIN_ZIP
,      DESTINATION_COMPANY
,      DEST_FACILITY_ID
,      DESTINATION_FACILITY
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_COUNTRY
,      DESTINATION_ZIP
,      EARLIEST_PICKUP_DATE
,      LATEST_PICKUP_DATE
,      EARLIEST_ACCEPTABLE_DATE
,      LATEST_ACCEPTABLE_DATE
FROM APPS.MST_ORG_ORDERS_V;

Dependencies

[top of page]

APPS.MST_ORG_ORDERS_V references the following:

APPS: FTE_LOCATION_PARAMETERS; MST_DELIVERIES; MST_DELIVERY_ASSIGNMENTS; MST_DELIVERY_DETAILS; MST_DELIVERY_LEGS; MST_PLANS; MST_TRIP_STOPS; WSH_LOCATIONS

APPS.MST_ORG_ORDERS_V is not referenced by any database object