[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');