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.

VIEW: APPS.GMI_WSH_PICK_SLIP_V

Source

View Text - Preformatted


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.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, 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, 'UNPICKED' LINE_STATUS, ITP.LINE_ID TRANSACTION_ID FROM IC_TXN_REQUEST_HEADERS MOH, IC_LOTS_MST LOT, IC_TRAN_PND ITP, IC_ITEM_MST ITM, MTL_SYSTEM_ITEMS MTI, IC_TXN_REQUEST_LINES MOL WHERE MOH.HEADER_ID = MOL.HEADER_ID AND ITP.LOT_ID = LOT.LOT_ID AND ITP.ITEM_ID = LOT.ITEM_ID 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.STAGED_IND = 0 AND ITP.DELETE_MARK = 0 AND ITP.COMPLETED_IND = 0 AND ITP.DOC_TYPE='OMSO' AND ITP.ITEM_ID = ITM.ITEM_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 UNION ALL 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.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, 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, 'PICKED' LINE_STATUS, ITP.LINE_ID TRANSACTION_ID FROM IC_TXN_REQUEST_HEADERS MOH, IC_LOTS_MST LOT, IC_TRAN_PND ITP, IC_ITEM_MST_B ITM, MTL_SYSTEM_ITEMS MTI, IC_TXN_REQUEST_LINES MOL WHERE MOH.HEADER_ID = MOL.HEADER_ID AND ITP.LOT_ID = LOT.LOT_ID AND ITP.ITEM_ID = LOT.ITEM_ID 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.STAGED_IND = 1 AND ITP.DELETE_MARK = 0 AND ITP.COMPLETED_IND = 0 AND ITP.DOC_TYPE='OMSO' AND ITP.ITEM_ID = ITM.ITEM_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

View Text - HTML Formatted

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.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, 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
, 'UNPICKED' LINE_STATUS
, ITP.LINE_ID TRANSACTION_ID
FROM IC_TXN_REQUEST_HEADERS MOH
, IC_LOTS_MST LOT
, IC_TRAN_PND ITP
, IC_ITEM_MST ITM
, MTL_SYSTEM_ITEMS MTI
, IC_TXN_REQUEST_LINES MOL
WHERE MOH.HEADER_ID = MOL.HEADER_ID
AND ITP.LOT_ID = LOT.LOT_ID
AND ITP.ITEM_ID = LOT.ITEM_ID
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.STAGED_IND = 0
AND ITP.DELETE_MARK = 0
AND ITP.COMPLETED_IND = 0
AND ITP.DOC_TYPE='OMSO'
AND ITP.ITEM_ID = ITM.ITEM_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 UNION ALL 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.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, 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
, 'PICKED' LINE_STATUS
, ITP.LINE_ID TRANSACTION_ID
FROM IC_TXN_REQUEST_HEADERS MOH
, IC_LOTS_MST LOT
, IC_TRAN_PND ITP
, IC_ITEM_MST_B ITM
, MTL_SYSTEM_ITEMS MTI
, IC_TXN_REQUEST_LINES MOL
WHERE MOH.HEADER_ID = MOL.HEADER_ID
AND ITP.LOT_ID = LOT.LOT_ID
AND ITP.ITEM_ID = LOT.ITEM_ID
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.STAGED_IND = 1
AND ITP.DELETE_MARK = 0
AND ITP.COMPLETED_IND = 0
AND ITP.DOC_TYPE='OMSO'
AND ITP.ITEM_ID = ITM.ITEM_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