1. Tables and Views for HCM
  2. BEN_REGN_F_VL

BEN_REGN_F_VL

Details

  • Schema: FUSION

  • Object owner: BEN

  • Object type: VIEW

Columns

Name

REGN_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

NAME

STTRY_CITN_NAME

ORGANIZATION_ID

BUSINESS_GROUP_ID

REG_ATTRIBUTE_CATEGORY

REG_ATTRIBUTE1

REG_ATTRIBUTE2

REG_ATTRIBUTE3

REG_ATTRIBUTE4

REG_ATTRIBUTE5

REG_ATTRIBUTE6

REG_ATTRIBUTE7

REG_ATTRIBUTE8

REG_ATTRIBUTE9

REG_ATTRIBUTE10

REG_ATTRIBUTE11

REG_ATTRIBUTE12

REG_ATTRIBUTE13

REG_ATTRIBUTE14

REG_ATTRIBUTE15

REG_ATTRIBUTE16

REG_ATTRIBUTE17

REG_ATTRIBUTE18

REG_ATTRIBUTE19

REG_ATTRIBUTE20

REG_ATTRIBUTE21

REG_ATTRIBUTE22

REG_ATTRIBUTE23

REG_ATTRIBUTE24

REG_ATTRIBUTE25

REG_ATTRIBUTE26

REG_ATTRIBUTE27

REG_ATTRIBUTE28

REG_ATTRIBUTE29

REG_ATTRIBUTE30

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

OBJECT_VERSION_NUMBER

REG_ATTRIBUTE_NUMBER1

REG_ATTRIBUTE_NUMBER2

REG_ATTRIBUTE_NUMBER3

REG_ATTRIBUTE_NUMBER4

REG_ATTRIBUTE_NUMBER5

REG_ATTRIBUTE_NUMBER6

REG_ATTRIBUTE_NUMBER7

REG_ATTRIBUTE_NUMBER8

REG_ATTRIBUTE_NUMBER9

REG_ATTRIBUTE_NUMBER10

REG_ATTRIBUTE_NUMBER11

REG_ATTRIBUTE_NUMBER12

REG_ATTRIBUTE_NUMBER13

REG_ATTRIBUTE_NUMBER14

REG_ATTRIBUTE_NUMBER15

REG_ATTRIBUTE_NUMBER16

REG_ATTRIBUTE_NUMBER17

REG_ATTRIBUTE_NUMBER18

REG_ATTRIBUTE_NUMBER19

REG_ATTRIBUTE_NUMBER20

REG_ATTRIBUTE_DATE1

REG_ATTRIBUTE_DATE2

REG_ATTRIBUTE_DATE3

REG_ATTRIBUTE_DATE4

REG_ATTRIBUTE_DATE5

REG_ATTRIBUTE_DATE6

REG_ATTRIBUTE_DATE7

REG_ATTRIBUTE_DATE8

REG_ATTRIBUTE_DATE9

REG_ATTRIBUTE_DATE10

REG_ATTRIBUTE_DATE11

REG_ATTRIBUTE_DATE12

REG_ATTRIBUTE_DATE13

REG_ATTRIBUTE_DATE14

REG_ATTRIBUTE_DATE15

Query

SQL_Statement

SELECT

REG.REGN_ID,

REG.EFFECTIVE_START_DATE,

REG.EFFECTIVE_END_DATE,

TL.NAME,

REG.STTRY_CITN_NAME,

REG.ORGANIZATION_ID,

REG.BUSINESS_GROUP_ID,

REG.REG_ATTRIBUTE_CATEGORY,

REG.REG_ATTRIBUTE1,

REG.REG_ATTRIBUTE2,

REG.REG_ATTRIBUTE3,

REG.REG_ATTRIBUTE4,

REG.REG_ATTRIBUTE5,

REG.REG_ATTRIBUTE6,

REG.REG_ATTRIBUTE7,

REG.REG_ATTRIBUTE8,

REG.REG_ATTRIBUTE9,

REG.REG_ATTRIBUTE10,

REG.REG_ATTRIBUTE11,

REG.REG_ATTRIBUTE12,

REG.REG_ATTRIBUTE13,

REG.REG_ATTRIBUTE14,

REG.REG_ATTRIBUTE15,

REG.REG_ATTRIBUTE16,

REG.REG_ATTRIBUTE17,

REG.REG_ATTRIBUTE18,

REG.REG_ATTRIBUTE19,

REG.REG_ATTRIBUTE20,

REG.REG_ATTRIBUTE21,

REG.REG_ATTRIBUTE22,

REG.REG_ATTRIBUTE23,

REG.REG_ATTRIBUTE24,

REG.REG_ATTRIBUTE25,

REG.REG_ATTRIBUTE26,

REG.REG_ATTRIBUTE27,

REG.REG_ATTRIBUTE28,

REG.REG_ATTRIBUTE29,

REG.REG_ATTRIBUTE30,

REG.LAST_UPDATE_DATE,

REG.LAST_UPDATED_BY,

REG.LAST_UPDATE_LOGIN,

REG.CREATED_BY,

REG.CREATION_DATE,

REG.OBJECT_VERSION_NUMBER,

REG.REG_ATTRIBUTE_NUMBER1,

REG.REG_ATTRIBUTE_NUMBER2,

REG.REG_ATTRIBUTE_NUMBER3,

REG.REG_ATTRIBUTE_NUMBER4,

REG.REG_ATTRIBUTE_NUMBER5,

REG.REG_ATTRIBUTE_NUMBER6,

REG.REG_ATTRIBUTE_NUMBER7,

REG.REG_ATTRIBUTE_NUMBER8,

REG.REG_ATTRIBUTE_NUMBER9,

REG.REG_ATTRIBUTE_NUMBER10,

REG.REG_ATTRIBUTE_NUMBER11,

REG.REG_ATTRIBUTE_NUMBER12,

REG.REG_ATTRIBUTE_NUMBER13,

REG.REG_ATTRIBUTE_NUMBER14,

REG.REG_ATTRIBUTE_NUMBER15,

REG.REG_ATTRIBUTE_NUMBER16,

REG.REG_ATTRIBUTE_NUMBER17,

REG.REG_ATTRIBUTE_NUMBER18,

REG.REG_ATTRIBUTE_NUMBER19,

REG.REG_ATTRIBUTE_NUMBER20,

REG.REG_ATTRIBUTE_DATE1,

REG.REG_ATTRIBUTE_DATE2,

REG.REG_ATTRIBUTE_DATE3,

REG.REG_ATTRIBUTE_DATE4,

REG.REG_ATTRIBUTE_DATE5,

REG.REG_ATTRIBUTE_DATE6,

REG.REG_ATTRIBUTE_DATE7,

REG.REG_ATTRIBUTE_DATE8,

REG.REG_ATTRIBUTE_DATE9,

REG.REG_ATTRIBUTE_DATE10,

REG.REG_ATTRIBUTE_DATE11,

REG.REG_ATTRIBUTE_DATE12,

REG.REG_ATTRIBUTE_DATE13,

REG.REG_ATTRIBUTE_DATE14,

REG.REG_ATTRIBUTE_DATE15

FROM

BEN_REGN_F REG,

BEN_REGN_F_TL TL

WHERE

REG.REGN_ID = TL.REGN_ID AND REG.EFFECTIVE_START_DATE = TL.EFFECTIVE_START_DATE AND TL.LANGUAGE = USERENV('LANG')