Sales Order Pick Status Lookup Value Query

Sales Order Pick Status Lookup Value Query


SELECT typ.lookup_type, typ.meaning lookup_type_meaning,
       typ.description lookup_type_description, flv_released.lookup_code,
       flv_released.meaning, flv_released.description
  FROM fnd_lookup_values flv_released, fnd_lookup_types_tl typ
 WHERE flv_released.lookup_type = 'PICK_STATUS'
   AND flv_released.LANGUAGE = USERENV ('LANG')
   AND flv_released.view_application_id = 665
   AND flv_released.security_group_id = 0
   AND flv_released.lookup_type = typ.lookup_type