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_OWB_COLLECTION_UTIL dependencies on EDW_TABLES_MD_V

Line 56: edw_tables_md_v ltc,

52: ltc.name,
53: ltc.elementid
54: from
55: edw_dimensions_md_v a,
56: edw_tables_md_v ltc,
57: edw_pvt_map_properties_md_v b,
58: edw_pvt_map_targets_md_v c
59: where
60: a.dim_name =p_dim_name

Line 84: edw_tables_md_v child_relation,

80: edw_pvt_columns_md_v child_fk_item,
81: edw_unique_keys_md_v parent_pk,
82: edw_pvt_key_columns_md_v parent_pk_set_usage,
83: edw_pvt_columns_md_v parent_pk_item,
84: edw_tables_md_v child_relation,
85: edw_tables_md_v parent_relation,
86: edw_pvt_level_relation_md_v lvl_rel,
87: edw_hierarchies_md_v hier,
88: edw_pvt_map_properties_md_v parent_map

Line 85: edw_tables_md_v parent_relation,

81: edw_unique_keys_md_v parent_pk,
82: edw_pvt_key_columns_md_v parent_pk_set_usage,
83: edw_pvt_columns_md_v parent_pk_item,
84: edw_tables_md_v child_relation,
85: edw_tables_md_v parent_relation,
86: edw_pvt_level_relation_md_v lvl_rel,
87: edw_hierarchies_md_v hier,
88: edw_pvt_map_properties_md_v parent_map
89: where

Line 122: edw_tables_md_v child_relation,

118: edw_levels_md_v lvl_child,
119: edw_unique_keys_md_v parent_pk,
120: edw_pvt_key_columns_md_v parent_pk_set_usage,
121: edw_pvt_columns_md_v parent_pk_item,
122: edw_tables_md_v child_relation,
123: edw_pvt_level_relation_md_v lvl_rel,
124: edw_hierarchies_md_v hier,
125: edw_pvt_map_properties_md_v parent_map
126: where

Line 148: edw_tables_md_v relation,

144: from
145: edw_pvt_map_properties_md_v map_properties,
146: edw_pvt_map_sources_md_v map_sources,
147: (select * from edw_pvt_map_columns_md_v where mapping_id=p_mapping_id) map_columns,
148: edw_tables_md_v relation,
149: edw_pvt_columns_md_v dim_item,
150: edw_pvt_columns_md_v level_item
151: where
152: map_properties.mapping_id=p_mapping_id

Line 548: l_stmt:='select rel.name from edw_tables_md_v rel, edw_facts_md_v fact, edw_foreign_keys_md_v fk, '||

544: end if;
545: l_log_desc :=p_log;
546: l_log_table:=null;
547: --p_table is the fact name
548: l_stmt:='select rel.name from edw_tables_md_v rel, edw_facts_md_v fact, edw_foreign_keys_md_v fk, '||
549: 'edw_unique_keys_md_v pk where fact.fact_name=:a and fk.entity_id=rel.elementid '||
550: 'and pk.entity_id=fact.fact_id and fk.key_id=pk.key_id '||
551: 'and fk.foreign_key_name like ''%_DLOG''';
552: open cv for l_stmt using p_table;

Line 4139: 'edw_tables_md_v ltc, '||

4135: 'edw_foreign_keys_md_v fk, '||
4136: 'edw_unique_keys_md_v pk, '||
4137: 'edw_dimensions_md_v dim, '||
4138: 'edw_levels_md_v lvl, '||
4139: 'edw_tables_md_v ltc, '||
4140: 'edw_unique_keys_md_v ltc_pk, '||
4141: 'edw_pvt_columns_md_v item, '||
4142: 'edw_pvt_key_columns_md_v isu '||
4143: 'where '||

Line 4970: 'edw_tables_md_v src_table, '||

4966: 'from '||
4967: 'edw_pvt_map_properties_md_v map_properties, '||
4968: 'edw_pvt_map_sources_md_v map_sources, '||
4969: 'edw_pvt_map_targets_md_v map_targets, '||
4970: 'edw_tables_md_v src_table, '||
4971: 'edw_relations_md_v tgt_relation, '||
4972: 'edw_unique_keys_md_v pk, '||
4973: 'edw_pvt_key_columns_md_v key_usage, '||
4974: 'edw_pvt_columns_md_v pk_col, '||

Line 5141: 'edw_tables_md_v rel, '||

5137: l_stmt:='select '||
5138: 'rel.name, '||
5139: 'fk_item.column_name '||
5140: 'from '||
5141: 'edw_tables_md_v rel, '||
5142: 'edw_foreign_keys_md_v fk, '||
5143: 'edw_pvt_key_columns_md_v fkisu, '||
5144: 'edw_pvt_columns_md_v fk_item, '||
5145: 'edw_dimensions_md_v dim, '||

Line 5415: l_stmt:='select 1 from edw_tables_md_v where name=:a';

