Query to get the status of the Sales Order in Oracle Fusion

SELECT DISTINCT
DHA.ORDER_NUMBER,
DLA.LINE_NUMBER || DFLA.FULFILL_LINE_NUMBER ,
DST.DISPLAY_NAME "STATUS",
DFLA.STATUS_CODE "LINE STATUS",
DFLA.ORDERED_QTY,
DFLA.UNIT_SELLING_PRICE,
DFLA.EXTENDED_AMOUNT,
ESIL.DESCRIPTION

FROM
DOO_HEADERS_ALL DHA,
DOO_STATUSES_B DSB,
DOO_STATUSES_TL DST,
DOO_LINES_ALL DLA,
DOO_FULFILL_LINES_ALL  DFLA,
EGP_SYSTEM_ITEMS_TL ESIL

WHERE
DSB.STATUS_CODE=DHA.STATUS_CODE
AND DST.STATUS_ID=DSB.STATUS_ID
AND DHA.HEADER_ID=DLA.HEADER_ID
AND DFLA.LINE_ID=DLA.LINE_ID
AND ESIL.INVENTORY_ITEM_ID=DFLA.INVENTORY_ITEM_ID
AND DHA.OPEN_FLAG='Y'
AND DST.LANGUAGE='US'
AND ESIL.LANGUAGE='US'

ORDER BY DHA.ORDER_NUMBER, DLA.LINE_NUMBER