[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;
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;