Knowledge Hub — Technical Document

Generated on 2026-08-28 09:15 | Confidential Client Asset

Status Codes Displayed on Order and Fulfillment Lines.sql

Published February 22, 2026 By Sai Sree Ram Gundepudi 
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

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article

You may also like

More in OM
OM

Order Management Parameters.sql

-- SQL Query to obtain Order Management Parameters. SELECT qppvl.NAME , qppvl.DESCRIPTION , qppvl.PARAMETER_CODE...

 OM

Customer, SHIP_TO and BILL_TO Information on an Order.sql

-- The following SQL can be run from BI to obtain Customer information. SELECT dha.ORDER_NUMBER , dha.source_order_nu...

 OM

Billing Period Details as Shown on Sales Order Screen.sql

SELECT h.source_order_number Src_Order , h.order_number Order_Num , h.source_order_id , h.status_code ,...