AS
 SELECT d."OBJTYPE",d."OBJNAME",d."OBJID",d."MAINOBJTYPE",d."MAINOBJNAME",d."MAINOBJID",d."SCHEMANAME",d."SCHEMAID",d."CATALOGNAME",d."CATALOGID",d."CONNNAME",d."CONNID",d."PROJECTNAME",d."PROJECTID",d."CAPTUREDORCONVERTED",d."QUALIFIEDNAME", p.native_sql,p.linecount 
 FROM md_stored_programs p , mgv_all_programs_details d
 WHERE p.id = d.objid
 AND d.capturedorconverted = 'CAPTURED'
 UNION ALL
 SELECT d."OBJTYPE",d."OBJNAME",d."OBJID",d."MAINOBJTYPE",d."MAINOBJNAME",d."MAINOBJID",d."SCHEMANAME",d."SCHEMAID",d."CATALOGNAME",d."CATALOGID",d."CONNNAME",d."CONNID",d."PROJECTNAME",d."PROJECTID",d."CAPTUREDORCONVERTED",d."QUALIFIEDNAME",v.native_sql,v.linecount
 FROM md_views v , mgv_all_view_details d
 WHERE v.id = d.objid
 AND d.capturedorconverted = 'CAPTURED'
 UNION ALL
 SELECT d."OBJTYPE",d."OBJNAME",d."OBJID",d."MAINOBJTYPE",d."MAINOBJNAME",d."MAINOBJID",d."SCHEMANAME",d."SCHEMAID",d."CATALOGNAME",d."CATALOGID",d."CONNNAME",d."CONNID",d."PROJECTNAME",d."PROJECTID",d."CAPTUREDORCONVERTED",d."QUALIFIEDNAME" ,t.native_sql,t.linecount
 FROM md_triggers t , mgv_all_trigger_details d
 WHERE t.id = d.objid
 AND d.capturedorconverted = 'CAPTURED'

AS
 SELECT 'MD_CATALOGS' objtype, cat.catalog_name objname, cat.id objid,  'MD_CATALOGS' MainObjType,cat.catalog_name MAINOBJNAME, cat.id MAINOBJID,null SchemaName,null schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id  connid,proj.project_name projectname,proj.id projectid,
 NVL(conn.type,'CAPTURED') CapturedOrConverted, 
 CASE WHEN conn.type IS NULL THEN cat.catalog_name ELSE NULL END QualifiedName
 FROM  MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
 WHERE  cat.connection_id_fk = conn.id
 AND conn.PROJECT_ID_FK = proj.id

AS
 SELECT md_projects.id project_id ,
     md_projects.project_name project_name,
     md_connections.id connection_id ,
     md_connections.host host ,
     md_connections.port port ,
     md_connections.username username ,
     md_connections.dburl dburl ,
     md_catalogs.id catalog_id ,
     md_catalogs.catalog_name catalog_name
   FROM md_projects ,
     md_connections,
     md_catalogs
   WHERE md_catalogs.connection_id_fk = md_connections.id
   AND md_connections.project_id_fk   = md_projects.id

AS
 SELECT 'MD_COLUMNS' objtype, c.COLUMN_NAME objname, c.Id objid,  'MD_TABLES' MainObjType,t.table_name MAINOBJNAME, t.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id  connid,proj.project_name projectname,proj.id projectid,
 NVL(conn.type,'CAPTURED') CapturedOrConverted, 
 CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||t.table_name ||'.'||c.COLUMN_NAME QualifiedName
 FROM MD_COLUMNS c, MD_TABLES t,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
 WHERE c.table_id_fk = t.id
 AND t.schema_id_fk = s.id
 AND s.catalog_id_fk = cat.id
 AND cat.connection_id_fk = conn.id
 AND conn.PROJECT_ID_FK = proj.id

