eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_DIM_SV dependencies on EDW_FLEX_SEG_MAPPINGS

Line 31: FROM edw_flex_seg_mappings

27:
28: Procedure getCountForVSTypes(dim_name in VARCHAR2) IS
29: CURSOR c_getCount IS
30: SELECT value_set_type type, count(*) count
31: FROM edw_flex_seg_mappings
32: WHERE dimension_short_name = dim_name
33: AND instance_code = edw_gen_view.g_instance
34: GROUP BY value_set_type;
35:

Line 385: id_column_name, value_set_name FROM edw_flex_seg_mappings a,'||

381: END IF;
382:
383:
384: stmt1 := 'SELECT distinct APPLICATION_TABLE_NAME, value_set_id, value_column_name, meaning_column_name,
385: id_column_name, value_set_name FROM edw_flex_seg_mappings a,'||
386: ' fnd_flex_validation_tables@' ||edw_gen_view.g_source_db_link
387: ||' b WHERE a.value_set_id = b.flex_value_set_id '
388: ||' AND a.dimension_short_name = :d1 AND A.VALUE_SET_TYPE = :d2';
389:

Line 484: stmt2 := stmt2||' ''''NA_EDW'''' l2_fk '', '||' APPLICATION_TABLE_NAME FROM edw_flex_seg_mappings a,';

480: stmt2 := stmt2 || ' description, ';
481:
482: END IF;
483:
484: stmt2 := stmt2||' ''''NA_EDW'''' l2_fk '', '||' APPLICATION_TABLE_NAME FROM edw_flex_seg_mappings a,';
485: stmt2 := stmt2|| ' fnd_flex_validation_tables@' ||edw_gen_view.g_source_db_link ||
486: ' b WHERE a.value_set_id = b.flex_value_set_id AND a.dimension_short_name = :d1 ';
487: stmt2 := stmt2||' AND application_table_name = :d2';
488:

Line 560: FROM edw_flex_seg_mappings a

556: l_count NUMBER := 0;
557:
558: CURSOR c_getLowerLevelIndepValueSets IS
559: SELECT distinct a.value_set_type, a.value_set_id, a.parent_value_set_id
560: FROM edw_flex_seg_mappings a
561: WHERE
562: dimension_short_name = p_dim_name
563: and instance_code = edw_gen_view.g_instance
564: AND ( value_set_type = 'I' /* OR value_set_type = 'N' OR

Line 567: (SELECT 1 FROM edw_flex_seg_mappings b

563: and instance_code = edw_gen_view.g_instance
564: AND ( value_set_type = 'I' /* OR value_set_type = 'N' OR
565: value_set_type = 'F' */)
566: AND NOT EXISTS
567: (SELECT 1 FROM edw_flex_seg_mappings b
568: where b.parent_value_set_id = a.value_set_id
569: AND b.dimension_short_name = a.dimension_short_name
570: AND b.structure_num = a.structure_num);
571:

Line 574: FROM edw_flex_seg_mappings parent, edw_flex_seg_mappings child

570: AND b.structure_num = a.structure_num);
571:
572: CURSOR c_getHigherLevelIndepValueSets IS
573: SELECT parent.value_set_type, parent.value_set_id, parent.parent_value_set_id , parent.structure_num
574: FROM edw_flex_seg_mappings parent, edw_flex_seg_mappings child
575: WHERE
576: parent.dimension_short_name = child.dimension_short_name
577: AND parent.dimension_short_name = p_dim_name
578: AND parent.instance_code = edw_gen_view.g_instance

Line 645: FROM edw_flex_seg_mappings a WHERE

641: l_count number := 0;
642: final_view varchar2(32000) := null;
643: CURSOR c_getLowerLevelVSets IS
644: SELECT distinct a.value_set_type, a.value_set_id, a.parent_value_set_id
645: FROM edw_flex_seg_mappings a WHERE
646: dimension_short_name = p_dim_name
647: and a.instance_code = edw_gen_view.g_instance
648: AND a.parent_value_set_id <> 0 ; /* dependant value sets */
649:

Line 735: whereKeyFlex := ' b.SET_DEFINING_COLUMN_NAME,''K'' FROM edw_flex_seg_mappings a, fnd_id_flexs@'||edw_gen_view.g_source_db_link||' b WHERE ( a.id_flex_code = b.id_flex_code ) and a.value_set_type =''N'' and a.application_id=b.application_id '||

731: END IF;
732:
733: select1 := 'SELECT b.APPLICATION_TABLE_NAME , a.structure_num, a.STRUCTURE_NAME,'||newline;
734:
735: whereKeyFlex := ' b.SET_DEFINING_COLUMN_NAME,''K'' FROM edw_flex_seg_mappings a, fnd_id_flexs@'||edw_gen_view.g_source_db_link||' b WHERE ( a.id_flex_code = b.id_flex_code ) and a.value_set_type =''N'' and a.application_id=b.application_id '||
736: ' and a.instance_code = :d1 '||
737: ' AND a.dimension_short_name = :d2 ';
738:
739: whereDescFlex := ' b.CONTEXT_COLUMN_NAME, ''D'' FROM edw_flex_seg_mappings a, fnd_descriptive_flexs_vl@'||edw_gen_view.g_source_db_link||

Line 739: whereDescFlex := ' b.CONTEXT_COLUMN_NAME, ''D'' FROM edw_flex_seg_mappings a, fnd_descriptive_flexs_vl@'||edw_gen_view.g_source_db_link||

735: whereKeyFlex := ' b.SET_DEFINING_COLUMN_NAME,''K'' FROM edw_flex_seg_mappings a, fnd_id_flexs@'||edw_gen_view.g_source_db_link||' b WHERE ( a.id_flex_code = b.id_flex_code ) and a.value_set_type =''N'' and a.application_id=b.application_id '||
736: ' and a.instance_code = :d1 '||
737: ' AND a.dimension_short_name = :d2 ';
738:
739: whereDescFlex := ' b.CONTEXT_COLUMN_NAME, ''D'' FROM edw_flex_seg_mappings a, fnd_descriptive_flexs_vl@'||edw_gen_view.g_source_db_link||
740: ' b WHERE ( a.id_flex_code = b.descriptive_flexfield_name ) and a.value_set_type = ''N'' and a.application_id=b.application_id '||
741: ' and a.instance_code = :d3 '||
742: ' AND a.dimension_short_name = :d4 ' ;
743:

Line 797: select4 := select4||''' FROM edw_flex_seg_mappings a, '||newline;

793: select4 := select4 ||' AND '||l_structure_col || ' = '''''|| l_struct_name ||'''''';
794: END IF;
795: END IF;
796:
797: select4 := select4||''' FROM edw_flex_seg_mappings a, '||newline;
798:
799: whereKeyFlex := 'fnd_id_flexs@'||edw_gen_view.g_source_db_link||' b WHERE ( a.id_flex_code = b.id_flex_code ) and a.value_set_type =''N'' and a.application_id=b.application_id '||
800: ' AND a.instance_code = :d1 '||
801: ' AND a.dimension_short_name = :d2 ' ||

Line 1192: from edw_flex_seg_mappings where

1188: apiClause VARCHAR2(32000);
1189:
1190: cursor c_getMappingsForDim(obj_name varchar2) is
1191: select value_set_type, value_set_id, parent_value_set_id
1192: from edw_flex_seg_mappings where
1193: dimension_short_name = obj_name
1194: and instance_code = edw_gen_view.g_instance
1195: order by value_set_type;
1196: