APPS.EDW_OWB_COLLECTION_UTIL dependencies on EDW_LEVEL_RELATIONS_MD_V

Line 11070: edw_level_relations_md_v rel

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;
11074: --

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));