Status Codes Displayed on Order and Fulfillment Lines.sql

SELECT
	dsb.STATUS_CODE
  , dst.DISPLAY_NAME
  , dsb.STATUS_ID
  , dsb.SEEDED_FLAG
FROM
	fusion.DOO_STATUSES_B  dsb
  , fusion.DOO_STATUSES_tl dst
WHERE
	dsb.STATUS_ID    = dst.STATUS_ID
	AND dst.language =userenv('LANG')
ORDER BY
	dsb.STATUS_CODE