AS
 SELECT 'MD_COLUMNS' objtype, c.COLUMN_NAME objname, c.Id objid,  'MD_TABLES' MainObjType,t.table_name MAINOBJNAME, t.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id  connid,proj.project_name projectname ,proj.id projectid,
 NVL(conn.type,'CAPTURED') CapturedOrConverted, 
 CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||t.table_name ||'.'||c.COLUMN_NAME QualifiedName,
 c.column_type datatype,
 CASE WHEN p.PROP_KEY='SEEDVALUE' THEN 'Y' ELSE 'N' END IsIdentity
 FROM MD_COLUMNS c LEFT OUTER JOIN MD_ADDITIONAL_PROPERTIES p ON c.id =p.ref_id_fk
 , MD_TABLES t,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn,MD_PROJECTS proj
 WHERE c.table_id_fk = t.id
 AND t.schema_id_fk = s.id
 AND s.catalog_id_fk = cat.id
 AND cat.connection_id_fk = conn.id
 AND conn.PROJECT_ID_FK = proj.id

AS
 SELECT md_projects.id project_id ,
     md_projects.project_name project_name,
     md_connections.id connection_id ,
     md_connections.host host ,
     md_connections.port port ,
     md_connections.username username ,
     md_connections.dburl dburl
   FROM md_projects,
     md_connections
   WHERE md_connections.project_id_fk = md_projects.id

AS
 SELECT 'MD_CONSTRAINTS' objtype, c.name objname, c.Id objid,  'MD_TABLES' MainObjType,t.table_name MAINOBJNAME, t.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id  connid,proj.project_name projectname,proj.id projectid,
 NVL(conn.type,'CAPTURED') CapturedOrConverted, 
 CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||t.table_name ||'.'||c.name QualifiedName
 FROM MD_CONSTRAINTS c, MD_TABLES t,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
 WHERE c.table_id_fk = t.id
 AND t.schema_id_fk = s.id
 AND s.catalog_id_fk = cat.id
 AND cat.connection_id_fk = conn.id
 AND conn.PROJECT_ID_FK = proj.id

AS
 SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_CATALOG_DETAILS
 UNION
 SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_SCHEMA_DETAILS
 UNION
 SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_TABLES_DETAILS
 UNION
 SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_COLUMN_DETAILS
 UNION
 SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_CONSTRAINTS_DETAILS
 UNION
 SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_INDEX_DETAILS
 UNION
 SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_TRIGGER_DETAILS
 UNION
 SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_VIEW_DETAILS
 UNION
 SELECT "OBJTYPE","OBJNAME","OBJID","MAINOBJTYPE","MAINOBJNAME","MAINOBJID","SCHEMANAME","SCHEMAID","CATALOGNAME","CATALOGID","CONNNAME","CONNID","PROJECTNAME","PROJECTID","CAPTUREDORCONVERTED","QUALIFIEDNAME" FROM MGV_ALL_PROGRAMS_DETAILS

AS
 SELECT 'MD_INDEXES' objtype,i.index_name objname, i.Id objid,  'MD_TABLES' MainObjType,t.table_name MAINOBJNAME,t.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id  connid, proj.project_name projectname,proj.id projectid,
 NVL(conn.type,'CAPTURED') CapturedOrConverted, 
 CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||i.index_name  QualifiedName
 FROM MD_INDEXES i, MD_TABLES t,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn,MD_PROJECTS proj
 WHERE i.table_id_fk = t.id
 AND t.schema_id_fk = s.id
 AND s.catalog_id_fk = cat.id
 AND cat.connection_id_fk = conn.id
 AND conn.PROJECT_ID_FK = proj.id

AS
 SELECT 'MD_STORED_PROGRAMS' objtype,p.name objname, p.Id objid,  'MD_STORED_PROGRAMS' MainObjType,p.name MAINOBJNAME,p.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id  connid,proj.project_name projectname,proj.id projectid,
 NVL(conn.type,'CAPTURED') CapturedOrConverted, 
 CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||p.name  QualifiedName
 FROM MD_STORED_PROGRAMS p,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
 WHERE p.schema_id_fk = s.id
 AND s.catalog_id_fk = cat.id
 AND cat.connection_id_fk = conn.id
 AND conn.PROJECT_ID_FK = proj.id

AS
 SELECT md_projects.id project_id ,
     md_projects.project_name project_name,
     md_connections.id connection_id ,
     md_connections.host host ,
     md_connections.port port ,
     md_connections.username username ,
     md_catalogs.id catalog_id ,
     md_catalogs.catalog_name catalog_name,
     md_schemas.id schema_id ,
     md_schemas.name schema_name
   FROM md_connections,
     md_catalogs ,
     md_schemas ,
     md_projects
   WHERE md_schemas.catalog_id_fk   = md_catalogs.id
   AND md_catalogs.connection_id_fk = md_connections.id
   AND md_connections.project_id_fk = md_projects.id

