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


TABLE: PA.PA_CI_TYPES_B

Object Details
Object Name: PA_CI_TYPES_B
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_CI_TYPES_B
Subobject Name:
Status: VALID


This table stores the control item type definition. Item type can be seeded as well as created by customer.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_CI_TYPES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCI_TYPE_ID
PA_CI_TYPES_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnCI_TYPE_CLASS_CODE
Columns
Name Datatype Length Mandatory Comments
CI_TYPE_ID NUMBER (15) Yes System-generated number that uniquely identifies the control item type
CI_TYPE_CLASS_CODE VARCHAR2 (30) Yes Lookup code for the control item type class
AUTO_NUMBER_FLAG VARCHAR2 (1) Yes Flag indicating that item numbers are system-generated
RESOLUTION_REQUIRED_FLAG VARCHAR2 (1) Yes Flag indicating that a resolution is required for closure of control items associated with this item type
APPROVAL_REQUIRED_FLAG VARCHAR2 (1) Yes For Change Orders and Change Requests, this flag indicates auto-approval of the item. For Issues, this flag indicates no approval required.
SOURCE_ATTRS_ENABLED_FLAG VARCHAR2 (1) Yes Flag indicating that the source attributes for a control item are made available for entry
ALLOW_ALL_USAGE_FLAG VARCHAR2 (1) Yes Flag indicating that all the project types are allowed to use this control item type.
RECORD_VERSION_NUMBER NUMBER (15) Yes Number used for record locking in self service applications
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
START_DATE_ACTIVE DATE
Yes The starting active date for the control item type
END_DATE_ACTIVE DATE

The ending active date for the control item type
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CLASSIFICATION_CATEGORY VARCHAR2 (100)
The class category used as list of values for classification
REASON_CATEGORY VARCHAR2 (100)
The class category used as list of values for reason
RESOLUTION_CATEGORY VARCHAR2 (100)
The class category used as list of values for resolution type
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context field
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
Query Text

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


SELECT CI_TYPE_ID
,      CI_TYPE_CLASS_CODE
,      AUTO_NUMBER_FLAG
,      RESOLUTION_REQUIRED_FLAG
,      APPROVAL_REQUIRED_FLAG
,      SOURCE_ATTRS_ENABLED_FLAG
,      ALLOW_ALL_USAGE_FLAG
,      RECORD_VERSION_NUMBER
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LAST_UPDATE_LOGIN
,      CLASSIFICATION_CATEGORY
,      REASON_CATEGORY
,      RESOLUTION_CATEGORY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM PA.PA_CI_TYPES_B;

Dependencies

[top of page]

PA.PA_CI_TYPES_B does not reference any database object

PA.PA_CI_TYPES_B is referenced by following:

SchemaAPPS
SynonymPA_CI_TYPES_B