Query to get the list of Item Orderability Rules defined in Order Management

SELECT oio.item_level,

       'Inventory Item' item_level_dsp,

       b.concatenated_segments item,

       t.description item_description,

       oio.item_category_id,

       oio.generally_available,

       oio.enable_flag,

       oior.rule_level,

       oior.enable_flag rule_enable_flag,

       DECODE (rule_level,