AS
 SELECT 'MD_SCHEMAS' objtype, s.name objname, s.id objid,  'MD_SCHEMAS' MainObjType,s.name MAINOBJNAME, s.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id  connid,proj.project_name projectname,proj.id projectid,
 NVL(conn.type,'CAPTURED') CapturedOrConverted, 
 CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name QualifiedName
 FROM MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
 WHERE s.catalog_id_fk = cat.id
 AND cat.connection_id_fk = conn.id
 AND conn.PROJECT_ID_FK = proj.id

AS
 SELECT md_projects.id project_id ,
     md_projects.project_name project_name ,
     md_connections.id connection_id ,
     md_connections.host host ,
     md_connections.port port ,
     md_connections.username username ,
     md_catalogs.id catalog_id ,
     md_catalogs.catalog_name catalog_name ,
     md_schemas.id schema_id ,
     md_schemas.name schema_name ,
     md_stored_programs.id stored_program_id ,
     md_stored_programs.programtype programtype ,
     md_stored_programs.name stored_program_name,
     md_stored_programs.package_id_fk package_id_fk
   FROM md_projects ,
     md_connections,
     md_catalogs ,
     md_schemas ,
     md_stored_programs
   WHERE md_stored_programs.schema_id_fk = md_schemas.id
   AND md_schemas.catalog_id_fk          = md_catalogs.id
   AND md_catalogs.connection_id_fk      = md_connections.id
   AND md_connections.project_id_fk      = md_projects.id

AS
 SELECT md_projects.id project_id ,
     md_projects.project_name project_name,
     md_connections.id connection_id ,
     md_connections.host host ,
     md_connections.port port ,
     md_connections.username username ,
     md_catalogs.id catalog_id ,
     md_catalogs.catalog_name catalog_name,
     md_catalogs.dummy_flag dummy_flag ,
     md_schemas.id schema_id ,
     md_schemas.name schema_name ,
     md_tables.id table_id ,
     md_tables.TABLE_NAME TABLE_NAME ,
     md_triggers.id trigger_id ,
     md_triggers.trigger_name trigger_name
   FROM md_projects ,
     md_connections,
     md_catalogs ,
     md_schemas ,
     md_tables ,
     md_triggers
   WHERE md_triggers.table_or_view_id_fk = md_tables.id
   AND md_tables.schema_id_fk            = md_schemas.id
   AND md_schemas.catalog_id_fk          = md_catalogs.id
   AND md_catalogs.connection_id_fk      = md_connections.id
   AND md_connections.project_id_fk      = md_projects.id

AS
 SELECT md_projects.id project_id ,
     md_projects.project_name project_name,
     md_connections.id connection_id ,
     md_connections.host host ,
     md_connections.port port ,
     md_connections.username username ,
     md_connections.dburl dburl ,
     md_catalogs.id catalog_id ,
     md_catalogs.catalog_name catalog_name,
     md_schemas.id schema_id ,
     md_schemas.name schema_name ,
     md_tables.id table_id ,
     md_tables.TABLE_NAME TABLE_NAME
   FROM md_connections,
     md_catalogs ,
     md_schemas ,
     md_tables ,
     md_projects
   WHERE md_tables.schema_id_fk     = md_schemas.id
   AND md_schemas.catalog_id_fk     = md_catalogs.id
   AND md_catalogs.connection_id_fk = md_connections.id
   AND md_connections.project_id_fk = md_projects.id

AS
 SELECT 'MD_TABLES' objtype, t.table_name objname, t.id objid,  'MD_TABLES' MainObjType,t.table_name MAINOBJNAME, t.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id  connid,proj.project_name projectname,proj.id projectid,
 NVL(conn.type,'CAPTURED') CapturedOrConverted, 
 CASE WHEN conn.type IS NULL THEN   ident.ldelimiter||cat.catalog_name||ident.rdelimiter||'.'||ident.ldelimiter || s.name||ident.rdelimiter||'.'||ident.ldelimiter|| t.table_name||ident.rdelimiter  ELSE s.name||'.'||t.table_name END QualifiedName
 FROM MD_TABLES t,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj,mgv_identifier_delimiter ident
 WHERE t.schema_id_fk = s.id
 AND s.catalog_id_fk = cat.id
 AND cat.connection_id_fk = conn.id
 AND conn.PROJECT_ID_FK = proj.id
 AND ident.connection_id_fk = conn.id

