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_UNIQUE_KEYS_MD_V

Line 81: edw_unique_keys_md_v parent_pk,

77: edw_levels_md_v lvl_parent,
78: edw_foreign_keys_md_v child_fk,
79: edw_pvt_key_columns_md_v child_fk_set_usage,
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,

Line 119: edw_unique_keys_md_v parent_pk,

115: nvl(parent_map.primary_source,0),
116: nvl(parent_map.primary_target,0)
117: from
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,

Line 549: 'edw_unique_keys_md_v pk where fact.fact_name=:a and fk.entity_id=rel.elementid '||

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;
553: fetch cv into l_log_table;

Line 557: 'edw_unique_keys_md_v pk where fact.fact_name=:a and fk.entity_id=rel.RELATION_ID '||

553: fetch cv into l_log_table;
554: close cv;
555: if l_log_table is null then
556: l_stmt:='select rel.RELATION_NAME from edw_relations_md_v rel, edw_facts_md_v fact, edw_foreign_keys_md_v fk, '||
557: 'edw_unique_keys_md_v pk where fact.fact_name=:a and fk.entity_id=rel.RELATION_ID '||
558: 'and pk.entity_id=fact.fact_id and fk.key_id=pk.key_id '||
559: 'and rel.description=:b';
560: open cv for l_stmt using p_table,l_log_desc;
561: fetch cv into l_log_table;

Line 753: 'edw_unique_keys_md_v pk '||

749: 'edw_foreign_keys_md_v fk, '||
750: 'edw_pvt_key_columns_md_v fkisu, '||
751: 'edw_pvt_columns_md_v fk_item, '||
752: 'edw_relations_md_v p_rel, '||
753: 'edw_unique_keys_md_v pk '||
754: 'where '||
755: 'rel.relation_name=:a '||
756: 'and fk.entity_id=rel.relation_id '||
757: 'and fkisu.key_id=fk.foreign_key_id '||

Line 2448: l_stmt:='select pk_item.column_name from edw_unique_keys_md_v pk,edw_pvt_columns_md_v pk_item,edw_relations_md_v rel, '||

2444: if g_debug then
2445: write_to_log_file_n('In get_table_surr_pk');
2446: write_to_log_file('p_table='||p_table);
2447: end if;
2448: l_stmt:='select pk_item.column_name from edw_unique_keys_md_v pk,edw_pvt_columns_md_v pk_item,edw_relations_md_v rel, '||
2449: 'edw_pvt_key_columns_md_v isu where rel.relation_name=:a and pk.entity_id=rel.relation_id '||
2450: 'and isu.key_id=pk.key_id and pk_item.column_id=isu.column_id and pk_item.column_name like ''%_KEY'' '||
2451: 'and pk_item.parent_object_id=rel.relation_id';
2452: open cv for l_stmt using p_table;

Line 3676: 'edw_unique_keys_md_v pk, '||

3672: l_stmt:='select '||
3673: 'pk_item.column_name '||
3674: 'from '||
3675: 'edw_relations_md_v rel , '||
3676: 'edw_unique_keys_md_v pk, '||
3677: 'edw_pvt_key_columns_md_v isu, '||
3678: 'edw_pvt_columns_md_v pk_item '||
3679: 'where '||
3680: 'rel.relation_name=:a '||

Line 4136: 'edw_unique_keys_md_v pk, '||

4132: Begin
4133: l_stmt:='select lvl.level_prefix||''_''||item.column_name '||
4134: 'from '||
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, '||

Line 4140: 'edw_unique_keys_md_v ltc_pk, '||

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 '||
4144: 'fk.entity_id=:a '||

Line 4308: 'edw_unique_keys_md_v pk, '||

4304: else
4305: l_stmt:='select pk_item.column_name,fk_item.column_name '||
4306: 'from '||
4307: 'edw_foreign_keys_md_v fk, '||
4308: 'edw_unique_keys_md_v pk, '||
4309: 'edw_pvt_key_columns_md_v fk_use, '||
4310: 'edw_pvt_key_columns_md_v pk_use, '||
4311: 'edw_pvt_columns_md_v fk_item, '||
4312: 'edw_pvt_columns_md_v pk_item '||

