VIEW: APPS.PA_CONTROL_ITEMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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