VIEW: APPS.PA_CI_IMPACTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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