DBA Data[Home] [Help]

APPS.AMS_UWQ_LIST_ENUM_PVT SQL Statements

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

Line: 21

    SELECT schedule_id, schedule_name, list_source_type
    FROM ams_list_sch_uwq_v
    WHERE resource_id = pResourceID
    ORDER BY 1;
Line: 32

 Select meaning into l_node_label
  from ams_lookups
  where lookup_type = 'AMS_UWQ_LABELS'
  and lookup_code = 'LIST_ASSIGN_LABEL';