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]

VIEW: APPS.PA_RBS_ELEMENTS_AMG_V

Object Details

Object Name:	PA_RBS_ELEMENTS_AMG_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_RBS_ELEMENTS_AMG_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view shows element information and the parent-child relationships for elements in a resource breakdown structure (RBS). The RBS header, version, and element names are in the user's language.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RBS_HEADER_ID	NUMBER	(15)	Yes	Identifier of the RBS header to which the element belongs
RBS_HEADER_NAME	VARCHAR2	(240)	Yes	Name of the RBS header to which the element belongs
RBS_VERSION_ID	NUMBER	(15)	Yes	Identifier of the RBS version to which the element belongs
RBS_VERSION_NAME	VARCHAR2	(240)	Yes	Name of the RBS version to which the element belongs
RBS_VERSION_NUMBER	NUMBER	(15)	Yes	The version number of the RBS version to which the element belongs
RBS_ELEMENT_ID	NUMBER	(15)	Yes	Identifier of the RBS element
RESOURCE_NAME	VARCHAR2	(240)	Yes	Name of the RBS element
RESOURCE_SOURCE_ID	NUMBER	(15)		Identifier of the resource of the RBS element. This is the identifier in the source table of the resource.
RESOURCE_TYPE_ID	NUMBER	(15)	Yes	Identifier of the resource type of the RBS element
RESOURCE_TYPE	VARCHAR2	(240)		Name of the resource type of the RBS element
RBS_LEVEL	NUMBER	(15)	Yes	The level of the element in the RBS
PARENT_ELEMENT_ID	NUMBER	(15)		The identifier of the parent element of the RBS element
RULE_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether the element is a resource or a resource type.

Query Text

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


SELECT RBS_HEADER_ID
,      RBS_HEADER_NAME
,      RBS_VERSION_ID
,      RBS_VERSION_NAME
,      RBS_VERSION_NUMBER
,      RBS_ELEMENT_ID
,      RESOURCE_NAME
,      RESOURCE_SOURCE_ID
,      RESOURCE_TYPE_ID
,      RESOURCE_TYPE
,      RBS_LEVEL
,      PARENT_ELEMENT_ID
,      RULE_FLAG
FROM APPS.PA_RBS_ELEMENTS_AMG_V;

Dependencies

[top of page]

APPS.PA_RBS_ELEMENTS_AMG_V references the following:

APPS: PA_RBS_ELEMENTS; PA_RBS_ELEMENT_NAMES_VL; PA_RBS_HEADERS_VL; PA_RBS_VERSIONS_VL; PA_RES_TYPES_VL

APPS.PA_RBS_ELEMENTS_AMG_V is not referenced by any database object