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_DIMENSIONS_MD_V

Line 55: edw_dimensions_md_v a,

51: a.dim_id,
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

Line 2246: l_stmt:='select 1 from edw_dimensions_md_v dim,edw_attribute_sets_md_v sis where sis.attribute_group_name=:a '||

2242: if edw_option.get_warehouse_option(null,l_dim_id,'SLOWDIM',l_is_name)=false then
2243: null;
2244: end if;
2245: else
2246: l_stmt:='select 1 from edw_dimensions_md_v dim,edw_attribute_sets_md_v sis where sis.attribute_group_name=:a '||
2247: ' and sis.entity_id=dim.dim_id and dim.dim_name=:b';
2248: l_is_name:=p_is_name;
2249: if l_is_name is null then
2250: l_is_name:='DIMENSION_HISTORY';

Line 2332: l_stmt:='select dim.dim_name from edw_dimensions_md_v dim,edw_attribute_sets_md_v sis where sis.attribute_group_name=:a '||

2328: l_is_name:=p_is_name;
2329: if l_is_name is null then
2330: l_is_name:='DIMENSION_HISTORY';
2331: end if;
2332: l_stmt:='select dim.dim_name from edw_dimensions_md_v dim,edw_attribute_sets_md_v sis where sis.attribute_group_name=:a '||
2333: ' and sis.entity_id=dim.dim_id and dim.dim_name in ('||l_in_clause||')';
2334: if g_debug then
2335: write_to_log_file_n('Going to execute '||l_stmt||' using '||l_is_name);
2336: end if;

Line 2531: l_stmt:='select 1 from edw_dimensions_md_v dim, edw_attribute_sets_md_v sis '||

2527: Begin
2528: if g_debug then
2529: write_to_log_file_n('In is_push_down_implemented '||p_dim);
2530: end if;
2531: l_stmt:='select 1 from edw_dimensions_md_v dim, edw_attribute_sets_md_v sis '||
2532: ' where dim.dim_name=:a and sis.entity_id=dim.dim_id '||
2533: 'and sis.attribute_group_name=''EDW_LEVEL_PUSH_DOWN''';
2534: if g_debug then
2535: write_to_log_file_n('Going to execute '||l_stmt);

Line 3397: l_stmt:='select 1 from edw_dimensions_md_v dim, edw_attribute_sets_md_v sis '||

3393: write_to_log_file_n('In is_slowly_changing_dimension , dim is '||p_dim_name);
3394: end if;
3395: l_sis_name:='DIMENSION_HISTORY';
3396: l_var:=null;
3397: l_stmt:='select 1 from edw_dimensions_md_v dim, edw_attribute_sets_md_v sis '||
3398: ' where dim.dim_name=:a and sis.entity_id=dim.dim_id and sis.attribute_group_name=:b ';
3399: open cv for l_stmt using p_dim_name, l_sis_name;
3400: fetch cv into l_var;
3401: close cv;

Line 3521: l_stmt:='select dim_id from edw_dimensions_md_v where dim_name=:a';

3517: TYPE CurTyp IS REF CURSOR;
3518: cv CurTyp;
3519: l_obj_id number;
3520: Begin
3521: l_stmt:='select dim_id from edw_dimensions_md_v where dim_name=:a';
3522: open cv for l_stmt using p_object;
3523: fetch cv into l_obj_id;
3524: close cv;
3525: return l_obj_id;

Line 4050: 'edw_dimensions_md_v rel, '||

4046: 'tgt.fact_id, '||
4047: 'src.fact_id '||
4048: 'from '||
4049: 'edw_pvt_map_sources_md_v ru, '||
4050: 'edw_dimensions_md_v rel, '||
4051: 'edw_pvt_map_properties_md_v map, '||
4052: 'edw_facts_md_v src, '||
4053: 'edw_facts_md_v tgt, '||
4054: 'edw_attribute_sets_md_v sis '||

Line 4070: 'edw_dimensions_md_v rel, '||

4066: 'tgt.fact_id, '||
4067: 'src.fact_id '||
4068: 'from '||
4069: 'edw_pvt_map_sources_md_v ru, '||
4070: 'edw_dimensions_md_v rel, '||
4071: 'edw_pvt_map_properties_md_v map, '||
4072: 'edw_facts_md_v src, '||
4073: 'edw_facts_md_v tgt '||
4074: 'where '||

Line 4137: 'edw_dimensions_md_v dim, '||

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, '||
4141: 'edw_pvt_columns_md_v 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 4788: 'edw_dimensions_md_v dim, '||

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

Line 5145: 'edw_dimensions_md_v dim, '||

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 '||
5148: 'dim.dim_name=:a '||
5149: 'and lvl.dim_id=dim.dim_id '||

Line 5401: l_stmt:='select 1 from edw_dimensions_md_v where dim_name=:a';

5397: TYPE CurTyp IS REF CURSOR;
5398: cv CurTyp;
5399: l_res number;
5400: Begin
5401: l_stmt:='select 1 from edw_dimensions_md_v where dim_name=:a';
5402: open cv for l_stmt using p_object_name;
5403: fetch cv into l_res;
5404: close cv;
5405: if l_res=1 then

Line 5440: 'edw_dimensions_md_v dim, '||

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 '||
5443: 'and lvl.dim_id=dim.dim_id '||
5444: 'and ltc.name=lvl.level_name||''_LTC'' '||

Line 5543: 'edw_dimensions_md_v dim '||

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 '||
5547: 'and not exists( '||

Line 5594: 'edw_dimensions_md_v dim '||

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 '||
5598: 'and not exists( '||

Line 5631: 'edw_dimensions_md_v dim '||

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
5635: l_stmt:=l_stmt||'and dim.dim_name in ('||p_dim_in||') ';

Line 6404: open cv for l_stmt using 'EDW_DIMENSIONS_MD_V';

6400: l_stmt:='select text from user_views where view_name=:a';
6401: if g_debug then
6402: write_to_log_file_n(l_stmt);
6403: end if;
6404: open cv for l_stmt using 'EDW_DIMENSIONS_MD_V';
6405: fetch cv into l_view_text;
6406: close cv;
6407: l_view_text:=lower(l_view_text);
6408: if g_debug then

Line 7047: 'edw_dimensions_md_v dim, '||

7043: 'hier.HIER_NAME '||
7044: 'from '||
7045: 'edw_pvt_level_relation_md_v lvl_rel, '||
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 '||