DBA Data[Home] [Help]

APPS.EDW_GEN_VIEW dependencies on EDW_FLEX_ATTRIBUTE_MAPPINGS

Line 38: FROM edw_attribute_mappings a, edw_flex_attribute_mappings b

34:
35:
36: cursor c_getFlexAttributeMappings(p_obj_name in varchar2, p_instance in varchar2, p_level IN VARCHAR2) IS
37: SELECT distinct(attribute_name) attribute_name, source_view, id_flex_code, datatype, flex_field_type
38: FROM edw_attribute_mappings a, edw_flex_attribute_mappings b
39: WHERE a.object_short_name = p_obj_name
40: AND decode(level_name, null, '000', 'null', '000', level_name) = nvl(p_level, '000')
41: AND a.attr_mapping_pk = b.attr_mapping_fk
42: AND a.instance_code = p_instance