[Home] [Help] [Dependency Information]
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 |
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.
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 |
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;
APPS.PA_RBS_VERSIONS_AMG_V is not referenced by any database object
|
|
|