Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_CI_IMPACTS_V |
SELECT PCI.CI_IMPACT_ID
, PCI.CI_ID
, PCI.IMPACT_TYPE_CODE
, PCI.STATUS_CODE
, PCI.DESCRIPTION
, PCI.IMPLEMENTATION_DATE
, PCI.IMPLEMENTED_BY
, PCI.IMPLEMENTATION_COMMENT
, PCI.RECORD_VERSION_NUMBER
, PCI.CREATION_DATE
, PCI.CREATED_BY
, PCI.LAST_UPDATE_DATE
, PCI.LAST_UPDATED_BY
, PCI.LAST_UPDATE_LOGIN
, PL.MEANING IMPACT_TYPE_MEANING
, P2.PROJECT_STATUS_NAME STATUS
, PT.TASK_ID
, PT.TASK_NAME
FROM PA_CI_IMPACTS PCI
, PA_LOOKUPS PL
, PA_PROJECT_STATUSES P2
, PA_TASKS PT
, PA_CONTROL_ITEMS PC
WHERE PCI.IMPACT_TYPE_CODE = PL.LOOKUP_CODE
AND PL.LOOKUP_TYPE = 'PA_CI_IMPACT_TYPES'
AND PCI.STATUS_CODE = P2.PROJECT_STATUS_CODE
AND P2.STATUS_TYPE = 'CI_IMPACT'
AND PC.CI_ID = PCI.CI_ID
AND PT.TASK_ID (+)= PCI.IMPACTED_TASK_ID