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_DELIVERY_LINES_V

Object Details

Object Name:	MST_DELIVERY_LINES_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 PLAN_ID of MST_PLANS
DELIVERY_ID	NUMBER		Yes	Unique Identifier for the Delivery. FK to DELIVERY_ID of MST_DELIVERIES.
DELIVERY_DETAIL_ID	NUMBER			Unique identifer for Delivery line. FK to DELIVERY_DETAIL_ID of MST_DELIVERY_DETAILS.
DELIVERY_NUMBER	NUMBER			Unique Delivery Number in a Plan.
SOURCE_LINE_NUMBER	VARCHAR2	(150)		User visible line number in source system
TRIP_ID	NUMBER			FK to TRIP_ID of MST_TRIPS.
SOURCE_CODE	VARCHAR2	(30)	Yes	OE/WIP/PO
SOURCE_HEADER_NUMBER	VARCHAR2	(150)		The user visible identifier for the header, ex. Order number
TP_REFER_HEADER_NUMBER	VARCHAR2	(50)		Customer PO Number, Supplier Sales Order Line Number or Shipper's Sales Order reference to return
REFERENCE_SOURCE_TYPE	VARCHAR2	(240)		Source type of the reference order SO, PO etc
SHIP_FROM_LOCATION_ID	NUMBER		Yes	Delivery Origin Location. FK to WSH_LOCATION_ID of WSH_LOCATIONS.
SHIP_TO_LOCATION_ID	NUMBER			Delivery Destination Location. FK to WSH_LOCATION_ID of WSH_LOCATIONS.
PICK_UP_STOP_ID	NUMBER		Yes	Pick-up stop identifier for the Delivery Leg. FK to STOP_ID of MST_TRIP_STOPS.
DROP_OFF_STOP_ID	NUMBER		Yes	Drop-off stop identifier for the Delivery Leg. FK to STOP_ID of MST_TRIP_STOPS.
ORIGIN_COMPANY	VARCHAR2	(80)		Company Name of Origin Facility of the Delivery.
ORIGIN_FACILITY_ID	NUMBER		Yes	ID of Origin Facility of the Delivery.
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	Name of Origin Facility of the Delivery.
ORIGIN_DESCRIPTION	VARCHAR2	(250)		Description of Origin Facility of the Delivery.
ORIGIN_CITY	VARCHAR2	(120)		Origin City of the Delivery.
ORIGIN_STATE	VARCHAR2	(120)		Origin State of the Delivery.
ORIGIN_ZIP	VARCHAR2	(60)		Origin Postal Code of the Delivery.
ORIGIN_COUNTRY	VARCHAR2	(120)		Origin Country of the Delivery.
DESTINATION_COMPANY	VARCHAR2	(80)		Company Name of Destination Facility of the Delivery.
DESTINATION_FACILITY_ID	NUMBER		Yes	ID of Destination Facility of the Delivery.
DESTINATION_FACILITY	VARCHAR2	(60)	Yes	Name of Destination Facility of the Delivery.
DESTINATION_DESCRIPTION	VARCHAR2	(250)		Description of Destination Facility of the Delivery.
DESTINATION_CITY	VARCHAR2	(120)		Destination City of the Delivery.
DESTINATION_STATE	VARCHAR2	(120)		Destination State of the Delivery.
DESTINATION_ZIP	VARCHAR2	(60)		Destination Postal Code of the Delivery.
DESTINATION_COUNTRY	VARCHAR2	(120)		Destination Country of the Delivery.
INVENTORY_ITEM_ID	NUMBER			ID of Item in the Delivery.
ITEM_NAME	VARCHAR2	(40)		Name of Item in the Delivery.
ITEM_DESCRIPTION	VARCHAR2	(240)		Description of Item in the Delivery.
EARLIEST_PICKUP_DATE_TIME	VARCHAR2	(80)		Early Pickup date of the Delivery.
LATEST_PICKUP_DATE_TIME	VARCHAR2	(80)		Latest Pickup date of the Delivery.
EARLIEST_ACCEPTABLE_DATE_TIME	VARCHAR2	(80)		Early Acceptable date at destination of the Delivery.
LATEST_ACCEPTABLE_DATE_TIME	VARCHAR2	(80)		Latest Acceptable date at Destination of the Delivery.
EARLY_PICKUP_DATE_HIDDEN	DATE			Hidden Field for Early Pickup date.
LATEST_PICKUP_DATE_HIDDEN	DATE			Hidden Field for Latest Pickup date.
EARLY_ACCEPTABLE_DATE_HIDDEN	DATE			Hidden Field for Early Acceptable date.
LATEST_ACCEPTABLE_DATE_HIDDEN	DATE			Hidden Field for Latest Acceptable date.
WEIGHT	NUMBER			Weight related to Delivery.
CUBE	NUMBER			Cube related to Delivery.
PALLETS	NUMBER			Pallets related to Delivery.
PIECES	NUMBER		Yes	Pieces related to Delivery.
WEIGHT_UOM	VARCHAR2	(3)		Unit of Measure for Weight.
VOLUME_UOM	VARCHAR2	(3)		Unit of Measure for Volume.

Query Text

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


SELECT PLAN_ID
,      DELIVERY_ID
,      DELIVERY_DETAIL_ID
,      DELIVERY_NUMBER
,      SOURCE_LINE_NUMBER
,      TRIP_ID
,      SOURCE_CODE
,      SOURCE_HEADER_NUMBER
,      TP_REFER_HEADER_NUMBER
,      REFERENCE_SOURCE_TYPE
,      SHIP_FROM_LOCATION_ID
,      SHIP_TO_LOCATION_ID
,      PICK_UP_STOP_ID
,      DROP_OFF_STOP_ID
,      ORIGIN_COMPANY
,      ORIGIN_FACILITY_ID
,      ORIGIN_FACILITY
,      ORIGIN_DESCRIPTION
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_COMPANY
,      DESTINATION_FACILITY_ID
,      DESTINATION_FACILITY
,      DESTINATION_DESCRIPTION
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      INVENTORY_ITEM_ID
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      EARLIEST_PICKUP_DATE_TIME
,      LATEST_PICKUP_DATE_TIME
,      EARLIEST_ACCEPTABLE_DATE_TIME
,      LATEST_ACCEPTABLE_DATE_TIME
,      EARLY_PICKUP_DATE_HIDDEN
,      LATEST_PICKUP_DATE_HIDDEN
,      EARLY_ACCEPTABLE_DATE_HIDDEN
,      LATEST_ACCEPTABLE_DATE_HIDDEN
,      WEIGHT
,      CUBE
,      PALLETS
,      PIECES
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_DELIVERY_LINES_V;

Dependencies

[top of page]

APPS.MST_DELIVERY_LINES_V references the following:

APPS: FTE_LOCATION_PARAMETERS; MST_DELIVERIES; MST_DELIVERY_ASSIGNMENTS; MST_DELIVERY_DETAILS; MST_DELIVERY_LEGS; MST_GEOCODING - show dependent code; MST_PLANS; MST_WB_UTIL - show dependent code; MTL_SYSTEM_ITEMS_KFV; MTL_SYSTEM_ITEMS_TL; WSH_LOCATIONS

APPS.MST_DELIVERY_LINES_V is not referenced by any database object