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_PVT_KEY_COLUMNS_MD_V

Line 79: edw_pvt_key_columns_md_v child_fk_set_usage,

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,
83: edw_pvt_columns_md_v parent_pk_item,

Line 82: edw_pvt_key_columns_md_v parent_pk_set_usage,

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,
86: edw_pvt_level_relation_md_v lvl_rel,

Line 120: edw_pvt_key_columns_md_v parent_pk_set_usage,

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,
124: edw_hierarchies_md_v hier,

Line 716: 'edw_pvt_key_columns_md_v fku where rel.relation_name=:a and fk.entity_id=rel.relation_id and '||

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
720: fetch cv into p_fks(p_number_fks);

Line 750: 'edw_pvt_key_columns_md_v fkisu, '||

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

Line 2449: 'edw_pvt_key_columns_md_v isu where rel.relation_name=:a and pk.entity_id=rel.relation_id '||

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;
2453: fetch cv into p_pk;

Line 2664: 'edw_pvt_key_columns_md_v fk_isu, '||

2660: 'edw_relations_md_v sec_relation, '||
2661: 'edw_pvt_map_sources_md_v sec_relation_child_usage, '||
2662: 'edw_relations_md_v sec_relation_child, '||
2663: 'edw_pvt_map_key_usages_md_v fk_usage, '||
2664: 'edw_pvt_key_columns_md_v fk_isu, '||
2665: 'edw_pvt_columns_md_v fk_item, '||
2666: 'edw_pvt_key_columns_md_v pk_isu, '||
2667: 'edw_pvt_columns_md_v pk_item '||
2668: 'where '||

Line 2666: 'edw_pvt_key_columns_md_v pk_isu, '||

2662: 'edw_relations_md_v sec_relation_child, '||
2663: 'edw_pvt_map_key_usages_md_v fk_usage, '||
2664: 'edw_pvt_key_columns_md_v fk_isu, '||
2665: 'edw_pvt_columns_md_v fk_item, '||
2666: 'edw_pvt_key_columns_md_v pk_isu, '||
2667: 'edw_pvt_columns_md_v pk_item '||
2668: 'where '||
2669: ' sec_relation_usage.mapping_id=:a '||
2670: 'and sec_relation.relation_id=sec_relation_usage.source_id '||

Line 3677: 'edw_pvt_key_columns_md_v isu, '||

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 '||
3681: 'and pk.entity_id=rel.relation_id '||

Line 4142: 'edw_pvt_key_columns_md_v isu '||

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 '||
4145: 'and fk.key_id=pk.key_id '||
4146: 'and dim.dim_id=pk.entity_id '||

Line 4282: 'edw_pvt_key_columns_md_v fk_key_column, '||

4278: 'edw_pvt_map_properties_md_v map, '||
4279: 'edw_pvt_map_sources_md_v map_sources_dim, '||
4280: 'edw_pvt_map_sources_md_v map_sources_fact, '||
4281: 'edw_pvt_map_key_usages_md_v map_key_usage, '||
4282: 'edw_pvt_key_columns_md_v fk_key_column, '||
4283: 'edw_pvt_columns_md_v fk_item, '||
4284: 'edw_pvt_key_columns_md_v pk_key_column, '||
4285: 'edw_pvt_columns_md_v pk_item '||
4286: 'where '||

Line 4284: 'edw_pvt_key_columns_md_v pk_key_column, '||

4280: 'edw_pvt_map_sources_md_v map_sources_fact, '||
4281: 'edw_pvt_map_key_usages_md_v map_key_usage, '||
4282: 'edw_pvt_key_columns_md_v fk_key_column, '||
4283: 'edw_pvt_columns_md_v fk_item, '||
4284: 'edw_pvt_key_columns_md_v pk_key_column, '||
4285: 'edw_pvt_columns_md_v pk_item '||
4286: 'where '||
4287: 'map_sources_dim.source_id=:a '||
4288: 'and map_sources_fact.source_id=:b '||

Line 4309: 'edw_pvt_key_columns_md_v fk_use, '||

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

Line 4310: 'edw_pvt_key_columns_md_v pk_use, '||

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 '||
4313: 'where '||
4314: ' pk.entity_id=:a '||

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 4973: 'edw_pvt_key_columns_md_v key_usage, '||

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

Line 5096: 'edw_pvt_key_columns_md_v fk_isu, '||

5092: 'from '||
5093: 'edw_pvt_map_sources_md_v ltc_ru, '||
5094: 'edw_relations_md_v ltc, '||
5095: 'edw_pvt_map_key_usages_md_v fk_usage, '||
5096: 'edw_pvt_key_columns_md_v fk_isu, '||
5097: 'edw_pvt_columns_md_v fk_item, '||
5098: 'edw_pvt_map_properties_md_v map, '||
5099: 'edw_relations_md_v tgt '||
5100: 'where '||

Line 5143: 'edw_pvt_key_columns_md_v fkisu, '||

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

Line 5857: 'edw_pvt_key_columns_md_v isu, '||

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 '||
5861: 'and pk.primarykey=1 '||

Line 5907: 'edw_pvt_key_columns_md_v isu, '||

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 '||
5911: ' lvl.dim_id=:a '||

Line 6050: 'edw_pvt_key_columns_md_v isu, '||

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 '||
6054: 'and isu.key_id=pk.key_id '||

Line 10220: edw_pvt_key_columns_md_v key_col,

10216: and edw_pvt_map_key_usages_md_v.Source_usage_id=p_fstg_usage_id
10217: and edw_pvt_map_key_usages_md_v.mapping_id=p_mapping_id
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,

Line 10221: edw_pvt_key_columns_md_v fk_key_col,

10217: and edw_pvt_map_key_usages_md_v.mapping_id=p_mapping_id
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,

Line 10437: 'EDW_PVT_KEY_COLUMNS_MD_V fku, '||

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

Line 10549: 'edw_pvt_key_columns_md_v key_usage, '||

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