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_ORDER_DETAILS_V

Object Details

Object Name:	MST_PQ_ORDER_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	Primary key
PLAN_NAME	VARCHAR2	(10)	Yes	Why not simple plan_code?
SOURCE_LINE_NUMBER	VARCHAR2	(150)		User visible line number in source system
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)		Ref. type in Source system.
ORDER_NUMBER	VARCHAR2	(181)		Order number.
TP_REFER_HEADER_NUMBER	VARCHAR2	(50)		Ref. number in Source system.
CUSTOMER_ID	NUMBER			ID of the Customer for the Order.
SUPPLIER_ID	NUMBER			ID of the Supplier for the Order.
CUSTOMER_NAME	VARCHAR2	(80)		Name of the Customer for the Order.
SUPPLIER_NAME	VARCHAR2	(80)		Name of Supplier for the Order.
ORIGIN_FACILITY_ID	NUMBER		Yes	ID of the Origin Facility for the Order.
ORIGIN_FACILITY	VARCHAR2	(60)	Yes	Name of the Origin Facility for the Order.
ORIGIN_CITY	VARCHAR2	(120)		Origin City for the Order.
ORIGIN_STATE	VARCHAR2	(120)		Origin State for the Order.
ORIGIN_ZIP	VARCHAR2	(60)		Origin postal Code for the Order.
ORIGIN_COUNTRY	VARCHAR2	(120)		Origin Country for the Order.
DESTINATION_FACILITY_ID	NUMBER		Yes	ID of Destination Facility for the Order.
DESTINATION_FACILITY	VARCHAR2	(60)	Yes	ID of Destination Facility for the Order.
DESTINATION_CITY	VARCHAR2	(120)		ID of Destination Facility for the Order.
DESTINATION_STATE	VARCHAR2	(120)		ID of Destination Facility for the Order.
DESTINATION_ZIP	VARCHAR2	(60)		ID of Destination Facility for the Order.
DESTINATION_COUNTRY	VARCHAR2	(120)		ID of Destination Facility for the Order.
INVENTORY_ITEM_ID	NUMBER			ID of Inventory Item for the Order.
ITEM_NAME	VARCHAR2	(40)		Name of Inventory Item for the Order.
TOTAL_WEIGHT	NUMBER			Total Weight for the Order.
TOTAL_CUBE	NUMBER			Total Cube for the Order.
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
,      PLAN_NAME
,      SOURCE_LINE_NUMBER
,      SOURCE_CODE
,      SOURCE_HEADER_NUMBER
,      REFERENCE_SOURCE_TYPE
,      ORDER_NUMBER
,      TP_REFER_HEADER_NUMBER
,      CUSTOMER_ID
,      SUPPLIER_ID
,      CUSTOMER_NAME
,      SUPPLIER_NAME
,      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_ORDER_DETAILS_V;

Dependencies

[top of page]

APPS.MST_PQ_ORDER_DETAILS_V references the following:

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

APPS.MST_PQ_ORDER_DETAILS_V is not referenced by any database object