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_FOREIGN_KEYS_MD_V

Line 78: edw_foreign_keys_md_v child_fk,

74: nvl(parent_map.primary_target,0)
75: from
76: edw_levels_md_v lvl_child,
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,

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 556: l_stmt:='select rel.RELATION_NAME from edw_relations_md_v rel, edw_facts_md_v fact, edw_foreign_keys_md_v fk, '||

552: open cv for l_stmt using p_table;
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;

Line 715: l_stmt:='select col.column_name from edw_pvt_columns_md_v col, edw_relations_md_v rel, edw_foreign_keys_md_v fk, '||

711: if g_debug then
712: write_to_log_file_n('In get_fks_for_table, Input params is '||p_table);
713: end if;
714: p_number_fks:=1;
715: l_stmt:='select col.column_name from edw_pvt_columns_md_v col, edw_relations_md_v rel, edw_foreign_keys_md_v fk, '||
716: 'edw_pvt_key_columns_md_v fku where rel.relation_name=:a and fk.entity_id=rel.relation_id and '||
717: 'fku.key_id=fk.foreign_key_id and col.column_id=fku.column_id and col.parent_object_id=rel.relation_id';
718: open cv for l_stmt using p_table;
719: loop

Line 749: 'edw_foreign_keys_md_v fk, '||

745: p_number_fks:=1;
746: l_stmt:='select fk_item.column_name,p_rel.relation_name '||
747: 'from '||
748: 'edw_relations_md_v rel, '||
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 '||

Line 4135: 'edw_foreign_keys_md_v fk, '||

4131: l_stmt varchar2(4000);
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, '||

Line 4307: 'edw_foreign_keys_md_v fk, '||

4303: open cv for l_stmt using p_parent,p_child,p_map_id;
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, '||

Line 4679: l_stmt:='select fk_item.column_name from edw_relations_md_v rel, edw_foreign_keys_md_v fk, '||

4675: TYPE CurTyp IS REF CURSOR;
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''';

Line 4789: 'edw_foreign_keys_md_v fk, '||

4785: l_stmt:='select vw.view_name '||
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 '||

Line 5142: 'edw_foreign_keys_md_v fk, '||

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, '||
5146: 'edw_levels_md_v lvl '||

Line 10436: 'edw_foreign_keys_md_v fk, '||

10432: 'fk_col.column_name, '||
10433: 'p_table.relation_name '||
10434: 'from '||
10435: 'edw_relations_md_v fstg, '||
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 '||