OM Hold Codes (Oracle Fusion SQL)

Supply Chain & Manufacturing (SCM) Order Management (OM-Fusion-SQL's)
1

This OM Hold Codes query retrieves various hold codes and related details for the orders.

#sqlquery



SELECT
-- SQL4FUSION (AN ORBIT ANALYTICS PROJECT)
-- This query retrieves various hold codes and related details for the orders.
  DHCB.HOLD_CODE,
  DHCT.HOLD_NAME,
  DHCT.HOLD_DESCRIPTION,
  DHCT.HOLD_CODE_ID,
  DHCB.EFFECTIVE_START_DATE,
  DHCB.EFFECTIVE_END_DATE,
  DHCB.GENERAL_HOLD_FLAG,
  DHCB.SYSTEM_FLAG,
  DHCB.APPLY_HOLD_ROLE_ELIGIBILITY,
  DHCB.RELEASE_HOLD_ROLE_ELIGIBILITY
FROM
  DOO_HOLD_CODES_B DHCB,
  DOO_HOLD_CODES_TL DHCT
WHERE
  DHCT.HOLD_CODE_ID = DHCB.HOLD_CODE_ID
  AND DHCT.LANGUAGE = USERENV('LANG')
ORDER BY
  DHCB.HOLD_CODE