Tune SQL statement (v 10g)
SELECT bl_nbr,
case_nbr,
case_pack_type,
DECODE (pre_case.store, :1, NVL (needs_ticketing, 'N'), 'N'),
DECODE (pre_case.store, :2, , pre_case.store)
FROM pre_case
WHERE pick_nbr IS NOT NULL
AND EXISTS
(SELECT *
FROM pre_Case_pack
WHERE case_nbr = pre_case.case_nbr AND dest_store = :4)