APPS.EDW_OWB_COLLECTION_UTIL dependencies on EDW_PVT_MAP_SOURCES_MD_V

Line 146: edw_pvt_map_sources_md_v map_sources,

142: upper(relation.name),
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

Line 2659: 'edw_pvt_map_sources_md_v sec_relation_usage, '||

2655: 'sec_relation_usage.source_usage_id, '||
2656: 'sec_relation_usage.source_alias, '||
2657: 'sec_relation_child_usage.source_usage_id '||
2658: 'from '||
2659: 'edw_pvt_map_sources_md_v sec_relation_usage, '||
2660: 'edw_relations_md_v sec_relation, '||
2661: 'edw_pvt_map_sources_md_v sec_relation_child_usage, '||
2662: 'edw_relations_md_v sec_relation_child, '||
2663: 'edw_pvt_map_key_usages_md_v fk_usage, '||

Line 2661: 'edw_pvt_map_sources_md_v sec_relation_child_usage, '||

2657: 'sec_relation_child_usage.source_usage_id '||
2658: 'from '||
2659: 'edw_pvt_map_sources_md_v sec_relation_usage, '||
2660: 'edw_relations_md_v sec_relation, '||
2661: 'edw_pvt_map_sources_md_v sec_relation_child_usage, '||
2662: 'edw_relations_md_v sec_relation_child, '||
2663: 'edw_pvt_map_key_usages_md_v fk_usage, '||
2664: 'edw_pvt_key_columns_md_v fk_isu, '||
2665: 'edw_pvt_columns_md_v fk_item, '||

Line 3225: 'edw_pvt_map_sources_md_v map_sources, '||

3221: l_stmt:='select src_it.column_name,tgt_it.column_name '||
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 '||

Line 3251: 'edw_pvt_map_sources_md_v map_sources, '||

3247: l_stmt:='select src_it.column_name,tgt_it.column_name '||
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, '||

Line 3338: 'edw_pvt_map_sources_md_v map_source, '||

3334: 'edw_relations_md_v tgt, '||
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 '||

Line 4049: 'edw_pvt_map_sources_md_v ru, '||

4045: 'distinct map.mapping_id, '||
4046: 'tgt.fact_id, '||
4047: 'src.fact_id '||
4048: 'from '||
4049: 'edw_pvt_map_sources_md_v ru, '||
4050: 'edw_dimensions_md_v rel, '||
4051: 'edw_pvt_map_properties_md_v map, '||
4052: 'edw_facts_md_v src, '||
4053: 'edw_facts_md_v tgt, '||

Line 4069: 'edw_pvt_map_sources_md_v ru, '||

4065: 'distinct map.mapping_id, '||
4066: 'tgt.fact_id, '||
4067: 'src.fact_id '||
4068: 'from '||
4069: 'edw_pvt_map_sources_md_v ru, '||
4070: 'edw_dimensions_md_v rel, '||
4071: 'edw_pvt_map_properties_md_v map, '||
4072: 'edw_facts_md_v src, '||
4073: 'edw_facts_md_v tgt '||

Line 4279: 'edw_pvt_map_sources_md_v map_sources_dim, '||

4275: if p_map_id is not null then
4276: l_stmt:='select pk_item.column_name, fk_item.column_name '||
4277: 'from '||
4278: 'edw_pvt_map_properties_md_v map, '||
4279: 'edw_pvt_map_sources_md_v map_sources_dim, '||
4280: 'edw_pvt_map_sources_md_v map_sources_fact, '||
4281: 'edw_pvt_map_key_usages_md_v map_key_usage, '||
4282: 'edw_pvt_key_columns_md_v fk_key_column, '||
4283: 'edw_pvt_columns_md_v fk_item, '||

Line 4280: 'edw_pvt_map_sources_md_v map_sources_fact, '||

4276: l_stmt:='select pk_item.column_name, fk_item.column_name '||
4277: 'from '||
4278: 'edw_pvt_map_properties_md_v map, '||
4279: 'edw_pvt_map_sources_md_v map_sources_dim, '||
4280: 'edw_pvt_map_sources_md_v map_sources_fact, '||
4281: 'edw_pvt_map_key_usages_md_v map_key_usage, '||
4282: 'edw_pvt_key_columns_md_v fk_key_column, '||
4283: 'edw_pvt_columns_md_v fk_item, '||
4284: 'edw_pvt_key_columns_md_v pk_key_column, '||

Line 4968: 'edw_pvt_map_sources_md_v map_sources, '||

