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_AD_DELIVERY_DETAILS_V

Object Details

Object Name:	MST_AD_DELIVERY_DETAILS_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
DELIVERY_DETAIL_ID	NUMBER		Yes	FK to mst_delivery_details
SPLIT_FROM_DELIVERY_DETAIL_ID	NUMBER			Delivery detail identifier that the line is split from
CONTAINER_FLAG	NUMBER		Yes	1 for container and 2 for delivery details
VENDOR_ID	NUMBER			If delivery details is for ship from supplier or return to supplier
ORGANIZATION_ID	NUMBER			Ship from organization for outbound
SHIP_FROM_LOCATION_ID	NUMBER		Yes	fk to hr_locations
DESTINATION_ORGANIZATION_ID	NUMBER			ship to organization id for internal inbound/outbound
CUSTOMER_ID	NUMBER			FK to ra_customers (same as hz_cust_accounts.cust_acct_id)
SHIP_TO_LOCATION_ID	NUMBER			Location identifier for ship to destination. FK to hz_locations
EARLIEST_AVAILABLE_TO_SHIP	DATE			Date on which this line is to be first picked up
LATEST_AVAILABLE_TO_SHIP	DATE			Latest date on which this line can be picked up
EARLIEST_DELIVERY_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_DELIVERY_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)
NET_WEIGHT	NUMBER			Weight of this delivery detail
GROSS_WEIGHT	NUMBER			Gross Weight
VOLUME	NUMBER			Volume of delivery line
INVENTORY_ITEM_ID	NUMBER			Foreign key to MTTL_SYSTEM_ITEMS
SHIP_SET_ID	NUMBER			Ship set identifier for lines that need to be shipped together
ARRIVAL_SET_ID	NUMBER			Arrival set identifier for lines that need to be shipped together
SHIP_MODEL_COMPLETE_FLAG	NUMBER			1 = Yes, 2 => No
TOP_MODEL_LINE_ID	NUMBER			line_id of top model of this line
ORG_ID	NUMBER			Organization identifier
FREIGHT_CLASS_CAT_ID	NUMBER			Freight class category id
COMMODITY_CODE_CAT_ID	NUMBER			commodity code category. FK to MTL_ITEM_CATEGORY
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_HEADER_NUMBER	VARCHAR2	(50)		Customer PO Number, Supplier Sales Order Line Number or Shipper's Sales Order reference to return
REFERENCE_LINE_NUMBER	VARCHAR2	(50)		customer PO Line number, Supplier Sales Order Line number or Shipper's Sales Order Line reference to return line
REFERENCE_SOURCE_TYPE	VARCHAR2	(240)		Source type of the reference order SO, PO etc
TP_QUANTITY	NUMBER		Yes	Requested quantity for this customer
SOURCE_CODE	VARCHAR2	(30)	Yes	OE/WIP/PO
RELEASED_STATUS	NUMBER			1 => Backordered, 2=> Shipped 3 => Cancelled 4 => Note ready to release 5 => Picking is not required 6 => Released to WMS
CONTAINER_TYPE_CODE	VARCHAR2	(30)		Type of container. Box, Rack, Pallet etc., Coming from CONTAINER_TYPE lookup in inventory.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
WEIGHT_UOM_CODE	VARCHAR2	(0)
VOLUME_UOM_CODE	VARCHAR2	(0)
LINE_DIRECTION	NUMBER
UNIT_PRICE	NUMBER
CURRENCY_CODE	VARCHAR2	(0)
PO_SHIPMENT_LINE_NUMBER	NUMBER
REFRESH_NUMBER	NUMBER		Yes
ALLOCATED_COST	NUMBER
PLAN_ID	NUMBER		Yes
SRC_REQUESTED_QUANTITY	NUMBER
SRC_REQUESTED_QUANTITY_UOM	VARCHAR2	(3)
TP_DELIVERY_DETAIL_ID	NUMBER		Yes

Query Text

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


SELECT DELIVERY_DETAIL_ID
,      SPLIT_FROM_DELIVERY_DETAIL_ID
,      CONTAINER_FLAG
,      VENDOR_ID
,      ORGANIZATION_ID
,      SHIP_FROM_LOCATION_ID
,      DESTINATION_ORGANIZATION_ID
,      CUSTOMER_ID
,      SHIP_TO_LOCATION_ID
,      EARLIEST_AVAILABLE_TO_SHIP
,      LATEST_AVAILABLE_TO_SHIP
,      EARLIEST_DELIVERY_DATE
,      LATEST_DELIVERY_DATE
,      NET_WEIGHT
,      GROSS_WEIGHT
,      VOLUME
,      INVENTORY_ITEM_ID
,      SHIP_SET_ID
,      ARRIVAL_SET_ID
,      SHIP_MODEL_COMPLETE_FLAG
,      TOP_MODEL_LINE_ID
,      ORG_ID
,      FREIGHT_CLASS_CAT_ID
,      COMMODITY_CODE_CAT_ID
,      SOURCE_HEADER_NUMBER
,      SOURCE_LINE_NUMBER
,      REFERENCE_HEADER_NUMBER
,      REFERENCE_LINE_NUMBER
,      REFERENCE_SOURCE_TYPE
,      TP_QUANTITY
,      SOURCE_CODE
,      RELEASED_STATUS
,      CONTAINER_TYPE_CODE
,      CREATED_BY
,      WEIGHT_UOM_CODE
,      VOLUME_UOM_CODE
,      LINE_DIRECTION
,      UNIT_PRICE
,      CURRENCY_CODE
,      PO_SHIPMENT_LINE_NUMBER
,      REFRESH_NUMBER
,      ALLOCATED_COST
,      PLAN_ID
,      SRC_REQUESTED_QUANTITY
,      SRC_REQUESTED_QUANTITY_UOM
,      TP_DELIVERY_DETAIL_ID
FROM APPS.MST_AD_DELIVERY_DETAILS_V;

Dependencies

[top of page]

APPS.MST_AD_DELIVERY_DETAILS_V references the following:

APPS: MST_AD_DELIVERY_DETAILS; MST_DELIVERY_DETAILS

APPS.MST_AD_DELIVERY_DETAILS_V is not referenced by any database object