View: PA_CI_BASIC_CTL_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_CI_BASIC_CTL_V

View Text

SELECT CI.PROJECT_ID
, PPA.SEGMENT1
, PPA.NAME || '(' || PPA.SEGMENT1 || ')'
, PPA.PROJECT_STATUS_CODE
, PPA.START_DATE
, CI.CI_ID
, CI.CI_NUMBER
, CI.CI_TYPE_ID
, CI.SUMMARY
, CI.DESCRIPTION
, 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_ID
, NULL
, NULL
, PA_CONTROL_ITEMS_UTILS.GET_OBJECT_NAME(CI.PROJECT_ID
, CI.OBJECT_ID
, CI.OBJECT_TYPE))
, CI.DATE_REQUIRED
, CI.RESOLUTION_CODE_ID
, RESOLUTION.CLASS_CODE
, CI.RESOLUTION
, CI.STATUS_OVERVIEW
, CI.CLASSIFICATION_CODE_ID
, CLASSIFICATION.CLASS_CODE
, CI.REASON_CODE_ID
, REASON.CLASS_CODE
, CI.PRIORITY_CODE
, PRIORITY_LKP.MEANING
, CI.PRICE
, CI.PRICE_CURRENCY_CODE
, CURRENCY.DESCRIPTION
, CI.SOURCE_TYPE_CODE
, SOURCE_LKP.MEANING
, CI.SOURCE_COMMENT
, CI.SOURCE_NUMBER
, CI.SOURCE_DATE_RECEIVED
, CI.SOURCE_ORGANIZATION
, CI.SOURCE_PERSON
, CI.CREATION_DATE
, CI.LAST_UPDATE_DATE
, CI.CREATED_BY
, PA_CONTROL_ITEMS_UTILS.GETUSERNAME(CI.CREATED_BY)
, CI.LAST_UPDATED_BY
, PA_CONTROL_ITEMS_UTILS.GETUSERNAME(CI.LAST_UPDATED_BY)
, CITYPE.CI_TYPE_CLASS_CODE
, CITYPE.NAME
, CITYPE.SHORT_NAME
, CITYPE.APPROVAL_REQUIRED_FLAG
, CITYPE.AUTO_NUMBER_FLAG
, CITYPE.RESOLUTION_REQUIRED_FLAG
, CITYPE.SOURCE_ATTRS_ENABLED_FLAG
, CI.HIGHLIGHTED_FLAG
, CI.DATE_CLOSED
, CI.CLOSED_BY_ID
, CLOSED_BY.PARTY_NAME
, CI.RECORD_VERSION_NUMBER
, CI.OPEN_ACTION_NUM
, CI.EFFORT_LEVEL_CODE
, EFFORT_LKP.MEANING
, CI.LAST_MODIFICATION_DATE
, CI.LAST_MODIFIED_BY_ID
, MODIFIED_BY.PARTY_NAME
, PPS.PROJECT_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPS.STATUS_ICON_IND
, PPS.STATUS_ICON_ACTIVE_IND
, CI.PROGRESS_AS_OF_DATE
, PA_CONTROL_ITEMS_UTILS.CLOSEALLOWED(CI.CI_ID
, CI.OWNER_ID
, CI.CREATED_BY
, STATUS.PROJECT_SYSTEM_STATUS_CODE)
, PA_CONTROL_ITEMS_UTILS.DELETEALLOWED(CI.CI_ID
, CI.OWNER_ID
, CI.CREATED_BY
, STATUS.PROJECT_SYSTEM_STATUS_CODE)
, PA_CONTROL_ITEMS_UTILS.SUBMITALLOWED(CI.CI_ID
, CI.OWNER_ID
, CI.CREATED_BY
, STATUS.PROJECT_SYSTEM_STATUS_CODE)
, CI.ATTRIBUTE_CATEGORY
, CI.ATTRIBUTE1
, CI.ATTRIBUTE2
, CI.ATTRIBUTE3
, CI.ATTRIBUTE4
, CI.ATTRIBUTE5
, CI.ATTRIBUTE6
, CI.ATTRIBUTE7
, CI.ATTRIBUTE8
, CI.ATTRIBUTE9
, CI.ATTRIBUTE10
, CI.ATTRIBUTE11
, CI.ATTRIBUTE12
, CI.ATTRIBUTE13
, CI.ATTRIBUTE14
, CI.ATTRIBUTE15
, CI.ROWID
, NULL PCO_NUMBER
, CI.VERSION_COMMENTS
, CI.PCO_STATUS_CODE
, PCO_LKP.MEANING PCO_STATUS
, CITYPE.APPROVAL_TYPE_CODE
, APPROVAL_LKP.MEANING APPROVAL_TYPE
, NVL(CI.LOCKED_FLAG
, 'N') LOCKED_FLAG
, LOCKED_LKP.MEANING CHANGE_DOC_STATUS
, CITYPE.IMPACT_BUDGET_TYPE_CODE
, CI.CHANGE_APPROVER
, CI.ORIGINAL_CI_ID
, CI.VERSION_NUMBER
FROM PA_CONTROL_ITEMS CI
, PA_CI_TYPES_VL CITYPE
, PA_PROJECTS_ALL PPA
, PA_PROJECT_STATUSES STATUS
, HZ_PARTIES OWNER
, HZ_PARTIES CLOSED_BY
, HZ_PARTIES MODIFIED_BY
, PA_LOOKUPS PRIORITY_LKP
, PA_LOOKUPS SOURCE_LKP
, PA_LOOKUPS EFFORT_LKP
, FND_CURRENCIES_TL CURRENCY
, PA_CLASS_CODES RESOLUTION
, PA_CLASS_CODES REASON
, PA_CLASS_CODES CLASSIFICATION
, PA_PROJECT_STATUSES PPS
, PA_LOOKUPS PCO_LKP
, PA_LOOKUPS APPROVAL_LKP
, PA_LOOKUPS LOCKED_LKP
WHERE CI.CI_TYPE_ID = CITYPE.CI_TYPE_ID
AND PPA.PROJECT_ID = CI.PROJECT_ID
AND STATUS.PROJECT_STATUS_CODE(+) = CI.STATUS_CODE
AND OWNER.PARTY_ID(+) = CI.OWNER_ID
AND CLOSED_BY.PARTY_ID(+) = CI.CLOSED_BY_ID
AND MODIFIED_BY.PARTY_ID(+) = CI.LAST_MODIFIED_BY_ID
AND PRIORITY_LKP.LOOKUP_TYPE(+) = 'PA_TASK_PRIORITY_CODE'
AND PRIORITY_LKP.LOOKUP_CODE(+) = CI.PRIORITY_CODE
AND CURRENCY.CURRENCY_CODE(+) = CI.PRICE_CURRENCY_CODE
AND CURRENCY.LANGUAGE(+) = USERENV('LANG')
AND SOURCE_LKP.LOOKUP_TYPE(+) = 'PA_CI_SOURCE_TYPES'
AND SOURCE_LKP.LOOKUP_CODE(+) = CI.SOURCE_TYPE_CODE
AND EFFORT_LKP.LOOKUP_TYPE(+) = 'PA_CI_EFFORT_LEVELS'
AND EFFORT_LKP.LOOKUP_CODE(+) = CI.EFFORT_LEVEL_CODE
AND PPS.PROJECT_STATUS_CODE(+) = CI.PROGRESS_STATUS_CODE
AND RESOLUTION.CLASS_CODE_ID(+) = CI.RESOLUTION_CODE_ID
AND REASON.CLASS_CODE_ID(+) = CI.REASON_CODE_ID
AND CLASSIFICATION.CLASS_CODE_ID(+) = CI.CLASSIFICATION_CODE_ID
AND PCO_LKP.LOOKUP_TYPE(+) = 'PA_CI_PCO_STATUSES'
AND PCO_LKP.LOOKUP_CODE(+) = CI.PCO_STATUS_CODE
AND APPROVAL_LKP.LOOKUP_TYPE(+) = 'PA_CI_APPROVAL_TYPES'
AND APPROVAL_LKP.LOOKUP_CODE(+) = CITYPE.APPROVAL_TYPE_CODE
AND LOCKED_LKP.LOOKUP_TYPE(+) = 'PA_CI_LOCKED_STATUSES'
AND LOCKED_LKP.LOOKUP_CODE(+) = DECODE(CI.LOCKED_FLAG
, 'Y'
, 'LOCKED'
, 'N'
, 'UNLOCKED'
, 'UNLOCKED')

Columns