AS
 SELECT 'MD_TRIGGERS' objtype,trig.trigger_name objname, trig.Id objid,  'MD_TABLES' MainObjType,t.table_name MAINOBJNAME,t.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id  connid,proj.project_name projectname,proj.id projectid,
 NVL(conn.type,'CAPTURED') CapturedOrConverted, 
 CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||trig.trigger_name  QualifiedName
 FROM MD_TRIGGERS trig, MD_TABLES t,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
 WHERE trig.table_or_view_id_fk = t.id
 AND t.schema_id_fk = s.id
 AND s.catalog_id_fk = cat.id
 AND cat.connection_id_fk = conn.id
 AND conn.PROJECT_ID_FK = proj.id 
 UNION
 SELECT 'MD_TRIGGERS' objtype,trig.trigger_name objname, trig.Id objid,  'MD_VIEWS' MainObjType,v.view_name MAINOBJNAME,v.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id  connid,proj.project_name projectname,proj.id projectid,
 NVL(conn.type,'CAPTURED') CapturedOrConverted, 
 CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||trig.trigger_name  QualifiedName
 FROM MD_TRIGGERS trig, MD_VIEWS v,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
 WHERE trig.table_or_view_id_fk = v.id
 AND v.schema_id_fk = s.id
 AND s.catalog_id_fk = cat.id
 AND cat.connection_id_fk = conn.id
 AND conn.PROJECT_ID_FK = proj.id 
 ORDER BY objid

AS
 SELECT 'MD_VIEWS' objtype, v.view_name objname, v.Id objid,  'MD_VIEWS' MainObjType,v.view_name MAINOBJNAME,v.id MAINOBJID, s.name SchemaName, s.id schemaid, cat.catalog_name catalogname,cat.id catalogid, conn.name connname,conn.id  connid,proj.project_name projectname,proj.id projectid,
 NVL(conn.type,'CAPTURED') CapturedOrConverted, 
 CASE WHEN conn.type IS NULL THEN cat.catalog_name||'.' ELSE '' END || s.name||'.'||v.view_name  QualifiedName
 FROM MD_VIEWS v,MD_SCHEMAS s, MD_CATALOGS cat,MD_CONNECTIONS conn, MD_PROJECTS proj
 WHERE v.schema_id_fk = s.id
 AND s.catalog_id_fk = cat.id
 AND cat.connection_id_fk = conn.id
 AND conn.PROJECT_ID_FK = proj.id

AS
 SELECT md_projects.id project_id ,
     md_projects.project_name project_name,
     md_connections.id connection_id ,
     md_connections.host host ,
     md_connections.port port ,
     md_connections.username username ,
     md_catalogs.id catalog_id ,
     md_catalogs.catalog_name catalog_name,
     md_catalogs.dummy_flag dummy_flag ,
     md_schemas.id schema_id ,
     md_schemas.name schema_name ,
     md_views.id view_id ,
     md_views.view_name view_name ,
     md_triggers.id trigger_id ,
     md_triggers.trigger_name trigger_name
   FROM md_projects ,
     md_connections,
     md_catalogs ,
     md_schemas ,
     md_views ,
     md_triggers
   WHERE md_triggers.table_or_view_id_fk = md_views.id
   AND md_views.schema_id_fk             = md_schemas.id
   AND md_schemas.catalog_id_fk          = md_catalogs.id
   AND md_catalogs.connection_id_fk      = md_connections.id
   AND md_connections.project_id_fk      = md_projects.id

