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_LIST_MEMBERS

Object Details

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

PA_RESOURCE_LIST_MEMBERS stores information about the individual
members which make up the resource list. All resource groups and
resources are regarded as members.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_RESOURCE_LIST_MEMBERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESOURCE_LIST_MEMBER_ID
PA_RESOURCE_LIST_MEMBERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_LIST_ID RESOURCE_ID
PA_RESOURCE_LIST_MEMBERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_MEMBER_ID
PA_RESOURCE_LIST_MEMBERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADW_NOTIFY_FLAG
PA_RESOURCE_LIST_MEMBERS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_LIST_ID OBJECT_ID OBJECT_TYPE RESOURCE_CLASS_ID RES_FORMAT_ID
PA_RESOURCE_LIST_MEMBERS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_LIST_ID ALIAS

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the resource list member.
RESOURCE_LIST_ID	NUMBER	(15)	Yes	The Identifier of the resource list to which the members belong to.
RESOURCE_ID	NUMBER	(15)	Yes	The identifier of the resource that is being used as a member of the resource list
ALIAS	VARCHAR2	(80)		User-defined short name to be used in budgets entry, reports and Project Status Inquiry.
PARENT_MEMBER_ID	NUMBER			Identifier of the resource group to which the member belongs to. This value would be Null in case of (1) resource groups or (2) resource lists which have not been grouped
SORT_ORDER	NUMBER			The order in which a resource appears in the resource list within its resource group or within the resource list
MEMBER_LEVEL	NUMBER			The level of the resource within the hierarchy. The value would be 1 for Parent or non grouped resources and 2 for second-level resources
DISPLAY_FLAG	VARCHAR2	(1)		This indicates whether the resource is to be displayed to the user when a resource list is queried. All resources created through the resource lists form would have the value set to 'Y'
ENABLED_FLAG	VARCHAR2	(1)		Indicates whether the resource is to be enabled for use by other modules like Budgets etc. A disabled resource cannot be used.
TRACK_AS_LABOR_FLAG	VARCHAR2	(1)		This attribute specifies that when the resource is used to Budget it is tracked as labor and quantity is tracked as labor hours
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
ADW_NOTIFY_FLAG	VARCHAR2	(1)		The flag that indicates whether this row needs to be sent to the interface table or not. This column is required for Oracle Project Analysis Collection Pack.
FUNDS_CONTROL_LEVEL_CODE	VARCHAR2	(30)		'The type of funds control for the resource or resource group level.
PERSON_ID	NUMBER	(15)		Holds the identifier of the employee.
JOB_ID	NUMBER	(15)		Holds the identifier of the Job.
ORGANIZATION_ID	NUMBER	(15)		Holds the identifier of the Organization.
VENDOR_ID	NUMBER	(15)		Holds the identifier of the Supplier.
EXPENDITURE_TYPE	VARCHAR2	(30)		Holds the identifier of the Expenditure Type.
EVENT_TYPE	VARCHAR2	(30)		Holds the identifier of the Event Type.
NON_LABOR_RESOURCE	VARCHAR2	(20)		Holds the identifier of the Non Labor Resource.
EXPENDITURE_CATEGORY	VARCHAR2	(30)		Holds the identifier of the Expenditure Category.
REVENUE_CATEGORY	VARCHAR2	(30)		Holds the identifier of the Revenue Category
NON_LABOR_RESOURCE_ORG_ID	NUMBER	(15)		Holds the identifier of the Non Labor Resource's Organization.
EVENT_TYPE_CLASSIFICATION	VARCHAR2	(30)		Holds the identifier of the Event Type Classification.
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(30)		Holds the identifier of the System Linkage.
PROJECT_ROLE_ID	NUMBER	(15)		Holds the identifier of project role.
RESOURCE_FORMAT_ID	NUMBER	(15)		Holds the identifier of the Resource Format.
RESOURCE_TYPE_ID	NUMBER	(15)		Holds the identifier of resource type.
RESOURCE_TYPE_CODE	VARCHAR2	(30)		olds the code used to identify the resource type.
OBJECT_TYPE	VARCHAR2	(30)		Indicates the resource class, organization or project to which the defaulting is applicable
OBJECT_ID	NUMBER	(15)		Indicates the resource list or project depending upon the object type
RESOURCE_CLASS_ID	NUMBER	(15)		Indicates the resource class
RES_FORMAT_ID	NUMBER	(15)		Indicates the resource format - new resource formats
SPREAD_CURVE_ID	NUMBER	(15)		Indicates the spread curve
ETC_METHOD_CODE	VARCHAR2	(30)		Indicates the ETC method
MFC_COST_TYPE_ID	NUMBER	(15)		Indicates the manufacturing cost type
PERSON_TYPE_CODE	VARCHAR2	(30)		Indicates the type of person
RES_TYPE_CODE	VARCHAR2	(30)		Indicates the resource type code for the resource.
RESOURCE_CLASS_CODE	VARCHAR2	(30)		Indicates the code of the resource class
RESOURCE_CLASS_FLAG	VARCHAR2	(1)		Indicates the resource is a resource class
FC_RES_TYPE_CODE	VARCHAR2	(30)		Indicates the resource type of the financial category element
BOM_RESOURCE_ID	NUMBER	(15)		Indicates the BOM labor resource
INVENTORY_ITEM_ID	NUMBER	(15)		Indicates the inventory item
ITEM_CATEGORY_ID	NUMBER	(15)		Indicates the inventory item category
TEAM_ROLE	VARCHAR2	(80)		The Team Role of the planning resource.
MIGRATION_CODE	VARCHAR2	(1)		Indicates whether the resource list member has been migrated - N = New (HTML model), M = Upgraded and NULL = Old.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE21	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE22	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE23	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE24	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE25	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE26	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE27	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE28	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE29	VARCHAR2	(150)		Descriptive flexfield
ATTRIBUTE30	VARCHAR2	(150)		Descriptive flexfield
RECORD_VERSION_NUMBER	NUMBER	(15)		Standard APPS column used for locking
INCURRED_BY_RES_FLAG	VARCHAR2	(1)		Indicates whether the resource columns(job_id, project_role_id, person_type_code, person_id) are used to track the incurred by Resources on financial element assignments.
INCUR_BY_RES_CLASS_CODE	VARCHAR2	(30)		Indicates the incurring resource class
INCUR_BY_ROLE_ID	NUMBER	(15)		Indicates the incurring role.
COPY_FROM_RL_FLAG	VARCHAR2	(1)		Flag that specifies whether the list member was copied from a central resource list.
WP_ELIGIBLE_FLAG	VARCHAR2	(1)		Flag that specifies whether the list
MIGRATED_RBS_ELEMENT_ID	NUMBER	(15)		The RBS Element ID that was created from the upgrade of this resource list member.
UNIT_OF_MEASURE	VARCHAR2	(30)		Unit of measure of the resource list

