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_RELATIONS_MD_V

Line 181: edw_relations_md_v relation

177: nvl(map.primary_source,0),
178: nvl(map.primary_target,0)
179: from
180: edw_pvt_map_properties_md_v map,
181: edw_relations_md_v relation
182: where
183: map.primary_target=relation.relation_id
184: and relation.relation_name=p_target_relation;
185:

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 583: l_stmt:='select col.column_name from edw_pvt_columns_md_v col, edw_relations_md_v rel where rel.relation_name=:s and '||

579: if g_debug then
580: write_to_log_file_n('In get_columns_for_table, Input params is '||p_table);
581: end if;
582: p_number_columns:=1;
583: l_stmt:='select col.column_name from edw_pvt_columns_md_v col, edw_relations_md_v rel where rel.relation_name=:s and '||
584: ' col.parent_object_id=rel.relation_id ';
585: open cv for l_stmt using p_table;
586: loop
587: fetch cv into p_columns(p_number_columns);

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 748: 'edw_relations_md_v rel, '||

744: end if;
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, '||

Line 752: 'edw_relations_md_v p_rel, '||

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 '||
755: 'rel.relation_name=:a '||
756: 'and fk.entity_id=rel.relation_id '||

Line 2145: l_stmt:='select 1 from edw_pvt_map_properties_md_v map, edw_relations_md_v rel where rel.relation_name=:a and '||

2141: if g_debug then
2142: write_to_log_file_n('In Util.is_object_a_source, p_object_name='||p_object_name);
2143: end if;
2144: --not checked
2145: l_stmt:='select 1 from edw_pvt_map_properties_md_v map, edw_relations_md_v rel where rel.relation_name=:a and '||
2146: ' map.primary_source=rel.relation_id and rownum=1';
2147: if g_debug then
2148: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_object_name);
2149: end if;

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 2660: 'edw_relations_md_v sec_relation, '||

2656: 'sec_relation_usage.source_alias, '||
2657: 'sec_relation_child_usage.source_usage_id '||
2658: 'from '||
2659: 'edw_pvt_map_sources_md_v sec_relation_usage, '||
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, '||

Line 2662: 'edw_relations_md_v sec_relation_child, '||

2658: 'from '||
2659: 'edw_pvt_map_sources_md_v sec_relation_usage, '||
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, '||

Line 3160: 'edw_relations_md_v rel where rel.relation_name=:a and sis.entity_id=rel.relation_id '||

3156: write_to_log_file_n('In get_item_set_cols');
3157: end if;
3158: l_stmt:='select item.column_name from edw_attribute_sets_md_v sis, edw_attribute_set_columns_md_v isu, '||
3159: 'edw_pvt_columns_md_v item, '||
3160: 'edw_relations_md_v rel where rel.relation_name=:a and sis.entity_id=rel.relation_id '||
3161: 'and sis.attribute_group_name=:b and isu.attribute_group_id=sis.attribute_group_id and '||
3162: 'item.column_id=isu.column_id and item.parent_object_id=rel.relation_id';
3163: p_number_cols:=0;
3164: l_count:=1;

Line 3223: 'edw_relations_md_v src_rel, '||

3219: l_mapping_id:=get_target_map(null,p_tgt_object);
3220: if p_map_name is null then
3221: l_stmt:='select src_it.column_name,tgt_it.column_name '||
3222: 'from '||
3223: 'edw_relations_md_v src_rel, '||
3224: 'edw_relations_md_v tgt_rel, '||
3225: 'edw_pvt_map_sources_md_v map_sources, '||
3226: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns, '||
3227: 'edw_pvt_map_properties_md_v map, '||

Line 3224: 'edw_relations_md_v tgt_rel, '||

3220: if p_map_name is null then
3221: l_stmt:='select src_it.column_name,tgt_it.column_name '||
3222: 'from '||
3223: 'edw_relations_md_v src_rel, '||
3224: 'edw_relations_md_v tgt_rel, '||
3225: 'edw_pvt_map_sources_md_v map_sources, '||
3226: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns, '||
3227: 'edw_pvt_map_properties_md_v map, '||
3228: 'edw_pvt_columns_md_v tgt_it, '||

Line 3249: 'edw_relations_md_v src_rel, '||

3245: open cv for l_stmt using l_mapping_id,p_tgt_object,p_src_object;
3246: else
3247: l_stmt:='select src_it.column_name,tgt_it.column_name '||
3248: 'from '||
3249: 'edw_relations_md_v src_rel, '||
3250: 'edw_relations_md_v tgt_rel, '||
3251: 'edw_pvt_map_sources_md_v map_sources, '||
3252: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns, '||
3253: 'edw_pvt_map_properties_md_v map, '||

Line 3250: 'edw_relations_md_v tgt_rel, '||

