VIEW: PA.PA_CONTROL_ITEMS#

Source

View Text - Preformatted

select CI_ID CI_ID, CI_TYPE_ID CI_TYPE_ID, SUMMARY SUMMARY, STATUS_CODE STATUS_CODE, OWNER_ID OWNER_ID, HIGHLIGHTED_FLAG HIGHLIGHTED_FLAG, PROGRESS_STATUS_CODE PROGRESS_STATUS_CODE, PROGRESS_AS_OF_DATE PROGRESS_AS_OF_DATE, CLASSIFICATION_CODE_ID CLASSIFICATION_CODE_ID, REASON_CODE_ID REASON_CODE_ID, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, PROJECT_ID PROJECT_ID, LAST_MODIFICATION_DATE LAST_MODIFICATION_DATE, LAST_MODIFIED_BY_ID LAST_MODIFIED_BY_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, CI_NUMBER CI_NUMBER, DATE_REQUIRED DATE_REQUIRED, DATE_CLOSED DATE_CLOSED, CLOSED_BY_ID CLOSED_BY_ID, DESCRIPTION DESCRIPTION, STATUS_OVERVIEW STATUS_OVERVIEW, RESOLUTION RESOLUTION, RESOLUTION_CODE_ID RESOLUTION_CODE_ID, PRIORITY_CODE PRIORITY_CODE, EFFORT_LEVEL_CODE EFFORT_LEVEL_CODE, OPEN_ACTION_NUM OPEN_ACTION_NUM, PRICE PRICE, PRICE_CURRENCY_CODE PRICE_CURRENCY_CODE, SOURCE_TYPE_CODE SOURCE_TYPE_CODE, SOURCE_COMMENT SOURCE_COMMENT, SOURCE_NUMBER SOURCE_NUMBER, SOURCE_DATE_RECEIVED SOURCE_DATE_RECEIVED, SOURCE_ORGANIZATION SOURCE_ORGANIZATION, SOURCE_PERSON SOURCE_PERSON, LAST_ACTION_NUMBER LAST_ACTION_NUMBER, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ORIG_SYSTEM_CODE ORIG_SYSTEM_CODE, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, APPROVAL_TYPE_CODE APPROVAL_TYPE_CODE, PCO_STATUS_CODE PCO_STATUS_CODE, LOCKED_FLAG LOCKED_FLAG, PCO_SEQUENCE PCO_SEQUENCE, VERSION_NUMBER VERSION_NUMBER, CURRENT_VERSION_FLAG CURRENT_VERSION_FLAG, ORIGINAL_CI_ID ORIGINAL_CI_ID, SOURCE_CI_ID SOURCE_CI_ID, VERSION_COMMENTS VERSION_COMMENTS, CHANGE_APPROVER CHANGE_APPROVER from "PA"."PA_CONTROL_ITEMS"

View Text - HTML Formatted

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