APPS.EDW_OWB_COLLECTION_UTIL dependencies on EDW_PVT_MAP_COLUMNS_MD_V

Line 147: (select * from edw_pvt_map_columns_md_v where mapping_id=p_mapping_id) map_columns,

143: upper(level_item.column_name)
144: from
145: edw_pvt_map_properties_md_v map_properties,
146: edw_pvt_map_sources_md_v map_sources,
147: (select * from edw_pvt_map_columns_md_v where mapping_id=p_mapping_id) map_columns,
148: edw_tables_md_v relation,
149: edw_pvt_columns_md_v dim_item,
150: edw_pvt_columns_md_v level_item
151: where

Line 3226: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns, '||

3222: 'from '||
3223: 'edw_relations_md_v src_rel, '||
3224: 'edw_relations_md_v tgt_rel, '||
3225: 'edw_pvt_map_sources_md_v map_sources, '||
3226: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns, '||
3227: 'edw_pvt_map_properties_md_v map, '||
3228: 'edw_pvt_columns_md_v tgt_it, '||
3229: 'edw_pvt_columns_md_v src_it '||
3230: 'where '||

Line 3252: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns, '||

3248: 'from '||
3249: 'edw_relations_md_v src_rel, '||
3250: 'edw_relations_md_v tgt_rel, '||
3251: 'edw_pvt_map_sources_md_v map_sources, '||
3252: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns, '||
3253: 'edw_pvt_map_properties_md_v map, '||
3254: 'edw_pvt_columns_md_v tgt_it, '||
3255: 'edw_pvt_columns_md_v src_it, '||
3256: 'edw_pvt_mappings_md_v model '||

Line 3339: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns '||

3335: 'edw_pvt_columns_md_v src_col, '||
3336: 'edw_pvt_columns_md_v tgt_col, '||
3337: 'edw_pvt_map_properties_md_v map, '||
3338: 'edw_pvt_map_sources_md_v map_source, '||
3339: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns '||
3340: 'where '||
3341: 'map.mapping_id=:a '||
3342: 'and map_source.mapping_id=map.mapping_id '||
3343: 'and map_source.source_id=src.relation_id '||

Line 3922: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_col, '||

3918: 'map_col.func_usage_id, '||
3919: '1 attribute_position, '||
3920: 'null '||
3921: 'from '||
3922: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_col, '||
3923: 'edw_relations_md rel, '||
3924: 'edw_pvt_columns_md col, '||
3925: 'edw_pvt_map_targets_md tgt '||
3926: 'where '||

Line 3973: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_col, '||

3969: 'map_col.func_usage_id, '||
3970: '1 attribute_position, '||
3971: 'null '||
3972: 'from '||
3973: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_col, '||
3974: 'edw_relations_md rel, '||
3975: 'edw_pvt_columns_md col, '||
3976: 'edw_pvt_map_sources_md src '||
3977: 'where '||

Line 4975: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns, '||

4971: 'edw_relations_md_v tgt_relation, '||
4972: 'edw_unique_keys_md_v pk, '||
4973: 'edw_pvt_key_columns_md_v key_usage, '||
4974: 'edw_pvt_columns_md_v pk_col, '||
4975: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns, '||
4976: 'edw_pvt_columns_md_v tgt_column '||
4977: 'where '||
4978: ' map_sources.source_id=map_properties.primary_source '||
4979: 'and map_targets.target_id=map_properties.primary_target '||

Line 5050: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns '||

5046: 'edw_pvt_columns_md_v src_col, '||
5047: 'edw_pvt_columns_md_v tgt_col, '||
5048: 'edw_pvt_map_properties_md_v map, '||
5049: 'edw_pvt_map_sources_md_v map_source, '||
5050: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns '||
5051: 'where '||
5052: 'map.mapping_id=:a '||
5053: 'and map_source.mapping_id=map.mapping_id '||
5054: 'and map_columns.mapping_id=map.mapping_id '||

Line 10207: (select Source_usage_id,Target_column_id from edw_pvt_map_columns_md_v

10203: dim_pk_item.column_name dim_col,
10204: fstg_item.column_name fstg_col,
10205: fact_item.column_name fact_col
10206: from
10207: (select Source_usage_id,Target_column_id from edw_pvt_map_columns_md_v
10208: where mapping_id=p_mapping_id) map_columns,
10209: (select edw_pvt_map_key_usages_md_v.Source_usage_id,
10210: edw_pvt_map_key_usages_md_v.Unique_key_id,
10211: edw_pvt_map_key_usages_md_v.foreign_key_id,

Line 10551: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns, '||

10547: 'edw_relations_md_v tgt_relation, '||
10548: 'edw_unique_keys_md_v pk, '||
10549: 'edw_pvt_key_columns_md_v key_usage, '||
10550: 'edw_pvt_columns_md_v pk_col, '||
10551: '(select * from edw_pvt_map_columns_md_v where mapping_id=:1) map_columns, '||
10552: 'edw_pvt_columns_md_v tgt_column '||
10553: 'where '||
10554: 'map_properties.mapping_id=:2 '||
10555: 'and map_sources.source_id=map_properties.primary_source '||