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]

TABLE: MST.MST_DELIVERIES

Object Details

Object Name:	MST_DELIVERIES
Object Type:	TABLE
Owner:	MST
Subobject Name:
Status:	VALID

This is the entity that stores consolidated delivery line details and/or packages that belong to same source and destination location

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MST_DELIVERIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_ID DELIVERY_ID
MST_DELIVERIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID ORGANIZATION_ID
MST_DELIVERIES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID CUSTOMER_ID
MST_DELIVERIES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID CARRIER_ID SERVICE_LEVEL
MST_DELIVERIES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID PICKUP_LOCATION_ID
MST_DELIVERIES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID DROPOFF_LOCATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERY_ID	NUMBER		Yes	Primary key
SR_DELIVERY_ID	NUMBER			This column stores the source delivery id
PLAN_ID	NUMBER		Yes	FK to MST_PLANS
DELIVERY_NUMBER	NUMBER			TP Delivery Number
DESCRIPTION	VARCHAR2	(240)		Description of delivery
PLANNED_FLAG	NUMBER		Yes	1 => Firm Delivery, 2 => Not Firmed
EARLIEST_PICKUP_DATE	DATE			Date on which this delivery is to be first picked up. Derived from mst_delivery_details
LATEST_PICKUP_DATE	DATE			Latest date on which this delivery can be picked up. Derived from delivery details.
EARLIEST_ACCEPTABLE_DATE	DATE			Earliest date on which delivery needs to be delivered. Derived from delivery details.
LATEST_ACCEPTABLE_DATE	DATE			Latest date on which delivery needs to be delivered. Derived from delivery details.
PICKUP_DATE	DATE			For firm delivery in TE, user can specify at what date this delivery need to be picked up. Or this can be populated by deliveries created by TP.
DROPOFF_DATE	DATE			For firm delivery in TE, user can specify at what date this delivery need to be picked up. Or this can be populated by deliveries created by TP.
PICKUP_LOCATION_ID	NUMBER		Yes	Initial pick-up location of delivery. Foreign key to wsh_locations.
DROPOFF_LOCATION_ID	NUMBER		Yes	Final drop-off location of delivery. Foreign key to wsh_locations.
CARRIER_ID	NUMBER			Freight carrier
SERVICE_LEVEL	VARCHAR2	(30)		Service Level eg., D2D, 2 days, Overnight etc.,
MODE_OF_TRANSPORT	VARCHAR2	(30)		1 TRUCK, 2 LTL, 3 PARCEL, 4 AIR
DIRECT_COST	NUMBER			Cost of delivery if it is sent directly.
GROSS_WEIGHT	NUMBER			Gross weight
NET_WEIGHT	NUMBER			Net weight
VOLUME	NUMBER			Volume
NUMBER_OF_PALLETS	NUMBER			Number of pallets required for this delivery
NUMBER_OF_PIECES	NUMBER			Denormalize : number of packages and loose pieces
CUSTOMER_ID	NUMBER			Foreign key to hz_cust_accounts
ORGANIZATION_ID	NUMBER			SHIP_FROM_ORG_ID
DESTINATION_ORGANIZATION_ID	NUMBER			Ship to organization id for internal inbound/outbound
SUPPLIER_ID	NUMBER			Ship from supplier or ship to supplier for return to supplier or shipment from supplier case.
RELEASE_ERROR_MSG	VARCHAR2	(30)		Message to capture any errors during release
LOCKED_FOR_IMPACT	NUMBER			1 - locked by user's action, 2 - not locked
OUT_OF_SCOPE	NUMBER			1 => Out of scope delivery
PRESERVE_GROUPING_FLAG	NUMBER			1 => preserve group, 2 => not group firm
SHIPMENT_DIRECTION	NUMBER			I Inbound, O Outbound, D Dropship. Not displayed on UI.
STATUS_CODE	NUMBER			1 Open, 2 Confirmed, 3 In Transit, 4 Closed, 5 Shipment Requested
KNOWN_TE_FIRM_STATUS	NUMBER			This column stores the known TE firming status
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Query Text

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


SELECT DELIVERY_ID
,      SR_DELIVERY_ID
,      PLAN_ID
,      DELIVERY_NUMBER
,      DESCRIPTION
,      PLANNED_FLAG
,      EARLIEST_PICKUP_DATE
,      LATEST_PICKUP_DATE
,      EARLIEST_ACCEPTABLE_DATE
,      LATEST_ACCEPTABLE_DATE
,      PICKUP_DATE
,      DROPOFF_DATE
,      PICKUP_LOCATION_ID
,      DROPOFF_LOCATION_ID
,      CARRIER_ID
,      SERVICE_LEVEL
,      MODE_OF_TRANSPORT
,      DIRECT_COST
,      GROSS_WEIGHT
,      NET_WEIGHT
,      VOLUME
,      NUMBER_OF_PALLETS
,      NUMBER_OF_PIECES
,      CUSTOMER_ID
,      ORGANIZATION_ID
,      DESTINATION_ORGANIZATION_ID
,      SUPPLIER_ID
,      RELEASE_ERROR_MSG
,      LOCKED_FOR_IMPACT
,      OUT_OF_SCOPE
,      PRESERVE_GROUPING_FLAG
,      SHIPMENT_DIRECTION
,      STATUS_CODE
,      KNOWN_TE_FIRM_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM MST.MST_DELIVERIES;

Dependencies

[top of page]

MST.MST_DELIVERIES does not reference any database object

MST.MST_DELIVERIES is referenced by following:

APPS: MST_DELIVERIES