View: PA_CONTROL_ITEMS_V

Product:	PA - Projects
Description:	This view provides the atrribute values for Control Items.
Implementation/DBA Data:	APPS.PA_CONTROL_ITEMS_V

View Text

SELECT CI_ID
, CI_TYPE_ID
, SUMMARY
, STATUS_CODE
, OWNER_ID
, HIGHLIGHTED_FLAG
, PROGRESS_STATUS_CODE
, PROGRESS_AS_OF_DATE
, CLASSIFICATION_CODE_ID
, REASON_CODE_ID
, RECORD_VERSION_NUMBER
, PROJECT_ID
, LAST_MODIFICATION_DATE
, LAST_MODIFIED_BY_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_TYPE
, OBJECT_ID
, CI_NUMBER
, DATE_REQUIRED
, DATE_CLOSED
, CLOSED_BY_ID
, DESCRIPTION
, STATUS_OVERVIEW
, RESOLUTION
, RESOLUTION_CODE_ID
, PRIORITY_CODE
, EFFORT_LEVEL_CODE
, OPEN_ACTION_NUM
, PRICE
, PRICE_CURRENCY_CODE
, SOURCE_TYPE_CODE
, SOURCE_COMMENT
, SOURCE_NUMBER
, SOURCE_DATE_RECEIVED
, SOURCE_ORGANIZATION
, SOURCE_PERSON
, LAST_ACTION_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM PA_CONTROL_ITEMS

Columns