APPS.EDW_OWB_COLLECTION_UTIL dependencies on EDW_PVT_MAP_KEY_USAGES_MD_V

Line 2663: 'edw_pvt_map_key_usages_md_v fk_usage, '||

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, '||
2666: 'edw_pvt_key_columns_md_v pk_isu, '||
2667: 'edw_pvt_columns_md_v pk_item '||

Line 4281: 'edw_pvt_map_key_usages_md_v map_key_usage, '||

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, '||
4285: 'edw_pvt_columns_md_v pk_item '||

Line 5095: 'edw_pvt_map_key_usages_md_v fk_usage, '||

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, '||
5098: 'edw_pvt_map_properties_md_v map, '||
5099: 'edw_relations_md_v tgt '||

Line 10209: (select edw_pvt_map_key_usages_md_v.Source_usage_id,

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,
10212: edw_pvt_map_key_usages_md_v.Parent_table_usage_id
10213: from

Line 10210: edw_pvt_map_key_usages_md_v.Unique_key_id,

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

Line 10211: edw_pvt_map_key_usages_md_v.foreign_key_id,

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

Line 10212: edw_pvt_map_key_usages_md_v.Parent_table_usage_id

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

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 10216: and edw_pvt_map_key_usages_md_v.Source_usage_id=p_fstg_usage_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,
10220: edw_pvt_key_columns_md_v key_col,

Line 10217: and edw_pvt_map_key_usages_md_v.mapping_id=p_mapping_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,
10220: edw_pvt_key_columns_md_v key_col,
10221: edw_pvt_key_columns_md_v fk_key_col,