[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rpad(nvl(segment1,'NA_EDW'), 25, ' ') || rpad(nvl(segment2,'NA_EDW'), 25, ' ') ||
rpad(nvl(segment3,'NA_EDW'), 25, ' ') || rpad(nvl(segment4,'NA_EDW'), 25, ' ') ||
rpad(nvl(segment5,'NA_EDW'), 25, ' ') || rpad(nvl(segment6,'NA_EDW'), 25, ' ') ||
rpad(nvl(segment7,'NA_EDW'), 25, ' ') || rpad(nvl(segment8,'NA_EDW'), 25, ' ') ||
rpad(nvl(segment9,'NA_EDW'), 25, ' ') || rpad(nvl(segment10,'NA_EDW'), 25, ' ') ||
rpad(nvl(segment11,'NA_EDW'), 25, ' ') || rpad(nvl(segment12,'NA_EDW'), 25, ' ') ||
rpad(nvl(segment13,'NA_EDW'), 25, ' ') || rpad(nvl(segment14,'NA_EDW'), 25, ' ') ||
rpad(nvl(segment15,'NA_EDW'), 25, ' ') || rpad(nvl(segment16,'NA_EDW'), 25, ' ') ||
rpad(nvl(segment17,'NA_EDW'), 25, ' ') || rpad(nvl(segment18,'NA_EDW'), 25, ' ') ||
rpad(nvl(segment19,'NA_EDW'), 25, ' ') || rpad(nvl(segment20,'NA_EDW'), 25, ' ') ||
rpad(nvl(segment21,'NA_EDW'), 25, ' ') || rpad(nvl(segment22,'NA_EDW'), 25, ' ') ||
rpad(nvl(segment23,'NA_EDW'), 25, ' ') || rpad(nvl(segment24,'NA_EDW'), 25, ' ') ||
rpad(nvl(segment25,'NA_EDW'), 25, ' ') || rpad(nvl(segment26,'NA_EDW'), 25, ' ') ||
rpad(nvl(segment27,'NA_EDW'), 25, ' ') || rpad(nvl(segment28,'NA_EDW'), 25, ' ') ||
rpad(nvl(segment29,'NA_EDW'), 25, ' ') || rpad(nvl(segment30,'NA_EDW'), 25, ' ')
segments
FROM gl_code_combinations
WHERE gl_code_combinations.code_combination_id = p_ccid;
select loc.set_of_books_id loc_sob,
equi.equi_set_of_books_id equi_sob,
parent.set_of_books_id parent_sob,
parent.instance parent_instance
from edw_local_set_of_books loc,
edw_local_equi_set_of_books equi,
edw_local_set_of_books parent
where loc.instance = g_local_instance
and equi.edw_set_of_books_id (+) = loc.edw_set_of_books_id
and parent.edw_set_of_books_id (+) = equi.equi_set_of_books_id;
'select map.structure_num structure_id, '||
' to_number(rtrim(substrb(map.dimension_short_name, 12, 2), ''_'')) dimension, '||
' to_number(substrb(map.application_column_name, 8, 2)) segment '||
'from edw_local_instance inst, '||
' edw_flex_seg_mappings_v@edw_apps_to_wh map, '||
' edw_fact_flex_fk_maps_v@edw_apps_to_wh fact '||
'where map.dimension_short_name = fact.dimension_short_name '||
'and map.instance_code = inst.instance_code '||
'and map.dimension_short_name like ''EDW_GL_ACCT%'' '||
'and upper(fact.enabled_flag) = ''Y'' '||
'and fact.fact_short_name = '''||p_fact_short_name||''' '||
'order by structure_num, dimension' ;
g_mc_structure.delete;
g_cache_sets_of_books.delete;