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_LISTS_ALL_BG

Object Details

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

PA_RESOURCE_LISTS_ALL_BG stores lists of resources.
Resource lists provide effective mechanism to group a
set of similar resources that are typically
used for specific kinds of project work. Oracle Projects
supports resource lists with up to a two-level hierarchy of resource
groups and resources.
.
.
Resources are owned by business group, and thus can be shared across
operating units that share business groups. This table holds all
resource lists defined with the system. The PA_RESOURCE_LISTS view
displays only those resource lists owned by the business group
specified in the implementation options under which you are logged on.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_RESOURCE_LISTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESOURCE_LIST_ID ZD_EDITION_NAME
PA_RESOURCE_LISTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME BUSINESS_GROUP_ID ZD_EDITION_NAME
PA_RESOURCE_LISTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADW_NOTIFY_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_LIST_ID	NUMBER	(15)	Yes	The system generated number that uniquely identifies the resource list
NAME	VARCHAR2	(60)		User-defined name for the resource list.
DESCRIPTION	VARCHAR2	(2000)		User-defined description for the resource list
PUBLIC_FLAG	VARCHAR2	(1)		Indicates whether this resource list can be used by all projects. At present this flag is set to 'Y' for all resource lists, since a resource list can be used by any project. Project specific resource lists would be set to 'N'
GROUP_RESOURCE_TYPE_ID	NUMBER			Indicates how the resource list has been grouped by. At present a resource list can be grouped either by Expenditure Category or Revenue Category or not grouped at all. If grouped , stores the identifier of the Resource Type.
START_DATE_ACTIVE	DATE		Yes	Indicates the effective start date of the Resource list
END_DATE_ACTIVE	DATE			Indicates the effective end date of the Resource list
UNCATEGORIZED_FLAG	VARCHAR2	(1)		Indicates whether the resource list is being used to categorize budget by resources. Oracle Projects delivers one resource list with this value set to 'Y'. Any User-defined resource list would have the value set to 'N'.
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
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Identifier of the business group that owns the list
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.
JOB_GROUP_ID	NUMBER	(15)		Holds the identifier of Job Group.
RESOURCE_LIST_TYPE	VARCHAR2	(30)		Indicates the type of Resource List ; valid values are Automatically generated and User-defined
CONTROL_FLAG	VARCHAR2	(1)		Indicates if the resource list is centrally-controlled
USE_FOR_WP_FLAG	VARCHAR2	(1)		Flag to indicate whether or not the resource list is used for workplan
MIGRATION_CODE	VARCHAR2	(1)		Indicates the resource list has been migrated - N = New (HTML model), M = Upgraded and NULL = Old
RECORD_VERSION_NUMBER	NUMBER	(15)		Standard APPS column used for locking.
MIGRATED_RBS_VERSION_ID	NUMBER	(15)		The ID of the RBS Version that was created
RESOURCE_CLASS_FLAG	VARCHAR2	(1)
ITEM_MASTER_ID	NUMBER	(15)		This indicates the item master id.
ITEM_CATEGORY_SET_ID	NUMBER	(15)		This indicates the item category set.
DEFAULT_EXPENDITURE_TYPE	VARCHAR2	(30)		This indicates the default expenditure type.
DEFAULT_COST_TYPE_ID	NUMBER	(15)		This holds the default cost type id.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT RESOURCE_LIST_ID
,      NAME
,      DESCRIPTION
,      PUBLIC_FLAG
,      GROUP_RESOURCE_TYPE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      UNCATEGORIZED_FLAG
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      BUSINESS_GROUP_ID
,      ADW_NOTIFY_FLAG
,      JOB_GROUP_ID
,      RESOURCE_LIST_TYPE
,      CONTROL_FLAG
,      USE_FOR_WP_FLAG
,      MIGRATION_CODE
,      RECORD_VERSION_NUMBER
,      MIGRATED_RBS_VERSION_ID
,      RESOURCE_CLASS_FLAG
,      ITEM_MASTER_ID
,      ITEM_CATEGORY_SET_ID
,      DEFAULT_EXPENDITURE_TYPE
,      DEFAULT_COST_TYPE_ID
,      ZD_EDITION_NAME
FROM PA.PA_RESOURCE_LISTS_ALL_BG;

Dependencies

[top of page]

PA.PA_RESOURCE_LISTS_ALL_BG does not reference any database object

PA.PA_RESOURCE_LISTS_ALL_BG is referenced by following:

PA: PA_RESOURCE_LISTS_ALL_BG#