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