eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_OWB_COLLECTION_UTIL dependencies on EDW_PVT_COLUMNS_MD_V

Line 80: edw_pvt_columns_md_v child_fk_item,

76: edw_levels_md_v lvl_child,
77: edw_levels_md_v lvl_parent,
78: edw_foreign_keys_md_v child_fk,
79: edw_pvt_key_columns_md_v child_fk_set_usage,
80: edw_pvt_columns_md_v child_fk_item,
81: edw_unique_keys_md_v parent_pk,
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,

Line 83: edw_pvt_columns_md_v parent_pk_item,

79: edw_pvt_key_columns_md_v child_fk_set_usage,
80: edw_pvt_columns_md_v child_fk_item,
81: edw_unique_keys_md_v parent_pk,
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,

Line 121: edw_pvt_columns_md_v parent_pk_item,

117: from
118: edw_levels_md_v lvl_child,
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

Line 149: edw_pvt_columns_md_v dim_item,

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
152: map_properties.mapping_id=p_mapping_id
153: and map_sources.mapping_id=map_properties.mapping_id

Line 150: edw_pvt_columns_md_v level_item

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
152: map_properties.mapping_id=p_mapping_id
153: and map_sources.mapping_id=map_properties.mapping_id
154: and map_columns.Target_column_id=dim_item.column_id

Line 583: l_stmt:='select col.column_name from edw_pvt_columns_md_v col, edw_relations_md_v rel where rel.relation_name=:s and '||

579: if g_debug then
580: write_to_log_file_n('In get_columns_for_table, Input params is '||p_table);
581: end if;
582: p_number_columns:=1;
583: l_stmt:='select col.column_name from edw_pvt_columns_md_v col, edw_relations_md_v rel where rel.relation_name=:s and '||
584: ' col.parent_object_id=rel.relation_id ';
585: open cv for l_stmt using p_table;
586: loop
587: fetch cv into p_columns(p_number_columns);

Line 715: l_stmt:='select col.column_name from edw_pvt_columns_md_v col, edw_relations_md_v rel, edw_foreign_keys_md_v fk, '||

711: if g_debug then
712: write_to_log_file_n('In get_fks_for_table, Input params is '||p_table);
713: end if;
714: p_number_fks:=1;
715: l_stmt:='select col.column_name from edw_pvt_columns_md_v col, edw_relations_md_v rel, edw_foreign_keys_md_v fk, '||
716: 'edw_pvt_key_columns_md_v fku where rel.relation_name=:a and fk.entity_id=rel.relation_id and '||
717: 'fku.key_id=fk.foreign_key_id and col.column_id=fku.column_id and col.parent_object_id=rel.relation_id';
718: open cv for l_stmt using p_table;
719: loop

Line 751: 'edw_pvt_columns_md_v fk_item, '||

747: 'from '||
748: 'edw_relations_md_v rel, '||
749: 'edw_foreign_keys_md_v fk, '||
750: 'edw_pvt_key_columns_md_v fkisu, '||
751: 'edw_pvt_columns_md_v fk_item, '||
752: 'edw_relations_md_v p_rel, '||
753: 'edw_unique_keys_md_v pk '||
754: 'where '||
755: 'rel.relation_name=:a '||

Line 2448: l_stmt:='select pk_item.column_name from edw_unique_keys_md_v pk,edw_pvt_columns_md_v pk_item,edw_relations_md_v rel, '||

2444: if g_debug then
2445: write_to_log_file_n('In get_table_surr_pk');
2446: write_to_log_file('p_table='||p_table);
2447: end if;
2448: l_stmt:='select pk_item.column_name from edw_unique_keys_md_v pk,edw_pvt_columns_md_v pk_item,edw_relations_md_v rel, '||
2449: 'edw_pvt_key_columns_md_v isu where rel.relation_name=:a and pk.entity_id=rel.relation_id '||
2450: 'and isu.key_id=pk.key_id and pk_item.column_id=isu.column_id and pk_item.column_name like ''%_KEY'' '||
2451: 'and pk_item.parent_object_id=rel.relation_id';
2452: open cv for l_stmt using p_table;

