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_RBS_ELEMENTS

Object Details

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

This table stores the element information and the parent-child relationship for all elements in a resource breakdown structure.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_RBS_ELEMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RBS_ELEMENT_ID
PA_RBS_ELEMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RBS_VERSION_ID RESOURCE_SOURCE_ID RESOURCE_TYPE_ID
PA_RBS_ELEMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RBS_VERSION_ID
PA_RBS_ELEMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_ELEMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RBS_ELEMENT_ID	NUMBER	(15)	Yes	Unique identifier of the RBS element.
RBS_ELEMENT_NAME_ID	NUMBER	(15)	Yes	Foreign key to the denormalized name table..
RBS_VERSION_ID	NUMBER	(15)	Yes	Identifier of the RBS version to which the element belongs.
OUTLINE_NUMBER	VARCHAR2	(240)	Yes	Indicates where in the hierarchy the element belongs.
ORDER_NUMBER	NUMBER	(15)		Indicates the order in which to display the element.
RESOURCE_TYPE_ID	NUMBER	(15)	Yes	The resource type of the element.
RESOURCE_SOURCE_ID	NUMBER	(15)		The Source based on the resource type.
PERSON_ID	NUMBER	(15)		The person ID of the element, if RBS element is a person.
JOB_ID	NUMBER	(15)		The job ID of the element, if RBS element is a job.
ORGANIZATION_ID	NUMBER	(15)		The organization ID of the element, if RBS element is a organization.
EXPENDITURE_TYPE_ID	NUMBER	(15)		The expenditure type ID, if RBS element is an expenditure type.
EVENT_TYPE_ID	NUMBER	(15)		The event type ID, if RBS element is an event type.
EXPENDITURE_CATEGORY_ID	NUMBER	(15)		The expenditure category ID, if RBS element is an expenditure category.
REVENUE_CATEGORY_ID	NUMBER	(15)		The revenue category code, if RBS element is a revenue category.
INVENTORY_ITEM_ID	NUMBER	(15)		The item ID of the element, if RBS element is an item.
ITEM_CATEGORY_ID	NUMBER	(15)		The item category ID of the element, if RBS element is an item category.
BOM_LABOR_ID	NUMBER	(15)		The BOM Resource ID of the element, if RBS element is a BOM Labor resource.
BOM_EQUIPMENT_ID	NUMBER	(15)		The BOM Resource ID of the element, if RBS element is a BOM Equipment resource.
NON_LABOR_RESOURCE_ID	NUMBER	(15)		The Non-labor Resource ID of the element, if RBS element is a PA Non-Labor resource.
ROLE_ID	NUMBER	(15)		The role ID of the element, if RBS element is a role.
PERSON_TYPE_ID	NUMBER	(15)		The person type ID, if RBS element is a person type.
RESOURCE_CLASS_ID	NUMBER	(15)		The resource class ID of the element, if RBS element is a resource class.
SUPPLIER_ID	NUMBER	(15)		The supplier ID of the element, if RBS element is a supplier.
RULE_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the RBS element is a rule .
PARENT_ELEMENT_ID	NUMBER	(15)		The parent element of the RBS element null for the top node..
RBS_LEVEL	NUMBER	(15)	Yes	Indicates the level of the RBS.
ELEMENT_IDENTIFIER	NUMBER	(15)	Yes	Unique identifier of the RBS element. This identifier is system-generated, and remains the same for each element for different versions of the RBS.
USER_DEFINED_CUSTOM1_ID	NUMBER	(15)		The user-defined resource ID used for mapping.
USER_DEFINED_CUSTOM2_ID	NUMBER	(15)		The user-defined resource ID used for mapping.
USER_DEFINED_CUSTOM3_ID	NUMBER	(15)		The user-defined resource ID used for mapping.
USER_DEFINED_CUSTOM4_ID	NUMBER	(15)		The user-defined resource ID used for mapping.
USER_DEFINED_CUSTOM5_ID	NUMBER	(15)		The user-defined resource ID used for mapping.
USER_CREATED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the element was created from the User interface or not.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column.
CREATION_DATE	DATE		Yes	Standard Who Column.
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column.
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column.
RECORD_VERSION_NUMBER	NUMBER	(15)	Yes	Apps Standard for locking from HTML..

Query Text

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


SELECT RBS_ELEMENT_ID
,      RBS_ELEMENT_NAME_ID
,      RBS_VERSION_ID
,      OUTLINE_NUMBER
,      ORDER_NUMBER
,      RESOURCE_TYPE_ID
,      RESOURCE_SOURCE_ID
,      PERSON_ID
,      JOB_ID
,      ORGANIZATION_ID
,      EXPENDITURE_TYPE_ID
,      EVENT_TYPE_ID
,      EXPENDITURE_CATEGORY_ID
,      REVENUE_CATEGORY_ID
,      INVENTORY_ITEM_ID
,      ITEM_CATEGORY_ID
,      BOM_LABOR_ID
,      BOM_EQUIPMENT_ID
,      NON_LABOR_RESOURCE_ID
,      ROLE_ID
,      PERSON_TYPE_ID
,      RESOURCE_CLASS_ID
,      SUPPLIER_ID
,      RULE_FLAG
,      PARENT_ELEMENT_ID
,      RBS_LEVEL
,      ELEMENT_IDENTIFIER
,      USER_DEFINED_CUSTOM1_ID
,      USER_DEFINED_CUSTOM2_ID
,      USER_DEFINED_CUSTOM3_ID
,      USER_DEFINED_CUSTOM4_ID
,      USER_DEFINED_CUSTOM5_ID
,      USER_CREATED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RECORD_VERSION_NUMBER
FROM PA.PA_RBS_ELEMENTS;

Dependencies

[top of page]

PA.PA_RBS_ELEMENTS does not reference any database object

PA.PA_RBS_ELEMENTS is referenced by following:

APPS: PA_RBS_ELEMENTS