APPS.EDW_OWB_COLLECTION_UTIL dependencies on EDW_PVT_MAP_PROPERTIES_MD_V

Line 57: edw_pvt_map_properties_md_v b,

53: ltc.elementid
54: from
55: edw_dimensions_md_v a,
56: edw_tables_md_v ltc,
57: edw_pvt_map_properties_md_v b,
58: edw_pvt_map_targets_md_v c
59: where
60: a.dim_name =p_dim_name
61: and b.primary_target=a.dim_id

Line 88: edw_pvt_map_properties_md_v parent_map

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
91: and lvl_rel.hierarchy_id=hier.hier_id
92: and lvl_child.level_id=lvl_rel.child_level_id

Line 125: edw_pvt_map_properties_md_v parent_map

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
128: and lvl_rel.hierarchy_id=hier.hier_id
129: and lvl_child.level_id=lvl_rel.child_level_id

Line 145: edw_pvt_map_properties_md_v map_properties,

141: upper(dim_item.column_name),
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,

Line 180: edw_pvt_map_properties_md_v map,

176: map.mapping_id,
177: nvl(map.primary_source,0),
178: nvl(map.primary_target,0)
179: from
180: edw_pvt_map_properties_md_v map,
181: edw_relations_md_v relation
182: where
183: map.primary_target=relation.relation_id
184: and relation.relation_name=p_target_relation;

Line 521: edw_pvt_map_properties_md_v fact_map

517: p_fact_src,
518: p_fact_target
519: from
520: edw_facts_md_v fact,
521: edw_pvt_map_properties_md_v fact_map
522: where
523: fact.fact_name=p_fact_name
524: and fact_map.primary_target=fact.fact_id;
525:

Line 1576: 'edw_pvt_map_properties_md_v map '||

1572: end if;
1573: if g_read_cfig_options then
1574: --not checked
1575: l_stmt:='select df.fact_id from edw_facts_md_v df, edw_facts_md_v fact, '||
1576: 'edw_pvt_map_properties_md_v map '||
1577: 'where fact.fact_name=:a and map.primary_source=fact.fact_id and df.fact_id=map.primary_target ';
1578: if g_debug then
1579: write_to_log_file_n(l_stmt||' '||p_fact);
1580: end if;

Line 1607: 'edw_pvt_map_properties_md_v map, edw_attribute_sets_md_v sis '||

1603: end if;
1604: else
1605: --not checked
1606: l_stmt:='select 1 from edw_facts_md_v df, edw_facts_md_v fact, '||
1607: 'edw_pvt_map_properties_md_v map, edw_attribute_sets_md_v sis '||
1608: 'where fact.fact_name=:a and map.primary_source=fact.fact_id and df.fact_id=map.primary_target '||
1609: 'and sis.entity_id=df.fact_id and sis.attribute_group_name=''EDW_INC_REFRESH''';
1610: if g_debug then
1611: write_to_log_file_n(l_stmt||' '||p_fact);

Line 1643: 'edw_pvt_map_properties_md_v map '||

1639: write_to_log_file_n('In get_all_derived_facts, input param='||p_object);
1640: end if;
1641: --not checked
1642: l_stmt:='select df.fact_name, df.fact_id, map.mapping_id from edw_facts_md_v df, edw_facts_md_v fact, '||
1643: 'edw_pvt_map_properties_md_v map '||
1644: 'where fact.fact_name=:a and map.primary_source=fact.fact_id and df.fact_id=map.primary_target';
1645: if g_debug then
1646: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_object);
1647: end if;

Line 2145: l_stmt:='select 1 from edw_pvt_map_properties_md_v map, edw_relations_md_v rel where rel.relation_name=:a and '||

2141: if g_debug then
2142: write_to_log_file_n('In Util.is_object_a_source, p_object_name='||p_object_name);
2143: end if;
2144: --not checked
2145: l_stmt:='select 1 from edw_pvt_map_properties_md_v map, edw_relations_md_v rel where rel.relation_name=:a and '||
2146: ' map.primary_source=rel.relation_id and rownum=1';
2147: if g_debug then
2148: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_object_name);
2149: end if;

Line 3227: 'edw_pvt_map_properties_md_v map, '||

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

Line 3253: 'edw_pvt_map_properties_md_v map, '||

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 '||
3257: 'where '||

Line 3316: 'from edw_pvt_map_properties_md_v map, edw_relations_md_v src, edw_relations_md_v tgt, '||

3312: l_src_id number;
3313: Begin
3314: p_number_maps:=0;
3315: l_stmt:='select map.mapping_id,map.primary_target, map.primary_source '||
3316: 'from edw_pvt_map_properties_md_v map, edw_relations_md_v src, edw_relations_md_v tgt, '||
3317: 'edw_pvt_mappings_md_v model where map.primary_target=tgt.relation_id and '||
3318: 'map.primary_source=src.relation_id and tgt.relation_name=:a and src.relation_name=:b and '||
3319: 'model.mapping_name=:c and model.mapping_id=map.mapping_id';
3320: if p_debug then

Line 3337: 'edw_pvt_map_properties_md_v map, '||

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 '||
3341: 'map.mapping_id=:a '||

