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_PROJECT_CLASSES

Object Details

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

PA_PROJECT_CLASSES stores class codes for a particular
class category which is used to describe or classify a project.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJECT_CLASSES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_ID OBJECT_TYPE CLASS_CATEGORY CLASS_CODE
PA_PROJECT_CLASSES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADW_NOTIFY_FLAG
PA_PROJECT_CLASSES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID CLASS_CATEGORY CLASS_CODE
PA_PROJECT_CLASSES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLASS_CODE CLASS_CATEGORY

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)		The identifier of the project that is classified by the project class
CLASS_CATEGORY	VARCHAR2	(30)	Yes	The class category by which the project is classified
CLASS_CODE	VARCHAR2	(30)	Yes	The class code that classifies the project
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
ADW_NOTIFY_FLAG	VARCHAR2	(1)		The flag that indicates whether this row needs to be sent to the interface table or not. This column is required for Oracle Project Analysis Collection Pack.
CODE_PERCENTAGE	NUMBER			The percentage associated with this classification
OBJECT_ID	NUMBER	(15)	Yes	The identifier of the object this classification belongs to
OBJECT_TYPE	VARCHAR2	(30)	Yes	The type of the object this classification belongs to
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
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
RECORD_VERSION_NUMBER	NUMBER			Record version number

Query Text

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


SELECT PROJECT_ID
,      CLASS_CATEGORY
,      CLASS_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ADW_NOTIFY_FLAG
,      CODE_PERCENTAGE
,      OBJECT_ID
,      OBJECT_TYPE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RECORD_VERSION_NUMBER
FROM PA.PA_PROJECT_CLASSES;

Dependencies

[top of page]

PA.PA_PROJECT_CLASSES does not reference any database object

PA.PA_PROJECT_CLASSES is referenced by following:

APPS: PA_ADW_PROJECT_CLASSES_T1; PA_PJI_PROJ_CLASS_T1; PA_PJI_PROJ_CLASS_T2; PA_PJI_PROJ_CLASS_T3; PA_PROJECT_CLASSES