Line 2665: 'edw_pvt_columns_md_v fk_item, '||

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 '||
2668: 'where '||
2669: ' sec_relation_usage.mapping_id=:a '||

Line 2667: 'edw_pvt_columns_md_v pk_item '||

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 '||
2668: 'where '||
2669: ' sec_relation_usage.mapping_id=:a '||
2670: 'and sec_relation.relation_id=sec_relation_usage.source_id '||
2671: 'and sec_relation_child_usage.mapping_id=sec_relation_usage.mapping_id '||

Line 3159: 'edw_pvt_columns_md_v item, '||

3155: if g_debug then
3156: write_to_log_file_n('In get_item_set_cols');
3157: end if;
3158: l_stmt:='select item.column_name from edw_attribute_sets_md_v sis, edw_attribute_set_columns_md_v isu, '||
3159: 'edw_pvt_columns_md_v item, '||
3160: 'edw_relations_md_v rel where rel.relation_name=:a and sis.entity_id=rel.relation_id '||
3161: 'and sis.attribute_group_name=:b and isu.attribute_group_id=sis.attribute_group_id and '||
3162: 'item.column_id=isu.column_id and item.parent_object_id=rel.relation_id';
3163: p_number_cols:=0;

Line 3228: 'edw_pvt_columns_md_v tgt_it, '||

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 '||
3231: 'tgt_rel.relation_name=:a '||
3232: 'and src_rel.relation_name=:b '||

Line 3229: 'edw_pvt_columns_md_v src_it '||

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 '||
3231: 'tgt_rel.relation_name=:a '||
3232: 'and src_rel.relation_name=:b '||
3233: 'and map.primary_target=tgt_rel.relation_id '||

Line 3254: 'edw_pvt_columns_md_v tgt_it, '||

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 '||
3257: 'where '||
3258: 'tgt_rel.relation_name=:a '||

Line 3255: 'edw_pvt_columns_md_v src_it, '||

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 '||
3257: 'where '||
3258: 'tgt_rel.relation_name=:a '||
3259: 'and src_rel.relation_name=:b '||

Line 3335: 'edw_pvt_columns_md_v src_col, '||

3331: 'tgt_col.column_name '||
3332: 'from '||
3333: 'edw_relations_md_v src, '||
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 '||

Line 3336: 'edw_pvt_columns_md_v tgt_col, '||

3332: 'from '||
3333: 'edw_relations_md_v src, '||
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 '||

Line 3678: 'edw_pvt_columns_md_v pk_item '||

3674: 'from '||
3675: 'edw_relations_md_v rel , '||
3676: 'edw_unique_keys_md_v pk, '||
3677: 'edw_pvt_key_columns_md_v isu, '||
3678: 'edw_pvt_columns_md_v pk_item '||
3679: 'where '||
3680: 'rel.relation_name=:a '||
3681: 'and pk.entity_id=rel.relation_id '||
3682: 'and pk.primarykey <> 1 '||

Line 4141: 'edw_pvt_columns_md_v item, '||

4137: 'edw_dimensions_md_v dim, '||
4138: 'edw_levels_md_v lvl, '||
4139: 'edw_tables_md_v ltc, '||
4140: 'edw_unique_keys_md_v ltc_pk, '||
4141: 'edw_pvt_columns_md_v item, '||
4142: 'edw_pvt_key_columns_md_v isu '||
4143: 'where '||
4144: 'fk.entity_id=:a '||
4145: 'and fk.key_id=pk.key_id '||

Line 4283: 'edw_pvt_columns_md_v fk_item, '||

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 '||
4286: 'where '||
4287: 'map_sources_dim.source_id=:a '||

Line 4285: 'edw_pvt_columns_md_v pk_item '||

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 '||
4286: 'where '||
4287: 'map_sources_dim.source_id=:a '||
4288: 'and map_sources_fact.source_id=:b '||
4289: 'and map.mapping_id=:c '||

Line 4311: 'edw_pvt_columns_md_v fk_item, '||

