APPS.EDW_UPDATE_ATTRIBUTES dependencies on EDW_FLEX_ATTRIBUTE_MAPPINGS

Line 107: FROM EDW_ATTRIBUTE_MAPPINGS ATTR, EDW_FLEX_ATTRIBUTE_MAPPINGS FLEX

103: l_map_count number := 0;
104: BEGIN
105:
106: SELECT count (1) into l_map_count
107: FROM EDW_ATTRIBUTE_MAPPINGS ATTR, EDW_FLEX_ATTRIBUTE_MAPPINGS FLEX
108: WHERE ATTR.ATTR_MAPPING_PK = FLEX.ATTR_MAPPING_FK
109: AND ATTR.OBJECT_SHORT_NAME = l_object_name
110: AND NVL(ATTR.LEVEL_NAME, 'null') = NVL(l_level_name, 'null')
111: AND FLEX.VALUE_SET_TYPE = 'F';

Line 563: FROM EDW_ATTRIBUTE_MAPPINGS ATTR, EDW_FLEX_ATTRIBUTE_MAPPINGS FLEX

559: SELECT
560: distinct FLEX.instance_code,
561: FLEX.VALUE_SET_ID,
562: decode(flex.flex_field_type, 'K', to_char(FLEX.STRUCTURE_NUM), FLEX.STRUCTURE_NAME) struct
563: FROM EDW_ATTRIBUTE_MAPPINGS ATTR, EDW_FLEX_ATTRIBUTE_MAPPINGS FLEX
564: WHERE ATTR.ATTR_MAPPING_PK = FLEX.ATTR_MAPPING_FK
565: AND ATTR.OBJECT_SHORT_NAME = p_object_name
566: AND NVL(ATTR.LEVEL_NAME, 'null') = NVL(p_level_name, 'null')
567: AND FLEX.VALUE_SET_TYPE = 'F';

Line 578: FROM EDW_ATTRIBUTE_MAPPINGS ATTR, EDW_FLEX_ATTRIBUTE_MAPPINGS FLEX

574:
575: CURSOR c_ignore_attribute(vsid NUMBER) IS
576: SELECT
577: distinct attr.attribute_name
578: FROM EDW_ATTRIBUTE_MAPPINGS ATTR, EDW_FLEX_ATTRIBUTE_MAPPINGS FLEX
579: WHERE ATTR.ATTR_MAPPING_PK = FLEX.ATTR_MAPPING_FK
580: AND ATTR.OBJECT_SHORT_NAME = p_object_name
581: AND NVL(ATTR.LEVEL_NAME, 'null') = NVL(p_level_name, 'null')
582: AND FLEX.VALUE_SET_TYPE = 'F'

Line 667: edw_flex_attribute_mappings flex,

663: flex.value_set_id, assg.flex_field_prefix,
664: vws.generated_view_name, vws.interface_table_name
665: from
666: edw_attribute_mappings attr,
667: edw_flex_attribute_mappings flex,
668: edw_sv_flex_assignments assg,
669: edw_source_views vws
670: where
671: attr.attribute_name = attr_name and

Line 688: from edw_attribute_mappings a, edw_flex_attribute_mappings b

684: c_mapped_attr c_mapped_list%rowtype;
685:
686: CURSOR c_attr_list (obj_name VARCHAR2, lvl_name VARCHAR2) IS
687: SELECT distinct attribute_name
688: from edw_attribute_mappings a, edw_flex_attribute_mappings b
689: where object_short_name = obj_name
690: and level_name = lvl_name
691: and a.attr_mapping_pk = b.attr_mapping_fk
692: and nvl(level_name, 'xxx') = nvl(lvl_name, 'xxx')

Line 716: FROM EDW_ATTRIBUTE_MAPPINGS ATTR, EDW_FLEX_ATTRIBUTE_MAPPINGS FLEX

712: SELECT
713: FLEX.instance_code,
714: FLEX.VALUE_SET_ID,
715: decode(flex.flex_field_type, 'K', to_char(FLEX.STRUCTURE_NUM), FLEX.STRUCTURE_NAME) struct
716: FROM EDW_ATTRIBUTE_MAPPINGS ATTR, EDW_FLEX_ATTRIBUTE_MAPPINGS FLEX
717: WHERE ATTR.ATTR_MAPPING_PK = FLEX.ATTR_MAPPING_FK
718: AND ATTR.OBJECT_SHORT_NAME = c_obj_name
719: AND NVL(ATTR.LEVEL_NAME, 'null') = NVL(c_lvl, 'null')
720: AND ATTR.ATTRIBUTE_NAME = c_attr