Line 4051: 'edw_pvt_map_properties_md_v map, '||

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, '||
4054: 'edw_attribute_sets_md_v sis '||
4055: 'where '||

Line 4071: 'edw_pvt_map_properties_md_v map, '||

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 '||
4074: 'where '||
4075: 'ru.mapping_id=map.mapping_id '||

Line 4278: 'edw_pvt_map_properties_md_v map, '||

4274: Begin
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, '||

Line 4387: l_stmt:='select mapping_id from edw_pvt_map_properties_md_v where primary_target=:a';

4383: TYPE CurTyp IS REF CURSOR;
4384: cv CurTyp;
4385: l_stmt varchar2(1000);
4386: Begin
4387: l_stmt:='select mapping_id from edw_pvt_map_properties_md_v where primary_target=:a';
4388: open cv for l_stmt using p_object_id;
4389: p_number_maps:=1;
4390: loop
4391: fetch cv into p_maps(p_number_maps);

Line 4759: 'edw_pvt_map_properties_md_v map, edw_attribute_sets_md_v sis '||

4755: if g_debug then
4756: write_to_log_file_n('In is_src_of_custom_inc_derv_fact, input param='||p_fact);
4757: end if;
4758: l_stmt:='select 1 from edw_facts_md_v df, edw_facts_md_v fact, '||
4759: 'edw_pvt_map_properties_md_v map, edw_attribute_sets_md_v sis '||
4760: 'where fact.fact_name=:a and map.primary_source=fact.fact_id and df.fact_id=map.primary_target '||
4761: 'and sis.entity_id=df.fact_id and sis.attribute_group_name=''EDW_CUSTOM_INC_REFRESH''';
4762: open cv for l_stmt using p_fact;
4763: fetch cv into l_var;

Line 4967: 'edw_pvt_map_properties_md_v map_properties, '||

4963: l_mapping_id:=get_target_map(l_object_id,null);
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, '||

Line 5027: 'from edw_pvt_map_properties_md_v map, '||

5023: Begin
5024: l_map_id:=p_map_id;
5025: if p_map_id is null then
5026: l_stmt:='select map.mapping_id '||
5027: 'from edw_pvt_map_properties_md_v map, '||
5028: 'edw_relations_md_v rel '||
5029: 'where rel.relation_name=:a '||
5030: 'and map.primary_target=rel.relation_id ';
5031: if g_debug then

Line 5048: 'edw_pvt_map_properties_md_v map, '||

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 '||
5052: 'map.mapping_id=:a '||

Line 5098: 'edw_pvt_map_properties_md_v map, '||

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 '||
5102: 'and map.primary_target=tgt.relation_id '||

Line 5439: 'edw_pvt_map_properties_md_v map, '||

5435: l_stmt:='select ltc.name,lstg.name '||
5436: 'from '||
5437: 'edw_tables_md_v ltc, '||
5438: 'edw_tables_md_v lstg, '||
5439: 'edw_pvt_map_properties_md_v map, '||
5440: 'edw_dimensions_md_v dim, '||
5441: 'edw_levels_md_v lvl '||
5442: 'where dim.dim_name=:a '||
5443: 'and lvl.dim_id=dim.dim_id '||

Line 5991: 'edw_pvt_map_properties_md_v map '||

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 '||
5994: 'and sec_relation_usage.mapping_id=map.mapping_id '||
5995: 'and sec_relation.sequence_id=sec_relation_usage.source_id';

Line 6944: l_stmt:='select text from edw_pvt_map_properties_md_v where mapping_id=:a and text_type=''Filter''';

6940: end if;
6941: --get filter
6942: --p_filter_stmt
6943: p_filter_stmt:=null;
6944: l_stmt:='select text from edw_pvt_map_properties_md_v where mapping_id=:a and text_type=''Filter''';
6945: if g_debug then
6946: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_mapping_id);
6947: end if;
6948: open cv for l_stmt using p_mapping_id;

Line 7087: l_stmt:='select mapping_id from edw_pvt_map_properties_md_v where primary_target=:a';

7083: cv CurTyp;
7084: l_mapping_id number;
7085: Begin
7086: if p_object_name is null then
7087: l_stmt:='select mapping_id from edw_pvt_map_properties_md_v where primary_target=:a';
7088: if g_debug then
7089: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_object_id);
7090: end if;
7091: open cv for l_stmt using p_object_id;

Line 7095: l_stmt:='select map.mapping_id from edw_pvt_map_properties_md_v map,edw_relations_md_v rel where '||

7091: open cv for l_stmt using p_object_id;
7092: fetch cv into l_mapping_id;
7093: close cv;
7094: else
7095: l_stmt:='select map.mapping_id from edw_pvt_map_properties_md_v map,edw_relations_md_v rel where '||
7096: 'rel.relation_name=:a and map.primary_target=rel.relation_id ';
7097: if g_debug then
7098: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_object_name);
7099: end if;

Line 10543: 'edw_pvt_map_properties_md_v map_properties, '||

10539: 'tgt_relation.relation_name, '||
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, '||