4307: 'edw_foreign_keys_md_v fk, '||
4308: 'edw_unique_keys_md_v pk, '||
4309: 'edw_pvt_key_columns_md_v fk_use, '||
4310: 'edw_pvt_key_columns_md_v pk_use, '||
4311: 'edw_pvt_columns_md_v fk_item, '||
4312: 'edw_pvt_columns_md_v pk_item '||
4313: 'where '||
4314: ' pk.entity_id=:a '||
4315: 'and fk.entity_id=:b '||

Line 4312: 'edw_pvt_columns_md_v pk_item '||

4308: 'edw_unique_keys_md_v pk, '||
4309: 'edw_pvt_key_columns_md_v fk_use, '||
4310: 'edw_pvt_key_columns_md_v pk_use, '||
4311: 'edw_pvt_columns_md_v fk_item, '||
4312: 'edw_pvt_columns_md_v pk_item '||
4313: 'where '||
4314: ' pk.entity_id=:a '||
4315: 'and fk.entity_id=:b '||
4316: 'and fk_use.key_id=fk.foreign_key_id '||

Line 4662: l_stmt:='select item.column_id from edw_pvt_columns_md_v item, edw_relations_md_v rel where rel.relation_name=:a '||

4658: TYPE CurTyp IS REF CURSOR;
4659: cv CurTyp;
4660: l_res number:=null;
4661: Begin
4662: l_stmt:='select item.column_id from edw_pvt_columns_md_v item, edw_relations_md_v rel where rel.relation_name=:a '||
4663: 'and item.column_name=:b and item.parent_object_id=rel.relation_id and item.parent_object_id=rel.relation_id';
4664: open cv for l_stmt using p_table,p_column;
4665: fetch cv into l_res;
4666: close cv;

Line 4680: 'edw_pvt_key_columns_md_v fkisu,edw_pvt_columns_md_v fk_item,edw_dimensions_md_v p_rel,edw_unique_keys_md_v pk '||

4676: cv CurTyp;
4677: l_res varchar2(200);
4678: Begin
4679: l_stmt:='select fk_item.column_name from edw_relations_md_v rel, edw_foreign_keys_md_v fk, '||
4680: 'edw_pvt_key_columns_md_v fkisu,edw_pvt_columns_md_v fk_item,edw_dimensions_md_v p_rel,edw_unique_keys_md_v pk '||
4681: 'where rel.relation_name=:a and fk.entity_id=rel.relation_id and fkisu.key_id=fk.foreign_key_id '||
4682: 'and fk_item.column_id=fkisu.column_id and fk_item.parent_object_id=rel.relation_id and pk.key_id=fk.key_id and '||
4683: 'p_rel.dim_id=pk.entity_id and p_rel.dim_name=''EDW_INSTANCE_M''';
4684: if g_debug then

Line 4691: l_stmt:='select item.column_name from edw_pvt_columns_md_v item, edw_relations_md_v rel where '||

4687: open cv for l_stmt using p_table;
4688: fetch cv into l_res;
4689: close cv;
4690: if l_res is null then
4691: l_stmt:='select item.column_name from edw_pvt_columns_md_v item, edw_relations_md_v rel where '||
4692: 'item.parent_object_id=rel.relation_id and rel.relation_name=:a and item.column_name '||
4693: 'in (''INSTANCE'',''INSTANCE_CODE'') and item.parent_object_id=rel.relation_id';
4694: if g_debug then
4695: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_table);

Line 4974: 'edw_pvt_columns_md_v pk_col, '||

4970: 'edw_tables_md_v src_table, '||
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 '||

Line 4976: 'edw_pvt_columns_md_v tgt_column '||

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 '||
4980: 'and map_properties.mapping_id=:a '||

Line 5046: 'edw_pvt_columns_md_v src_col, '||

5042: 'tgt_col.column_name '||
5043: 'from '||
5044: 'edw_relations_md_v src, '||
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 '||

Line 5047: 'edw_pvt_columns_md_v tgt_col, '||

5043: 'from '||
5044: 'edw_relations_md_v src, '||
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 '||

Line 5097: 'edw_pvt_columns_md_v fk_item, '||

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 '||
5100: 'where '||
5101: 'tgt.relation_name=:a '||

Line 5144: 'edw_pvt_columns_md_v fk_item, '||

