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_LEVELS_MD_V

Line 76: edw_levels_md_v lvl_child,

72: nvl(parent_map.mapping_id,0),
73: nvl(parent_map.primary_source,0),
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,

Line 77: edw_levels_md_v lvl_parent,

73: nvl(parent_map.primary_source,0),
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,

Line 118: edw_levels_md_v lvl_child,

114: parent_map.mapping_id, --actually child map
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,

Line 166: edw_levels_md_v lvl,

162: lvl.level_prefix||'_'||item.column_name||'_ROWID',
163: lvl.level_name||'_LTC',
164: 'ROWID'
165: from
166: edw_levels_md_v lvl,
167: edw_pvt_level_columns_md_v item
168: where
169: lvl.dim_id=p_dim_id
170: and item.level_id=lvl.level_id

Line 3191: l_stmt:='select level_prefix from edw_levels_md_v where level_name=:a';

3187: l_stmt varchar2(1000);
3188: TYPE CurTyp IS REF CURSOR;
3189: cv CurTyp;
3190: Begin
3191: l_stmt:='select level_prefix from edw_levels_md_v where level_name=:a';
3192: if g_debug then
3193: write_to_log_file_n(l_stmt||' '||p_level);
3194: end if;
3195: open cv for l_stmt using p_level;

Line 4138: 'edw_levels_md_v lvl, '||

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, '||
4142: 'edw_pvt_key_columns_md_v isu '||

Line 5146: 'edw_levels_md_v lvl '||

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 '||
5150: 'and rel.name=lvl.level_name||''_LTC'' '||

Line 5441: 'edw_levels_md_v lvl '||

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'' '||
5445: 'and map.primary_target(+)=ltc.elementid '||

Line 5541: 'edw_levels_md_v lvl, '||

5537: cv CurTyp;
5538: Begin
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'' '||

Line 5592: 'edw_levels_md_v lvl, '||

5588: l_dim_id:=get_dim_id(p_dim);
5589: end if;
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'' '||

Line 5629: 'edw_levels_md_v lvl, '||

5625: Begin
5626: p_number_dim:=0;
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'' ';

Line 5909: 'edw_levels_md_v lvl '||

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 '||
5912: 'and rel.name=lvl.level_name||''_LTC'' '||
5913: 'and pk.entity_id=rel.elementid '||

Line 5953: 'edw_levels_md_v lvl '||

5949: end if;
5950: l_stmt:='select '||
5951: 'lvl.level_prefix||''_NAME'' '||
5952: 'from '||
5953: 'edw_levels_md_v lvl '||
5954: 'where '||
5955: ' lvl.dim_id=:a ';
5956: if g_debug then
5957: write_to_log_file_n(l_stmt||' using '||l_dim_id);

Line 7048: 'edw_levels_md_v child_level, '||

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

Line 7049: 'edw_levels_md_v parent_level, '||

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 '||
7052: 'where '||
7053: 'dim.dim_name=:a '||

Line 11069: edw_levels_md_v lvl,

11065: lvl.LEVEL_TABLE_ID,
11066: rel.CHIL_LVLTBL_NAME,
11067: rel.CHILD_LVLTBL_ID
11068: from
11069: edw_levels_md_v lvl,
11070: edw_level_relations_md_v rel
11071: where
11072: lvl.LEVEL_TABLE_NAME=p_ltc
11073: and rel.PARENT_LVL_ID(+)=lvl.level_id;

Line 11107: 'from edw_levels_md_v lvl,edw_level_relations_md_v rel where lvl.LEVEL_TABLE_NAME='||p_level_order(i)||

11103: l_count:=0;
11104: for i in 1..p_number_levels loop
11105: if g_debug then
11106: write_to_log_file_n('select distinct rel.PARENT_LVLTBL_ID,rel.CHIL_LVLTBL_NAME,rel.CHILD_LVLTBL_ID '||
11107: 'from edw_levels_md_v lvl,edw_level_relations_md_v rel where lvl.LEVEL_TABLE_NAME='||p_level_order(i)||
11108: ' and rel.PARENT_LVL_ID=lvl.level_id');
11109: end if;
11110: l_num_ltc:=1;
11111: open c1(p_level_order(i));

Line 11182: select LEVEL_TABLE_ID from edw_levels_md_v where dim_id=p_dim_id;

11178: p_bis_owner varchar2
11179: ) return boolean is
11180: --
11181: cursor c1(p_dim_id number) is
11182: select LEVEL_TABLE_ID from edw_levels_md_v where dim_id=p_dim_id;
11183: --
11184: l_ltc_id number;
11185: --
11186: Begin