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_TEAM_TEMPLATES

Object Details

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

PA_TEAM_TEMPLATES stores details of the team templates. The templates are system-wide and accessible to all with appropriate privileges within the system.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_TEAM_TEMPLATES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEAM_TEMPLATE_ID
PA_TEAM_TEMPLATES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEAM_TEMPLATE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
TEAM_TEMPLATE_ID	NUMBER		Yes	The system-generated number that uniquely identifies the team template
RECORD_VERSION_NUMBER	NUMBER		Yes	System-generated version of row. Increments by one with each update
TEAM_TEMPLATE_NAME	VARCHAR2	(80)	Yes	User-defined name than uniquely identifies the team template
START_DATE_ACTIVE	DATE		Yes	First effective date of the team template
END_DATE_ACTIVE	DATE			Last effective date of the team template
DESCRIPTION	VARCHAR2	(240)		Free text description of the template
ROLE_LIST_ID	NUMBER			Identifier of the role list associated with the team template
CALENDAR_ID	NUMBER			The identifier of the default calendar used for requirements assigned to this team template
WORK_TYPE_ID	NUMBER			The identifier of the default type of work being carried out for requirements assigned to this team template
TEAM_START_DATE	DATE		Yes	The relative start date for requirements assigned to this team template. Used to determine the actual start date of the requirements when applying the team template to a project
WORKFLOW_IN_PROGRESS_FLAG	VARCHAR2	(1)		Indicates if this team template is currently being applied to a project by a workflow process. No changes are allowed to the template if workflow is in progress
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
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column

Query Text

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


SELECT TEAM_TEMPLATE_ID
,      RECORD_VERSION_NUMBER
,      TEAM_TEMPLATE_NAME
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DESCRIPTION
,      ROLE_LIST_ID
,      CALENDAR_ID
,      WORK_TYPE_ID
,      TEAM_START_DATE
,      WORKFLOW_IN_PROGRESS_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_TEAM_TEMPLATES;

Dependencies

[top of page]

PA.PA_TEAM_TEMPLATES does not reference any database object

PA.PA_TEAM_TEMPLATES is referenced by following:

PA: PA_TEAM_TEMPLATES#