ENQ_QUALITY_TYPES

Details

Schema: FUSION
Object owner: ENQ
Object type: VIEW

Columns

Name
QUALITY_TYPE_ID PARENT_QUALITY_TYPE_ID OBJECT_TYPE IS_ACTIVE INSTANTIATION_ALLOWED SOURCE CODE IS_SEEDED DISPLAY_ORDER NUMBER_GENERATION_METHOD OBJECT_VERSION_NUMBER DEFAULT_ASSIGNEE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN NAME LABEL DESCRIPTION

Name

QUALITY_TYPE_ID

PARENT_QUALITY_TYPE_ID

OBJECT_TYPE

IS_ACTIVE

INSTANTIATION_ALLOWED

SOURCE

CODE

IS_SEEDED

DISPLAY_ORDER

NUMBER_GENERATION_METHOD

OBJECT_VERSION_NUMBER

DEFAULT_ASSIGNEE_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

NAME

LABEL

DESCRIPTION

Query

SQL_Statement
SELECT ENQ_QUALITY_TYPES_B.QUALITY_TYPE_ID QUALITY_TYPE_ID, ENQ_QUALITY_TYPES_B.PARENT_QUALITY_TYPE_ID PARENT_QUALITY_TYPE_ID, ENQ_QUALITY_TYPES_B.OBJECT_TYPE OBJECT_TYPE, ENQ_QUALITY_TYPES_B.IS_ACTIVE IS_ACTIVE, ENQ_QUALITY_TYPES_B.INSTANTIATION_ALLOWED INSTANTIATION_ALLOWED, ENQ_QUALITY_TYPES_B.SOURCE SOURCE, ENQ_QUALITY_TYPES_B.CODE CODE, ENQ_QUALITY_TYPES_B.IS_SEEDED IS_SEEDED, ENQ_QUALITY_TYPES_B.DISPLAY_ORDER DISPLAY_ORDER, ENQ_QUALITY_TYPES_B.NUMBER_GENERATION_METHOD NUMBER_GENERATION_METHOD, ENQ_QUALITY_TYPES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ENQ_QUALITY_TYPES_B.DEFAULT_ASSIGNEE_ID DEFAULT_ASSIGNEE_ID, ENQ_QUALITY_TYPES_B.CREATED_BY CREATED_BY, ENQ_QUALITY_TYPES_B.CREATION_DATE CREATION_DATE, ENQ_QUALITY_TYPES_B.LAST_UPDATED_BY LAST_UPDATED_BY, ENQ_QUALITY_TYPES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ENQ_QUALITY_TYPES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ENQ_QUALITY_TYPES_TL.NAME NAME, ENQ_QUALITY_TYPES_TL.LABEL LABEL, ENQ_QUALITY_TYPES_TL.DESCRIPTION DESCRIPTION FROM ENQ_QUALITY_TYPES_B, ENQ_QUALITY_TYPES_TL WHERE ENQ_QUALITY_TYPES_B.QUALITY_TYPE_ID = ENQ_QUALITY_TYPES_TL.QUALITY_TYPE_ID AND ENQ_QUALITY_TYPES_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

ENQ_QUALITY_TYPES_B.QUALITY_TYPE_ID QUALITY_TYPE_ID,

ENQ_QUALITY_TYPES_B.PARENT_QUALITY_TYPE_ID PARENT_QUALITY_TYPE_ID,

ENQ_QUALITY_TYPES_B.OBJECT_TYPE OBJECT_TYPE,

ENQ_QUALITY_TYPES_B.IS_ACTIVE IS_ACTIVE,

ENQ_QUALITY_TYPES_B.INSTANTIATION_ALLOWED INSTANTIATION_ALLOWED,

ENQ_QUALITY_TYPES_B.SOURCE SOURCE,

ENQ_QUALITY_TYPES_B.CODE CODE,

ENQ_QUALITY_TYPES_B.IS_SEEDED IS_SEEDED,

ENQ_QUALITY_TYPES_B.DISPLAY_ORDER DISPLAY_ORDER,

ENQ_QUALITY_TYPES_B.NUMBER_GENERATION_METHOD NUMBER_GENERATION_METHOD,

ENQ_QUALITY_TYPES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

ENQ_QUALITY_TYPES_B.DEFAULT_ASSIGNEE_ID DEFAULT_ASSIGNEE_ID,

ENQ_QUALITY_TYPES_B.CREATED_BY CREATED_BY,

ENQ_QUALITY_TYPES_B.CREATION_DATE CREATION_DATE,

ENQ_QUALITY_TYPES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

ENQ_QUALITY_TYPES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

ENQ_QUALITY_TYPES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

ENQ_QUALITY_TYPES_TL.NAME NAME,

ENQ_QUALITY_TYPES_TL.LABEL LABEL,

ENQ_QUALITY_TYPES_TL.DESCRIPTION DESCRIPTION

FROM

ENQ_QUALITY_TYPES_B,

ENQ_QUALITY_TYPES_TL

WHERE

ENQ_QUALITY_TYPES_B.QUALITY_TYPE_ID = ENQ_QUALITY_TYPES_TL.QUALITY_TYPE_ID AND ENQ_QUALITY_TYPES_TL.LANGUAGE = USERENV('LANG')