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

Source

View Text - Preformatted


SELECT subinventory_code from_subinventory, locator_id from_locator_id, transfer_subinventory to_subinventory, transfer_to_location to_locator_id, abs(primary_quantity) primary_qty, pick_slip_number, creation_date detailing_date, move_order_line_id, 'UNPICKED' line_status, transaction_temp_id transaction_id, item_primary_uom_code, secondary_transaction_quantity, secondary_uom_code FROM mtl_material_transactions_temp WHERE pick_slip_number IS NOT NULL AND abs(nvl(transaction_quantity,0)) > 0 UNION ALL SELECT subinventory_code from_subinventory, locator_id from_locator_id, transfer_subinventory to_subinventory, transfer_locator_id to_locator_id, abs(primary_quantity) primary_qty, pick_slip_number, transaction_date detailing_date, move_order_line_id, 'PICKED' line_status, transaction_id, transaction_uom, secondary_transaction_quantity, secondary_uom_code FROM mtl_material_transactions WHERE pick_slip_number IS NOT NULL AND nvl(transaction_quantity,0) < 0 UNION ALL SELECT from_subinventory_code from_subinventory, from_locator_id, to_subinventory_code to_subinventory, to_locator_id, abs(primary_quantity) primary_quantity, pick_slip_number, pick_slip_date detailing_date, line_id move_order_line_id, 'PICKED' line_status, to_number(null) transaction_id, uom_code, secondary_quantity, secondary_uom_code FROM mtl_txn_request_lines WHERE pick_slip_number is not null

View Text - HTML Formatted

SELECT SUBINVENTORY_CODE FROM_SUBINVENTORY
, LOCATOR_ID FROM_LOCATOR_ID
, TRANSFER_SUBINVENTORY TO_SUBINVENTORY
, TRANSFER_TO_LOCATION TO_LOCATOR_ID
, ABS(PRIMARY_QUANTITY) PRIMARY_QTY
, PICK_SLIP_NUMBER
, CREATION_DATE DETAILING_DATE
, MOVE_ORDER_LINE_ID
, 'UNPICKED' LINE_STATUS
, TRANSACTION_TEMP_ID TRANSACTION_ID
, ITEM_PRIMARY_UOM_CODE
, SECONDARY_TRANSACTION_QUANTITY
, SECONDARY_UOM_CODE
FROM MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE PICK_SLIP_NUMBER IS NOT NULL
AND ABS(NVL(TRANSACTION_QUANTITY
, 0)) > 0 UNION ALL SELECT SUBINVENTORY_CODE FROM_SUBINVENTORY
, LOCATOR_ID FROM_LOCATOR_ID
, TRANSFER_SUBINVENTORY TO_SUBINVENTORY
, TRANSFER_LOCATOR_ID TO_LOCATOR_ID
, ABS(PRIMARY_QUANTITY) PRIMARY_QTY
, PICK_SLIP_NUMBER
, TRANSACTION_DATE DETAILING_DATE
, MOVE_ORDER_LINE_ID
, 'PICKED' LINE_STATUS
, TRANSACTION_ID
, TRANSACTION_UOM
, SECONDARY_TRANSACTION_QUANTITY
, SECONDARY_UOM_CODE
FROM MTL_MATERIAL_TRANSACTIONS
WHERE PICK_SLIP_NUMBER IS NOT NULL
AND NVL(TRANSACTION_QUANTITY
, 0) < 0 UNION ALL SELECT FROM_SUBINVENTORY_CODE FROM_SUBINVENTORY
, FROM_LOCATOR_ID
, TO_SUBINVENTORY_CODE TO_SUBINVENTORY
, TO_LOCATOR_ID
, ABS(PRIMARY_QUANTITY) PRIMARY_QUANTITY
, PICK_SLIP_NUMBER
, PICK_SLIP_DATE DETAILING_DATE
, LINE_ID MOVE_ORDER_LINE_ID
, 'PICKED' LINE_STATUS
, TO_NUMBER(NULL) TRANSACTION_ID
, UOM_CODE
, SECONDARY_QUANTITY
, SECONDARY_UOM_CODE
FROM MTL_TXN_REQUEST_LINES
WHERE PICK_SLIP_NUMBER IS NOT NULL