DBA Data[Home] [Help] [Dependency Information]

TABLE: PA.PA_RESOURCE_LIST_ASSIGNMENTS

Object Details
Object Name: PA_RESOURCE_LIST_ASSIGNMENTS
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_RESOURCE_LIST_ASSIGNMENTS
Subobject Name:
Status: VALID


PA_RESOURCE_LIST_ASSIGNMENTS stores information on what resource
lists are assigned to a project. You can assign resource lists to a
project for project summarization.
.
Oracle Projects automatically creates a row in this table and in the
PA_RESOURCE_LIST_USES table for the resource list used in budgeting
when you baseline a budget version for the project.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_RESOURCE_LIST_ASGN_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_LIST_ASSIGNMENT_ID
PA_RESOURCE_LIST_ASGN_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnRESOURCE_LIST_ID
PA_RESOURCE_LIST_ASGN_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_LIST_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_LIST_ASSIGNMENT_ID NUMBER (15) Yes System generated number that uniquely identifies the assignment
RESOURCE_LIST_ID NUMBER (15) Yes The identifier of the resource list that is assigned to the project
PROJECT_ID NUMBER (15) Yes The identifier of the project to which the resource list is being assigned to.
RESOURCE_LIST_CHANGED_FLAG VARCHAR2 (1)
Indicates whether any changes have been made to the resource list.Examples: (1) A resource group or resource is added or deleted; (2) An existing resource group or resource is enabled or disabled; (3) Deactivation of the resourcelist
RESOURCE_LIST_ACCUMULATED_FLAG VARCHAR2 (1)
Indicates whether actuals have been accumulated against the resource list for that project.
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who Column
USED_IN_WP_FLAG VARCHAR2 (1)
Indicates usage in work plan
USED_IN_FP_FLAG VARCHAR2 (1)
Indicates usage in financial plan
Query Text

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


SELECT RESOURCE_LIST_ASSIGNMENT_ID
,      RESOURCE_LIST_ID
,      PROJECT_ID
,      RESOURCE_LIST_CHANGED_FLAG
,      RESOURCE_LIST_ACCUMULATED_FLAG
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      USED_IN_WP_FLAG
,      USED_IN_FP_FLAG
FROM PA.PA_RESOURCE_LIST_ASSIGNMENTS;

Dependencies

[top of page]

PA.PA_RESOURCE_LIST_ASSIGNMENTS does not reference any database object

PA.PA_RESOURCE_LIST_ASSIGNMENTS is referenced by following:

SchemaPA
ViewPA_RESOURCE_LIST_ASSIGNMENTS#