begin -- detailed table report 10047 -- materialized view summary report 10117 -- is self describing 10095 -- cube implementation report 10022 -- function library summary report 10078 -- table impact analysis report 10170 -- transform summary report 10184 -- materialized view lineage report 10116 -- dimension implementation report 10052 -- cube summary report 10024 -- file summary report 10066 -- detailed project report 10043 -- cube lineage report 10023 -- detailed sequence report 10046 -- table summary report 10172 -- detailed view report 10049 -- sequence impact analysis report 10162 -- detailed record report 10044 -- view impact analysis report 10199 -- table lineage report 10171 -- record classifier position 10146 -- record impact analysis report 10148 -- no 10271 -- detailed business area report 10032 -- detailed function report 10038 -- detailed dimension report 10034 -- sequence summary report 10163 -- detailed information system report 10039 -- dimension impact analysis report 10051 -- view summary report 10201 -- record classifier length 10145 -- continuation at end 10018 -- detailed installation report 10040 -- view lineage report 10200 -- detailed materialized view report 10041 -- business area summary report 10004 -- dimension summary report 10055 -- record lineage report 10149 -- unknown 10314 -- yes 10322 -- detailed transform map report 10048 -- text start delimiter 10177 -- detailed function library report 10037 -- materialized view impact analysis report 10115 -- dimension lineage report 10053 -- detailed cube report 10033 -- detailed file report 10036 -- record size 10150 -- continuation delimiter 10017 -- text end delimiter 10176 -- cube impact analysis report 10021 -- record delimiter 10147 -- number of physical records in logical 10126 declare begin -- Number of Table Rows Inserted = 181 INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Collection10', 'SELECT wmp_api_nls.get_string(''10032'') || '' - '' || collection_name as c1 FROM all_iv_collections@# ' || 'WHERE collection_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Collection20', 'SELECT decode('':mls_lang'', '':base_lang'', c.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'c.created_on as "10222", ' || 'c.collection_name as "10281", ' || 'c.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', c.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(c.project_name, ''Project'', ' || 'c.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10091" ' || 'FROM all_iv_collections@# c ' || 'WHERE c.collection_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Collection30', 'SELECT initcap(i.collection_reference_type) as "10273", ' || 'i.collection_reference_name as "10267" ' || 'FROM all_iv_collection_references@# i ' || 'WHERE i.collection_id = :id '|| 'ORDER BY initcap(i.collection_reference_type), i.collection_reference_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Location10', 'SELECT wmp_api_nls.get_string(''10514'') || '' - '' || location_name as c1 FROM all_iv_LOCATIONS@# ' || 'WHERE location_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Location20', 'SELECT decode('':mls_lang'', '':base_lang'', c.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'c.created_on as "10222", ' || 'c.location_name as "10281", ' || 'c.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', c.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(c.project_name, ''Project'', ' || 'c.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285" ' || 'FROM ALL_IV_LOCATIONS@# c ' || 'WHERE c.location_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Location30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''Connector'', ' || 'connector_id, ''wmp_rh_generic_report'', ''Connector_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(connector_name, ''Connector'', ' || 'connector_id, ''wmp_rh_generic_report'', ''Connector_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM ALL_IV_CONNECTORS@# WHERE location_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Connector10', 'SELECT wmp_api_nls.get_string(''10527'') || '' - '' || connector_name as c1 FROM all_iv_CONNECTORS@# ' || 'WHERE connector_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Connector20', 'SELECT decode('':mls_lang'', '':base_lang'', c.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'c.created_on as "10222", ' || 'c.connector_name as "10281", ' || 'c.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', c.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(c.location_name, ''Location'', ' || 'c.location_id, ''wmp_rh_generic_report'', ''Location_Detail'') as "10428", ' || 'wmp_api_hlink.report_hlink(l.project_name, ''Project'', ' || 'l.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285" ' || 'FROM ALL_IV_CONNECTORS@# c , ALL_IV_LOCATIONS@# l ' || 'WHERE l.location_id = c.location_id and c.connector_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Connector30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', loc.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''Location'', ' || 'loc.location_id, ''wmp_rh_generic_report'', ''Location_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(loc.location_name, ''Location'', ' || 'loc.location_id, ''wmp_rh_generic_report'', ''Location_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', loc.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM ALL_IV_CONNECTORS@# con, ALL_IV_LOCATIONS@# loc '|| 'WHERE loc.location_id = con.referenced_location_id and con.connector_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('RuntimeLocation10', 'SELECT wmp_api_nls.get_string(''10514'') || '' - '' || location_name as c1 FROM all_iv_RUNTIME_REPOSITORIES@# ' || 'WHERE location_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('RuntimeLocation20', 'SELECT decode('':mls_lang'', '':base_lang'', c.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'c.created_on as "10222", ' || 'c.location_name as "10281", ' || 'c.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', c.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(c.project_name, ''Project'', ' || 'c.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285" ' || 'FROM ALL_IV_RUNTIME_REPOSITORIES@# c ' || 'WHERE c.location_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('AdvancedQueue10', 'SELECT wmp_api_nls.get_string(''10515'') || '' - '' || queue_name as c1 FROM all_iv_advanced_queues@# ' || 'WHERE queue_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('AdvancedQueue20', 'SELECT decode('':mls_lang'', '':base_lang'', c.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'c.created_on as "10222", ' || 'c.queue_name as "10281", ' || 'c.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', c.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285" ' || 'FROM all_iv_advanced_queues@# c, all_iv_information_systems@# s ' || 'WHERE c.queue_id = :id AND s.information_system_id = c.schema_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('AdvancedQueue30', 'SELECT wmp_api_hlink.report_hlink(ot.business_name, ''ObjectType'', '|| ' ot.object_type_id, ''wmp_rh_generic_report'', ''ObjectType_Detail'') as "10261", ' || ' wmp_api_hlink.report_hlink(ot.object_type_name, ''ObjectType'', '|| ' ot.object_type_id, ''wmp_rh_generic_report'', ''ObjectType_Detail'') as "10281", ' || ' decode('':mls_lang'', '':base_lang'', ot.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_advanced_queues@# q, all_iv_object_types@# ot WHERE q.load_type_id = ot.object_type_id and q.queue_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('AdvancedQueue70', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id ' || 'AND upper(configured_object_type) = ''ADVANCED_QUEUE'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND configuration_parameter_key like ''8i.%'' ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ObjectType10', 'SELECT wmp_api_nls.get_string(''10598'') || '' - '' || object_type_name as c1 FROM all_iv_object_types@# ' || 'WHERE object_type_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ObjectType20', 'SELECT decode('':mls_lang'', '':base_lang'', c.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'c.created_on as "10222", ' || 'c.object_type_name as "10281", ' || 'c.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', c.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285" ' || 'FROM all_iv_object_types@# c, all_iv_information_systems@# s ' || 'WHERE c.object_type_id = :id AND s.information_system_id = c.schema_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ObjectType30', 'SELECT rf.business_name as "10261", ' || 'rf.recordfield_name as "10281", ' || 'decode('':mls_lang'', '':base_lang'', rf.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_object_types@# ot, all_iv_record_fields@# rf WHERE rf.firstclass_object_id = ot.object_type_id and ot.object_type_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube10', 'SELECT wmp_api_nls.get_string(''10033'') || '' - '' || cube_name as c1 FROM all_iv_cubes@# WHERE cube_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube11', 'SELECT wmp_api_nls.get_string(''10023'') || '' - '' || cube_name as c1 FROM all_iv_cubes@# WHERE cube_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube12', 'SELECT wmp_api_nls.get_string(''10021'') || '' - '' || cube_name as c1 FROM all_iv_cubes@# WHERE cube_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', c.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''Cube'', ' || 'c.cube_id, ''wmp_rh_generic_report'', ''Cube_Implememtation'') as "10261", ' || 'c.created_on as "10222", ' || 'wmp_api_hlink.report_hlink(c.cube_name, ''Cube'', ' || 'c.cube_id, ''wmp_rh_generic_report'', ''Cube_Implememtation'') as "10281", ' || 'c.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', c.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(c.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_cubes@# c, all_iv_information_systems@# s ' || 'WHERE c.cube_id = :id AND s.information_system_id = c.schema_id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube30', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', measure_id, '':mls_lang'')) as "10261", ' || 'measure_name as "10281", ' || 'data_type as "10029", ' || 'length as "10102", ' || 'precision as "10140", ' || 'scale as "10154", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', measure_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_cube_measures@# WHERE cube_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube40', 'SELECT wmp_api_hlink.report_hlink(dimension_name, ''Dimension'', ' || 'dimension_id, ''wmp_rh_generic_report'', ''Dimension_Detail'') as "10054", ' || 'dimension_alias as "10050" ' || 'FROM (SELECT DISTINCT dimension_name, dimension_id, dimension_alias ' || 'FROM all_iv_cube_measure_dim_uses@# WHERE cube_id = :id ' || 'ORDER BY dimension_name)'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube50', 'SELECT parm_id as "10264" ' || 'FROM (SELECT DISTINCT parm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE comp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube60', 'SELECT depparm_id as "10264" ' || 'FROM (SELECT DISTINCT depparm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE depcomp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube70', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id ' || 'AND upper(configured_object_type) = ''CUBE'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND configuration_parameter_key like ''8i.%'' ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube:Lineage51', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10010" FROM all_iv_columns@# WHERE column_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube:Lineage52', 'SELECT item.object_name as "10619", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10620", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.parm_id = :id and mv.depparm_id = item.object_id and mv.depcomp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube:Impact61', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10010" FROM all_iv_columns@# WHERE column_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube:Impact62', 'SELECT item.object_name as "10617", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10618", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.depparm_id = :id and mv.parm_id = item.object_id and mv.comp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube_Implementation10', 'SELECT wmp_api_nls.get_string(''10022'') || '' - '' || cube_name as c1 FROM all_iv_cubes@# WHERE cube_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube_Implementation20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', c.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''Cube'', ' || 'c.cube_id, ''wmp_rh_generic_report'', ''Cube_Detail'') as "10261", ' || 'c.created_on as "10222", ' || 'wmp_api_hlink.report_hlink(c.cube_name, ''Cube'', ' || 'c.cube_id, ''wmp_rh_generic_report'', ''Cube_Detail'') as "10281", ' || 'c.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', c.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(c.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_cubes@# c, all_iv_information_systems@# s ' || 'WHERE c.cube_id = :id AND s.information_system_id = c.schema_id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube_Implementation30', 'SELECT wmp_api_hlink.report_hlink(table_name, ''Table'', ' || 'table_id, ''wmp_rh_generic_report'', ''Table_Detail'') as "10342" ' || 'FROM (SELECT DISTINCT table_name, table_id FROM all_iv_cube_impls@# ' || 'WHERE cube_id = :id AND item_type = ''MEASURE'' ' || 'ORDER BY table_name)'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube_Implementation40', 'SELECT measure_id FROM all_iv_cube_measures@# WHERE cube_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube_Implementation50', 'SELECT cube_id ||''.''|| dimension_id || 9 '|| 'FROM all_iv_cube_dimensions@# where cube_id = :id ORDER BY dimension_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube_Implementation:Measure41', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'measure_name as "10281" ' || 'FROM all_iv_cube_measures@# WHERE measure_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube_Implementation:Measure42', 'SELECT table_name || ''.'' || column_name as "10011" ' || 'FROM all_iv_cube_impls@# ' || 'WHERE item_id = :id AND upper(item_type) = ''MEASURE'' ' || 'ORDER BY table_name, column_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube_Implementation:Dimension51', 'SELECT wmp_api_hlink.report_hlink(dimension_name, ''Dimension'', ' || 'dimension_id, ''wmp_rh_generic_report'', ''Dimension_Implementation'') as "10054" ' || 'FROM all_iv_cube_dimensions@# WHERE dimension_id = to_number(SUBSTR('':id'', INSTR('':id'', ''.'')+1, LENGTH('':id'')-1-INSTR('':id'', ''.''))) AND '|| ' cube_id = to_number(SUBSTR('':id'', 1, INSTR('':id'', ''.'')-1)) '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Cube_Implementation:Dimension52', 'SELECT i.table_name || ''.'' || i.foreign_key_name || '' to '' || k.entity_name || ''.'' || k.key_name as "10070" ' || 'FROM all_iv_cube_impls@# i, all_iv_keys@# k, all_iv_foreign_keys@# f ' || 'WHERE i.dimension_id = to_number(SUBSTR('':id'', INSTR('':id'', ''.'')+1, LENGTH('':id'')-1-INSTR('':id'', ''.''))) AND upper(i.item_type) = ''CUBE_DIMENSION_USE'' ' || 'AND i.item_id = f.foreign_key_id AND f.key_id = k.key_id AND '|| ' cube_id = to_number(SUBSTR('':id'', 1, INSTR('':id'', ''.'')-1)) '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension10', 'SELECT wmp_api_nls.get_string(''10034'') || '' - '' || dimension_name as c1 ' || 'FROM all_iv_dimensions@# WHERE dimension_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension11', 'SELECT wmp_api_nls.get_string(''10053'') || '' - '' || dimension_name as c1 ' || 'FROM all_iv_dimensions@# WHERE dimension_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension12', 'SELECT wmp_api_nls.get_string(''10051'') || '' - '' || dimension_name as c1 ' || 'FROM all_iv_dimensions@# WHERE dimension_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', d.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''Dimension'', ' || 'd.dimension_id, ''wmp_rh_generic_report'', ''Dimension_Implementation'') as "10261", ' || 'd.created_on as "10222", ' || 'wmp_api_hlink.report_hlink(d.dimension_name, ''Dimension'', ' || 'd.dimension_id, ''wmp_rh_generic_report'', ''Dimension_Implementation'') as "10281", ' || 'd.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', d.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(d.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_dimensions@# d, all_iv_information_systems@# s ' || 'WHERE d.dimension_id = :id AND s.information_system_id = d.schema_id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension30', 'SELECT hierarchy_id FROM all_iv_dim_hierarchies@# WHERE dimension_id = :id ORDER BY hierarchy_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension40', 'SELECT level_id FROM all_iv_dim_levels@# WHERE dimension_id = :id ORDER BY level_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension50', 'SELECT parm_id as "10216" ' || 'FROM (SELECT DISTINCT parm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE comp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension60', 'SELECT depparm_id as "10216" ' || 'FROM (SELECT DISTINCT depparm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE depcomp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension70', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''DIMENSION'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND configuration_parameter_key like ''8i.%'' ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension:Hierarchy31', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'hierarchy_name as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_dim_hierarchies@# WHERE hierarchy_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension:Hierarchy32', 'SELECT level_name as "10105", '|| 'decode('':mls_lang'', '':base_lang'', level_description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || ' FROM all_iv_dim_hierarchy_levels@# ' || ' WHERE hierarchy_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension:Level41', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'level_name as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_dim_levels@# WHERE level_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension:Level42', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'attribute_name as "10281", ' || 'data_type as "10029", ' || 'length as "10102", ' || 'precision as "10140", ' || 'scale as "10154", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_dim_level_attributes@# ' || 'WHERE level_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension:Lineage51', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10010" FROM all_iv_columns@# WHERE column_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension:Lineage52', 'SELECT item.object_name as "10619", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10620", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.parm_id = :id and mv.depparm_id = item.object_id and mv.depcomp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension:Impact61', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10010" FROM all_iv_columns@# WHERE column_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension:Impact62', 'SELECT item.object_name as "10617", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10618", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.depparm_id = :id and mv.parm_id = item.object_id and mv.comp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension_Implementation10', 'SELECT wmp_api_nls.get_string(''10052'') || '' - '' || dimension_name as c1 ' || 'FROM all_iv_dimensions@# WHERE dimension_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension_Implementation20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', d.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''Dimension'', ' || 'd.dimension_id, ''wmp_rh_generic_report'', ''Dimension_Detail'') as "10261", ' || 'd.created_on as "10222", ' || 'wmp_api_hlink.report_hlink(d.dimension_name, ''Dimension'', ' || 'd.dimension_id, ''wmp_rh_generic_report'', ''Dimension_Detail'') as "10281", ' || 'd.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', d.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(d.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_dimensions@# d, all_iv_information_systems@# s ' || 'WHERE d.dimension_id = :id AND s.information_system_id = d.schema_id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension_Implementation30', 'SELECT level_id FROM all_iv_dim_levels@# WHERE dimension_id = :id ORDER BY level_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension_Implementation:Level31', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'level_name as "10281" ' || 'FROM all_iv_dim_levels@# WHERE level_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension_Implementation:Level32', 'SELECT wmp_api_hlink.report_hlink(table_name, ''Table'', ' || 'table_id, ''wmp_rh_generic_report'', ''Table_Detail'') as "10342" ' || 'FROM (SELECT DISTINCT i.table_name, i.table_id ' || 'FROM all_iv_dim_level_attributes@# a, all_iv_dim_level_impls@# i ' || 'WHERE a.level_id = :id AND i.item_id = a.attribute_id ' || 'ORDER BY i.table_name)'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension_Implementation:Level33', 'SELECT attribute_id FROM all_iv_dim_level_attributes@# ' || 'WHERE level_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension_Implementation:Level:Attribute34', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'attribute_name as "10281" ' || 'FROM all_iv_dim_level_attributes@# WHERE attribute_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Dimension_Implementation:Level:Attribute35', 'SELECT table_name || ''.'' || column_name as "10011" ' || 'FROM all_iv_dim_level_impls@# ' || 'WHERE item_id = :id AND upper(item_type) = ''LEVEL_ATTRIBUTE'' ' || 'ORDER BY table_name, column_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('File10', 'SELECT wmp_api_nls.get_string(''10036'') || '' - '' || file_name as c1 FROM all_iv_files@# WHERE file_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('File11', 'SELECT wmp_api_nls.get_string(''10260'') || '' - '' || file_name as c1 FROM all_iv_files@# WHERE file_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('File12', 'SELECT wmp_api_nls.get_string(''10089'') || '' - '' || file_name as c1 FROM all_iv_files@# WHERE file_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('File20', 'SELECT decode('':mls_lang'', '':base_lang'', f.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'f.created_on as "10222", ' || 'f.file_name as "10281", ' || 'f.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', f.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(f.information_system_name, ''FileModule'', ' || 'f.information_system_id, ''wmp_rh_generic_report'', ''FileModule_Detail'') as "10091", ' || 'wmp_api_hlink.report_hlink(i.project_name, ''Project'', ' || 'i.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(f.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_files@# f, ALL_IV_FILE_MODULES@# i ' || 'WHERE f.file_id = :id AND f.information_system_id = i.information_system_id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('File30', 'SELECT wmp_api_nls.get_string(''10146'') as "10267", ' || 'to_char(record_classifier_position) as "10196" ' || 'FROM all_iv_files@# WHERE file_id = :id AND record_classifier_position is not null ' || 'UNION SELECT wmp_api_nls.get_string(''10145'') as "10267", ' || 'to_char(record_classifier_length) as "10196" ' || 'FROM all_iv_files@# WHERE file_id = :id AND record_classifier_length is not null ' || 'UNION SELECT wmp_api_nls.get_string(''10150'') as "10267", ' || 'to_char(record_size) as "10196" ' || 'FROM all_iv_files@# WHERE file_id = :id AND record_size is not null ' || 'UNION SELECT wmp_api_nls.get_string(''10126'') as "10267", ' || 'to_char(n_physical_records_in_logical) as "10196" ' || 'FROM all_iv_files@# WHERE file_id = :id AND n_physical_records_in_logical is not null ' || 'UNION SELECT wmp_api_nls.get_string(''10016'') as "10267", ' || 'continuation_at_end as "10196" ' || 'FROM all_iv_files@# WHERE file_id = :id AND continuation_at_end is not null ' || 'UNION SELECT wmp_api_nls.get_string(''10017'') as "10267", ' || 'continuation_delimiter as "10196" ' || 'FROM all_iv_files@# WHERE file_id = :id AND continuation_delimiter is not null ' || 'UNION SELECT wmp_api_nls.get_string(''10017'') as "10267", ' || 'continuation_delimiter as "10196" ' || 'FROM all_iv_files@# WHERE file_id = :id AND continuation_delimiter is not null ' || 'UNION SELECT wmp_api_nls.get_string(''10147'') as "10267", ' || 'decode(record_delimiter, ''\n'', ''New Line'', '''', ''Carriage Return'', record_delimiter) as "10196" ' || 'FROM all_iv_files@# WHERE file_id = :id AND record_delimiter is not null ' || 'UNION SELECT wmp_api_nls.get_string(''10177'') as "10267", ' || 'text_start_delimiter as "10196" ' || 'FROM all_iv_files@# WHERE file_id = :id AND text_start_delimiter is not null ' || 'UNION SELECT wmp_api_nls.get_string(''10176'') as "10267", ' || 'text_end_delimiter as "10196" ' || 'FROM all_iv_files@# WHERE file_id = :id AND text_end_delimiter is not null ' || 'UNION SELECT wmp_api_nls.get_string(''10625'') as "10267", ' || 'source_from as "10196" ' || 'FROM all_iv_files@# WHERE file_id = :id AND source_from is not null ' || 'UNION SELECT wmp_api_nls.get_string(''10626'') as "10267", ' || 'file_format as "10196" ' || 'FROM all_iv_files@# WHERE file_id = :id AND file_format is not null ' || 'UNION SELECT wmp_api_nls.get_string(''10581'') as "10267", ' || 'field_delimiter as "10196" ' || 'FROM all_iv_files@# WHERE file_id = :id AND field_delimiter is not null'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('File40', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', record_id, '':mls_lang'')), ''Record'', ' || 'record_id, ''wmp_rh_generic_report'', ''Record_Detail'') as "10281", ' || 'wmp_api_hlink.report_hlink(record_name, ''Record'', ' || 'record_id, ''wmp_rh_generic_report'', ''Record_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', record_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_records@# WHERE file_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('File50', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''FILE'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND configuration_parameter_key like ''8i.%'' ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('File60', 'SELECT parm_id as "10216" ' || 'FROM (SELECT DISTINCT parm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE comp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('File70', 'SELECT depparm_id as "10216" ' || 'FROM (SELECT DISTINCT depparm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE depcomp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('File:Lineage61', 'SELECT decode('':mls_lang'', '':base_lang'', f.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10063" FROM all_iv_fields@# f WHERE f.field_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('File:Lineage62', 'SELECT item.object_name as "10619", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10620", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.parm_id = :id and mv.depparm_id = item.object_id and mv.depcomp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('File:Impact71', 'SELECT decode('':mls_lang'', '':base_lang'', f.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10063" FROM all_iv_fields@# f WHERE f.field_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('File:Impact72', 'SELECT item.object_name as "10617", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10618", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.depparm_id = :id and mv.parm_id = item.object_id and mv.comp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Function10', 'SELECT wmp_api_nls.get_string(''10038'') || '' - '' || function_name as c1 ' || 'FROM all_iv_functions@# WHERE function_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Function20', 'SELECT decode('':mls_lang'', '':base_lang'', f.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'f.created_on as "10222", ' || 'f.function_name as "10281", ' || 'f.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', f.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(f.function_library_name, ''FunctionLibrary'', ' || 'f.function_library_id, ''wmp_rh_generic_report'', ''FunctionLibrary_Detail'') as "10077", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(f.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_functions@# f, all_iv_function_libraries@# l, all_iv_information_systems@# s ' || 'WHERE f.function_id = :id AND f.function_library_id = l.function_library_id ' || 'AND l.information_system_id = s.information_system_id '|| 'AND s.project_name != ''Admin Project'' AND s.project_name != ''Global Shared'' '|| 'UNION '|| 'SELECT decode('':mls_lang'', '':base_lang'', f.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'f.created_on as "10222", ' || 'f.function_name as "10281", ' || 'f.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', f.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(f.function_library_name, ''FunctionLibrary'', ' || 'f.function_library_id, ''wmp_rh_generic_report'', ''FunctionLibrary_Detail'') as "10077", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'NULL as "10285", ' || 'decode(f.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_functions@# f, all_iv_function_libraries@# l, all_iv_information_systems@# s ' || 'WHERE f.function_id = :id AND f.function_library_id = l.function_library_id ' || 'AND l.information_system_id = s.information_system_id '|| 'AND (s.project_name = ''Admin Project'' OR s.project_name = ''Global Shared'') '|| 'UNION '|| 'SELECT decode('':mls_lang'', '':base_lang'', f.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'f.created_on as "10222", ' || 'f.function_name as "10281", ' || 'f.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', f.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'null as "10077", '|| 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(f.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_functions@# f, all_iv_information_systems@# s ' || 'WHERE f.function_id = :id AND f.function_library_id is null ' || 'AND f.schema_id = s.information_system_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Function30', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', parameter_id, '':mls_lang'')) as "10261", ' || 'parameter_name as "10281", ' || 'parameter_type as "10193", ' || 'data_type as "10029", ' || 'length as "10102", ' || 'precision as "10140", ' || 'scale as "10154", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', parameter_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_function_parameters@# WHERE function_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Function40', 'SELECT function_implementation_name as "10267", ' || 'script as "10158" ' || 'FROM all_iv_function_impls@# ' || 'WHERE function_id = :id ORDER BY function_implementation_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Function50', 'SELECT distinct decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''FUNCTION'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND configuration_parameter_key like ''8i.%'' ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('TableFunction10', 'SELECT wmp_api_nls.get_string(''10038'') || '' - '' || function_name as c1 ' || 'FROM all_iv_table_functions@# WHERE function_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('TableFunction20', 'SELECT decode('':mls_lang'', '':base_lang'', f.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'f.created_on as "10222", ' || 'f.function_name as "10281", ' || 'f.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', f.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(f.function_library_name, ''FunctionLibrary'', ' || 'f.function_library_id, ''wmp_rh_generic_report'', ''FunctionLibrary_Detail'') as "10077", ' || 'wmp_api_hlink.report_hlink(i.information_system_name, i.information_system_type, ' || 'i.information_system_id, ''wmp_rh_generic_report'', i.information_system_type||''_Detail'') as "10091", ' || 'wmp_api_hlink.report_hlink(i.project_name, ''Project'', ' || 'i.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(f.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_table_functions@# f, all_iv_information_systems@# i ' || 'WHERE f.function_id = :id AND f.schema_id = i.information_system_id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('TableFunction30', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', parameter_id, '':mls_lang'')) as "10261", ' || 'parameter_name as "10281", ' || 'parameter_type as "10193", ' || 'data_type as "10029", ' || 'length as "10102", ' || 'precision as "10140", ' || 'scale as "10154", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', parameter_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_function_parameters@# WHERE function_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('TableFunction40', 'SELECT function_implementation_name as "10267", ' || 'script as "10158" ' || 'FROM all_iv_function_impls@# ' || 'WHERE function_id = :id ORDER BY function_implementation_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('FunctionLibrary10', 'SELECT wmp_api_nls.get_string(''10037'') || '' - '' || function_library_name as c1 ' || 'FROM all_iv_function_libraries@# WHERE function_library_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('FunctionLibrary20', 'SELECT decode('':mls_lang'', '':base_lang'', l.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'l.created_on as "10222", ' || 'l.function_library_name as "10281", ' || 'l.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', l.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(i.information_system_name, i.information_system_type, ' || 'i.information_system_id, ''wmp_rh_generic_report'', i.information_system_type||''_Detail'') as "10091", ' || 'wmp_api_hlink.report_hlink(i.project_name, ''Project'', ' || 'i.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(l.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_function_libraries@# l, all_iv_information_systems@# i ' || 'WHERE l.function_library_id = :id AND l.information_system_id = i.information_system_id '|| 'AND i.project_name != ''Admin Project'' AND i.project_name != ''Global Shared'' '|| 'UNION '|| 'SELECT decode('':mls_lang'', '':base_lang'', l.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'l.created_on as "10222", ' || 'l.function_library_name as "10281", ' || 'l.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', l.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(i.information_system_name, i.information_system_type, ' || 'i.information_system_id, ''wmp_rh_generic_report'', i.information_system_type||''_Detail'') as "10091", ' || 'NULL as "10285", ' || 'decode(l.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_function_libraries@# l, all_iv_information_systems@# i ' || 'WHERE l.function_library_id = :id AND l.information_system_id = i.information_system_id '|| 'AND (i.project_name = ''Admin Project'' OR i.project_name = ''Global Shared'') '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('FunctionLibrary30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''Function'', ' || 'function_id, ''wmp_rh_generic_report'', ''Function_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(function_name, ''Function'', ' || 'function_id, ''wmp_rh_generic_report'', ''Function_Detail'') as "10281", ' || 'signature as "10166", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_functions@# WHERE function_library_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('FunctionLibrary40', 'SELECT distinct decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''FUNCTION_LIBRARY'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND configuration_parameter_key like ''8i.%'' ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse10', 'SELECT wmp_api_nls.get_string(''10039'') || '' - '' || information_system_name as c1 ' || 'FROM ALL_IV_WAREHOUSE_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse20', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'created_on as "10222", ' || 'information_system_name as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_warehouse_modules@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse30', 'SELECT decode(upper(object_type), ''CUBE'', ''Fact'', initcap(object_type)) as "10273", ' || 'wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10261", ' || 'wmp_api_hlink.report_hlink(object_name, ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10281", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_all_objects@# WHERE parent_object_id = :id ' || 'ORDER BY initcap(object_type), business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse40', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''DATAWAREHOUSE'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND (configuration_parameter_key like ''8i.ORACLE%'' OR ' || 'configuration_parameter_key like ''8i.DBLINKS.%'') ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_FunctionLibrary10', 'SELECT wmp_api_nls.get_string(''10408'') || '' - '' || information_system_name as c1 ' || 'FROM ALL_IV_WAREHOUSE_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_FunctionLibrary20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''DataWarehouse'', ' || 'information_system_id, ''wmp_rh_generic_report'', ''DataWarehouse_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, ''DataWarehouse'', ' || 'information_system_id, ''wmp_rh_generic_report'', ''DataWarehouse_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM ALL_IV_WAREHOUSE_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_FunctionLibrary30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', function_library_id, '':mls_lang'')), ''FunctionLibrary'', ' || 'function_library_id, ''wmp_rh_generic_report'', null) as "10261", ' || 'wmp_api_hlink.report_hlink(function_library_name, ''FunctionLibrary'', ' || 'function_library_id, ''wmp_rh_generic_report'', ''FunctionLibrary_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', function_library_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_function_libraries@# WHERE information_system_id = :id ' || 'ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_TransformMap10', 'SELECT wmp_api_nls.get_string(''10184'') || '' - '' || information_system_name as c1 ' || 'FROM ALL_IV_WAREHOUSE_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_TransformMap20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''InformationSystem'', ' || 'information_system_id, ''wmp_rh_generic_report'', null) as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, ''DataWarehouse'', ' || 'information_system_id, ''wmp_rh_generic_report'', ''DataWarehouse_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM ALL_IV_WAREHOUSE_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_TransformMap30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', map_id, '':mls_lang'')), ''TransformMap'', ' || 'map_id, ''wmp_rh_generic_report'', ''TransformMap_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(map_name, ''TransformMap'', ' || 'map_id, ''wmp_rh_generic_report'', ''TransformMap_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', map_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_xform_maps@# WHERE information_system_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Cube10', 'SELECT wmp_api_nls.get_string(''10062'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Cube20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Cube30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', cube_id, '':mls_lang'')), ''Cube'', ' || 'cube_id, ''wmp_rh_generic_report'', ''Cube_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(cube_name, ''Cube'', ' || 'cube_id, ''wmp_rh_generic_report'', ''Cube_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', cube_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_cubes@# WHERE schema_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Dimension10', 'SELECT wmp_api_nls.get_string(''10055'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Dimension20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Dimension30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', dimension_id, '':mls_lang'')), ''Dimension'', ' || 'dimension_id, ''wmp_rh_generic_report'', ''Dimension_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(dimension_name, ''Dimension'', ' || 'dimension_id, ''wmp_rh_generic_report'', ''Dimension_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', dimension_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_dimensions@# WHERE schema_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_MaterializedView10', 'SELECT wmp_api_nls.get_string(''10117'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_MaterializedView20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_MaterializedView30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', view_id, '':mls_lang'')), ''MaterializedView'', ' || 'view_id, ''wmp_rh_generic_report'', ''MaterializedView_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(view_name, ''MaterializedView'', ' || 'view_id, ''wmp_rh_generic_report'', ''MaterializedView_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', view_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_materialized_views@# WHERE schema_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Sequence10', 'SELECT wmp_api_nls.get_string(''10306'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Sequence20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Sequence30', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', sequence_id, '':mls_lang'')) as "10261", ' || 'wmp_api_hlink.report_hlink(sequence_name, ''Sequence'', ' || 'sequence_id, ''wmp_rh_generic_report'', ''Sequence_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', sequence_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_sequences@# WHERE schema_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule_Sequence10', 'SELECT wmp_api_nls.get_string(''10306'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule_Sequence20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule_Sequence30', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', sequence_id, '':mls_lang'')) as "10261", ' || 'wmp_api_hlink.report_hlink(sequence_name, ''Sequence'', ' || 'sequence_id, ''wmp_rh_generic_report'', ''Sequence_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', sequence_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_sequences@# WHERE schema_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Table10', 'SELECT wmp_api_nls.get_string(''10172'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Table20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Table30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', table_id, '':mls_lang'')), ''Table'', ' || 'table_id, ''wmp_rh_generic_report'', ''Table_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(table_name, ''Table'', ' || 'table_id, ''wmp_rh_generic_report'', ''Table_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', table_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_tables@# WHERE schema_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule_Table10', 'SELECT wmp_api_nls.get_string(''10172'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule_Table20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule_Table30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', table_id, '':mls_lang'')), ''Table'', ' || 'table_id, ''wmp_rh_generic_report'', ''Table_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(table_name, ''Table'', ' || 'table_id, ''wmp_rh_generic_report'', ''Table_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', table_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_tables@# WHERE schema_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_View10', 'SELECT wmp_api_nls.get_string(''10201'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_View20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_View30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', view_id, '':mls_lang'')), ''View'', ' || 'view_id, ''wmp_rh_generic_report'', ''View_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(view_name, ''View'', ' || 'view_id, ''wmp_rh_generic_report'', ''View_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', view_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_views@# WHERE schema_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule_View10', 'SELECT wmp_api_nls.get_string(''10201'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule_View20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule_View30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', view_id, '':mls_lang'')), ''View'', ' || 'view_id, ''wmp_rh_generic_report'', ''View_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(view_name, ''View'', ' || 'view_id, ''wmp_rh_generic_report'', ''View_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', view_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_views@# WHERE schema_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_ExternalTable10', 'SELECT wmp_api_nls.get_string(''10490'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_ExternalTable20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_ExternalTable30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', table_id, '':mls_lang'')), ''ExternalTable'', ' || 'table_id, ''wmp_rh_generic_report'', ''ExternalTable_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(table_name, ''ExternalTable'', ' || 'table_id, ''wmp_rh_generic_report'', ''ExternalTable_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', table_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_external_tables@# WHERE schema_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule_ExternalTable10', 'SELECT wmp_api_nls.get_string(''10490'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule_ExternalTable20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule_ExternalTable30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', table_id, '':mls_lang'')), ''ExternalTable'', ' || 'table_id, ''wmp_rh_generic_report'', ''ExternalTable_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(table_name, ''ExternalTable'', ' || 'table_id, ''wmp_rh_generic_report'', ''ExternalTable_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', table_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_external_tables@# WHERE schema_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_AdvancedQueue10', 'SELECT wmp_api_nls.get_string(''10491'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_AdvancedQueue20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_AdvancedQueue30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', queue_id, '':mls_lang'')), ''AdvancedQueue'', ' || 'queue_id, ''wmp_rh_generic_report'', ''AdvancedQueue_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(queue_name, ''AdvancedQueue'', ' || 'queue_id, ''wmp_rh_generic_report'', ''AdvancedQueue_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', queue_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_advanced_queues@# WHERE schema_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Function10', 'SELECT wmp_api_nls.get_string(''10595'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Function20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Function30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', function_id, '':mls_lang'')), ''Function'', ' || 'function_id, ''wmp_rh_generic_report'', ''Function_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(function_name, ''Function'', ' || 'function_id, ''wmp_rh_generic_report'', ''Function_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', function_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_functions@# WHERE schema_id = :id and function_type = ''Function'' ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Procedure10', 'SELECT wmp_api_nls.get_string(''10596'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Procedure20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_Procedure30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', function_id, '':mls_lang'')), ''Function'', ' || 'function_id, ''wmp_rh_generic_report'', ''Function_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(function_name, ''Function'', ' || 'function_id, ''wmp_rh_generic_report'', ''Function_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', function_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_functions@# WHERE schema_id = :id and function_type = ''Procedure'' ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_TableFunction10', 'SELECT wmp_api_nls.get_string(''10597'') || '' - '' || information_system_name as c1 ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_TableFunction20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM all_iv_information_systems@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('DataWarehouse_TableFunction30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', function_id, '':mls_lang'')), ''TableFunction'', ' || 'function_id, ''wmp_rh_generic_report'', ''TableFunction_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(function_name, ''TableFunction'', ' || 'function_id, ''wmp_rh_generic_report'', ''TableFunction_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', function_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_table_functions@# WHERE schema_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('FileModule10', 'SELECT wmp_api_nls.get_string(''10489'') || '' - '' || information_system_name as c1 ' || 'FROM ALL_IV_FILE_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('FileModule20', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'created_on as "10222", ' || 'information_system_name as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'directory as "10580" ' || 'FROM ALL_IV_FILE_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('FileModule30', 'SELECT decode(upper(object_type), ''CUBE'', ''Fact'', initcap(object_type)) as "10273", ' || 'wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10261", ' || 'wmp_api_hlink.report_hlink(object_name, ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10281", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_all_objects@# WHERE parent_object_id = :id ' || 'ORDER BY initcap(object_type), business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('FileModule40', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''FILE_MODULE'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND (configuration_parameter_key like ''8i.ORACLE%'' OR ' || 'configuration_parameter_key like ''8i.DBLINKS.%'') ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('FileModule_File10', 'SELECT wmp_api_nls.get_string(''10066'') || '' - '' || information_system_name as c1 ' || 'FROM ALL_IV_FILE_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('FileModule_File20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''FileModule'', ' || 'information_system_id, ''wmp_rh_generic_report'', ''FileModule_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, ''FileModule'', ' || 'information_system_id, ''wmp_rh_generic_report'', ''FileModule_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM ALL_IV_FILE_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('FileModule_File30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', file_id, '':mls_lang'')), ''File'', ' || 'file_id, ''wmp_rh_generic_report'', ''File_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(file_name, ''File'', ' || 'file_id, ''wmp_rh_generic_report'', ''File_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', file_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_files@# WHERE information_system_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PreDefinedModule10', 'SELECT wmp_api_nls.get_string(''10039'') || '' - '' || information_system_name as c1 ' || 'FROM ALL_IV_PREDEFINED_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PreDefinedModule20', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'created_on as "10222", ' || 'information_system_name as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM ALL_IV_PREDEFINED_MODULES@# WHERE information_system_id = :id '|| 'AND project_name != ''Admin Project'' AND project_name != ''Global Shared'' '|| 'UNION '|| 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'created_on as "10222", ' || 'information_system_name as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'NULL as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM ALL_IV_PREDEFINED_MODULES@# WHERE information_system_id = :id '|| 'AND (project_name = ''Admin Project'' OR project_name = ''Global Shared'') '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PreDefinedModule30', 'SELECT decode(upper(object_type), ''CUBE'', ''Fact'', initcap(object_type)) as "10273", ' || 'wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10261", ' || 'wmp_api_hlink.report_hlink(object_name, ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10281", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_all_objects@# WHERE parent_object_id = :id ' || 'ORDER BY initcap(object_type), business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PreDefinedModule40', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''PREDEFINED_MODULE'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('GatewayModule10', 'SELECT wmp_api_nls.get_string(''10039'') || '' - '' || information_system_name as c1 ' || 'FROM ALL_IV_GATEWAY_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('GatewayModule20', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'created_on as "10222", ' || 'information_system_name as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'strong_type_name as "10529", '|| 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM ALL_IV_GATEWAY_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('GatewayModule30', 'SELECT decode(upper(object_type), ''CUBE'', ''Fact'', initcap(object_type)) as "10273", ' || 'wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10261", ' || 'wmp_api_hlink.report_hlink(object_name, ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10281", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_all_objects@# WHERE parent_object_id = :id ' || 'ORDER BY initcap(object_type), business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('GatewayModule40', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''GATEWAY_MODULE'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND (configuration_parameter_key like ''8i.ORACLE%'' OR ' || 'configuration_parameter_key like ''8i.DBLINKS.%'') ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MIVModule10', 'SELECT wmp_api_nls.get_string(''10039'') || '' - '' || information_system_name as c1 ' || 'FROM OWB_MIV_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MIVModule20', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'created_on as "10222", ' || 'information_system_name as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM OWB_MIV_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MIVModule30', 'SELECT decode(upper(object_type), ''CUBE'', ''Fact'', initcap(object_type)) as "10273", ' || 'wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10261", ' || 'wmp_api_hlink.report_hlink(object_name, ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10281", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_all_objects@# WHERE parent_object_id = :id ' || 'ORDER BY initcap(object_type), business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MIVModule40', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''MIV_MODULE'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND (configuration_parameter_key like ''8i.ORACLE%'' OR ' || 'configuration_parameter_key like ''8i.DBLINKS.%'') ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('XMLModule10', 'SELECT wmp_api_nls.get_string(''10039'') || '' - '' || information_system_name as c1 ' || 'FROM OWB_XML_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('XMLModule20', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'created_on as "10222", ' || 'information_system_name as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM OWB_XML_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('XMLModule30', 'SELECT decode(upper(object_type), ''CUBE'', ''Fact'', initcap(object_type)) as "10273", ' || 'wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10261", ' || 'wmp_api_hlink.report_hlink(object_name, ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10281", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_all_objects@# WHERE parent_object_id = :id ' || 'ORDER BY initcap(object_type), business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('XMLModule40', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''XML_MODULE'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND (configuration_parameter_key like ''8i.ORACLE%'' OR ' || 'configuration_parameter_key like ''8i.DBLINKS.%'') ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule10', 'SELECT wmp_api_nls.get_string(''10494'') || '' - '' || information_system_name as c1 ' || 'FROM ALL_IV_PACKAGED_APPS_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule20', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'created_on as "10222", ' || 'information_system_name as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM ALL_IV_PACKAGED_APPS_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule30', 'SELECT decode(upper(object_type), ''CUBE'', ''Fact'', initcap(object_type)) as "10273", ' || 'wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10261", ' || 'wmp_api_hlink.report_hlink(object_name, ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10281", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_all_objects@# WHERE parent_object_id = :id ' || 'ORDER BY initcap(object_type), business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('PackagedModule40', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''PACKAGED_MODULE'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND (configuration_parameter_key like ''8i.ORACLE%'' OR ' || 'configuration_parameter_key like ''8i.DBLINKS.%'') ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessModule10', 'SELECT wmp_api_nls.get_string(''10492'') || '' - '' || information_system_name as c1 ' || 'FROM ALL_IV_PROCESS_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessModule20', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'created_on as "10222", ' || 'information_system_name as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM ALL_IV_PROCESS_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessModule30', 'SELECT decode(upper(object_type), ''CUBE'', ''Fact'', initcap(object_type)) as "10273", ' || 'wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10261", ' || 'wmp_api_hlink.report_hlink(object_name, ' || 'wmp_report_query.report_type(object_type), ' || 'object_id, ''wmp_rh_generic_report'', ' || 'wmp_report_query.report_category(object_type)) as "10281", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_all_objects@# WHERE parent_object_id = :id ' || 'ORDER BY initcap(object_type), business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessModule_ProcessPackage10', 'SELECT wmp_api_nls.get_string(''10528'') || '' - '' || information_system_name as c1 ' || 'FROM ALL_IV_PROCESS_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessModule_ProcessPackage20', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''ProcessModule'', ' || 'information_system_id, ''wmp_rh_generic_report'', ''ProcessModule_Detail'') as "10261", ' || 'created_on as "10222", ' || 'wmp_api_hlink.report_hlink(information_system_name, ''ProcessModule'', ' || 'information_system_id, ''wmp_rh_generic_report'', ''ProcessModule_Detail'') as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'status as "10308", ' || 'decode(is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'integrator_name as "10405", ' || 'database_link as "10224" ' || 'FROM ALL_IV_PROCESS_MODULES@# WHERE information_system_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessModule_ProcessPackage30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', package_id, '':mls_lang'')), ''ProcessPackage'', ' || 'package_id, ''wmp_rh_generic_report'', ''ProcessPackage_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(package_name, ''ProcessPackage'', ' || 'package_id, ''wmp_rh_generic_report'', ''ProcessPackage_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', package_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_packages@# WHERE schema_id = :id ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Installation10', 'SELECT wmp_api_nls.get_string(''10040'') || '' - '' || installation_name as c1 ' || 'FROM all_iv_installations@# ' || 'WHERE installation_id = (SELECT min(installation_id) FROM all_iv_installations@#)'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Installation20', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', installation_id , '':mls_lang'')) as "10261", ' || 'created_on as "10222", ' || 'installation_name as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'public_view_version as "10318", ' || 'release as "10293", ' || 'installed_version as "10253", ' || 'repository_model_version as "10330" ' || 'FROM all_iv_installations@# ' || 'WHERE installation_id = (SELECT min(installation_id) FROM all_iv_installations@#)'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Installation30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', project_id, '':mls_lang'')), ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(project_name, ''Project'', ' || 'project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_projects@# ' || 'WHERE project_name != ''Admin Project'' AND project_name != ''Global Shared'' ' || 'ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Installation40', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', information_system_id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_information_systems@# ' || 'WHERE project_name = ''Admin Project'' OR project_name = ''Global Shared'' ' || 'ORDER BY business_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView10', 'SELECT wmp_api_nls.get_string(''10041'') || '' - '' || view_name as c1 ' || 'FROM all_iv_materialized_views@# WHERE view_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView11', 'SELECT wmp_api_nls.get_string(''10116'') || '' - '' || view_name ' || 'FROM all_iv_materialized_views@# WHERE view_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView12', 'SELECT wmp_api_nls.get_string(''10115'') || '' - '' || view_name ' || 'FROM all_iv_materialized_views@# WHERE view_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView20', 'SELECT decode('':mls_lang'', '':base_lang'', m.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'm.created_on as "10222", ' || 'm.view_name as "10281", ' || 'm.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', m.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(m.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_materialized_views@# m, all_iv_information_systems@# s ' || 'WHERE m.view_id = :id AND s.information_system_id = m.schema_id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView30', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', column_id, '':mls_lang'')) as "10261", ' || 'column_name as "10281", ' || 'data_type as "10029", ' || 'length as "10102", ' || 'precision as "10140", ' || 'scale as "10154", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', column_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_columns@# WHERE entity_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView40', 'SELECT key_id FROM all_iv_keys@# WHERE entity_id = :id ORDER BY key_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView50', 'SELECT foreign_key_id FROM all_iv_foreign_keys@# WHERE entity_id = :id ORDER BY foreign_key_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView55', 'SELECT constraint_name as "10587", '|| 'constraint_text as "10588" '|| 'FROM all_iv_check_constraints@# ' || 'WHERE relation_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView60', 'SELECT parm_id as "10216" ' || 'FROM (SELECT DISTINCT parm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE comp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView70', 'SELECT depparm_id as "10216" ' || 'FROM (SELECT DISTINCT depparm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE depcomp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView80', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id ' || 'AND upper(configured_object_type) = ''MATERIALIZED_VIEW'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND configuration_parameter_key like ''8i.%'' ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView:Key41', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'key_name as "10281", ' || 'is_primary as "10585", '|| 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_keys@# WHERE key_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView:Key42', 'SELECT column_name as "10281" FROM all_iv_key_column_uses@# ' || 'WHERE key_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView:ForeignKey51', 'SELECT decode('':mls_lang'', '':base_lang'', fk.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'fk.foreign_key_name as "10281", ' || 'k.schema_name as "10613", '|| 'k.entity_name as "10614", '|| 'k.key_name as "10100" ' || 'FROM all_iv_foreign_keys@# fk, all_iv_keys@# k WHERE fk.key_id = k.key_id and fk.foreign_key_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView:ForeignKey52', 'SELECT fkc.column_name as "10615", ' || 'kc.column_name as "10616" '|| ' FROM all_iv_key_column_uses@# fkc, all_iv_key_column_uses@# kc, all_iv_foreign_keys@# fk, all_iv_keys@# k ' || 'WHERE fk.foreign_key_id = :id and fk.key_id = k.key_id and fk.foreign_key_id = fkc.key_id and fkc.position = kc.position and k.key_id = kc.key_id ORDER BY fkc.position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView:Lineage61', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10010" FROM all_iv_columns@# WHERE column_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView:Lineage62', 'SELECT item.object_name as "10619", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10620", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.parm_id = :id and mv.depparm_id = item.object_id and mv.depcomp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView:Impact71', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10010" FROM all_iv_columns@# WHERE column_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('MaterializedView:Impact72', 'SELECT item.object_name as "10617", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10618", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.depparm_id = :id and mv.parm_id = item.object_id and mv.comp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Project10', 'SELECT wmp_api_nls.get_string(''10043'') || '' - '' || project_name as c1 FROM all_iv_projects@# WHERE project_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Project20', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'created_on as "10222", ' || 'project_name as "10281", ' || 'updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_projects@# WHERE project_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Project30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', information_system_id, '':mls_lang'')), information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(information_system_name, information_system_type, ' || 'information_system_id, ''wmp_rh_generic_report'', information_system_type||''_Detail'') as "10281", ' || 'product_type as "10404", ' || 'system_type as "10309", ' || 'vendor as "10197", ' || 'version_label as "10318", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', information_system_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_information_systems@# WHERE project_id = :id '|| 'ORDER BY 1 ASC '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Project40', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''Location'', ' || 'location_id, ''wmp_rh_generic_report'', ''Location_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(location_name, ''Location'', ' || 'location_id, ''wmp_rh_generic_report'',''Location_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM ALL_IV_LOCATIONS@# ' || 'WHERE project_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Project50', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''Collection'', ' || 'collection_id, ''wmp_rh_generic_report'', ''Collection_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(collection_name, ''Collection'', ' || 'collection_id, ''wmp_rh_generic_report'',''Collection_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_collections@# ' || 'WHERE project_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Project60', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''RuntimeLocation'', ' || 'location_id, ''wmp_rh_generic_report'', ''RuntimeLocation_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(location_name, ''RuntimeLocation'', ' || 'location_id, ''wmp_rh_generic_report'',''RuntimeLocation_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM ALL_IV_RUNTIME_REPOSITORIES@# ' || 'WHERE project_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Record10', 'SELECT wmp_api_nls.get_string(''10044'') || '' - '' || record_name as c1 FROM all_iv_records@# WHERE record_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Record20', 'SELECT decode('':mls_lang'', '':base_lang'', r.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'r.created_on as "10222", ' || 'r.record_name as "10281", ' || 'r.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', r.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(r.file_name, ''File'', ' || 'r.file_id, ''wmp_rh_generic_report'', ''File_Detail'') as "10343", ' || 'wmp_api_hlink.report_hlink(f.information_system_name, ''FileModule'', ' || 'f.information_system_id, ''wmp_rh_generic_report'', ''FileModule_Detail'') as "10091", ' || 'wmp_api_hlink.report_hlink(i.project_name, ''Project'', ' || 'i.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285" ' || 'FROM all_iv_records@# r, all_iv_files@# f, ALL_IV_FILE_MODULES@# i ' || 'WHERE r.record_id = :id AND r.file_id = f.file_id AND f.information_system_id = i.information_system_id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Record30', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', field_id, '':mls_lang'')) as "10261", ' || 'field_name as "10281", ' || 'data_type as "10029", ' || 'mask as "10627", ' || 'nullif as "10628", ' || 'defaultif as "10629", ' || 'length as "10102", ' || 'precision as "10140", ' || 'scale as "10154", ' || 'sql_data_type as "10630", ' || 'sql_precision as "10631", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', field_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_fields@# WHERE record_id = :id ' || 'ORDER by position '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Sequence10', 'SELECT wmp_api_nls.get_string(''10046'') || '' - '' || sequence_name as c1 FROM all_iv_sequences@# WHERE sequence_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Sequence12', 'SELECT wmp_api_nls.get_string(''10162'') || '' - '' || sequence_name as c1 FROM all_iv_sequences@# WHERE sequence_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Sequence20', 'SELECT decode('':mls_lang'', '':base_lang'', q.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'q.created_on as "10222", ' || 'q.sequence_name as "10281", ' || 'q.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', q.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(q.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_sequences@# q, all_iv_information_systems@# s ' || 'WHERE q.sequence_id = :id AND s.information_system_id = q.schema_id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Sequence30', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', column_id, '':mls_lang'')) as "10261", ' || 'column_name as "10281", ' || 'data_type as "10029", ' || 'length as "10102", ' || 'precision as "10140", ' || 'scale as "10154", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', column_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_columns@# WHERE entity_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Sequence40', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''SEQUENCE'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND configuration_parameter_key like ''8i.%'' ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Sequence70', 'SELECT depparm_id as "10216" ' || 'FROM (SELECT DISTINCT depparm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE depcomp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Sequence:Impact71', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10010" FROM all_iv_columns@# WHERE column_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Sequence:Impact72', 'SELECT item.object_name as "10617", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10618", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.depparm_id = :id and mv.parm_id = item.object_id and mv.comp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table10', 'SELECT wmp_api_nls.get_string(''10047'') || '' - '' || table_name as c1 FROM all_iv_tables@# WHERE table_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table11', 'SELECT wmp_api_nls.get_string(''10171'') || '' - '' || table_name as c1 FROM all_iv_tables@# WHERE table_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table12', 'SELECT wmp_api_nls.get_string(''10170'') || '' - '' || table_name as c1 FROM all_iv_tables@# WHERE table_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table20', 'SELECT decode('':mls_lang'', '':base_lang'', t.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 't.created_on as "10222", ' || 't.table_name as "10281", ' || 't.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', t.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(t.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_tables@# t, all_iv_information_systems@# s ' || 'WHERE t.table_id = :id AND s.information_system_id = t.schema_id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table30', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', column_id, '':mls_lang'')) as "10261", ' || 'column_name as "10281", ' || 'data_type as "10029", ' || 'length as "10102", ' || 'precision as "10140", ' || 'scale as "10154", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', column_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_columns@# WHERE entity_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table40', 'SELECT key_id FROM all_iv_keys@# WHERE entity_id = :id ORDER BY key_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table50', 'SELECT foreign_key_id FROM all_iv_foreign_keys@# WHERE entity_id = :id ORDER BY foreign_key_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table55', 'SELECT constraint_name as "10587", '|| 'constraint_text as "10588" '|| 'FROM all_iv_check_constraints@# ' || 'WHERE relation_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table60', 'SELECT parm_id as "10216" ' || 'FROM (SELECT DISTINCT parm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE comp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table70', 'SELECT depparm_id as "10216" ' || 'FROM (SELECT DISTINCT depparm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE depcomp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table80', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''TABLE'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND configuration_parameter_key like ''8i.%'' ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_key, decode(parameter_nlskey, null, configuration_parameter_key, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_key))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table:Key41', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'key_name as "10281", ' || 'is_primary as "10585", '|| 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_keys@# WHERE key_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table:Key42', 'SELECT column_name as "10281" FROM all_iv_key_column_uses@# ' || 'WHERE key_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table:ForeignKey51', 'SELECT decode('':mls_lang'', '':base_lang'', fk.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'fk.foreign_key_name as "10281", ' || 'k.schema_name as "10613", '|| 'k.entity_name as "10614", '|| 'k.key_name as "10100" ' || 'FROM all_iv_foreign_keys@# fk, all_iv_keys@# k WHERE fk.key_id = k.key_id and fk.foreign_key_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table:ForeignKey52', 'SELECT fkc.column_name as "10615", ' || 'kc.column_name as "10616" '|| ' FROM all_iv_key_column_uses@# fkc, all_iv_key_column_uses@# kc, all_iv_foreign_keys@# fk, all_iv_keys@# k ' || 'WHERE fk.foreign_key_id = :id and fk.key_id = k.key_id and fk.foreign_key_id = fkc.key_id and fkc.position = kc.position and k.key_id = kc.key_id ORDER BY fkc.position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table:Lineage61', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10010" FROM all_iv_columns@# WHERE column_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table:Lineage62', 'SELECT item.object_name as "10619", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10620", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.parm_id = :id and mv.depparm_id = item.object_id and mv.depcomp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table:Impact71', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10010" FROM all_iv_columns@# WHERE column_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Table:Impact72', 'SELECT item.object_name as "10617", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10618", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.depparm_id = :id and mv.parm_id = item.object_id and mv.comp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable10', 'SELECT wmp_api_nls.get_string(''10047'') || '' - '' || table_name as c1 FROM all_iv_external_tables@# WHERE table_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable11', 'SELECT wmp_api_nls.get_string(''10171'') || '' - '' || table_name as c1 FROM all_iv_external_tables@# WHERE table_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable12', 'SELECT wmp_api_nls.get_string(''10170'') || '' - '' || table_name as c1 FROM all_iv_external_tables@# WHERE table_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable20', 'SELECT decode('':mls_lang'', '':base_lang'', t.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 't.created_on as "10222", ' || 't.table_name as "10281", ' || 't.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', t.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(t.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_external_tables@# t, all_iv_information_systems@# s ' || 'WHERE t.table_id = :id AND s.information_system_id = t.schema_id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable30', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', column_id, '':mls_lang'')) as "10261", ' || 'column_name as "10281", ' || 'data_type as "10029", ' || 'length as "10102", ' || 'precision as "10140", ' || 'scale as "10154", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', column_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_columns@# WHERE entity_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable40', 'SELECT key_id FROM all_iv_keys@# WHERE entity_id = :id ORDER BY key_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable50', 'SELECT foreign_key_id FROM all_iv_foreign_keys@# WHERE entity_id = :id ORDER BY foreign_key_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable60', 'SELECT parm_id as "10216" ' || 'FROM (SELECT DISTINCT parm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE comp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable70', 'SELECT depparm_id as "10216" ' || 'FROM (SELECT DISTINCT depparm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE depcomp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable80', 'SELECT decode('':mls_lang'', '':base_lang'', r.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'record_name as "10281", ' || 'file_name as "10343", ' || 'decode('':mls_lang'', '':base_lang'', r.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_records@# r, all_iv_external_tables@# t WHERE r.record_id = t.source_record_id AND t.table_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable90', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''EXTERNAL_TABLE'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND configuration_parameter_key like ''8i.%'' ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable:Key41', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'key_name as "10281", ' || 'is_primary as "10585", '|| 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_keys@# WHERE key_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable:Key42', 'SELECT column_name as "10281" FROM all_iv_key_column_uses@# ' || 'WHERE key_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable:ForeignKey51', 'SELECT decode('':mls_lang'', '':base_lang'', fk.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'fk.foreign_key_name as "10281", ' || 'k.schema_name as "10613", '|| 'k.entity_name as "10614", '|| 'k.key_name as "10100" ' || 'FROM all_iv_foreign_keys@# fk, all_iv_keys@# k WHERE fk.key_id = k.key_id and fk.foreign_key_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable:ForeignKey52', 'SELECT fkc.column_name as "10615", ' || 'kc.column_name as "10616" '|| ' FROM all_iv_key_column_uses@# fkc, all_iv_key_column_uses@# kc, all_iv_foreign_keys@# fk, all_iv_keys@# k ' || 'WHERE fk.foreign_key_id = :id and fk.key_id = k.key_id and fk.foreign_key_id = fkc.key_id and fkc.position = kc.position and k.key_id = kc.key_id ORDER BY fkc.position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable:Lineage61', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10010" FROM all_iv_columns@# WHERE column_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable:Lineage62', 'SELECT item.object_name as "10619", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10620", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.parm_id = :id and mv.depparm_id = item.object_id and mv.depcomp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable:Impact71', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10010" FROM all_iv_columns@# WHERE column_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ExternalTable:Impact72', 'SELECT item.object_name as "10617", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10618", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.depparm_id = :id and mv.parm_id = item.object_id and mv.comp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('TransformMap10', 'SELECT wmp_api_nls.get_string(''10048'') || '' - '' || map_name as c1 FROM all_iv_xform_maps@# WHERE map_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('TransformMap20', 'SELECT decode('':mls_lang'', '':base_lang'', t.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 't.created_on as "10222", ' || 't.map_name as "10281", ' || 't.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', t.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(t.information_system_name, ''DataWarehouse'', ' || 't.information_system_id, ''wmp_rh_generic_report'', ''DataWarehouse_Detail'') as "10091", ' || 'wmp_api_hlink.report_hlink(i.project_name, ''Project'', ' || 'i.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(t.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_xform_maps@# t, ALL_IV_WAREHOUSE_MODULES@# i ' || 'WHERE t.map_id = :id AND t.information_system_id = i.information_system_id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('TransformMap30', 'SELECT initcap(c.operator_type) as "10273", ' || 'c.map_component_name as "10127", ' || 'pp.parameter_type as "10192" ' || 'FROM all_iv_xform_map_components@# c, ' || '(SELECT DISTINCT map_component_id, parameter_type FROM all_iv_xform_map_parameters@# ) pp ' || 'WHERE c.map_id = :id AND c.map_component_id = pp.map_component_id (+) ' || 'AND upper(c.data_entity_type) != ''FUNCTION'' AND upper(c.data_entity_type) != ''UNKNOWN'' ' || 'ORDER BY initcap(c.operator_type), c.map_component_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('TransformMap40', 'SELECT map_component_id FROM ' || '(SELECT map_component_id, map_component_name, data_entity_type, 1 as "10344" ' || 'FROM all_iv_xform_map_components@# ' || 'WHERE map_id = :id AND ' || '(upper(data_entity_type) = ''FUNCTION'' OR upper(data_entity_type) = ''UNKNOWN'') ' || 'UNION ' || 'SELECT map_component_id, map_component_name, data_entity_type, 2 as "10344" ' || 'FROM all_iv_xform_map_components@# ' || 'WHERE map_id = :id AND ' || 'upper(data_entity_type) != ''FUNCTION'' AND upper(data_entity_type) != ''UNKNOWN'' ) ' || 'ORDER BY "10344", data_entity_type, map_component_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('TransformMap50', 'SELECT distinct decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''TRANSFORM_MAP'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND language = ''en'' ' || 'AND configuration_parameter_name != ''A'' ' || 'AND group_name not like ''%SQL Loader Settings%'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('TransformMap:TransformMapComponent41', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'map_component_name as "10281", ' || 'composite_component_name as "10135", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_xform_map_components@# WHERE map_component_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('TransformMap:TransformMapComponent42', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'parameter_name as "10281", ' || 'source_expression as "10345", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM ALL_IV_XFORM_MAP_DETAILS@# ' || 'WHERE map_component_id = :id ' || 'ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View10', 'SELECT wmp_api_nls.get_string(''10049'') || '' - '' || view_name as c1 FROM all_iv_views@# WHERE view_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View11', 'SELECT wmp_api_nls.get_string(''10200'') || '' - '' || view_name as c1 FROM all_iv_views@# WHERE view_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View12', 'SELECT wmp_api_nls.get_string(''10199'') || '' - '' || view_name as c1 FROM all_iv_views@# WHERE view_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View20', 'SELECT decode('':mls_lang'', '':base_lang'', v.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'v.created_on as "10222", ' || 'v.view_name as "10281", ' || 'v.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', v.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(v.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_views@# v, all_iv_information_systems@# s ' || 'WHERE v.view_id = :id AND s.information_system_id = v.schema_id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View30', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', column_id, '':mls_lang'')) as "10261", ' || 'column_name as "10281", ' || 'data_type as "10029", ' || 'length as "10102", ' || 'precision as "10140", ' || 'scale as "10154", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', column_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_columns@# WHERE entity_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View40', 'SELECT key_id FROM all_iv_keys@# WHERE entity_id = :id ORDER BY key_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View50', 'SELECT foreign_key_id FROM all_iv_foreign_keys@# WHERE entity_id = :id ORDER BY foreign_key_name'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View55', 'SELECT constraint_name as "10587", '|| 'constraint_text as "10588" '|| 'FROM all_iv_check_constraints@# ' || 'WHERE relation_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View60', 'SELECT parm_id as "10216" ' || 'FROM (SELECT DISTINCT parm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE comp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View70', 'SELECT depparm_id as "10216" ' || 'FROM (SELECT DISTINCT depparm_id ' || 'FROM owb_compparam_mv@# ' || 'WHERE depcomp_id = :id )'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View80', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''VIEW'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND configuration_parameter_key like ''8i.%'' ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View:Key41', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'key_name as "10281", ' || 'is_primary as "10585", '|| 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_keys@# WHERE key_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View:Key42', 'SELECT column_name as "10281" FROM all_iv_key_column_uses@# ' || 'WHERE key_id = :id ORDER BY position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View:ForeignKey51', 'SELECT decode('':mls_lang'', '':base_lang'', fk.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'fk.foreign_key_name as "10281", ' || 'k.schema_name as "10613", '|| 'k.entity_name as "10614", '|| 'k.key_name as "10100" ' || 'FROM all_iv_foreign_keys@# fk, all_iv_keys@# k WHERE fk.key_id = k.key_id and fk.foreign_key_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View:ForeignKey52', 'SELECT fkc.column_name as "10615", ' || 'kc.column_name as "10616" '|| ' FROM all_iv_key_column_uses@# fkc, all_iv_key_column_uses@# kc, all_iv_foreign_keys@# fk, all_iv_keys@# k ' || 'WHERE fk.foreign_key_id = :id and fk.key_id = k.key_id and fk.foreign_key_id = fkc.key_id and fkc.position = kc.position and k.key_id = kc.key_id ORDER BY fkc.position'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View:Lineage61', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10010" FROM all_iv_columns@# WHERE column_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View:Lineage62', 'SELECT item.object_name as "10619", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10620", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.parm_id = :id and mv.depparm_id = item.object_id and mv.depcomp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View:Impact71', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10010" FROM all_iv_columns@# WHERE column_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('View:Impact72', 'SELECT item.object_name as "10617", ' || 'item.object_type as "10312", '|| 'obj.object_name as "10618", ' || 'obj.object_type as "10312" ' || ' FROM owb_compparam_mv@# mv, all_iv_objects@# item, all_iv_objects@# obj ' || 'WHERE mv.depparm_id = :id and mv.parm_id = item.object_id and mv.comp_id = obj.object_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessPackage10', 'SELECT wmp_api_nls.get_string(''10516'') || '' - '' || package_name as c1 FROM all_iv_packages@# WHERE package_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessPackage20', 'SELECT decode('':mls_lang'', '':base_lang'', q.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'q.created_on as "10222", ' || 'q.package_name as "10281", ' || 'q.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', q.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(q.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_packages@# q, all_iv_information_systems@# s ' || 'WHERE q.package_id = :id AND s.information_system_id = q.schema_id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessPackage30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', process_id, '':mls_lang'')), ''Process'', ' || 'process_id, ''wmp_rh_generic_report'', ''Process_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(process_name, ''Process'', ' || 'process_id, ''wmp_rh_generic_report'', ''Process_Detail'') as "10281", ' || 'bound_object_name as "10456", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', process_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_processes@# WHERE package_id = :id and parent_process_id = 0'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Process10', 'SELECT wmp_api_nls.get_string(''10518'') || '' - '' || process_name as c1 FROM all_iv_processes@# WHERE process_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Process20', 'SELECT decode('':mls_lang'', '':base_lang'', q.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'q.created_on as "10222", ' || 'q.process_name as "10281", ' || 'q.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', q.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285", ' || 'decode(q.is_valid, ''Y'', wmp_api_nls.get_string(''10322''), ''N'', wmp_api_nls.get_string(''10271''), ' || 'wmp_api_nls.get_string(''10314'')) as "10195" ' || 'FROM all_iv_processes@# q, all_iv_packages@# p, all_iv_information_systems@# s ' || 'WHERE q.process_id = :id AND s.information_system_id = p.schema_id AND p.package_id = q.package_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Process30', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''ProcessActivity'', ' || 'activity_id, ''wmp_rh_generic_report'', ''ProcessActivity_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(activity_name, ''ProcessActivity'', ' || 'activity_id, ''wmp_rh_generic_report'', ''ProcessActivity_Detail'') as "10281", ' || 'decode(activity_type, ''PlSqlMapProcessNoteTag'', ''MAP'', ''FunctionProcessNoteTag'', ''TRANSFORM'', activity_type) as "10611", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_process_activities@# WHERE process_id = :id '|| 'UNION '|| 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', p.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''Process'', ' || 'p.process_id, ''wmp_rh_generic_report'', ''Process_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(p.process_name, ''Process'', ' || 'p.process_id, ''wmp_rh_generic_report'', ''Process_Detail'') as "10281", ' || '''SUBPROCESS'' as "10456", ' || 'decode('':mls_lang'', '':base_lang'', p.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_processes@# p, all_iv_processes@# sub WHERE sub.parent_process_id = :id and sub.bound_object_id = p.process_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Process40', 'SELECT wmp_api_hlink.report_hlink(decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')), ''ProcessTransition'', '|| 'transition_id, ''wmp_rh_generic_report'', ''ProcessTransition_Detail'') as "10261", ' || 'wmp_api_hlink.report_hlink(transition_name, ''ProcessTransition'', ' || 'transition_id, ''wmp_rh_generic_report'', ''ProcessTransition_Detail'') as "10281", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_process_transitions@# WHERE process_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Process50', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'variable_name as "10281", ' || 'data_type as "10458", ' || 'default_value as "10459", ' || 'is_final as "10460", '|| 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_process_variables@# WHERE process_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('Process60', 'SELECT decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))) as "10218", ' || 'decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) as "10217", ' || 'argument as "10219" ' || 'FROM ALL_IV_OBJECT_CONFIGURATIONS@# ' || 'WHERE configured_object_id = :id AND upper(configured_object_type) = ''PROCESS'' ' || 'AND upper(configuration_parameter_type) = ''CONFIGURATION_PARAMETER'' ' || 'AND language = ''en'' ' || 'ORDER BY decode(wmp_api_nls.get_nls_language, ''us'', group_name, decode(group_nlskey, null, group_name, nvl(wmp_api_nls.get_string(group_nlskey), group_name))), ' || ' decode(wmp_api_nls.get_nls_language, ''us'', configuration_parameter_name, decode(parameter_nlskey, null, configuration_parameter_name, nvl(wmp_api_nls.get_string(parameter_nlskey), configuration_parameter_name))) ' ); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessActivity10', 'SELECT wmp_api_nls.get_string(''10520'') || '' - '' || activity_name as c1 FROM all_iv_process_activities@# WHERE activity_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessActivity20', 'SELECT decode('':mls_lang'', '':base_lang'', q.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'q.created_on as "10222", ' || 'q.activity_name as "10281", ' || 'q.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', q.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285" ' || 'FROM all_iv_process_activities@# q, all_iv_processes@# pro, all_iv_packages@# p, all_iv_information_systems@# s ' || 'WHERE q.activity_id = :id AND s.information_system_id = p.schema_id AND p.package_id = pro.package_id AND q.process_id = pro.process_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessActivity30', 'SELECT decode('':mls_lang'', '':base_lang'', business_name, wmp_api_repository.mls_name(''#'', parameter_id, '':mls_lang'')) as "10261", ' || 'parameter_name as "10281", ' || 'default_value as "10459", ' || 'decode('':mls_lang'', '':base_lang'', description, wmp_api_repository.mls_description(''#'', parameter_id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_process_parameters@# WHERE parameter_owner_id = :id and direction = ''IN'''); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessTransition10', 'SELECT wmp_api_nls.get_string(''10521'') || '' - '' || transition_name as c1 FROM all_iv_process_transitions@# WHERE transition_id = :id'); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessTransition20', 'SELECT decode('':mls_lang'', '':base_lang'', q.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'q.created_on as "10222", ' || 'p.package_name as "10281", ' || 'q.updated_on as "10316", ' || 'decode('':mls_lang'', '':base_lang'', q.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228", ' || 'wmp_api_hlink.report_hlink(s.information_system_name, s.information_system_type, ' || 's.information_system_id, ''wmp_rh_generic_report'', s.information_system_type||''_Detail'') as "10155", ' || 'wmp_api_hlink.report_hlink(s.project_name, ''Project'', ' || 's.project_id, ''wmp_rh_generic_report'', ''Project_Detail'') as "10285" ' || 'FROM all_iv_process_transitions@# q, all_iv_processes@# pro, all_iv_packages@# p, all_iv_information_systems@# s ' || 'WHERE q.transition_id = :id AND s.information_system_id = p.schema_id AND p.package_id = pro.package_id AND q.process_id = pro.process_id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessTransition30', 'SELECT decode('':mls_lang'', '':base_lang'', a.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'a.activity_name as "10281", ' || 'a.bound_object_name as "10456", ' || 'decode('':mls_lang'', '':base_lang'', a.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_process_activities@# a, all_iv_process_transitions@# pt WHERE a.activity_id = pt.source_activity_id and pt.transition_id = :id '); INSERT INTO wmp_report_queries (query_name, query_statement) VALUES ('ProcessTransition40', 'SELECT decode('':mls_lang'', '':base_lang'', a.business_name, wmp_api_repository.mls_name(''#'', :id, '':mls_lang'')) as "10261", ' || 'a.activity_name as "10281", ' || 'a.bound_object_name as "10456", ' || 'decode('':mls_lang'', '':base_lang'', a.description, wmp_api_repository.mls_description(''#'', :id, '':mls_lang'')) as "10228" ' || 'FROM all_iv_process_activities@# a, all_iv_process_transitions@# pt WHERE a.activity_id = pt.target_activity_id and pt.transition_id = :id '); COMMIT; end; end;