5140: 'from '||
5141: 'edw_tables_md_v rel, '||
5142: 'edw_foreign_keys_md_v fk, '||
5143: 'edw_pvt_key_columns_md_v fkisu, '||
5144: 'edw_pvt_columns_md_v fk_item, '||
5145: 'edw_dimensions_md_v dim, '||
5146: 'edw_levels_md_v lvl '||
5147: 'where '||
5148: 'dim.dim_name=:a '||

Line 5858: 'edw_pvt_columns_md_v pk_item '||

5854: l_stmt:='select pk_item.column_name '||
5855: 'from '||
5856: 'edw_unique_keys_md_v pk, '||
5857: 'edw_pvt_key_columns_md_v isu, '||
5858: 'edw_pvt_columns_md_v pk_item '||
5859: 'where '||
5860: 'pk.entity_id=:a '||
5861: 'and pk.primarykey=1 '||
5862: 'and isu.key_id=pk.key_id '||

Line 5908: 'edw_pvt_columns_md_v pk_item, '||

5904: 'from '||
5905: 'edw_tables_md_v rel, '||
5906: 'edw_unique_keys_md_v pk, '||
5907: 'edw_pvt_key_columns_md_v isu, '||
5908: 'edw_pvt_columns_md_v pk_item, '||
5909: 'edw_levels_md_v lvl '||
5910: 'where '||
5911: ' lvl.dim_id=:a '||
5912: 'and rel.name=lvl.level_name||''_LTC'' '||

Line 6051: 'edw_pvt_columns_md_v pk_item '||

6047: l_stmt:='select pk_item.column_name '||
6048: 'from '||
6049: 'edw_unique_keys_md_v pk, '||
6050: 'edw_pvt_key_columns_md_v isu, '||
6051: 'edw_pvt_columns_md_v pk_item '||
6052: 'where '||
6053: 'pk.entity_id=:a '||
6054: 'and isu.key_id=pk.key_id '||
6055: 'and pk_item.column_id=isu.column_id '||

Line 10224: edw_pvt_columns_md_v dim_pk_item,

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,
10223: edw_relations_md_v dim,
10224: edw_pvt_columns_md_v dim_pk_item,
10225: edw_pvt_columns_md_v fstg_item,
10226: edw_pvt_columns_md_v fact_item
10227: where
10228: dim_pk.key_id=key_usage.Unique_key_id

Line 10225: edw_pvt_columns_md_v fstg_item,

10221: edw_pvt_key_columns_md_v fk_key_col,
10222: edw_unique_keys_md_v dim_pk,
10223: edw_relations_md_v dim,
10224: edw_pvt_columns_md_v dim_pk_item,
10225: edw_pvt_columns_md_v fstg_item,
10226: edw_pvt_columns_md_v fact_item
10227: where
10228: dim_pk.key_id=key_usage.Unique_key_id
10229: and dim.relation_id=dim_pk.entity_id

Line 10226: edw_pvt_columns_md_v fact_item

10222: edw_unique_keys_md_v dim_pk,
10223: edw_relations_md_v dim,
10224: edw_pvt_columns_md_v dim_pk_item,
10225: edw_pvt_columns_md_v fstg_item,
10226: edw_pvt_columns_md_v fact_item
10227: where
10228: dim_pk.key_id=key_usage.Unique_key_id
10229: and dim.relation_id=dim_pk.entity_id
10230: and key_col.key_id=dim_pk.key_id

Line 10438: 'edw_pvt_columns_md_v fk_col, '||

10434: 'from '||
10435: 'edw_relations_md_v fstg, '||
10436: 'edw_foreign_keys_md_v fk, '||
10437: 'EDW_PVT_KEY_COLUMNS_MD_V fku, '||
10438: 'edw_pvt_columns_md_v fk_col, '||
10439: 'edw_relations_md_v p_table, '||
10440: 'edw_unique_keys_md_v pk '||
10441: 'where '||
10442: 'fstg.relation_id=fk.entity_id '||

Line 10550: 'edw_pvt_columns_md_v pk_col, '||

10546: 'edw_tables_md_v src_table, '||
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 '||

Line 10552: 'edw_pvt_columns_md_v tgt_column '||

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 '||
10556: 'and map_targets.target_id=map_properties.primary_target '||