View: WSH_PICK_SLIP_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_PICK_SLIP_V

View Text

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

Columns