eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PA.PA_CONTROL_ITEMS

Object Details

Object Name:	PA_CONTROL_ITEMS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_CONTROL_ITEMS
Subobject Name:
Status:	VALID

PA_CONTROL_ITEMS stores user-defined control items in a project. Each item belongs to an item type as specified by the CI_TYPE_ID column. The items are categorized using the Classification, Reason and Priority attributes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_CONTROL_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CI_ID
PA_CONTROL_ITEMS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORIGINAL_CI_ID VERSION_NUMBER
PA_CONTROL_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID OBJECT_TYPE OBJECT_ID
PA_CONTROL_ITEMS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CI_TYPE_ID PROJECT_ID OBJECT_TYPE OBJECT_ID CI_NUMBER
PA_CONTROL_ITEMS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_ID CI_TYPE_ID STATUS_CODE
PA_CONTROL_ITEMS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_MODIFIED_BY_ID
PA_CONTROL_ITEMS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLOSED_BY_ID
PA_CONTROL_ITEMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CI_TYPE_ID PROJECT_ID OBJECT_TYPE OBJECT_ID SUMMARY
PA_CONTROL_ITEMS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE CI_TYPE_ID
PA_CONTROL_ITEMS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLASSIFICATION_CODE_ID CI_TYPE_ID
PA_CONTROL_ITEMS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REASON_CODE_ID CI_TYPE_ID
PA_CONTROL_ITEMS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRIORITY_CODE CI_TYPE_ID
PA_CONTROL_ITEMS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOLUTION_CODE_ID CI_TYPE_ID
PA_CONTROL_ITEMS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUMMARY CI_TYPE_ID
PA_CONTROL_ITEMS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EFFORT_LEVEL_CODE CI_TYPE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CI_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the control item, shown on the user-interface as System Number
CI_TYPE_ID	NUMBER	(15)	Yes	The identifier of the control item type to which the item belongs
SUMMARY	VARCHAR2	(240)	Yes	User-defined short summary of the control item
STATUS_CODE	VARCHAR2	(100)	Yes	The user status code for the control item
OWNER_ID	NUMBER	(15)	Yes	The identifier of the owner of the control item
HIGHLIGHTED_FLAG	VARCHAR2	(1)	Yes	Indicator that the control item is included in the project status report
PROGRESS_STATUS_CODE	VARCHAR2	(100)	Yes	The user stautus code for the progress of the control item
PROGRESS_AS_OF_DATE	DATE		Yes	The as of date of the progress status
CLASSIFICATION_CODE_ID	NUMBER	(15)		The category code identifier indicates the classification of the control item
REASON_CODE_ID	NUMBER	(15)		The category code identifier indicates the reason of the control item
RECORD_VERSION_NUMBER	NUMBER	(15)	Yes	Number used for record locking in self service applications
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project for which the control item is created
LAST_MODIFICATION_DATE	DATE		Yes	The date when the control item or its impacts were last modified
LAST_MODIFIED_BY_ID	NUMBER	(15)	Yes	The identifier of the person who last modified the control item
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_TYPE	VARCHAR2	(100)		Code indicating the object type for which the control item is created
OBJECT_ID	NUMBER	(15)		The identifier of the object for which the control item is created. For example: object_type=PA_TASKS and object_id is project_element_id
CI_NUMBER	VARCHAR2	(100)		A number that uniquely identifies the control item of a given type within a project. It can be user-defined or system-generated, depending on an option set up on the control item type level
DATE_REQUIRED	DATE			The date on which the control item is required
DATE_CLOSED	DATE			The date on which the control item was closed
CLOSED_BY_ID	NUMBER	(15)		The identifier of the person who closed control item
DESCRIPTION	VARCHAR2	(2000)		User-defined description of the control item
STATUS_OVERVIEW	VARCHAR2	(4000)		The overview for the status of the control item
RESOLUTION	VARCHAR2	(4000)		The resolution for the control item
RESOLUTION_CODE_ID	NUMBER	(15)		The category code identifier indicates the type of the resolution
PRIORITY_CODE	VARCHAR2	(30)		Lookup code indicating the priority of the control item. This is the same set of lookup codes as used for task priority
EFFORT_LEVEL_CODE	VARCHAR2	(30)		The lookup code indicating the level of effort of the control item
OPEN_ACTION_NUM	NUMBER	(15)		The number of open actions on the control item
PRICE	NUMBER			The price of the control item
PRICE_CURRENCY_CODE	VARCHAR2	(15)		The currency code for the price
SOURCE_TYPE_CODE	VARCHAR2	(30)		Lookup code indicating the type of the source of the control item
SOURCE_COMMENT	VARCHAR2	(2000)		A comment on the source of the control item
SOURCE_NUMBER	VARCHAR2	(100)		User-defined number to identify the source of the control item
SOURCE_DATE_RECEIVED	DATE			The date on which the source was received
SOURCE_ORGANIZATION	VARCHAR2	(150)		The name of the organization of the source of the control item
SOURCE_PERSON	VARCHAR2	(150)		The name of the person of who is the source of the control item
LAST_ACTION_NUMBER	NUMBER	(15)		The identifier of the last action for the control item
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield context field
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield context field
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield context field
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield context field
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield context field
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield context field
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield context field
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield context field
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield context field
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield context field
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield context field
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield context field
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield context field
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield context field
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield context field
ORIG_SYSTEM_CODE	VARCHAR2	(80)		The identifier of the external project management system from which the control item was imported.
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)		The identifier of the control item in the external project management system from which the control item was imported.
APPROVAL_TYPE_CODE	VARCHAR2	(1)		This column stores the Approval Type code required for the change document.
PCO_STATUS_CODE	VARCHAR2	(30)		This column stores the PCO report acceptance status code
LOCKED_FLAG	VARCHAR2	(240)		The value in this column indicates whether the change document is locked. The value Y indicates locked status.
PCO_SEQUENCE	NUMBER	(20)		This column stores the numbering sequence for Potential Change Order report.
VERSION_NUMBER	NUMBER	(15)		This column stores the version of the change document.
CURRENT_VERSION_FLAG	VARCHAR2	(1)		The value in this column distinguishes between a current and previous version of the change document. A value of Y indicates current version.
ORIGINAL_CI_ID	NUMBER	(15)		This column stores the ID of the original change document from which the change document is created.
SOURCE_CI_ID	NUMBER	(15)		This column stores the ID of the change document version from which the change document is created.
VERSION_COMMENTS	VARCHAR2	(4000)		This column stores comments added while creating change document versions.
CHANGE_APPROVER	VARCHAR2	(50)		This column stores the name of the customer who can approve the change request.

Query Text

Cut, paste (and edit) the following text to query this object:


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
,      ORIG_SYSTEM_CODE
,      ORIG_SYSTEM_REFERENCE
,      APPROVAL_TYPE_CODE
,      PCO_STATUS_CODE
,      LOCKED_FLAG
,      PCO_SEQUENCE
,      VERSION_NUMBER
,      CURRENT_VERSION_FLAG
,      ORIGINAL_CI_ID
,      SOURCE_CI_ID
,      VERSION_COMMENTS
,      CHANGE_APPROVER
FROM PA.PA_CONTROL_ITEMS;

Dependencies

[top of page]

PA.PA_CONTROL_ITEMS does not reference any database object

PA.PA_CONTROL_ITEMS is referenced by following:

PA: PA_CONTROL_ITEMS#