[Home] [Help]
View: PA_CI_CLASS_DESC_V
Product: | PA - Projects |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PCC.CLASS_CATEGORY
, PCC.CLASS_CODE
, PCC.DESCRIPTION
, CI.PROJECT_ID
, CI.CI_ID
FROM PA_CONTROL_ITEMS CI
, PA_CI_TYPES_VL CITYPE
, PA_CLASS_CODES PCC
WHERE CI.CI_TYPE_ID = CITYPE.CI_TYPE_ID
AND ( ( PCC.CLASS_CODE = CI.RESOLUTION_CODE
AND PCC.CLASS_CATEGORY = CITYPE.RESOLUTION_CATEGORY) OR ( PCC.CLASS_CODE = CI.CLASSIFICATION_CODE
AND PCC.CLASS_CATEGORY = CITYPE.CLASSIFICATION_CATEGORY) OR ( PCC.CLASS_CODE = CI.REASON_CODE
AND PCC.CLASS_CATEGORY = CITYPE.REASON_CATEGORY) )
Columns
Name |
CLASS_CATEGORY |
CLASS_CODE |
DESCRIPTION |
PROJECT_ID |
CI_ID |