Query Text

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


SELECT RESOURCE_LIST_MEMBER_ID
,      RESOURCE_LIST_ID
,      RESOURCE_ID
,      ALIAS
,      PARENT_MEMBER_ID
,      SORT_ORDER
,      MEMBER_LEVEL
,      DISPLAY_FLAG
,      ENABLED_FLAG
,      TRACK_AS_LABOR_FLAG
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ADW_NOTIFY_FLAG
,      FUNDS_CONTROL_LEVEL_CODE
,      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
,      PROJECT_ROLE_ID
,      RESOURCE_FORMAT_ID
,      RESOURCE_TYPE_ID
,      RESOURCE_TYPE_CODE
,      OBJECT_TYPE
,      OBJECT_ID
,      RESOURCE_CLASS_ID
,      RES_FORMAT_ID
,      SPREAD_CURVE_ID
,      ETC_METHOD_CODE
,      MFC_COST_TYPE_ID
,      PERSON_TYPE_CODE
,      RES_TYPE_CODE
,      RESOURCE_CLASS_CODE
,      RESOURCE_CLASS_FLAG
,      FC_RES_TYPE_CODE
,      BOM_RESOURCE_ID
,      INVENTORY_ITEM_ID
,      ITEM_CATEGORY_ID
,      TEAM_ROLE
,      MIGRATION_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      RECORD_VERSION_NUMBER
,      INCURRED_BY_RES_FLAG
,      INCUR_BY_RES_CLASS_CODE
,      INCUR_BY_ROLE_ID
,      COPY_FROM_RL_FLAG
,      WP_ELIGIBLE_FLAG
,      MIGRATED_RBS_ELEMENT_ID
,      UNIT_OF_MEASURE
FROM PA.PA_RESOURCE_LIST_MEMBERS;

Dependencies

[top of page]

PA.PA_RESOURCE_LIST_MEMBERS does not reference any database object

PA.PA_RESOURCE_LIST_MEMBERS is referenced by following:

APPS: PA_ADW_RESOURCES_T1; PA_RESOURCE_LIST_MEMBERS