3246: else
3247: l_stmt:='select src_it.column_name,tgt_it.column_name '||
3248: 'from '||
3249: 'edw_relations_md_v src_rel, '||
3250: 'edw_relations_md_v tgt_rel, '||
3251: 'edw_pvt_map_sources_md_v map_sources, '||
3252: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns, '||
3253: 'edw_pvt_map_properties_md_v map, '||
3254: 'edw_pvt_columns_md_v tgt_it, '||

Line 3316: 'from edw_pvt_map_properties_md_v map, edw_relations_md_v src, edw_relations_md_v tgt, '||

3312: l_src_id number;
3313: Begin
3314: p_number_maps:=0;
3315: l_stmt:='select map.mapping_id,map.primary_target, map.primary_source '||
3316: 'from edw_pvt_map_properties_md_v map, edw_relations_md_v src, edw_relations_md_v tgt, '||
3317: 'edw_pvt_mappings_md_v model where map.primary_target=tgt.relation_id and '||
3318: 'map.primary_source=src.relation_id and tgt.relation_name=:a and src.relation_name=:b and '||
3319: 'model.mapping_name=:c and model.mapping_id=map.mapping_id';
3320: if p_debug then

Line 3333: 'edw_relations_md_v src, '||

3329: 'src_col.column_name, '||
3330: 'tgt.relation_name, '||
3331: 'tgt_col.column_name '||
3332: 'from '||
3333: 'edw_relations_md_v src, '||
3334: 'edw_relations_md_v tgt, '||
3335: 'edw_pvt_columns_md_v src_col, '||
3336: 'edw_pvt_columns_md_v tgt_col, '||
3337: 'edw_pvt_map_properties_md_v map, '||

Line 3334: 'edw_relations_md_v tgt, '||

3330: 'tgt.relation_name, '||
3331: 'tgt_col.column_name '||
3332: 'from '||
3333: 'edw_relations_md_v src, '||
3334: 'edw_relations_md_v tgt, '||
3335: 'edw_pvt_columns_md_v src_col, '||
3336: 'edw_pvt_columns_md_v tgt_col, '||
3337: 'edw_pvt_map_properties_md_v map, '||
3338: 'edw_pvt_map_sources_md_v map_source, '||

Line 3504: l_stmt:='select relation_id from edw_relations_md_v where relation_name=:a';

3500: TYPE CurTyp IS REF CURSOR;
3501: cv CurTyp;
3502: l_obj_id number;
3503: Begin
3504: l_stmt:='select relation_id from edw_relations_md_v where relation_name=:a';
3505: open cv for l_stmt using p_object;
3506: fetch cv into l_obj_id;
3507: close cv;
3508: return l_obj_id;

Line 3675: 'edw_relations_md_v rel , '||

3671: Begin
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 '||

Line 4181: l_stmt:='select relation_name from edw_relations_md_v where relation_id=:a';

4177: cv CurTyp;
4178: l_stmt varchar2(1000);
4179: l_name varchar2(400);
4180: Begin
4181: l_stmt:='select relation_name from edw_relations_md_v where relation_id=:a';
4182: open cv for l_stmt using p_object_id;
4183: fetch cv into l_name;
4184: close cv;
4185: return l_name;

Line 4448: l_stmt:='select 1 from edw_relations_md_v rel,edw_attribute_sets_md_v sis where sis.attribute_group_name=:a '||

4444: if g_debug then
4445: write_to_log_file_n('In is_itemset_implemented '||p_object_name||' '||p_item_set||' '||p_object_id);
4446: end if;
4447: if p_object_id is null then
4448: l_stmt:='select 1 from edw_relations_md_v rel,edw_attribute_sets_md_v sis where sis.attribute_group_name=:a '||
4449: ' and sis.entity_id=rel.relation_id and rel.relation_name=:b';
4450: else
4451: l_stmt:='select 1 from edw_attribute_sets_md_v sis where sis.attribute_group_name=:a and sis.entity_id=:b';
4452: end if;

Line 4546: l_stmt:='select instr(lower(description),''master instance'') from edw_relations_md_v where relation_name=:a';

4542: if edw_option.get_warehouse_option(p_object_name,null,'MASTER_INSTANCE',l_master)=false then
4543: null;
4544: end if;
4545: else
4546: l_stmt:='select instr(lower(description),''master instance'') from edw_relations_md_v where relation_name=:a';
4547: if g_debug then
4548: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_object_name||get_time);
4549: end if;
4550: open cv for l_stmt using p_object_name;

Line 4557: 'length(description)))) from edw_relations_md_v where relation_name=:a';

4553: if l_res =0 then
4554: return null;
4555: end if;
4556: l_stmt:='select rtrim(ltrim(substr(upper(description),instr(lower(description),''master instance'')+16,'||
4557: 'length(description)))) from edw_relations_md_v where relation_name=:a';
4558: if g_debug then
4559: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_object_name||get_time);
4560: end if;
4561: open cv for l_stmt using p_object_name;

