VIEW: APPS.BEN_RPTG_GRP_V

Source

View Text - Preformatted

SELECT bnr.ROWID ROW_ID , bnr.RPTG_GRP_ID , tl.NAME , bnr.BUSINESS_GROUP_ID , bnr.RPTG_PRPS_CD , bnr.RPG_DESC , bnr.ORDR_NUM ,BNR_ATTRIBUTE_CATEGORY ,BNR_ATTRIBUTE1 ,BNR_ATTRIBUTE2 ,BNR_ATTRIBUTE3 ,BNR_ATTRIBUTE4 ,BNR_ATTRIBUTE5 ,BNR_ATTRIBUTE6 ,BNR_ATTRIBUTE7 ,BNR_ATTRIBUTE8 ,BNR_ATTRIBUTE9 ,BNR_ATTRIBUTE10 ,BNR_ATTRIBUTE11 ,BNR_ATTRIBUTE12 ,BNR_ATTRIBUTE13 ,BNR_ATTRIBUTE14 ,BNR_ATTRIBUTE15 ,BNR_ATTRIBUTE16 ,BNR_ATTRIBUTE17 ,BNR_ATTRIBUTE18 ,BNR_ATTRIBUTE19 ,BNR_ATTRIBUTE20 ,BNR_ATTRIBUTE21 ,BNR_ATTRIBUTE22 ,BNR_ATTRIBUTE23 ,BNR_ATTRIBUTE24 ,BNR_ATTRIBUTE25 ,BNR_ATTRIBUTE26 ,BNR_ATTRIBUTE27 ,BNR_ATTRIBUTE28 ,BNR_ATTRIBUTE29 ,BNR_ATTRIBUTE30 ,tl.function_code ,legislation_code , bnr.LAST_UPDATE_DATE , bnr.LAST_UPDATED_BY , bnr.LAST_UPDATE_LOGIN , bnr.CREATED_BY , bnr.CREATION_DATE , bnr.OBJECT_VERSION_NUMBER ,decode(nvl( bnr.business_group_id, -1), -1, 'Y', 'N') GLOBAL_FLAG from BEN_RPTG_GRP BNR, BEN_RPTG_GRP_TL TL WHERE bnr.rptg_grp_id = tl.rptg_grp_id and TL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT BNR.ROWID ROW_ID
, BNR.RPTG_GRP_ID
, TL.NAME
, BNR.BUSINESS_GROUP_ID
, BNR.RPTG_PRPS_CD
, BNR.RPG_DESC
, BNR.ORDR_NUM
, BNR_ATTRIBUTE_CATEGORY
, BNR_ATTRIBUTE1
, BNR_ATTRIBUTE2
, BNR_ATTRIBUTE3
, BNR_ATTRIBUTE4
, BNR_ATTRIBUTE5
, BNR_ATTRIBUTE6
, BNR_ATTRIBUTE7
, BNR_ATTRIBUTE8
, BNR_ATTRIBUTE9
, BNR_ATTRIBUTE10
, BNR_ATTRIBUTE11
, BNR_ATTRIBUTE12
, BNR_ATTRIBUTE13
, BNR_ATTRIBUTE14
, BNR_ATTRIBUTE15
, BNR_ATTRIBUTE16
, BNR_ATTRIBUTE17
, BNR_ATTRIBUTE18
, BNR_ATTRIBUTE19
, BNR_ATTRIBUTE20
, BNR_ATTRIBUTE21
, BNR_ATTRIBUTE22
, BNR_ATTRIBUTE23
, BNR_ATTRIBUTE24
, BNR_ATTRIBUTE25
, BNR_ATTRIBUTE26
, BNR_ATTRIBUTE27
, BNR_ATTRIBUTE28
, BNR_ATTRIBUTE29
, BNR_ATTRIBUTE30
, TL.FUNCTION_CODE
, LEGISLATION_CODE
, BNR.LAST_UPDATE_DATE
, BNR.LAST_UPDATED_BY
, BNR.LAST_UPDATE_LOGIN
, BNR.CREATED_BY
, BNR.CREATION_DATE
, BNR.OBJECT_VERSION_NUMBER
, DECODE(NVL( BNR.BUSINESS_GROUP_ID
, -1)
, -1
, 'Y'
, 'N') GLOBAL_FLAG
FROM BEN_RPTG_GRP BNR
, BEN_RPTG_GRP_TL TL
WHERE BNR.RPTG_GRP_ID = TL.RPTG_GRP_ID
AND TL.LANGUAGE = USERENV('LANG')