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_VERSIONS_AMG_V

Object Details

Object Name:	PA_RBS_VERSIONS_AMG_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_RBS_VERSIONS_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 the version information, such as dates and job group, for a resource breakdown structure version (RBS). The information in this view is applicable to a specific version of the RBS. The RBS version name and description shown is in the user's language.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RBS_HEADER_ID	NUMBER	(15)	Yes	Identifier of the RBS to which the version belongs
RBS_HEADER_NAME	VARCHAR2	(240)	Yes	The name of the RBS to which the version belongs
RBS_VERSION_ID	NUMBER	(15)	Yes	Identifier of the RBS version
RBS_VERSION_NAME	VARCHAR2	(240)	Yes	The name of the RBS version
RBS_VERSION_NUMBER	NUMBER	(15)	Yes	System-generated version number
CURRENT_REPORTING_FLAG	VARCHAR2	(1)		Flag indicating whether the RBS version is the latest frozen version
STATUS_CODE	VARCHAR2	(30)	Yes	The status of the RBS version. Possible values are WORKING or FROZEN.
VERSION_START_DATE	DATE			The start date of the RBS version
VERSION_END_DATE	DATE			The end date of the RBS version
JOB_GROUP_ID	NUMBER	(15)		The default job group ID of the RBS version
JOB_GROUP_NAME	VARCHAR2	(30)		The default job group name of the RBS version

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
,      CURRENT_REPORTING_FLAG
,      STATUS_CODE
,      VERSION_START_DATE
,      VERSION_END_DATE
,      JOB_GROUP_ID
,      JOB_GROUP_NAME
FROM APPS.PA_RBS_VERSIONS_AMG_V;

Dependencies

[top of page]

APPS.PA_RBS_VERSIONS_AMG_V references the following:

APPS: PA_RBS_HEADERS_VL; PA_RBS_VERSIONS_VL; PER_JOB_GROUPS

APPS.PA_RBS_VERSIONS_AMG_V is not referenced by any database object