APPS.EDW_SUMMARY_COLLECT dependencies on EDW_PVT_MAP_PROPERTIES_MD_V

Line 2542: edw_pvt_map_properties_md_v map,

2538: l_table_count number:=1;
2539: cursor c4(p_dim_id number) is
2540: select relation.sequence_name
2541: from edw_pvt_sequences_md_v relation,
2542: edw_pvt_map_properties_md_v map,
2543: edw_pvt_map_properties_md_v map2,
2544: edw_pvt_map_sources_md_v ru
2545: where
2546: map.primary_target=p_dim_id

Line 2543: edw_pvt_map_properties_md_v map2,

2539: cursor c4(p_dim_id number) is
2540: select relation.sequence_name
2541: from edw_pvt_sequences_md_v relation,
2542: edw_pvt_map_properties_md_v map,
2543: edw_pvt_map_properties_md_v map2,
2544: edw_pvt_map_sources_md_v ru
2545: where
2546: map.primary_target=p_dim_id
2547: and map2.primary_target=map.primary_source

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

6171: return false;
6172: end if;
6173: --also look at the filter clause
6174: --not checked
6175: l_stmt:='select text from edw_pvt_map_properties_md_v where mapping_id=:a and text_type=''Filter''';
6176: if g_debug then
6177: write_to_log_file_n('Going to execute '||l_stmt||' using '||p_mapping_id);
6178: end if;
6179: open cv for l_stmt using p_mapping_id;