AS
 SELECT md_projects.id project_id ,
     md_projects.project_name project_name,
     md_connections.id connection_id ,
     md_connections.host host ,
     md_connections.port port ,
     username username ,
     md_catalogs.id catalog_id ,
     md_catalogs.catalog_name catalog_name,
     md_catalogs.dummy_flag dummy_flag ,
     md_schemas.id schema_id ,
     md_schemas.name schema_name ,
     md_views.id view_id ,
     md_views.view_name view_name
   FROM md_projects ,
     md_connections,
     md_catalogs ,
     md_schemas ,
     md_views
   WHERE md_views.schema_id_fk      = md_schemas.id
   AND md_schemas.catalog_id_fk     = md_catalogs.id
   AND md_catalogs.connection_id_fk = md_connections.id
   AND md_connections.project_id_fk = md_projects.id

AS
 SELECT "ID","SRC_ID","SRC_TYPE","DERIVED_ID","DERIVED_TYPE","DERIVED_CONNECTION_ID_FK","TRANSFORMED","ORIGINAL_IDENTIFIER","NEW_IDENTIFIER","DERIVED_OBJECT_NAMESPACE","DERIVATIVE_REASON","SECURITY_GROUP_ID","CREATED_ON","CREATED_BY","LAST_UPDATED_ON","LAST_UPDATED_BY" FROM MD_DERIVATIVES WHERE (Derivative_Reason <> 'SCRATCH' OR DERIVative_Reason IS NULL)

AS
 select d1.catalogid capcatalogid, d1.catalogname capcatalogname, d1.connid capconnid,
 d1.connname capconnname, d1.mainobjid capmainobjid, d1.mainobjname capmainobjname, d1.mainobjtype capmainobjtype , d1.objid capobjid,
 d1.objname capobjname, d1.objtype capobjtype, d1.projectid capprojectid, d1.projectname capprojectname, d1.qualifiedname capqualifiedname,
 d1.schemaid capschemaid, d1.schemaname capschemaname,
 d2.catalogid concatalogid, d2.catalogname concatalogname, d2.connid conconnid,
 d2.connname conconnname, d2.mainobjid conmainobjid, d2.mainobjname conmainobjname, d2.mainobjtype conmainobjtype , d2.objid conobjid,
 d2.objname conobjname, d2.objtype conobjtype, d2.projectid conprojectid, d2.projectname conprojectname, d2.qualifiedname conqualifiedname,
 d2.schemaid conschemaid, d2.schemaname conschemaname
 FROM mgv_all_details d1 LEFT OUTER JOIN md_derivatives der
 ON der.src_id = d1.objid 
 AND der.derivative_reason IS NULL LEFT OUTER JOIN mgv_all_details d2
 ON der.derived_id = d2.objid
 WHERE d1.capturedorconverted = 'CAPTURED'

AS
 SELECT CONNECTION_ID_FK,VALUE, CASE WHEN VALUE LIKE '%Sybase%' THEN '['
                               WHEN VALUE LIKE '%SQLServer%' THEN '['
                               WHEN VALUE LIKE '%MSAccess%' THEN '['
                               WHEN VALUE LIKE '%MySQL%' THEN'`'
                               WHEN VALUE LIKE '%DB2%' THEN '"'
                               WHEN VALUE LIKE '%Teradata%' THEN '"'
                               ELSE NULL END LDELIMITER,
                               CASE WHEN VALUE LIKE '%Sybase%' THEN ']'
                               WHEN VALUE LIKE '%SQLServer%' THEN ']'
                               WHEN VALUE LIKE '%MSAccess%' THEN ']'
                               WHEN VALUE LIKE '%MySQL%' THEN'`'
                               WHEN VALUE LIKE '%DB2%' THEN '"'
                               WHEN VALUE LIKE '%Teradata%' THEN '"'
                               ELSE NULL END RDELIMITER
 FROM MD_ADDITIONAL_PROPERTIES WHERE LOWER(PROP_KEY)  = 'plugin_id'

AS
 SELECT "ID","SRC_ID","SRC_TYPE","DERIVED_ID","DERIVED_TYPE","DERIVED_CONNECTION_ID_FK","TRANSFORMED","ORIGINAL_IDENTIFIER","NEW_IDENTIFIER","DERIVED_OBJECT_NAMESPACE","DERIVATIVE_REASON","SECURITY_GROUP_ID","CREATED_ON","CREATED_BY","LAST_UPDATED_ON","LAST_UPDATED_BY" FROM MD_DERIVATIVES WHERE Derivative_Reason = 'SCRATCH'