5411: close cv;
5412: if l_res=1 then
5413: return 'FACT';
5414: end if;
5415: l_stmt:='select 1 from edw_tables_md_v where name=:a';
5416: open cv for l_stmt using p_object_name;
5417: fetch cv into l_res;
5418: close cv;
5419: if l_res=1 then

Line 5437: 'edw_tables_md_v ltc, '||

5433: cv CurTyp;
5434: Begin
5435: l_stmt:='select ltc.name,lstg.name '||
5436: 'from '||
5437: 'edw_tables_md_v ltc, '||
5438: 'edw_tables_md_v lstg, '||
5439: 'edw_pvt_map_properties_md_v map, '||
5440: 'edw_dimensions_md_v dim, '||
5441: 'edw_levels_md_v lvl '||

Line 5438: 'edw_tables_md_v lstg, '||

5434: Begin
5435: l_stmt:='select ltc.name,lstg.name '||
5436: 'from '||
5437: 'edw_tables_md_v ltc, '||
5438: 'edw_tables_md_v lstg, '||
5439: 'edw_pvt_map_properties_md_v map, '||
5440: 'edw_dimensions_md_v dim, '||
5441: 'edw_levels_md_v lvl '||
5442: 'where dim.dim_name=:a '||

Line 5542: 'edw_tables_md_v ltc, '||

5538: Begin
5539: l_stmt:='select ltc.name,ltc.elementid '||
5540: 'from '||
5541: 'edw_levels_md_v lvl, '||
5542: 'edw_tables_md_v ltc, '||
5543: 'edw_dimensions_md_v dim '||
5544: 'where lvl.dim_id=dim.dim_id '||
5545: 'and ltc.name=lvl.level_name||''_LTC'' '||
5546: 'and dim.dim_name=:a '||

Line 5593: 'edw_tables_md_v ltc, '||

5589: end if;
5590: l_stmt:='select ltc.name '||
5591: 'from '||
5592: 'edw_levels_md_v lvl, '||
5593: 'edw_tables_md_v ltc, '||
5594: 'edw_dimensions_md_v dim '||
5595: 'where lvl.dim_id=dim.dim_id '||
5596: 'and ltc.name=lvl.level_name||''_LTC'' '||
5597: 'and dim.dim_name=:a '||

Line 5630: 'edw_tables_md_v ltc, '||

5626: p_number_dim:=0;
5627: l_stmt:='select dim.dim_name,ltc.elementid,ltc.name '||
5628: 'from '||
5629: 'edw_levels_md_v lvl, '||
5630: 'edw_tables_md_v ltc, '||
5631: 'edw_dimensions_md_v dim '||
5632: 'where lvl.dim_id=dim.dim_id '||
5633: 'and ltc.name=lvl.level_name||''_LTC'' ';
5634: if p_dim_in is not null then

Line 5905: 'edw_tables_md_v rel, '||

5901: end if;
5902: l_stmt:='select '||
5903: 'lvl.level_prefix||''_''||pk_item.column_name '||
5904: 'from '||
5905: 'edw_tables_md_v rel, '||
5906: 'edw_unique_keys_md_v pk, '||
5907: 'edw_pvt_key_columns_md_v isu, '||
5908: 'edw_pvt_columns_md_v pk_item, '||
5909: 'edw_levels_md_v lvl '||

Line 7050: 'edw_tables_md_v parent_ltc, '||

7046: 'edw_hierarchies_md_v hier, '||
7047: 'edw_dimensions_md_v dim, '||
7048: 'edw_levels_md_v child_level, '||
7049: 'edw_levels_md_v parent_level, '||
7050: 'edw_tables_md_v parent_ltc, '||
7051: 'edw_tables_md_v child_ltc '||
7052: 'where '||
7053: 'dim.dim_name=:a '||
7054: 'and hier.DIM_ID=dim.DIM_ID '||

Line 7051: 'edw_tables_md_v child_ltc '||

7047: 'edw_dimensions_md_v dim, '||
7048: 'edw_levels_md_v child_level, '||
7049: 'edw_levels_md_v parent_level, '||
7050: 'edw_tables_md_v parent_ltc, '||
7051: 'edw_tables_md_v child_ltc '||
7052: 'where '||
7053: 'dim.dim_name=:a '||
7054: 'and hier.DIM_ID=dim.DIM_ID '||
7055: 'and lvl_rel.HIERARCHY_ID=hier.HIER_ID '||

Line 10546: 'edw_tables_md_v src_table, '||

10542: 'from '||
10543: 'edw_pvt_map_properties_md_v map_properties, '||
10544: 'edw_pvt_map_sources_md_v map_sources, '||
10545: 'edw_pvt_map_targets_md_v map_targets, '||
10546: 'edw_tables_md_v src_table, '||
10547: 'edw_relations_md_v tgt_relation, '||
10548: 'edw_unique_keys_md_v pk, '||
10549: 'edw_pvt_key_columns_md_v key_usage, '||
10550: 'edw_pvt_columns_md_v pk_col, '||