Line 4680: 'edw_pvt_key_columns_md_v fkisu,edw_pvt_columns_md_v fk_item,edw_dimensions_md_v p_rel,edw_unique_keys_md_v pk '||

4676: cv CurTyp;
4677: l_res varchar2(200);
4678: Begin
4679: l_stmt:='select fk_item.column_name from edw_relations_md_v rel, edw_foreign_keys_md_v fk, '||
4680: 'edw_pvt_key_columns_md_v fkisu,edw_pvt_columns_md_v fk_item,edw_dimensions_md_v p_rel,edw_unique_keys_md_v pk '||
4681: 'where rel.relation_name=:a and fk.entity_id=rel.relation_id and fkisu.key_id=fk.foreign_key_id '||
4682: 'and fk_item.column_id=fkisu.column_id and fk_item.parent_object_id=rel.relation_id and pk.key_id=fk.key_id and '||
4683: 'p_rel.dim_id=pk.entity_id and p_rel.dim_name=''EDW_INSTANCE_M''';
4684: if g_debug then

Line 4790: 'edw_unique_keys_md_v pk '||

4786: 'from '||
4787: 'edw_pvt_md_views_v vw, '||
4788: 'edw_dimensions_md_v dim, '||
4789: 'edw_foreign_keys_md_v fk, '||
4790: 'edw_unique_keys_md_v pk '||
4791: 'where fk.entity_id=vw.view_id '||
4792: 'and pk.entity_id=dim.dim_id '||
4793: 'and fk.key_id=pk.key_id '||
4794: 'and instr(fk.foreign_key_name,''_PK_VIEW'')<>0 '||

Line 4972: 'edw_unique_keys_md_v pk, '||

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, '||
4975: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns, '||
4976: 'edw_pvt_columns_md_v tgt_column '||

Line 5856: 'edw_unique_keys_md_v pk, '||

5852: l_dim_id:=get_dim_id(p_dim_name);
5853: end if;
5854: l_stmt:='select pk_item.column_name '||
5855: 'from '||
5856: 'edw_unique_keys_md_v pk, '||
5857: 'edw_pvt_key_columns_md_v isu, '||
5858: 'edw_pvt_columns_md_v pk_item '||
5859: 'where '||
5860: 'pk.entity_id=:a '||

Line 5906: 'edw_unique_keys_md_v pk, '||

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 '||
5910: 'where '||

Line 6049: 'edw_unique_keys_md_v pk, '||

6045: l_object_id:=get_object_id(p_object);
6046: end if;
6047: l_stmt:='select pk_item.column_name '||
6048: 'from '||
6049: 'edw_unique_keys_md_v pk, '||
6050: 'edw_pvt_key_columns_md_v isu, '||
6051: 'edw_pvt_columns_md_v pk_item '||
6052: 'where '||
6053: 'pk.entity_id=:a '||

Line 10222: edw_unique_keys_md_v dim_pk,

10218: and edw_pvt_map_sources_md_v.mapping_id=p_mapping_id
10219: ) key_usage,
10220: edw_pvt_key_columns_md_v key_col,
10221: edw_pvt_key_columns_md_v fk_key_col,
10222: edw_unique_keys_md_v dim_pk,
10223: edw_relations_md_v dim,
10224: edw_pvt_columns_md_v dim_pk_item,
10225: edw_pvt_columns_md_v fstg_item,
10226: edw_pvt_columns_md_v fact_item

Line 10440: 'edw_unique_keys_md_v pk '||

10436: 'edw_foreign_keys_md_v fk, '||
10437: 'EDW_PVT_KEY_COLUMNS_MD_V fku, '||
10438: 'edw_pvt_columns_md_v fk_col, '||
10439: 'edw_relations_md_v p_table, '||
10440: 'edw_unique_keys_md_v pk '||
10441: 'where '||
10442: 'fstg.relation_id=fk.entity_id '||
10443: 'and fk.foreign_key_id=fku.key_id '||
10444: 'and fk_col.column_id=fku.column_id '||

Line 10548: 'edw_unique_keys_md_v pk, '||

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, '||
10551: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns, '||
10552: 'edw_pvt_columns_md_v tgt_column '||