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.GML_OM_SHIP_DTL_VW

Object Details

Object Name:	GML_OM_SHIP_DTL_VW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.GML_OM_SHIP_DTL_VW
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

OBSOLETE:Selects the OM Shipments and their related information in OPM Inventory Transactions.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERY_ID	NUMBER		Yes	Delivery Id
DELIVERY_DETAIL_ID	NUMBER		Yes	Delivery Detail Id
SOURCE_HEADER_ID	NUMBER			Source Header Id
SOURCE_LINE_ID	NUMBER		Yes	Source Line Id
FOB_CODE	VARCHAR2	(30)		Fob Code
NET_WEIGHT	NUMBER			Net Weight
WEIGHT_UOM_CODE	VARCHAR2	(3)		Weight Uom Code
ORDER_NUMBER	NUMBER		Yes	Order Number
LINE_NUMBER	NUMBER		Yes	Line Number
SHIPPING_QUANTITY	NUMBER			Shipping Quantity
SHIPPING_QUANTITY_UOM	VARCHAR2	(3)		Shipping Quantity Uom
UNIT_SELLING_PRICE	NUMBER			Unit Selling Price
ITEM_ID	NUMBER	(10)	Yes	Item Id
IC_TRANS_QTY	NUMBER			Ic Trans Qty
ORGN_CODE	VARCHAR2	(4)	Yes	Orgn Code
WHSE_CODE	VARCHAR2	(4)	Yes	Whse Code
TRANS_UM	VARCHAR2	(4)	Yes	Trans Um
COMPLETED_IND	NUMBER	(5)	Yes	Completed Ind
GL_POSTED_IND	NUMBER	(10)	Yes	Gl Posted Ind

Query Text

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


SELECT DELIVERY_ID
,      DELIVERY_DETAIL_ID
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      FOB_CODE
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      ORDER_NUMBER
,      LINE_NUMBER
,      SHIPPING_QUANTITY
,      SHIPPING_QUANTITY_UOM
,      UNIT_SELLING_PRICE
,      ITEM_ID
,      IC_TRANS_QTY
,      ORGN_CODE
,      WHSE_CODE
,      TRANS_UM
,      COMPLETED_IND
,      GL_POSTED_IND
FROM APPS.GML_OM_SHIP_DTL_VW;

Dependencies

[top of page]

APPS.GML_OM_SHIP_DTL_VW references the following:

APPS: IC_TRAN_PND; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; WSH_DELIVERY_ASSIGNMENTS; WSH_DELIVERY_DETAILS; WSH_NEW_DELIVERIES

APPS.GML_OM_SHIP_DTL_VW is not referenced by any database object