View: PA_RBS_HEADERS_V

Product:	PA - Projects
Description:	This view shows the header information, such as dates and usage, for a resource breakdown structure.
Implementation/DBA Data:	APPS.PA_RBS_HEADERS_V

View Text

SELECT HDR.RBS_HEADER_ID
, HDRTL.NAME
, HDRTL.DESCRIPTION
, HDR.EFFECTIVE_FROM_DATE
, HDR.EFFECTIVE_TO_DATE
, HDR.BUSINESS_GROUP_ID
, HDR.USE_FOR_ALLOC_FLAG
FROM PA_RBS_HEADERS_B HDR
, PA_RBS_HEADERS_TL HDRTL
WHERE HDR.RBS_HEADER_ID = HDRTL.RBS_HEADER_ID
AND HDRTL.LANGUAGE = USERENV('LANG')
AND EXISTS (SELECT 'Y'
FROM PA_RBS_VERSIONS_B VER
WHERE VER.RBS_HEADER_ID = HDR.RBS_HEADER_ID
AND VER.STATUS_CODE = 'FROZEN')
AND ((HDR.BUSINESS_GROUP_ID = PA_UTILS.BUSINESS_GROUP_ID
AND PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'N') OR PA_CROSS_BUSINESS_GRP.ISCROSSBGPROFILE = 'Y')

Columns