VIEW: APPS.PA_RBS_HEADERS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')