DBA Data[Home] [Help]

VIEW: APPS.QA_CHAR_ACTION_OUTPUTS_V

Source

View Text - Preformatted

SELECT QCAO.ROWID ROW_ID , QCAO.CHAR_ACTION_ID , QCAO.TOKEN_NAME , QCAO.LAST_UPDATE_DATE , QCAO.LAST_UPDATED_BY , QCAO.CREATION_DATE , QCAO.CREATED_BY , QCAO.LAST_UPDATE_LOGIN , QA.ACTION_ID , QA.DESCRIPTION ACTION_DESCRIPTION , QCA.CHAR_ACTION_TRIGGER_ID , QC.CHAR_ID , QC.NAME CHAR_NAME FROM QA_ACTIONS QA,QA_CHARS QC,QA_CHAR_ACTIONS QCA,QA_CHAR_ACTION_OUTPUTS QCAO WHERE QCA.CHAR_ACTION_ID = QCAO.CHAR_ACTION_ID AND QCA.ACTION_ID = QA.ACTION_ID AND QC.CHAR_ID = QCAO.CHAR_ID
View Text - HTML Formatted

SELECT QCAO.ROWID ROW_ID
, QCAO.CHAR_ACTION_ID
, QCAO.TOKEN_NAME
, QCAO.LAST_UPDATE_DATE
, QCAO.LAST_UPDATED_BY
, QCAO.CREATION_DATE
, QCAO.CREATED_BY
, QCAO.LAST_UPDATE_LOGIN
, QA.ACTION_ID
, QA.DESCRIPTION ACTION_DESCRIPTION
, QCA.CHAR_ACTION_TRIGGER_ID
, QC.CHAR_ID
, QC.NAME CHAR_NAME
FROM QA_ACTIONS QA
, QA_CHARS QC
, QA_CHAR_ACTIONS QCA
, QA_CHAR_ACTION_OUTPUTS QCAO
WHERE QCA.CHAR_ACTION_ID = QCAO.CHAR_ACTION_ID
AND QCA.ACTION_ID = QA.ACTION_ID
AND QC.CHAR_ID = QCAO.CHAR_ID