APPS.EDW_FACT_SV dependencies on EDW_FLEX_SEG_MAPPINGS

Line 616: FROM edw_flex_seg_mappings a, edw_fact_flex_fk_maps b

612:
613: CURSOR c IS SELECT fk_physical_name, b.dimension_short_name dimension_short_name,
614: a.value_set_id value_set_id, segment_name, flex_field_type,
615: structure_num , value_set_type, instance_code, id_flex_code, structure_name, parent_value_set_id
616: FROM edw_flex_seg_mappings a, edw_fact_flex_fk_maps b
617: WHERE b.fact_short_name = pFactName
618: AND b.enabled_flag = 'Y'
619: AND b.dimension_short_name = a.dimension_short_name
620: AND a.instance_code = edw_gen_view.g_instance

Line 623: AND NOT EXISTS( select 1 from edw_flex_seg_mappings c

619: AND b.dimension_short_name = a.dimension_short_name
620: AND a.instance_code = edw_gen_view.g_instance
621: AND (b.fk_physical_name = pAttributeName
622: or b.fk_physical_name = pAttributeName||'_KEY')
623: AND NOT EXISTS( select 1 from edw_flex_seg_mappings c
624: where c.parent_value_set_id = a.value_set_id
625: and a.instance_code = c.instance_code
626: and a.dimension_short_name = c.dimension_short_name
627: and a.structure_num = c.structure_num);

Line 672: stmt := ' SELECT segment_name, structure_num FROM edw_flex_seg_mappings'||

668:
669: l_gen_seg_name := edw_gen_view.formSegmentName(sPrefix, cRec.segment_name, cRec.structure_num, pFactName, cRec.flex_field_type);
670:
671: IF (upper(cRec.value_set_type) = 'D' ) THEN /* Dependant Value Set, need parent segment name also */
672: stmt := ' SELECT segment_name, structure_num FROM edw_flex_seg_mappings'||
673: ' WHERE value_set_id = :s1 AND ';
674:
675: IF (cRec.flex_field_type = 'D') THEN /* Descr Flex */
676: stmt := stmt ||' structure_name = :s2 ';