Query to get OM Order Hold details in Oracle Apps

SELECT OHD.NAME "Name"
       ,OHD.DESCRIPTION "Description"
       ,FLV_TC.MEANING "Type"
       ,WITT.DISPLAY_NAME "Workflow Item"
       ,(SELECT MEANING
        FROM   APPS.FND_LOOKUP_VALUES FLV_ACT
        WHERE  LOOKUP_TYPE IN ('HOLDABLE_LINE_ACTIVITIES',
                               'HOLDABLE_HEADER_ACTIVITIES')
        AND    FLV_ACT.LOOKUP_CODE = OHD.ACTIVITY_NAME
        AND FLV_ACT.LANGUAGE = FLV_TC.LANGUAGE) "Workflow Activity"
       ,OHD.HOLD_INCLUDED_ITEMS_FLAG "Hold Included Items"
       ,OHD.APPLY_TO_ORDER_AND_LINE_FLAG "Apply to Order and Line"
       ,OHD.PROGRESS_WF_ON_RELEASE_FLAG "Progress WF on Release"
       ,TO_CHAR(OHD.START_DATE_ACTIVE,
               'DD-MON-YYYY') || ' - ' ||
       TO_CHAR(OHD.END_DATE_ACTIVE,
               'DD-MON-YYYY') "Effective Dates"
       ,FRV.RESPONSIBILITY_NAME "Responsibility"
       ,TO_CHAR(OHA.START_DATE_ACTIVE,
               'DD-MON-YYYY') || ' - ' ||
       TO_CHAR(OHA.END_DATE_ACTIVE,
               'DD-MON-YYYY') "Effective Dates"
       ,OHA.AUTHORIZED_ACTION_CODE "Authorized Action"
FROM   APPS.OE_HOLD_DEFINITIONS    OHD
      ,APPS.OE_HOLD_AUTHORIZATIONS OHA
      ,APPS.FND_LOOKUP_VALUES      FLV_TC
      ,APPS.WF_ITEM_TYPES_TL       WITT
      ,APPS.FND_RESPONSIBILITY_VL  FRV
WHERE  1 = 1
AND    OHD.HOLD_ID = OHA.HOLD_ID
AND    FLV_TC.LOOKUP_CODE = OHD.TYPE_CODE
AND    FLV_TC.LOOKUP_TYPE = 'HOLD_TYPE'
AND    FLV_TC.LANGUAGE = 'US'
AND    WITT.LANGUAGE = FLV_TC.LANGUAGE
AND    OHD.ITEM_TYPE = WITT.NAME(+)
AND    FRV.RESPONSIBILITY_ID = OHA.RESPONSIBILITY_ID
ORDER  BY OHD.NAME
         ,FRV.RESPONSIBILITY_NAME
         ,OHA.AUTHORIZED_ACTION_CODE