View: QA_CHAR_ACTIONS_V

Product:	QA - Quality
Description:	shows collection elements and actions
Implementation/DBA Data:	APPS.QA_CHAR_ACTIONS_V

View Text

SELECT QCA.ROWID ROW_ID
, QCA.CHAR_ACTION_ID
, QCA.LAST_UPDATE_DATE
, QCA.LAST_UPDATED_BY
, QCA.CREATION_DATE
, QCA.CREATED_BY
, QCA.LAST_UPDATE_LOGIN
, QCA.CHAR_ACTION_TRIGGER_ID
, QCA.ACTION_ID
, QA.DESCRIPTION ACTION_DESCRIPTION
, QCAT.TRIGGER_SEQUENCE
, QCA.CAR_NAME_PREFIX
, QCA.CAR_TYPE_ID
, NULL CAR_TYPE_NAME
, QCA.CAR_OWNER
, NULL CAR_OWNER_NAME
, QCA.MESSAGE
, QCA.STATUS_CODE
, QCA.STATUS_ID
, QC.CHAR_ID
, QC.NAME CHAR_NAME
, QCA.ALR_ACTION_SET_ID
, QCA.ALR_ACTION_ID
FROM QA_CHAR_ACTION_TRIGGERS QCAT
, QA_ACTIONS QA
, QA_CHARS QC
, QA_CHAR_ACTIONS QCA
WHERE QCA.CHAR_ACTION_TRIGGER_ID = QCAT.CHAR_ACTION_TRIGGER_ID
AND QCA.ACTION_ID = QA.ACTION_ID
AND QCAT.CHAR_ID = QC.CHAR_ID

Columns