1. Tables and Views for HCM
  2. HR_ORG_CLASSIFICATIONS_VL

HR_ORG_CLASSIFICATIONS_VL

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

CLASSIFICATION_CODE

CLASSIFICATION_NAME

MODULE_ID

DESCRIPTION

BUSINESS_GROUP_ID

LEGISLATION_CODE

SET_ENABLED_FLAG

ENABLED_FLAG

INFORMATION_CATEGORY

INFORMATION1

INFORMATION2

INFORMATION3

INFORMATION4

INFORMATION5

INFORMATION6

INFORMATION7

INFORMATION8

INFORMATION9

INFORMATION10

INFORMATION11

INFORMATION12

INFORMATION13

INFORMATION14

INFORMATION15

INFORMATION16

INFORMATION17

INFORMATION18

INFORMATION19

INFORMATION20

INFORMATION21

INFORMATION22

INFORMATION23

INFORMATION24

INFORMATION25

INFORMATION26

INFORMATION27

INFORMATION28

INFORMATION29

INFORMATION30

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ALLOW_IN_SELECT_ORG_CLASS_YN

AGGREGATE_FLAG

Query

SQL_Statement

SELECT

oc.CLASSIFICATION_CODE,

oct.CLASSIFICATION_NAME,

oc.MODULE_ID,

oct.DESCRIPTION,

oc.BUSINESS_GROUP_ID,

oc.LEGISLATION_CODE,

oc.SET_ENABLED_FLAG,

oc.ENABLED_FLAG,

oc.INFORMATION_CATEGORY,

oc.INFORMATION1,

oc.INFORMATION2,

oc.INFORMATION3,

oc.INFORMATION4,

oc.INFORMATION5,

oc.INFORMATION6,

oc.INFORMATION7,

oc.INFORMATION8,

oc.INFORMATION9,

oc.INFORMATION10,

oc.INFORMATION11,

oc.INFORMATION12,

oc.INFORMATION13,

oc.INFORMATION14,

oc.INFORMATION15,

oc.INFORMATION16,

oc.INFORMATION17,

oc.INFORMATION18,

oc.INFORMATION19,

oc.INFORMATION20,

oc.INFORMATION21,

oc.INFORMATION22,

oc.INFORMATION23,

oc.INFORMATION24,

oc.INFORMATION25,

oc.INFORMATION26,

oc.INFORMATION27,

oc.INFORMATION28,

oc.INFORMATION29,

oc.INFORMATION30,

oc.OBJECT_VERSION_NUMBER,

oc.CREATED_BY,

oc.CREATION_DATE,

oc.LAST_UPDATED_BY,

oc.LAST_UPDATE_DATE,

oc.LAST_UPDATE_LOGIN,

oc.ALLOW_IN_SELECT_ORG_CLASS_YN,

oc.AGGREGATE_FLAG

FROM

HR_ORG_CLASSIFICATIONS oc,

HR_ORG_CLASSIFICATIONS_TL oct

WHERE

oc.CLASSIFICATION_CODE = oct.CLASSIFICATION_CODE AND oct.LANGUAGE = SYS_CONTEXT('USERENV', 'LANG')