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_WSH_DEL_DET_WFIRMDEL_V

Object Details

Object Name:	MST_WSH_DEL_DET_WFIRMDEL_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
SPLIT_FROM_DELIVERY_DETAIL_ID	NUMBER
CONTAINER_FLAG	VARCHAR2	(1)
VENDOR_ID	NUMBER
ORGANIZATION_ID	NUMBER
SHIP_FROM_LOCATION_ID	NUMBER		Yes
DESTINATION_ORGANIZATION_ID	NUMBER
CUSTOMER_ID	NUMBER
SHIP_TO_LOCATION_ID	NUMBER
EARLIEST_AVAILABLE_TO_SHIP	DATE
LATEST_AVAILABLE_TO_SHIP	DATE
EARLIEST_DELIVERY_DATE	DATE
LATEST_DELIVERY_DATE	DATE
NET_WEIGHT	NUMBER
GROSS_WEIGHT	NUMBER
VOLUME	NUMBER
INVENTORY_ITEM_ID	NUMBER
SHIP_SET_ID	NUMBER
ARRIVAL_SET_ID	NUMBER
SHIP_MODEL_COMPLETE_FLAG	VARCHAR2	(1)
TOP_MODEL_LINE_ID	NUMBER
ORG_ID	NUMBER			Organization identifier
FREIGHT_CLASS_CAT_ID	NUMBER
COMMODITY_CODE_CAT_ID	NUMBER
SOURCE_HEADER_NUMBER	VARCHAR2	(150)
SOURCE_LINE_NUMBER	VARCHAR2	(150)
REFERENCE_HEADER_NUMBER	VARCHAR2	(50)
REFERENCE_LINE_NUMBER	VARCHAR2	(0)
REFERENCE_SOURCE_TYPE	VARCHAR2	(2)
TP_QUANTITY	NUMBER
TP_QUANTITY_TYPE	VARCHAR2	(9)
SOURCE_CODE	VARCHAR2	(30)	Yes
SOURCE_DOCUMENT_TYPE_ID	NUMBER
RELEASED_STATUS	VARCHAR2	(1)
CONTAINER_TYPE_CODE	VARCHAR2	(30)
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
WEIGHT_UOM_CODE	VARCHAR2	(3)
VOLUME_UOM_CODE	VARCHAR2	(3)
IGNORE_FOR_PLANNING	VARCHAR2	(1)
LINE_DIRECTION	VARCHAR2	(30)
UNIT_PRICE	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
OSP_FLAG	VARCHAR2	(1)
FREIGHT_TERMS_CODE	VARCHAR2	(30)
DETAIL_TYPE	NUMBER
PO_SHIPMENT_LINE_NUMBER	NUMBER
ALLOCATED_COST	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(250)
SRC_REQUESTED_QUANTITY	NUMBER
SRC_REQUESTED_QUANTITY_UOM	VARCHAR2	(3)
DEL_EARLIEST_AVAILABLE_TO_SHIP	DATE			Earliest available to ship date
DEL_LATEST_AVAILABLE_TO_SHIP	DATE			Latest available to ship date
DELIVERY_ID	NUMBER		Yes	FK to mst_deliveries

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
,      TP_QUANTITY_TYPE
,      SOURCE_CODE
,      SOURCE_DOCUMENT_TYPE_ID
,      RELEASED_STATUS
,      CONTAINER_TYPE_CODE
,      CREATED_BY
,      LAST_UPDATED_BY
,      WEIGHT_UOM_CODE
,      VOLUME_UOM_CODE
,      IGNORE_FOR_PLANNING
,      LINE_DIRECTION
,      UNIT_PRICE
,      CURRENCY_CODE
,      OSP_FLAG
,      FREIGHT_TERMS_CODE
,      DETAIL_TYPE
,      PO_SHIPMENT_LINE_NUMBER
,      ALLOCATED_COST
,      ITEM_DESCRIPTION
,      SRC_REQUESTED_QUANTITY
,      SRC_REQUESTED_QUANTITY_UOM
,      DEL_EARLIEST_AVAILABLE_TO_SHIP
,      DEL_LATEST_AVAILABLE_TO_SHIP
,      DELIVERY_ID
FROM APPS.MST_WSH_DEL_DET_WFIRMDEL_V;

Dependencies

[top of page]

APPS.MST_WSH_DEL_DET_WFIRMDEL_V references the following:

APPS: MST_PO_LOCATION_ASSO_V; MST_WSH_NEW_DELIVERIES_V; WSH_DELIVERY_ASSIGNMENTS; WSH_DELIVERY_DETAILS

APPS.MST_WSH_DEL_DET_WFIRMDEL_V is not referenced by any database object