[Home] [Help]
View: QA_PLAN_CHAR_ACTION_OUTPUTS_V
View Text
SELECT QPCAO.ROWID ROW_ID
, QPCAO.PLAN_CHAR_ACTION_ID
, QPCAO.TOKEN_NAME
, QPCAO.LAST_UPDATE_DATE
, QPCAO.LAST_UPDATED_BY
, QPCAO.CREATION_DATE
, QPCAO.CREATED_BY
, QPCAO.LAST_UPDATE_LOGIN
, QPCA.ACTION_ID
, QA.DESCRIPTION ACTION_DESCRIPTION
, QPCA.PLAN_CHAR_ACTION_TRIGGER_ID
, QPCAO.CHAR_ID
, QC.NAME CHAR_NAME
FROM QA_ACTIONS QA
, QA_CHARS QC
, QA_PLAN_CHAR_ACTIONS QPCA
, QA_PLAN_CHAR_ACTION_OUTPUTS QPCAO
WHERE QPCA.PLAN_CHAR_ACTION_ID = QPCAO.PLAN_CHAR_ACTION_ID
AND QPCA.ACTION_ID = QA.ACTION_ID
AND QC.CHAR_ID = QPCAO.CHAR_ID
Columns
Name |
ROW_ID |
PLAN_CHAR_ACTION_ID |
TOKEN_NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
ACTION_ID |
ACTION_DESCRIPTION |
PLAN_CHAR_ACTION_TRIGGER_ID |
CHAR_ID |
CHAR_NAME |