Actual code
from      stop_detail_requirements sdi
     join orders o on o.order_id = sdi.order_id
     left outer join unitload_detail     ud on ud.stop_detail_req_id =
sdi.stop_detail_req_id
     left outer join unitload            ul on  ul.unitload_number =
ud.unitload_number
     left outer join part_packaging           pp on pp.packaging_id =
sdi.packaging_id
     left outer join container           c on c.container_id =
pp.prmpk_container_id
Aid to quick understanding
o -> sdr (n)
     -> pp -> c
     -> ud -> ul
How to read
- 1. An order leads to multiple stop detail requirements
 - 2. An "sdr" can independently yield 1 "pp - part packaging" and 1 "ud - unitload detail" 
 - 3. A "pp" can lead to a single container "c" 
 - 4. A "unitload detail" can lead to a single "unitload"