DBA Data[Home] [Help]

APPS.AMS_GEN_SUP_LIST_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 41

      SELECT list_header_id,list_name
      FROM   ams_list_headers_vl
      WHERE  list_type='SUPPRESSION'
      AND STATUS_CODE NOT IN('ARCHIVED','CANCELLED');