VIEW: APPS.QA_CHAR_ACTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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