Monday, April 28, 2014

How to find all the valid hold release reason codes from back end

  SELECT  *
               FROM    OE_LOOKUPS
          WHERE   LOOKUP_TYPE = 'RELEASE_REASON'
          and enabled_flag ='Y'
          and end_date_active is null