DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PA_RBS_HEADERS_AMG_V

Object Details
Object Name: PA_RBS_HEADERS_AMG_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_RBS_HEADERS_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 name, effective dates, and related information for a resource breakdown structure (RBS). The information in this view is applicable to all versions of the RBS. The RBS header name and description are shown in the user's language.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RBS_HEADER_ID NUMBER (15) Yes Identifier of the RBS header
EFFECTIVE_FROM_DATE DATE
Yes The start date of the RBS
EFFECTIVE_TO_DATE DATE

The end date of the RBS
BUSINESS_GROUP_ID NUMBER (15)
Identifier of the business group to which the RBS header belongs
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes Name of the business group to which the RBS header belongs
USE_FOR_ALLOC_FLAG VARCHAR2 (1)
Flag indicating whether the RBS can be used in allocations. An RBS can be used in allocations if there are no rule-based RBS elements in any of its versions.
NAME VARCHAR2 (240) Yes The name of the RBS
DESCRIPTION VARCHAR2 (2000)
The description of the RBS
Query Text

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


SELECT RBS_HEADER_ID
,      EFFECTIVE_FROM_DATE
,      EFFECTIVE_TO_DATE
,      BUSINESS_GROUP_ID
,      BUSINESS_GROUP_NAME
,      USE_FOR_ALLOC_FLAG
,      NAME
,      DESCRIPTION
FROM APPS.PA_RBS_HEADERS_AMG_V;

Dependencies

[top of page]

APPS.PA_RBS_HEADERS_AMG_V references the following:

SchemaAPPS
ViewPA_RBS_HEADERS_VL
ViewPER_BUSINESS_GROUPS

APPS.PA_RBS_HEADERS_AMG_V is not referenced by any database object