[Home] [Help]
View: PA_CI_ACTIONS_QA_V
Product: | PA - Projects |
Description: | This view lists the action log on the Question/Answer format |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PCC.CI_ID
, PCC.CI_ACTION_ID
, DECODE(PCC.TYPE_CODE
, 'REQUESTOR'
, PA_CI_LOG_UTIL.GET_ACTION_QA(PCC.CI_ACTION_ID)
, PA_CI_LOG_UTIL.GET_COMMENT_QA(PCC.CI_COMMENT_ID)) ACTION_QA
, PCC.TYPE_CODE
, PCC.LAST_UPDATE_DATE
FROM PA_CI_COMMENTS PCC
WHERE PCC.TYPE_CODE = 'REQUESTOR' OR (PCC.TYPE_CODE = 'UNSOLICITED'
AND PCC.CI_ACTION_ID IS NULL)
Columns
Name |
CI_ID |
CI_ACTION_ID |
ACTION_QA |
TYPE_CODE |
LAST_UPDATE_DATE |