4964: l_stmt:='select '||
4965: 'tgt_column.column_name '||
4966: 'from '||
4967: 'edw_pvt_map_properties_md_v map_properties, '||
4968: 'edw_pvt_map_sources_md_v map_sources, '||
4969: 'edw_pvt_map_targets_md_v map_targets, '||
4970: 'edw_tables_md_v src_table, '||
4971: 'edw_relations_md_v tgt_relation, '||
4972: 'edw_unique_keys_md_v pk, '||

Line 5049: 'edw_pvt_map_sources_md_v map_source, '||

5045: 'edw_relations_md_v tgt, '||
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 '||

Line 5093: 'edw_pvt_map_sources_md_v ltc_ru, '||

5089: l_stmt:='select '||
5090: 'ltc.relation_name, '||
5091: 'fk_item.column_name '||
5092: 'from '||
5093: 'edw_pvt_map_sources_md_v ltc_ru, '||
5094: 'edw_relations_md_v ltc, '||
5095: 'edw_pvt_map_key_usages_md_v fk_usage, '||
5096: 'edw_pvt_key_columns_md_v fk_isu, '||
5097: 'edw_pvt_columns_md_v fk_item, '||

Line 5989: 'edw_pvt_map_sources_md_v sec_relation_usage, '||

5985: end if;
5986: l_stmt:='select '||
5987: 'sec_relation.sequence_name '||
5988: 'from '||
5989: 'edw_pvt_map_sources_md_v sec_relation_usage, '||
5990: 'edw_pvt_sequences_md_v sec_relation, '||
5991: 'edw_pvt_map_properties_md_v map '||
5992: 'where '||
5993: 'map.primary_target=:a '||

Line 10214: edw_pvt_map_key_usages_md_v,edw_pvt_map_sources_md_v

10210: edw_pvt_map_key_usages_md_v.Unique_key_id,
10211: edw_pvt_map_key_usages_md_v.foreign_key_id,
10212: edw_pvt_map_key_usages_md_v.Parent_table_usage_id
10213: from
10214: edw_pvt_map_key_usages_md_v,edw_pvt_map_sources_md_v
10215: where edw_pvt_map_sources_md_v.source_usage_id=edw_pvt_map_key_usages_md_v.parent_table_usage_id
10216: and edw_pvt_map_key_usages_md_v.Source_usage_id=p_fstg_usage_id
10217: and edw_pvt_map_key_usages_md_v.mapping_id=p_mapping_id
10218: and edw_pvt_map_sources_md_v.mapping_id=p_mapping_id

Line 10215: where edw_pvt_map_sources_md_v.source_usage_id=edw_pvt_map_key_usages_md_v.parent_table_usage_id

10211: edw_pvt_map_key_usages_md_v.foreign_key_id,
10212: edw_pvt_map_key_usages_md_v.Parent_table_usage_id
10213: from
10214: edw_pvt_map_key_usages_md_v,edw_pvt_map_sources_md_v
10215: where edw_pvt_map_sources_md_v.source_usage_id=edw_pvt_map_key_usages_md_v.parent_table_usage_id
10216: and edw_pvt_map_key_usages_md_v.Source_usage_id=p_fstg_usage_id
10217: and edw_pvt_map_key_usages_md_v.mapping_id=p_mapping_id
10218: and edw_pvt_map_sources_md_v.mapping_id=p_mapping_id
10219: ) key_usage,

Line 10218: and edw_pvt_map_sources_md_v.mapping_id=p_mapping_id

10214: edw_pvt_map_key_usages_md_v,edw_pvt_map_sources_md_v
10215: where edw_pvt_map_sources_md_v.source_usage_id=edw_pvt_map_key_usages_md_v.parent_table_usage_id
10216: and edw_pvt_map_key_usages_md_v.Source_usage_id=p_fstg_usage_id
10217: and edw_pvt_map_key_usages_md_v.mapping_id=p_mapping_id
10218: and edw_pvt_map_sources_md_v.mapping_id=p_mapping_id
10219: ) key_usage,
10220: edw_pvt_key_columns_md_v key_col,
10221: edw_pvt_key_columns_md_v fk_key_col,
10222: edw_unique_keys_md_v dim_pk,

Line 10544: 'edw_pvt_map_sources_md_v map_sources, '||

10540: 'pk_col.column_name, '||
10541: 'tgt_column.column_name '||
10542: 'from '||
10543: 'edw_pvt_map_properties_md_v map_properties, '||
10544: 'edw_pvt_map_sources_md_v map_sources, '||
10545: 'edw_pvt_map_targets_md_v map_targets, '||
10546: 'edw_tables_md_v src_table, '||
10547: 'edw_relations_md_v tgt_relation, '||
10548: 'edw_unique_keys_md_v pk, '||