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_PQ_UA_DEL_DETAILS_V

Object Details

Object Name:	MST_PQ_UA_DEL_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
PLAN_ID	NUMBER		Yes	FK to MST_PLANS
DELIVERY_ID	NUMBER		Yes	ID of the Unassigned delivery.
CUSTOMER_ID	NUMBER			ID of the Customer for Unassigned delivery.
CUSTOMER_NAME	VARCHAR2	(80)		Name of the customer of the Unassigned delivery.
SUPPLIER_ID	NUMBER
SUPPLIER_NAME	VARCHAR2	(80)		Name of the customer of the Unassigned delivery.
DELIVERY_DETAIL_ID	NUMBER		Yes	Delivery Detail of the Unassigned delivery.
DELIVERY_NUMBER	NUMBER			TP Delivery Number
SOURCE_CODE	VARCHAR2	(30)	Yes	OE/WIP/PO
SOURCE_HEADER_NUMBER	VARCHAR2	(150)		The user visible identifier for the header, ex. Order number
REFERENCE_SOURCE_TYPE	VARCHAR2	(240)		Source type of the reference order SO, PO etc
ORIGIN_FACILITY_ID	NUMBER		Yes	ID of the Origin Facility of the Unassigned delivery.
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	Name of the Origin Facility of the Unassigned delivery.
ORIGIN_CITY	VARCHAR2	(120)		Origin City of the Unassigned delivery.
ORIGIN_STATE	VARCHAR2	(120)		Origin State of the Unassigned delivery.
ORIGIN_ZIP	VARCHAR2	(60)		Origin Postal Code of the Unassigned delivery.
ORIGIN_COUNTRY	VARCHAR2	(120)		Origin Country of the Unassigned delivery.
DESTINATION_FACILITY_ID	NUMBER		Yes	ID of the Destination Facility of the Unassigned delivery.
DESTINATION_FACILITY	VARCHAR2	(60)	Yes	Name of the Destination Facility of the Unassigned delivery.
DESTINATION_CITY	VARCHAR2	(120)		Destination of the Unassigned delivery.
DESTINATION_STATE	VARCHAR2	(120)		Destination of the Unassigned delivery.
DESTINATION_ZIP	VARCHAR2	(60)		Destination Postal Code of the Unassigned delivery.
DESTINATION_COUNTRY	VARCHAR2	(120)		Destination Country of the Unassigned delivery.
INVENTORY_ITEM_ID	NUMBER			ID of Inventory Item of the Unassigned delivery.
ITEM_NAME	VARCHAR2	(40)		Name of Inventory Item of the Unassigned delivery.
TOTAL_WEIGHT	NUMBER			Total Weight in the Unassigned delivery.
TOTAL_CUBE	NUMBER			Total Cube in the Unassigned 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
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      DELIVERY_DETAIL_ID
,      DELIVERY_NUMBER
,      SOURCE_CODE
,      SOURCE_HEADER_NUMBER
,      REFERENCE_SOURCE_TYPE
,      ORIGIN_FACILITY_ID
,      ORIGIN_FACILITY
,      ORIGIN_CITY
,      ORIGIN_STATE
,      ORIGIN_ZIP
,      ORIGIN_COUNTRY
,      DESTINATION_FACILITY_ID
,      DESTINATION_FACILITY
,      DESTINATION_CITY
,      DESTINATION_STATE
,      DESTINATION_ZIP
,      DESTINATION_COUNTRY
,      INVENTORY_ITEM_ID
,      ITEM_NAME
,      TOTAL_WEIGHT
,      TOTAL_CUBE
,      WEIGHT_UOM
,      VOLUME_UOM
FROM APPS.MST_PQ_UA_DEL_DETAILS_V;

Dependencies

[top of page]

APPS.MST_PQ_UA_DEL_DETAILS_V references the following:

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

APPS.MST_PQ_UA_DEL_DETAILS_V is not referenced by any database object