Query to find out order and line hold information

select distinct ohd.name
,ooh.hold_until_date
,ooh.hold_comment
,h.order_number
,l.item_identifier_type
,l.inventory_item_id
,l.ordered_item
,oh.header_id
,oh.line_id
,oh.order_hold_id
from oe_hold_definitions ohd,
oe_hold_sources_all ooh,
oe_order_headers_all h,
oe_order_lines_all l,
oe_order_holds_all oh
where ohd.hold_id = ooh.hold_id
and oh.hold_source_id = ooh.hold_source_id
and oh.header_id = h.header_id
and h.header_id=l.header_id
and l.open_flag='Y'
and h.open_flag='Y'
order by ohd.name,h.order_number;