APPS.AST_UWQ_PLISTS_OPPS_ENUMS_PVT SQL Statements

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

Line: 25

  SELECT
  alh.list_name,
  alh.list_header_id,
  alh.list_source_type
  from ams_list_headers_vl alh
  where
  owner_user_id = c_resource_id
  and list_type='MANUAL' and
  list_source_type = 'OPPORTUNITY'
  and enabled_flag = 'Y' and
  list_source='UWQ'
  order by creation_date desc;

Line: 50

  Select meaning into l_node_label
  from ast_lookups
  where lookup_type = lkp_type
  and lookup_code = lkp_code;

Line: 119

			' and EXISTS (SELECT /*+ no_unnest */ 1 ' ||
            	' FROM AS_ACCESSES_ALL ASS ' ||
            	' WHERE ASS.SALESFORCE_ID = :resource_id ' ||
			 ' AND AST_PLIST_OPP_UWQ_V.CUSTOMER_ID = ASS.CUSTOMER_ID ' ||
		    ' AND AST_PLIST_OPP_UWQ_V.LEAD_ID = ASS.LEAD_ID) ';