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