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_PARTIES

Object Details

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

This table provides all the project people whether active or inactive.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROJECT_PARTIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_PARTY_ID
PA_PROJECT_PARTIES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_ID OBJECT_TYPE RESOURCE_TYPE_ID RESOURCE_SOURCE_ID PROJECT_ROLE_ID START_DATE_ACTIVE
PA_PROJECT_PARTIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID PROJECT_ROLE_ID
PA_PROJECT_PARTIES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_SOURCE_ID RESOURCE_TYPE_ID
PA_PROJECT_PARTIES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE OBJECT_ID PROJECT_ROLE_ID
PA_PROJECT_PARTIES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ROLE_ID RESOURCE_TYPE_ID RESOURCE_SOURCE_ID
PA_PROJECT_PARTIES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_PARTY_ID	NUMBER	(15)	Yes	System generated number that uniquely identifies the project party
OBJECT_ID	NUMBER		Yes	The identifier of the object to which the party is assigned to
OBJECT_TYPE	VARCHAR2	(30)	Yes	The identifier of the type of the objects, such as Projects or
PROJECT_ID	NUMBER	(15)		The identifier of the project to which the objects belong
RESOURCE_ID	NUMBER	(15)		The identifier of the resource assigned to the project
RESOURCE_TYPE_ID	NUMBER	(15)	Yes	The identifier of the type of the resource, such as EMPLOYEE or PARTY
RESOURCE_SOURCE_ID	NUMBER	(15)	Yes	The identifier of the source. Source can be employee or party.
PROJECT_ROLE_ID	NUMBER		Yes	The identifier of the role that is assigned to the RESOURCE_SOURCE_ID
START_DATE_ACTIVE	DATE		Yes	The first effective date for the project party
END_DATE_ACTIVE	DATE			The last effective date for the project party
SCHEDULED_FLAG	VARCHAR2	(1)		Flag indicating whether an assignment exists for this person
RECORD_VERSION_NUMBER	NUMBER			Sequence number for locking strategy in self service applications
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
GRANT_ID	RAW	(16)		Identifier of the grant that the user has on the project.

Query Text

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


SELECT PROJECT_PARTY_ID
,      OBJECT_ID
,      OBJECT_TYPE
,      PROJECT_ID
,      RESOURCE_ID
,      RESOURCE_TYPE_ID
,      RESOURCE_SOURCE_ID
,      PROJECT_ROLE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SCHEDULED_FLAG
,      RECORD_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      GRANT_ID
FROM PA.PA_PROJECT_PARTIES;

Dependencies

[top of page]

PA.PA_PROJECT_PARTIES does not reference any database object

PA.PA_PROJECT_PARTIES is referenced by following:

APPS: PA_PROJECT_PARTIES