[Home] [Help]
View: QABV_QUALITY_ACTION_TYPES
View Text
SELECT QUALITY_ACTION_TYPE.ACTION_ID
, QUALITY_ACTION_TYPE.DESCRIPTION ACTION_DESCRIPTION
, MF.MEANING ENABLED_FLAG
, QUALITY_ACTION_TYPE.LAST_UPDATE_DATE
, QUALITY_ACTION_TYPE.LAST_UPDATED_BY
, QUALITY_ACTION_TYPE.CREATION_DATE
, QUALITY_ACTION_TYPE.CREATED_BY
FROM QA_ACTIONS QUALITY_ACTION_TYPE
, MFG_LOOKUPS MF
WHERE MF.LOOKUP_TYPE = 'SYS_YES_NO'
AND MF.LOOKUP_CODE = QUALITY_ACTION_TYPE.ENABLED_FLAG WITH READ ONLY
Columns
Name |
ACTION_ID |
ACTION_DESCRIPTION |
ENABLED_FLAG |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |