1. Tables and Views for HCM
  2. BEN_RPTG_GRP_VL

BEN_RPTG_GRP_VL

Details

  • Schema: FUSION

  • Object owner: BEN

  • Object type: VIEW

Columns

Name

RPTG_GRP_ID

NAME

BUSINESS_GROUP_ID

RPTG_PRPS_CD

RPG_DESC

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

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

OBJECT_VERSION_NUMBER

FUNCTION_CODE

LEGISLATION_CODE

ORDR_NUM

GLOBAL_FLAG

BNR_ATTRIBUTE_NUMBER1

BNR_ATTRIBUTE_NUMBER2

BNR_ATTRIBUTE_NUMBER3

BNR_ATTRIBUTE_NUMBER4

BNR_ATTRIBUTE_NUMBER5

BNR_ATTRIBUTE_NUMBER6

BNR_ATTRIBUTE_NUMBER7

BNR_ATTRIBUTE_NUMBER8

BNR_ATTRIBUTE_NUMBER9

BNR_ATTRIBUTE_NUMBER10

BNR_ATTRIBUTE_NUMBER11

BNR_ATTRIBUTE_NUMBER12

BNR_ATTRIBUTE_NUMBER13

BNR_ATTRIBUTE_NUMBER14

BNR_ATTRIBUTE_NUMBER15

BNR_ATTRIBUTE_NUMBER16

BNR_ATTRIBUTE_NUMBER17

BNR_ATTRIBUTE_NUMBER18

BNR_ATTRIBUTE_NUMBER19

BNR_ATTRIBUTE_NUMBER20

BNR_ATTRIBUTE_DATE1

BNR_ATTRIBUTE_DATE2

BNR_ATTRIBUTE_DATE3

BNR_ATTRIBUTE_DATE4

BNR_ATTRIBUTE_DATE5

BNR_ATTRIBUTE_DATE6

BNR_ATTRIBUTE_DATE7

BNR_ATTRIBUTE_DATE8

BNR_ATTRIBUTE_DATE9

BNR_ATTRIBUTE_DATE10

BNR_ATTRIBUTE_DATE11

BNR_ATTRIBUTE_DATE12

BNR_ATTRIBUTE_DATE13

BNR_ATTRIBUTE_DATE14

BNR_ATTRIBUTE_DATE15

Query

SQL_Statement

SELECT

bnr.RPTG_GRP_ID,

tl.NAME,

bnr.BUSINESS_GROUP_ID,

bnr.RPTG_PRPS_CD,

bnr.RPG_DESC,

bnr.BNR_ATTRIBUTE_CATEGORY,

bnr.BNR_ATTRIBUTE1,

bnr.BNR_ATTRIBUTE2,

bnr.BNR_ATTRIBUTE3,

bnr.BNR_ATTRIBUTE4,

bnr.BNR_ATTRIBUTE5,

bnr.BNR_ATTRIBUTE6,

bnr.BNR_ATTRIBUTE7,

bnr.BNR_ATTRIBUTE8,

bnr.BNR_ATTRIBUTE9,

bnr.BNR_ATTRIBUTE10,

bnr.BNR_ATTRIBUTE11,

bnr.BNR_ATTRIBUTE12,

bnr.BNR_ATTRIBUTE13,

bnr.BNR_ATTRIBUTE14,

bnr.BNR_ATTRIBUTE15,

bnr.BNR_ATTRIBUTE16,

bnr.BNR_ATTRIBUTE17,

bnr.BNR_ATTRIBUTE18,

bnr.BNR_ATTRIBUTE19,

bnr.BNR_ATTRIBUTE20,

bnr.BNR_ATTRIBUTE21,

bnr.BNR_ATTRIBUTE22,

bnr.BNR_ATTRIBUTE23,

bnr.BNR_ATTRIBUTE24,

bnr.BNR_ATTRIBUTE25,

bnr.BNR_ATTRIBUTE26,

bnr.BNR_ATTRIBUTE27,

bnr.BNR_ATTRIBUTE28,

bnr.BNR_ATTRIBUTE29,

bnr.BNR_ATTRIBUTE30,

bnr.LAST_UPDATE_DATE,

bnr.LAST_UPDATED_BY,

bnr.LAST_UPDATE_LOGIN,

bnr.CREATED_BY,

bnr.CREATION_DATE,

bnr.OBJECT_VERSION_NUMBER,

bnr.FUNCTION_CODE,

bnr.LEGISLATION_CODE,

bnr.ORDR_NUM,

bnr.GLOBAL_FLAG,

bnr.BNR_ATTRIBUTE_NUMBER1,

bnr.BNR_ATTRIBUTE_NUMBER2,

bnr.BNR_ATTRIBUTE_NUMBER3,

bnr.BNR_ATTRIBUTE_NUMBER4,

bnr.BNR_ATTRIBUTE_NUMBER5,

bnr.BNR_ATTRIBUTE_NUMBER6,

bnr.BNR_ATTRIBUTE_NUMBER7,

bnr.BNR_ATTRIBUTE_NUMBER8,

bnr.BNR_ATTRIBUTE_NUMBER9,

bnr.BNR_ATTRIBUTE_NUMBER10,

bnr.BNR_ATTRIBUTE_NUMBER11,

bnr.BNR_ATTRIBUTE_NUMBER12,

bnr.BNR_ATTRIBUTE_NUMBER13,

bnr.BNR_ATTRIBUTE_NUMBER14,

bnr.BNR_ATTRIBUTE_NUMBER15,

bnr.BNR_ATTRIBUTE_NUMBER16,

bnr.BNR_ATTRIBUTE_NUMBER17,

bnr.BNR_ATTRIBUTE_NUMBER18,

bnr.BNR_ATTRIBUTE_NUMBER19,

bnr.BNR_ATTRIBUTE_NUMBER20,

bnr.BNR_ATTRIBUTE_DATE1,

bnr.BNR_ATTRIBUTE_DATE2,

bnr.BNR_ATTRIBUTE_DATE3,

bnr.BNR_ATTRIBUTE_DATE4,

bnr.BNR_ATTRIBUTE_DATE5,

bnr.BNR_ATTRIBUTE_DATE6,

bnr.BNR_ATTRIBUTE_DATE7,

bnr.BNR_ATTRIBUTE_DATE8,

bnr.BNR_ATTRIBUTE_DATE9,

bnr.BNR_ATTRIBUTE_DATE10,

bnr.BNR_ATTRIBUTE_DATE11,

bnr.BNR_ATTRIBUTE_DATE12,

bnr.BNR_ATTRIBUTE_DATE13,

bnr.BNR_ATTRIBUTE_DATE14,

bnr.BNR_ATTRIBUTE_DATE15

FROM

BEN_RPTG_GRP bnr,

BEN_RPTG_GRP_TL tl

WHERE

bnr.RPTG_GRP_ID = tl.RPTG_GRP_ID AND tl.LANGUAGE = USERENV('LANG')