View: GML_OM_SHIP_DTL_VW

Product:	GMF - Process Manufacturing Financials
Description:	OBSOLETE:Selects the OM Shipments and their related information in OPM Inventory Transactions.
Implementation/DBA Data:	APPS.GML_OM_SHIP_DTL_VW

View Text

SELECT W.DELIVERY_ID
, WD.DELIVERY_DETAIL_ID
, WD.SOURCE_HEADER_ID
, WD.SOURCE_LINE_ID
, WD.FOB_CODE
, WD.NET_WEIGHT
, WD.WEIGHT_UOM_CODE
, OH.ORDER_NUMBER
, OL.LINE_NUMBER
, OL.SHIPPING_QUANTITY
, OL.SHIPPING_QUANTITY_UOM
, OL.UNIT_SELLING_PRICE
, T.ITEM_ID
, SUM(T.TRANS_QTY) IC_TRANS_QTY
, T.ORGN_CODE
, T.WHSE_CODE
, T.TRANS_UM
, T.COMPLETED_IND
, T.GL_POSTED_IND
FROM WSH_NEW_DELIVERIES W
, WSH_DELIVERY_ASSIGNMENTS WA
, WSH_DELIVERY_DETAILS WD
, OE_ORDER_HEADERS_ALL OH
, OE_ORDER_LINES_ALL OL
, IC_TRAN_PND T
WHERE W.DELIVERY_ID = WA.DELIVERY_ID
AND WA.DELIVERY_DETAIL_ID = WD.DELIVERY_DETAIL_ID
AND WD.SOURCE_CODE = 'OE'
AND WD.OE_INTERFACED_FLAG = 'Y'
AND WD.SOURCE_HEADER_ID = OH.HEADER_ID
AND WD.SOURCE_LINE_ID = OL.LINE_ID
AND WD.SOURCE_LINE_ID = T.LINE_ID
AND T.DOC_TYPE = 'OMSO'
AND T.COMPLETED_IND = 1
AND T.GL_POSTED_IND = 1
AND T.DELETE_MARK = 0 GROUP BY W.DELIVERY_ID
, WD.DELIVERY_DETAIL_ID
, WD.SOURCE_HEADER_ID
, WD.SOURCE_LINE_ID
, WD.FOB_CODE
, WD.NET_WEIGHT
, WD.WEIGHT_UOM_CODE
, OH.ORDER_NUMBER
, OL.LINE_NUMBER
, OL.SHIPPING_QUANTITY
, OL.SHIPPING_QUANTITY_UOM
, OL.UNIT_SELLING_PRICE
, T.ITEM_ID
, T.ORGN_CODE
, T.WHSE_CODE
, T.TRANS_UM
, T.COMPLETED_IND
, T.GL_POSTED_IND

Columns