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_DELIVERY_DETAILS

Object Details

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

MST_DELIVERY_DETAILS has delivery lines and container records

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MST_DELIVERY_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_ID DELIVERY_DETAIL_ID
MST_DELIVERY_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID CUSTOMER_ID
MST_DELIVERY_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID SHIP_FROM_LOCATION_ID
MST_DELIVERY_DETAILS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID SHIP_TO_LOCATION_ID
MST_DELIVERY_DETAILS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID SOURCE_CODE SOURCE_HEADER_NUMBER
MST_DELIVERY_DETAILS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID SUPPLIER_ID
MST_DELIVERY_DETAILS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID CONTAINER_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERY_DETAIL_ID	NUMBER		Yes	primary key to identify delivery line
SR_DELIVERY_DETAIL_ID	NUMBER		Yes	PK in source system
PLAN_ID	NUMBER		Yes	plan id
ORGANIZATION_ID	NUMBER			Ship from organization for outbound
CUSTOMER_ID	NUMBER			FK to ra_customers (same as hz_cust_accounts.cust_acct_id)
SUPPLIER_ID	NUMBER			If delivery details is for ship from supplier or return to supplier
INVENTORY_ITEM_ID	NUMBER			Foreign key to MTTL_SYSTEM_ITEMS
REQUESTED_QUANTITY	NUMBER		Yes	Requested quantity for this customer
SRC_REQUESTED_QUANTITY	NUMBER			Requested Quantity in source system
SRC_REQUESTED_QUANTITY_UOM	VARCHAR2	(3)		UOM of the requested quantity in source system.
UNIT_PRICE	NUMBER			No impact on UI. Engine uses this for calculating penalty for late/early orders)
GROSS_WEIGHT	NUMBER			Gross Weight
NET_WEIGHT	NUMBER			Weight of this delivery detail
VOLUME	NUMBER			This column stores the gross volumn of the delivery details
ALLOCATED_COST	NUMBER			Cost allocated to this delivery detail
EARLIEST_PICKUP_DATE	DATE			Date on which this line is to be first picked up
LATEST_PICKUP_DATE	DATE			Latest date on which this line can be picked up
EARLIEST_ACCEPTABLE_DATE	DATE			Latest date on which the package needs to be delivered (this is present OE lines but may not be populated. If not poulated then use same as date_requested)
LATEST_ACCEPTABLE_DATE	DATE			Latest date at which this is to be delivered to customer (this is present OE lines but may not be populated. If not populated then use same as date_requested)
SHIP_FROM_LOCATION_ID	NUMBER		Yes	fk to hr_locations
SHIP_TO_LOCATION_ID	NUMBER			Location identifier for ship to destination. FK to hz_locations
SHIP_TO_SITE_ID	NUMBER			Site identifier for ship to site. Ship_to_org_id in oe_lines. FK to hz_cust_sites_uses_all.site_use_id. This can also be supplier site or internal site move orders from one org to other org.
SHIP_SET_ID	NUMBER			Ship set identifier for lines that need to be shipped together
SHIP_MODEL_COMPLETE_FLAG	NUMBER			1 = Yes, 2 => No
ARRIVAL_SET_ID	NUMBER			Arrival set identifier for lines that need to be shipped together
SPLIT_FROM_DELIVERY_DETAIL_ID	NUMBER			Delivery detail identifier that the line is split from
ORG_ID	NUMBER			Organization identifier
COMMODITY_CODE_CAT_ID	NUMBER			commodity code category. FK to MTL_ITEM_CATEGORY
FREIGHT_CLASS_CAT_ID	NUMBER			Freight class category id
CARRIER_ID	NUMBER			freight carrier
DESTINATION_ORGANIZATION_ID	NUMBER			ship to organization id for internal inbound/outbound
TOP_MODEL_LINE_ID	NUMBER			stores the top model for this delivery detail line. All lines with the same top model line id should be shipped together
NUMBER_OF_PALLETS	NUMBER			Number of pallets required for this delivery details.
CONTAINER_NAME	VARCHAR2	(50)		Name of the package given in TE/WMS
CONTAINER_TYPE_CODE	VARCHAR2	(30)		Type of container. Box, Rack, Pallet etc., Coming from CONTAINER_TYPE lookup in inventory.
CONTAINER_FLAG	NUMBER		Yes	1 for container and 2 for delivery details
SOURCE_CODE	VARCHAR2	(30)	Yes	OE/WIP/PO
SOURCE_HEADER_NUMBER	VARCHAR2	(150)		The user visible identifier for the header, ex. Order number
SOURCE_LINE_NUMBER	VARCHAR2	(150)		User visible line number in source system
REFERENCE_SOURCE_TYPE	VARCHAR2	(240)		Source type of the reference order SO, PO etc
TP_REFER_HEADER_NUMBER	VARCHAR2	(50)		Customer PO Number, Supplier Sales Order Line Number or Shipper's Sales Order reference to return
TP_REFERENCE_LINE_NUMBER	VARCHAR2	(50)		customer PO Line number, Supplier Sales Order Line number or Shipper's Sales Order Line reference to return line
PO_SHIPMENT_LINE_NUMBER	NUMBER			PO shipment line number. Populated for PO lines.
RELEASED_STATUS	NUMBER			1 => Backordered, 2=> Shipped 3 => Cancelled 4 => Note ready to release 5 => Picking is not required 6 => Released to WMS
OUT_OF_SCOPE	VARCHAR2	(240)		Out of scope delivery details
SERVICE_LEVEL	VARCHAR2	(30)		service level
MODE_OF_TRANSPORT	VARCHAR2	(30)		TL, LTL, PARCEL
LINE_DIRECTION	NUMBER			I Inbound, O Outbound, D Dropship. Not displayed on UI.
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_DETAIL_ID
,      SR_DELIVERY_DETAIL_ID
,      PLAN_ID
,      ORGANIZATION_ID
,      CUSTOMER_ID
,      SUPPLIER_ID
,      INVENTORY_ITEM_ID
,      REQUESTED_QUANTITY
,      SRC_REQUESTED_QUANTITY
,      SRC_REQUESTED_QUANTITY_UOM
,      UNIT_PRICE
,      GROSS_WEIGHT
,      NET_WEIGHT
,      VOLUME
,      ALLOCATED_COST
,      EARLIEST_PICKUP_DATE
,      LATEST_PICKUP_DATE
,      EARLIEST_ACCEPTABLE_DATE
,      LATEST_ACCEPTABLE_DATE
,      SHIP_FROM_LOCATION_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_SITE_ID
,      SHIP_SET_ID
,      SHIP_MODEL_COMPLETE_FLAG
,      ARRIVAL_SET_ID
,      SPLIT_FROM_DELIVERY_DETAIL_ID
,      ORG_ID
,      COMMODITY_CODE_CAT_ID
,      FREIGHT_CLASS_CAT_ID
,      CARRIER_ID
,      DESTINATION_ORGANIZATION_ID
,      TOP_MODEL_LINE_ID
,      NUMBER_OF_PALLETS
,      CONTAINER_NAME
,      CONTAINER_TYPE_CODE
,      CONTAINER_FLAG
,      SOURCE_CODE
,      SOURCE_HEADER_NUMBER
,      SOURCE_LINE_NUMBER
,      REFERENCE_SOURCE_TYPE
,      TP_REFER_HEADER_NUMBER
,      TP_REFERENCE_LINE_NUMBER
,      PO_SHIPMENT_LINE_NUMBER
,      RELEASED_STATUS
,      OUT_OF_SCOPE
,      SERVICE_LEVEL
,      MODE_OF_TRANSPORT
,      LINE_DIRECTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM MST.MST_DELIVERY_DETAILS;

Dependencies

[top of page]

MST.MST_DELIVERY_DETAILS does not reference any database object

MST.MST_DELIVERY_DETAILS is referenced by following:

APPS: MST_DELIVERY_DETAILS