APPS.EDW_OWB_COLLECTION_UTIL dependencies on EDW_PVT_LEVEL_RELATION_MD_V

Line 86: edw_pvt_level_relation_md_v lvl_rel,

82: edw_pvt_key_columns_md_v parent_pk_set_usage,
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

Line 123: edw_pvt_level_relation_md_v lvl_rel,

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,
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

Line 5549: 'edw_pvt_level_relation_md_v lvl_rel, '||

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

Line 5600: 'edw_pvt_level_relation_md_v lvl_rel, '||

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

Line 5639: 'edw_pvt_level_relation_md_v lvl_rel, '||

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

Line 7045: 'edw_pvt_level_relation_md_v lvl_rel, '||

7041: 'child_ltc.name, '||
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, '||