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_CI_TYPES_B

Object Details

Object Name:	PA_CI_TYPES_B
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.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:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_CI_TYPES_B_U1	NORMAL	UNIQUE	APPS_TS_SEED	CI_TYPE_ID ZD_EDITION_NAME
PA_CI_TYPES_B_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	CI_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
APPROVAL_TYPE_CODE	VARCHAR2	(30)		The value in this column specifies the approval type code required for the control item type.
SUBCONTRACTOR_REPORTING_FLAG	VARCHAR2	(1)		The value in this column determines whether the Subcontract Reporting region is displayed in the Change Management page. To display this region, set the value to Y.
PREFIX_AUTO_NUMBER	VARCHAR2	(30)		This column stores the prefix of the change document number.
IMPACT_BUDGET_TYPE_CODE	VARCHAR2	(30)		The value in this column indicates the budget update method code for the control item type.
COST_COL_FLAG	VARCHAR2	(1)		The value in this column determines whether the Cost column is displayed in the Financial region. A value of Y indicates that the column is displayed.
REV_COL_FLAG	VARCHAR2	(1)		The value in this column determines whether the Revenue column is displayed in the Financial region. A value of Y indicates that the column is displayed.
DIR_COST_REG_FLAG	VARCHAR2	(1)		The value in this column determines whether the Direct Cost sub-region is displayed in the Financial region. A value of Y indicates that the sub-region is displayed.
SUPP_COST_REG_FLAG	VARCHAR2	(1)		The value in this column determines whether the Supplier Cost sub-region is displayed in the Financial region. A value of Y indicates that the sub-region is displayed.
DIR_REG_REV_COL_FLAG	VARCHAR2	(1)		The value in this column determines whether the Revenue column is displayed in the Direct Cost as well as the Supplier cost sub-regions of the Financial region. A value of Y indicates that the column is displayed in both the sub-regions.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

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
,      APPROVAL_TYPE_CODE
,      SUBCONTRACTOR_REPORTING_FLAG
,      PREFIX_AUTO_NUMBER
,      IMPACT_BUDGET_TYPE_CODE
,      COST_COL_FLAG
,      REV_COL_FLAG
,      DIR_COST_REG_FLAG
,      SUPP_COST_REG_FLAG
,      DIR_REG_REV_COL_FLAG
,      ZD_EDITION_NAME
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:

PA: PA_CI_TYPES_B#