Line 4662: l_stmt:='select item.column_id from edw_pvt_columns_md_v item, edw_relations_md_v rel where rel.relation_name=:a '||

4658: TYPE CurTyp IS REF CURSOR;
4659: cv CurTyp;
4660: l_res number:=null;
4661: Begin
4662: l_stmt:='select item.column_id from edw_pvt_columns_md_v item, edw_relations_md_v rel where rel.relation_name=:a '||
4663: 'and item.column_name=:b and item.parent_object_id=rel.relation_id and item.parent_object_id=rel.relation_id';
4664: open cv for l_stmt using p_table,p_column;
4665: fetch cv into l_res;
4666: close cv;

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 4691: l_stmt:='select item.column_name from edw_pvt_columns_md_v item, edw_relations_md_v rel where '||

4687: open cv for l_stmt using p_table;
4688: fetch cv into l_res;
4689: close cv;
4690: if l_res is null then
4691: l_stmt:='select item.column_name from edw_pvt_columns_md_v item, edw_relations_md_v rel where '||
4692: 'item.parent_object_id=rel.relation_id and rel.relation_name=:a and item.column_name '||
4693: 'in (''INSTANCE'',''INSTANCE_CODE'') and item.parent_object_id=rel.relation_id';
4694: if g_debug then
4695: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_table);

Line 4866: l_stmt:='select relation_long_name from edw_relations_md_v where relation_id=:a';

4862: l_stmt varchar2(2000);
4863: TYPE CurTyp IS REF CURSOR;
4864: cv CurTyp;
4865: Begin
4866: l_stmt:='select relation_long_name from edw_relations_md_v where relation_id=:a';
4867: open cv for l_stmt using p_obj_id;
4868: fetch cv into l_name;
4869: close cv;
4870: return l_name;

Line 4971: 'edw_relations_md_v tgt_relation, '||

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

Line 5028: 'edw_relations_md_v rel '||

5024: l_map_id:=p_map_id;
5025: if p_map_id is null then
5026: l_stmt:='select map.mapping_id '||
5027: 'from edw_pvt_map_properties_md_v map, '||
5028: 'edw_relations_md_v rel '||
5029: 'where rel.relation_name=:a '||
5030: 'and map.primary_target=rel.relation_id ';
5031: if g_debug then
5032: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_object);

Line 5044: 'edw_relations_md_v src, '||

5040: 'src_col.column_name, '||
5041: 'tgt.relation_name, '||
5042: 'tgt_col.column_name '||
5043: 'from '||
5044: 'edw_relations_md_v src, '||
5045: 'edw_relations_md_v tgt, '||
5046: 'edw_pvt_columns_md_v src_col, '||
5047: 'edw_pvt_columns_md_v tgt_col, '||
5048: 'edw_pvt_map_properties_md_v map, '||

Line 5045: 'edw_relations_md_v tgt, '||

5041: 'tgt.relation_name, '||
5042: 'tgt_col.column_name '||
5043: 'from '||
5044: 'edw_relations_md_v src, '||
5045: 'edw_relations_md_v tgt, '||
5046: 'edw_pvt_columns_md_v src_col, '||
5047: 'edw_pvt_columns_md_v tgt_col, '||
5048: 'edw_pvt_map_properties_md_v map, '||
5049: 'edw_pvt_map_sources_md_v map_source, '||

Line 5094: 'edw_relations_md_v ltc, '||

5090: 'ltc.relation_name, '||
5091: 'fk_item.column_name '||
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, '||

Line 5099: 'edw_relations_md_v tgt '||

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 '||
5101: 'tgt.relation_name=:a '||
5102: 'and map.primary_target=tgt.relation_id '||
5103: 'and ltc_ru.mapping_id=map.mapping_id '||

Line 7095: l_stmt:='select map.mapping_id from edw_pvt_map_properties_md_v map,edw_relations_md_v rel where '||

7091: open cv for l_stmt using p_object_id;
7092: fetch cv into l_mapping_id;
7093: close cv;
7094: else
7095: l_stmt:='select map.mapping_id from edw_pvt_map_properties_md_v map,edw_relations_md_v rel where '||
7096: 'rel.relation_name=:a and map.primary_target=rel.relation_id ';
7097: if g_debug then
7098: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_object_name);
7099: end if;

Line 10223: edw_relations_md_v dim,

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
10227: where

Line 10435: 'edw_relations_md_v fstg, '||

10431: g_stmt:='select '||
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, '||

Line 10439: 'edw_relations_md_v p_table, '||

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 '||
10442: 'fstg.relation_id=fk.entity_id '||
10443: 'and fk.foreign_key_id=fku.key_id '||

Line 10547: 'edw_relations_md_v tgt_relation, '||

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