select  task_dtl.task_id, task_dtl.invn_need_type AS "Status",
task_dtl.pkt_ctrl_nbr AS "SO Ref", item_master.sku_desc AS "Description",
item_master.dsp_sku AS "Prod Code", locn_hdr.dsp_locn AS "Location",
qty_alloc/std_pack_qty AS "Cases", pkt_hdr.shipto AS "CustID",
pkt_hdr.shipto_name AS "Customer", pkt_hdr.plan_load_nbr AS "CM REF" from task_dtl

INNER JOIN item_master ON item_master.sku_id=task_dtl.sku_id
inner join pkt_hdr on pkt_hdr.pkt_ctrl_nbr=task_dtl.pkt_ctrl_nbr
inner join locn_hdr on locn_hdr.locn_id=task_dtl.pull_locn_id

where pkt_hdr.plan_load_nbr = 'C9207000' and qty_alloc/std_pack_qty > 0
order by invn_need_type asc, locn_pick_seq desc