SELECT   lta_number, CV.customer_code || ' ' || CV.customer_name customer,
         print_count, 0 PRT
    FROM customers_view CV, lta_profile lp
   WHERE CV.customer_code = lp.customer_code
     AND lp.depot_code = 400
     AND NVL (ho_approved, 'N') = 'Y'
     AND lp.depot_code = CV.depot_code
ORDER BY NVL (print_count, 0), lta_number DESC

01453, 00000, "SET TRANSACTION must be first statement of transaction"
// *Cause: self-evident
// *Action: commit (or rollback) transaction, and re-execute