View: WSH_SRS_PICK_SLIP_V

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

View Text

SELECT PICK_SLIP_NUMBER
FROM MTL_MATERIAL_TRANSACTIONS_TEMP
WHERE PICK_SLIP_NUMBER IS NOT NULL
AND NVL(TRANSACTION_QUANTITY
, 0) > 0 UNION SELECT /*+ INDEX(M) */ PICK_SLIP_NUMBER
FROM MTL_MATERIAL_TRANSACTIONS M
WHERE PICK_SLIP_NUMBER IS NOT NULL
AND NVL(TRANSACTION_QUANTITY
, 0) < 0 UNION SELECT /*+ INDEX(R) */ PICK_SLIP_NUMBER
FROM MTL_TXN_REQUEST_LINES R
WHERE PICK_SLIP_NUMBER IS NOT NULL

Columns