View: PA_RELATED_ITEMS_V

Product:	PA - Projects
Description:	This view provides all the control items which can be included.
Implementation/DBA Data:	APPS.PA_RELATED_ITEMS_V

View Text

SELECT CI.PROJECT_ID
, PPA.NAME || '(' || PPA.SEGMENT1 || ')'
, CI.CI_ID
, CI.CI_NUMBER
, CITYPEB.CI_TYPE_ID
, CI.SUMMARY
, CI.STATUS_CODE
, STATUS.PROJECT_STATUS_NAME
, STATUS.PROJECT_SYSTEM_STATUS_CODE
, CI.OWNER_ID
, OWNER.PARTY_NAME
, CI.OBJECT_TYPE
, CI.OBJECT_ID
, DECODE(CI.OBJECT_TYPE
, NULL
, NULL
, PA_PROJ_ELEMENTS_UTILS.GET_ELEMENT_NAME(CI.OBJECT_ID))
, CLASSIFICATION.CLASS_CODE
, REASON.CLASS_CODE
, CITYPEB.CI_TYPE_CLASS_CODE
, CITYPETL.NAME
, CITYPETL.SHORT_NAME
, CITYPETL.SHORT_NAME || '(' || CI.CI_NUMBER || ')'
, CI.RECORD_VERSION_NUMBER
FROM PA_CI_TYPES_B CITYPEB
, PA_CI_TYPES_TL CITYPETL
, PA_CONTROL_ITEMS CI
, PA_PROJECTS_ALL PPA
, PA_PROJECT_STATUSES STATUS
, HZ_PARTIES OWNER
, PA_CLASS_CODES REASON
, PA_CLASS_CODES CLASSIFICATION
WHERE CI.CI_TYPE_ID = CITYPEB.CI_TYPE_ID
AND PA_CI_SECURITY_PKG.CHECK_VIEW_ACCESS(CI_ID) = 'T'
AND CITYPETL.CI_TYPE_ID = CITYPEB.CI_TYPE_ID
AND CITYPETL.LANGUAGE = USERENV('LANG')
AND PPA.PROJECT_ID = CI.PROJECT_ID
AND STATUS.PROJECT_STATUS_CODE = CI.STATUS_CODE
AND STATUS.STATUS_TYPE = 'CONTROL_ITEM'
AND OWNER.PARTY_ID = CI.OWNER_ID
AND REASON.CLASS_CODE_ID(+) = CI.REASON_CODE_ID
AND CLASSIFICATION.CLASS_CODE_ID(+) = CI.CLASSIFICATION_CODE_ID

Columns