Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement