DBA Data[Home] [Help]

VIEW: APPS.QABV_QUALITY_ACTION_TYPES

Source

View Text - Preformatted

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
View Text - HTML Formatted

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