Query to get the Status of the Sales Order.

SELECT DISTINCT
DHA.ORDER_NUMBER,
--DHA.CREATION_DATE,
DHA.SOURCE_ORDER_SYSTEM,
DHA.SOURCE_ORDER_NUMBER,
DHA.ORG_ID,
DHA.SOLD_TO_CUSTOMER_ID,
--DHA.ORDERED_DATE,
DHA.CUSTOMER_PO_NUMBER,
DHA.OPEN_FLAG,
DHA.ON_HOLD,
DHA.CANCELED_FLAG,
--DHA.STATUS_CODE,
DST.DISPLAY_NAME


FROM
DOO_HEADERS_ALL DHA,
DOO_STATUSES_B DSB,
DOO_STATUSES_TL DST

WHERE
 DSB.STATUS_CODE=DHA.STATUS_CODE
AND DST.STATUS_ID=DSB.STATUS_ID