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_GEN_VIEW dependencies on EDW_ATTRIBUTE_MAPPINGS

Line 6: SELECT attribute_name, source_attribute, datatype FROM edw_attribute_mappings

2: /*$Header: EDWVGENS.pls 120.1 2005/06/13 12:56:16 aguwalan noship $*/
3:
4:
5: cursor c_getAttributeMappings(p_obj_name in varchar2, p_instance in varchar2, p_level IN VARCHAR2) IS
6: SELECT attribute_name, source_attribute, datatype FROM edw_attribute_mappings
7: WHERE object_short_name = p_obj_name and upper(flex_flag) = 'N'
8: AND instance_code = p_instance
9: AND decode(level_name, null, '000', 'null','000',level_name) = nvl(p_level, '000')
10: AND attribute_name NOT IN /* for multiple columns mapping to single target col*/

Line 11: (SELECT attribute_name FROM edw_attribute_mappings

7: WHERE object_short_name = p_obj_name and upper(flex_flag) = 'N'
8: AND instance_code = p_instance
9: AND decode(level_name, null, '000', 'null','000',level_name) = nvl(p_level, '000')
10: AND attribute_name NOT IN /* for multiple columns mapping to single target col*/
11: (SELECT attribute_name FROM edw_attribute_mappings
12: WHERE object_short_name = p_obj_name and upper(flex_flag) = 'N'
13: AND instance_code = p_instance
14: AND decode(level_name, null, '000', 'null', '000', level_name) = nvl(p_level, '000')
15: GROUP BY attribute_name having count(attribute_name) > 1)

Line 19: SELECT distinct attribute_name FROM edw_attribute_mappings

15: GROUP BY attribute_name having count(attribute_name) > 1)
16: ORDER BY attribute_name;
17:
18: cursor c_getMultiAttributeList(p_obj_name in varchar2, p_instance in varchar2, p_level IN VARCHAR2) IS
19: SELECT distinct attribute_name FROM edw_attribute_mappings
20: WHERE object_short_name = p_obj_name and upper(flex_flag) = 'N'
21: AND instance_code = p_instance
22: AND decode(level_name, null, '000', 'null', '000', level_name) = nvl(p_level, '000')
23: GROUP BY attribute_name having count(attribute_name) > 1

Line 29: SELECT source_attribute FROM edw_attribute_mappings

25:
26:
27: cursor c_getMultiAttributeMappings(p_obj_name in varchar2, p_instance in varchar2, p_level IN VARCHAR2,
28: p_column IN VARCHAR2) IS
29: SELECT source_attribute FROM edw_attribute_mappings
30: WHERE object_short_name = p_obj_name and upper(flex_flag) = 'N'
31: AND instance_code = p_instance
32: AND decode(level_name, null, '000', 'null', '000', level_name)= nvl(p_level, '000')
33: AND attribute_name = p_column;

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