APPS.EDW_OWB_COLLECTION_UTIL dependencies on EDW_HIERARCHIES_MD_V

Line 87: edw_hierarchies_md_v hier,

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,
87: edw_hierarchies_md_v hier,
88: edw_pvt_map_properties_md_v parent_map
89: where
90: hier.dim_id=p_dim_id
91: and lvl_rel.hierarchy_id=hier.hier_id

Line 124: edw_hierarchies_md_v hier,

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,
125: edw_pvt_map_properties_md_v parent_map
126: where
127: hier.dim_id=p_dim_id
128: and lvl_rel.hierarchy_id=hier.hier_id

Line 5550: 'edw_hierarchies_md_v hier '||

5546: 'and dim.dim_name=:a '||
5547: 'and not exists( '||
5548: 'select 1 from '||
5549: 'edw_pvt_level_relation_md_v lvl_rel, '||
5550: 'edw_hierarchies_md_v hier '||
5551: 'where '||
5552: 'lvl_rel.hierarchy_id=hier.hier_id '||
5553: 'and hier.dim_id=dim.dim_id '||
5554: 'and lvl_rel.parent_level_id=lvl.level_id) ';

Line 5601: 'edw_hierarchies_md_v hier '||

5597: 'and dim.dim_name=:a '||
5598: 'and not exists( '||
5599: 'select 1 from '||
5600: 'edw_pvt_level_relation_md_v lvl_rel, '||
5601: 'edw_hierarchies_md_v hier '||
5602: 'where '||
5603: 'lvl_rel.hierarchy_id=hier.hier_id '||
5604: 'and hier.dim_id=dim.dim_id '||
5605: 'and lvl_rel.parent_level_id=lvl.level_id) ';

Line 5640: 'edw_hierarchies_md_v hier '||

5636: end if;
5637: l_stmt:=l_stmt||'and not exists( '||
5638: 'select 1 from '||
5639: 'edw_pvt_level_relation_md_v lvl_rel, '||
5640: 'edw_hierarchies_md_v hier '||
5641: 'where '||
5642: 'lvl_rel.hierarchy_id=hier.hier_id '||
5643: 'and hier.dim_id=dim.dim_id '||
5644: 'and lvl_rel.parent_level_id=lvl.level_id) ';

Line 7046: 'edw_hierarchies_md_v hier, '||

7042: 'child_ltc.elementid, '||
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, '||