[Home] [Help] [Dependency Information]
Object Name: | PA_PROJECT_PARTIES_AR |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_PROJECT_PARTIES_AR |
Subobject Name: | |
Status: | VALID |
This table provides all the project people whether active or inactive.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_PROJECT_PARTIES_AR_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PURGE_PROJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_BATCH_ID | NUMBER | (15) | Yes | Purge batch Id |
PURGE_RELEASE | VARCHAR2 | (50) | Yes | Purge release version |
PURGE_PROJECT_ID | NUMBER | (15) | Yes | Purged project Id |
PROJECT_PARTY_ID | NUMBER | (15) | System generated number that uniquely identifies the project party | |
OBJECT_ID | NUMBER | The identifier of the object to which the party is assigned to | ||
OBJECT_TYPE | VARCHAR2 | (30) | 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) | The identifier of the type of the resource, such as EMPLOYEE or PARTY | |
RESOURCE_SOURCE_ID | NUMBER | (15) | The identifier of the source. Source can be employee or party. | |
PROJECT_ROLE_ID | NUMBER | The identifier of the role that is assigned to the RESOURCE_SOURCE_ID | ||
START_DATE_ACTIVE | DATE | 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 | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
GRANT_ID | RAW | (16) | Identifier of the grant that the user has on the project. |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_BATCH_ID
, PURGE_RELEASE
, PURGE_PROJECT_ID
, 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_AR;
PA.PA_PROJECT_PARTIES_AR does not reference any database object
PA.PA_PROJECT_PARTIES_AR is referenced by following:
|
|
|