View: GMI_PICK_SLIP_VW

Product:	GMI - Process Manufacturing Inventory
Description:	This view is the basis of the OPM Pick Slip report (GMIRDPIK.rdf).
Implementation/DBA Data:	APPS.GMI_PICK_SLIP_VW

View Text

SELECT MOL.FROM_SUBINVENTORY_CODE FROM_SUBINVENTORY
, MOL.FROM_LOCATOR_ID FROM_LOCATOR_ID
, MOL.TO_SUBINVENTORY_CODE TO_SUBINVENTORY
, MOL.TO_LOCATOR_ID TO_LOCATOR_ID
, ITM.ITEM_NO ITEM_NO
, ITM.ITEM_ID ITEM_ID
, MTI.ORGANIZATION_ID ORGANIZATION_ID
, MTI.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MTI.DESCRIPTION ITEM_DESC
, ITP.LOT_ID LOT_ID
, LOT.LOT_NO LOT_NO
, LOT.SUBLOT_NO SUBLOT_NO
, ITP.LOCATION LOCATION
, ITP.TRANS_QTY*(-1) PRIMARY_QTY
, ITP.TRANS_UM TRANS_UM1
, ITP.TRANS_QTY2*(-1) SECONDARY_QTY
, ITP.TRANS_UM2 TRANS_UM2
, ITP.PICK_SLIP_NUMBER PICK_SLIP_NUMBER
, ITP.QC_GRADE QC_GRADE
, ITP.TRANS_DATE DETAILING_DATE
, MOH.REQUEST_NUMBER MO_NUMBER
, MOL.LINE_ID MOVE_ORDER_LINE_ID
, MOL.LINE_NUMBER MOVE_ORDER_LINE_NO
, DECODE(ITP.STAGED_IND
, 1
, 'PICKED'
, 'UNPICKED') LINE_STATUS
, ITP.LINE_ID TRANSACTION_ID
FROM IC_TRAN_PND ITP
, IC_LOTS_MST LOT
, IC_ITEM_MST ITM
, MTL_SYSTEM_ITEMS MTI
, IC_TXN_REQUEST_HEADERS MOH
, IC_TXN_REQUEST_LINES MOL
, WSH_DELIVERY_DETAILS WDD
WHERE ITP.DOC_TYPE = 'OMSO'
AND ITP.COMPLETED_IND = 0
AND ITP.DELETE_MARK = 0
AND ITP.PICK_SLIP_NUMBER > 0
AND ((ITP.LOT_ID > 0
AND ITM.LOT_CTL > 0) OR (ITP.LOT_ID = 0
AND ITM.LOT_CTL = 0))
AND ITP.ITEM_ID = LOT.ITEM_ID
AND ITP.LOT_ID = LOT.LOT_ID
AND ITP.LINE_ID = MOL.TXN_SOURCE_LINE_ID
AND ITM.ITEM_NO = MTI.SEGMENT1
AND MTI.ORGANIZATION_ID = MOL.ORGANIZATION_ID
AND MTI.INVENTORY_ITEM_ID = MOL.INVENTORY_ITEM_ID
AND MOH.HEADER_ID = MOL.HEADER_ID
AND MOL.LINE_ID = WDD.MOVE_ORDER_LINE_ID
AND MOL.TXN_SOURCE_LINE_ID = WDD.SOURCE_LINE_ID
AND WDD.DELIVERY_DETAIL_ID = ITP.LINE_DETAIL_ID

Columns