[Home] [Help]
View: QAFV_COLELMACTN
View Text
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
Columns
Name |
ELEMENT_ACTION_ID |
MESSAGE |
STATUS_CODE |
ELEMENT_ACTION_TRIGGER_ID |
ACTION_ID |
ACTION_DESCRIPTION |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |