DBA Data[Home] [Help]

VIEW: APPS.QAFV_COLELMACTN

Source

View Text - Preformatted

SELECT QCA.CHAR_ACTION_ID ELEMENT_ACTION_ID , QCA.MESSAGE , QCA.STATUS_CODE , QCA.CHAR_ACTION_TRIGGER_ID ELEMENT_ACTION_TRIGGER_ID , QCA.ACTION_ID , QUALITY_ACTION_TYPE.DESCRIPTION ACTION_DESCRIPTION , QCA.LAST_UPDATE_DATE , QCA.LAST_UPDATED_BY , QCA.CREATION_DATE , QCA.CREATED_BY FROM QA_CHAR_ACTIONS QCA, QA_ACTIONS QUALITY_ACTION_TYPE WHERE QCA.ACTION_ID = QUALITY_ACTION_TYPE.ACTION_ID WITH READ ONLY
View Text - HTML Formatted

SELECT QCA.CHAR_ACTION_ID ELEMENT_ACTION_ID
, QCA.MESSAGE
, QCA.STATUS_CODE
, QCA.CHAR_ACTION_TRIGGER_ID ELEMENT_ACTION_TRIGGER_ID
, QCA.ACTION_ID
, QUALITY_ACTION_TYPE.DESCRIPTION ACTION_DESCRIPTION
, QCA.LAST_UPDATE_DATE
, QCA.LAST_UPDATED_BY
, QCA.CREATION_DATE
, QCA.CREATED_BY
FROM QA_CHAR_ACTIONS QCA
, QA_ACTIONS QUALITY_ACTION_TYPE
WHERE QCA.ACTION_ID = QUALITY_ACTION_TYPE.ACTION_ID WITH READ ONLY