DBA Data[Home] [Help]

APPS.EGO_COM_ATTR_VALIDATION SQL Statements

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

Line: 75

  Select descriptive_flex_context_name
  from fnd_descr_flex_contexts_vl
  where application_id = p_application_id
  and descriptive_flexfield_name = p_descriptive_flexfield_name
  and descriptive_flex_context_code = p_attr_grp_name;
Line: 512

  Select attr_group_id
  from ego_fnd_dsc_flx_ctx_ext
  where application_id = p_application_id
  and descriptive_flexfield_name = p_descriptive_flexfield_name
  and descriptive_flex_context_code = p_attr_grp_name;
Line: 732

  Select a.attr_group_id
         ,a.attr_group_name
         ,a.attr_group_type
         ,b.multi_row
  from ego_obj_attr_grp_assocs_v a,
       ego_fnd_dsc_flx_ctx_ext b
  where a.object_id = p_object_id
  and a.classification_code = to_char(p_structure_type_id)
  and a.data_level_int_name = 'COMPONENTS_LEVEL'
  and a.attr_group_id = b.attr_group_id;