ENQ_QUALITY_TYPES_SUBTYPES_V

Details

• Schema: FUSION

• Object owner: ENQ

• Object type: VIEW

Columns

Name

QUALITY_TYPE_ID OBJECT_VERSION_NUMBER OBJECT_TYPE CODE DISPLAY_ORDER INSTANTIATION_ALLOWED NUMBER_GENERATION_METHOD CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE IS_SEEDED NAME DESCRIPTION LANGUAGE LABEL SEED_DATA_SOURCE PARENT_QUALITY_TYPE_ID1 PARENT_QUALITY_TYPE_ID2 PARENT_QUALITY_TYPE_ID3 PARENT_QUALITY_TYPE_ID4 PARENT_QUALITY_TYPE_ID5 PARENT_QUALITY_TYPE_ID6 PARENT_QUALITY_TYPE_ID7 PARENT_QUALITY_TYPE_ID8 PARENT_QUALITY_TYPE_ID9 PARENT_QUALITY_TYPE_ID10 PARENT_QUALITY_TYPE_ID11 PARENT_QUALITY_TYPE_ID12 PARENT_QUALITY_TYPE_ID13 PARENT_QUALITY_TYPE_ID14 PARENT_QUALITY_TYPE_ID15

Query

SQL_Statement

SELECT eqtb.quality_type_id, eqtb.object_version_number, eqtb.OBJECT_TYPE, eqtb.code, eqtb.display_order, eqtb.instantiation_allowed, eqtb.number_generation_method, eqtb.created_by, eqtb.creation_date, eqtb.last_updated_by, eqtb.last_update_date, eqtb.is_seeded, qttl.NAME, qttl.description, qttl.language, qttl.label, qttl.seed_data_source, type_hier.PARENT_QUALITY_TYPE_id1, type_hier.PARENT_QUALITY_TYPE_id2, type_hier.PARENT_QUALITY_TYPE_id3, type_hier.PARENT_QUALITY_TYPE_id4, type_hier.PARENT_QUALITY_TYPE_id5, type_hier.PARENT_QUALITY_TYPE_id6, type_hier.PARENT_QUALITY_TYPE_id7, type_hier.PARENT_QUALITY_TYPE_id8, type_hier.PARENT_QUALITY_TYPE_id9, type_hier.PARENT_QUALITY_TYPE_id10, type_hier.PARENT_QUALITY_TYPE_id11, type_hier.PARENT_QUALITY_TYPE_id12, type_hier.PARENT_QUALITY_TYPE_id13, type_hier.PARENT_QUALITY_TYPE_id14, type_hier.PARENT_QUALITY_TYPE_id15 FROM ENQ_QUALITY_TYPES_B eqtb,ENQ_QUALITY_TYPES_TL qttl, (SELECT qt.QUALITY_TYPE_ID, qt.INSTANTIATION_ALLOWED, LEVEL, Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/') path, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,1)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,2) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,1)-1 ) PARENT_QUALITY_TYPE_ID1, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,2)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,3) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,2)-1 ) PARENT_QUALITY_TYPE_ID2, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,3)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,4) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,3)-1 ) PARENT_QUALITY_TYPE_ID3, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,4)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,5) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,4)-1 ) PARENT_QUALITY_TYPE_ID4, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,5)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,6) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,5)-1 ) PARENT_QUALITY_TYPE_ID5, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,6)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,7) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,6)-1 ) PARENT_QUALITY_TYPE_ID6, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,7)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,8) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,7)-1 ) PARENT_QUALITY_TYPE_ID7, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,8)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,9) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,8)-1 ) PARENT_QUALITY_TYPE_ID8, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,9)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,10) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,9)-1 ) PARENT_QUALITY_TYPE_ID9, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,10)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,11) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,10)-1 ) PARENT_QUALITY_TYPE_ID10, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,11)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,12) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,11)-1 ) PARENT_QUALITY_TYPE_ID11, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,12)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,13) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,12)-1 ) PARENT_QUALITY_TYPE_ID12, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,13)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,14) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,13)-1 ) PARENT_QUALITY_TYPE_ID13, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,14)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,15) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,14)-1 ) PARENT_QUALITY_TYPE_ID14, SubStr( Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'), InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,15)+1, InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,16) - InStr(Sys_connect_by_path(qt.QUALITY_TYPE_ID, '/'),'/',1,15)-1 ) PARENT_QUALITY_TYPE_ID15 FROM ENQ_QUALITY_TYPES_B qt CONNECT BY PRIOR qt.QUALITY_TYPE_ID = qt.PARENT_QUALITY_TYPE_ID START WITH nvl(qt.PARENT_QUALITY_TYPE_ID, -1) = -1) type_hier WHERE type_hier.QUALITY_TYPE_ID = eqtb.QUALITY_TYPE_ID AND type_hier.QUALITY_TYPE_ID=qttl.QUALITY_TYPE_ID AND qttl.language=USERENV('LANG')