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_RESOURCE_MAPS

Object Details

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

PA_RESOURCE_MAPS stores the information to map a resource list member
to a combination of resource transaction attributes in the Update
Project Summary Amounts processes.
.
When a transaction is mapped to a resource, this table is scanned
first for a resource map. If the resource map is not present, then the
transaction is mapped to the given resource list member and then a
resource map is created in this table. This allows faster processing
of transactions as mapping is done only when it is needed (mapping
only those that have not previously been mapped).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_RESOURCE_MAPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_LIST_ASSIGNMENT_ID RESOURCE_LIST_ID EXPENDITURE_TYPE ORGANIZATION_ID PERSON_ID
PA_RESOURCE_MAPS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_LIST_ASSIGNMENT_ID RESOURCE_LIST_ID EVENT_TYPE ORGANIZATION_ID
PA_RESOURCE_MAPS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_LIST_ID EXPENDITURE_TYPE ORGANIZATION_ID PERSON_ID
PA_RESOURCE_MAPS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_LIST_ID EVENT_TYPE ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER			The identifier of employee for which the resource map was created
JOB_ID	NUMBER			The identifier of job for which the resource map was created
ORGANIZATION_ID	NUMBER			The identifier of organization for which the resource map was created
VENDOR_ID	NUMBER			The identifier of the supplier for which the resource map was created
EXPENDITURE_TYPE	VARCHAR2	(30)		The expenditure type for which the resource map was created
EVENT_TYPE	VARCHAR2	(30)		The event type for which the resource map was created
NON_LABOR_RESOURCE	VARCHAR2	(20)		The non labor resource for which the resource map was created
EXPENDITURE_CATEGORY	VARCHAR2	(30)		The expenditure category for which the resource map was created
REVENUE_CATEGORY	VARCHAR2	(30)		The revenue category for which the resource map was created
NON_LABOR_RESOURCE_ORG_ID	NUMBER			The identifier of non labor resource org id for which the map was created
EVENT_TYPE_CLASSIFICATION	VARCHAR2	(30)		The event type classification for which the resource map was created
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(30)		The system linkage function for which the resource map was created
RESOURCE_LIST_ASSIGNMENT_ID	NUMBER	(15)	Yes	The identifier of resource list assignment for which the resource map was created
RESOURCE_LIST_ID	NUMBER	(15)	Yes	The identifier of resource list for which the resource map was created
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)	Yes	The identifier of resource list member for which the resource map was created
RESOURCE_ID	NUMBER	(15)	Yes	The identifier of resource for which the resource map was created
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
REQUEST_ID	NUMBER			Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column
PROGRAM_ID	NUMBER			Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column

Query Text

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


SELECT PERSON_ID
,      JOB_ID
,      ORGANIZATION_ID
,      VENDOR_ID
,      EXPENDITURE_TYPE
,      EVENT_TYPE
,      NON_LABOR_RESOURCE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY
,      NON_LABOR_RESOURCE_ORG_ID
,      EVENT_TYPE_CLASSIFICATION
,      SYSTEM_LINKAGE_FUNCTION
,      RESOURCE_LIST_ASSIGNMENT_ID
,      RESOURCE_LIST_ID
,      RESOURCE_LIST_MEMBER_ID
,      RESOURCE_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM PA.PA_RESOURCE_MAPS;

Dependencies

[top of page]

PA.PA_RESOURCE_MAPS does not reference any database object

PA.PA_RESOURCE_MAPS is referenced by following:

APPS: PA_RESOURCE_MAPS