Query to check Sales Order HOLD reasons

 SELECT ooha.order_number

, ooha.ordered_date
, ooha.flow_status_code
, ooha.credit_card_approval_code
, ohd.name "Hold Name"
, ohs.released_flag
, ohr.release_reason_code
, ohr.creation_date "Hold Release Date"
, ooha.payment_type_code 

FROM apps.oe_order_headers_all ooha

, apps.oe_order_holds_all ohld
, apps.oe_hold_sources_all ohs
, apps.oe_hold_definitions ohd
, apps.oe_hold_releases ohr 

WHERE 1 = 1

AND ooha.order_category_code = 'ORDER' 
AND ohld.header_id(+)       = ooha.header_id 
AND ohs.hold_source_id(+)   = ohld.hold_source_id 
AND ohd.hold_id(+)          = ohs.hold_id 
AND ohr.hold_release_id(+)  = ohs.hold_release_id 
-- AND ooha.order_number = 'ORDERNUMBER'
ORDER BY ooha.order_number