[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 |