PAY_ELE_CLASSIFICATIONS

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
CLASSIFICATION_ID DATE_FROM DATE_TO BASE_CLASSIFICATION_NAME CLASSIFICATION_NAME DESCRIPTION LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID NON_PAYMENTS_FLAG DEFAULT_LOW_PRIORITY DEFAULT_PRIORITY DEFAULT_HIGH_PRIORITY COSTABLE_FLAG COSTING_DEBIT_OR_CREDIT DISTRIBUTABLE_OVER_FLAG FREQ_RULE_ENABLED PROCESS_WHEN_EARNING PARENT_CLASSIFICATION_ID SECONDARY_CLASSIFICATION_FLAG CREATE_BY_DEFAULT_FLAG BASE_CLASSIFICATION_ID MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE OBJECT_VERSION_NUMBER PEC_INFORMATION_CATEGORY PEC_INFORMATION1 PEC_INFORMATION2 PEC_INFORMATION3 PEC_INFORMATION4 PEC_INFORMATION5 PEC_INFORMATION6 PEC_INFORMATION7 PEC_INFORMATION8 PEC_INFORMATION9 PEC_INFORMATION10 PEC_INFORMATION11 PEC_INFORMATION12 PEC_INFORMATION13 PEC_INFORMATION14 PEC_INFORMATION15 PEC_INFORMATION16 PEC_INFORMATION17 PEC_INFORMATION18 PEC_INFORMATION19 PEC_INFORMATION20 PEC_INFORMATION21 PEC_INFORMATION22 PEC_INFORMATION23 PEC_INFORMATION24 PEC_INFORMATION25 PEC_INFORMATION26 PEC_INFORMATION27 PEC_INFORMATION28 PEC_INFORMATION29 PEC_INFORMATION30 PEC_INFORMATION_NUMBER1 PEC_INFORMATION_NUMBER2 PEC_INFORMATION_NUMBER3 PEC_INFORMATION_NUMBER4 PEC_INFORMATION_NUMBER5 PEC_INFORMATION_NUMBER6 PEC_INFORMATION_NUMBER7 PEC_INFORMATION_NUMBER8 PEC_INFORMATION_NUMBER9 PEC_INFORMATION_NUMBER10 PEC_INFORMATION_NUMBER11 PEC_INFORMATION_NUMBER12 PEC_INFORMATION_NUMBER13 PEC_INFORMATION_NUMBER14 PEC_INFORMATION_NUMBER15 PEC_INFORMATION_NUMBER16 PEC_INFORMATION_NUMBER17 PEC_INFORMATION_NUMBER18 PEC_INFORMATION_NUMBER19 PEC_INFORMATION_NUMBER20 PEC_INFORMATION_DATE1 PEC_INFORMATION_DATE2 PEC_INFORMATION_DATE3 PEC_INFORMATION_DATE4 PEC_INFORMATION_DATE5 PEC_INFORMATION_DATE6 PEC_INFORMATION_DATE7 PEC_INFORMATION_DATE8 PEC_INFORMATION_DATE9 PEC_INFORMATION_DATE10 PEC_INFORMATION_DATE11 PEC_INFORMATION_DATE12 PEC_INFORMATION_DATE13 PEC_INFORMATION_DATE14 PEC_INFORMATION_DATE15

Name

CLASSIFICATION_ID

DATE_FROM

DATE_TO

BASE_CLASSIFICATION_NAME

CLASSIFICATION_NAME

DESCRIPTION

LEGISLATIVE_DATA_GROUP_ID

LEGISLATION_CODE

ENTERPRISE_ID

NON_PAYMENTS_FLAG

DEFAULT_LOW_PRIORITY

DEFAULT_PRIORITY

DEFAULT_HIGH_PRIORITY

COSTABLE_FLAG

COSTING_DEBIT_OR_CREDIT

DISTRIBUTABLE_OVER_FLAG

FREQ_RULE_ENABLED

PROCESS_WHEN_EARNING

PARENT_CLASSIFICATION_ID

SECONDARY_CLASSIFICATION_FLAG

CREATE_BY_DEFAULT_FLAG

BASE_CLASSIFICATION_ID

MODULE_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

LAST_UPDATE_DATE

OBJECT_VERSION_NUMBER

PEC_INFORMATION_CATEGORY

PEC_INFORMATION1

PEC_INFORMATION2

PEC_INFORMATION3

PEC_INFORMATION4

PEC_INFORMATION5

PEC_INFORMATION6

PEC_INFORMATION7

PEC_INFORMATION8

PEC_INFORMATION9

PEC_INFORMATION10

PEC_INFORMATION11

PEC_INFORMATION12

PEC_INFORMATION13

PEC_INFORMATION14

PEC_INFORMATION15

PEC_INFORMATION16

PEC_INFORMATION17

PEC_INFORMATION18

PEC_INFORMATION19

PEC_INFORMATION20

PEC_INFORMATION21

PEC_INFORMATION22

PEC_INFORMATION23

PEC_INFORMATION24

PEC_INFORMATION25

PEC_INFORMATION26

PEC_INFORMATION27

PEC_INFORMATION28

PEC_INFORMATION29

PEC_INFORMATION30

PEC_INFORMATION_NUMBER1

PEC_INFORMATION_NUMBER2

PEC_INFORMATION_NUMBER3

PEC_INFORMATION_NUMBER4

PEC_INFORMATION_NUMBER5

PEC_INFORMATION_NUMBER6

PEC_INFORMATION_NUMBER7

PEC_INFORMATION_NUMBER8

PEC_INFORMATION_NUMBER9

PEC_INFORMATION_NUMBER10

PEC_INFORMATION_NUMBER11

PEC_INFORMATION_NUMBER12

PEC_INFORMATION_NUMBER13

PEC_INFORMATION_NUMBER14

PEC_INFORMATION_NUMBER15

PEC_INFORMATION_NUMBER16

PEC_INFORMATION_NUMBER17

PEC_INFORMATION_NUMBER18

PEC_INFORMATION_NUMBER19

PEC_INFORMATION_NUMBER20

PEC_INFORMATION_DATE1

PEC_INFORMATION_DATE2

PEC_INFORMATION_DATE3

PEC_INFORMATION_DATE4

PEC_INFORMATION_DATE5

PEC_INFORMATION_DATE6

PEC_INFORMATION_DATE7

PEC_INFORMATION_DATE8

PEC_INFORMATION_DATE9

PEC_INFORMATION_DATE10

PEC_INFORMATION_DATE11

PEC_INFORMATION_DATE12

PEC_INFORMATION_DATE13

PEC_INFORMATION_DATE14

PEC_INFORMATION_DATE15

Query

SQL_Statement
SELECT pec.CLASSIFICATION_ID CLASSIFICATION_ID, pec.DATE_FROM DATE_FROM, pec.DATE_TO DATE_TO, pec.BASE_CLASSIFICATION_NAME BASE_CLASSIFICATION_NAME, pectl.CLASSIFICATION_NAME CLASSIFICATION_NAME, pectl.DESCRIPTION DESCRIPTION, pec.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, pec.LEGISLATION_CODE LEGISLATION_CODE, pec.ENTERPRISE_ID ENTERPRISE_ID, pec.NON_PAYMENTS_FLAG NON_PAYMENTS_FLAG, pec.DEFAULT_LOW_PRIORITY DEFAULT_LOW_PRIORITY, pec.DEFAULT_PRIORITY DEFAULT_PRIORITY, pec.DEFAULT_HIGH_PRIORITY DEFAULT_HIGH_PRIORITY, pec.COSTABLE_FLAG COSTABLE_FLAG, pec.COSTING_DEBIT_OR_CREDIT COSTING_DEBIT_OR_CREDIT, pec.DISTRIBUTABLE_OVER_FLAG DISTRIBUTABLE_OVER_FLAG, pec.FREQ_RULE_ENABLED FREQ_RULE_ENABLED, pec.PROCESS_WHEN_EARNING PROCESS_WHEN_EARNING, pec.PARENT_CLASSIFICATION_ID PARENT_CLASSIFICATION_ID, pec.SECONDARY_CLASSIFICATION_FLAG SECONDARY_CLASSIFICATION_FLAG, pec.CREATE_BY_DEFAULT_FLAG CREATE_BY_DEFAULT_FLAG, pec.BASE_CLASSIFICATION_ID BASE_CLASSIFICATION_ID, pec.MODULE_ID MODULE_ID, pec.CREATED_BY CREATED_BY, pec.CREATION_DATE CREATION_DATE, pec.LAST_UPDATED_BY LAST_UPDATED_BY, pec.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pec.LAST_UPDATE_DATE LAST_UPDATE_DATE, pec.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, pec.PEC_INFORMATION_CATEGORY PEC_INFORMATION_CATEGORY, pec.PEC_INFORMATION1 PEC_INFORMATION1, pec.PEC_INFORMATION2 PEC_INFORMATION2, pec.PEC_INFORMATION3 PEC_INFORMATION3, pec.PEC_INFORMATION4 PEC_INFORMATION4, pec.PEC_INFORMATION5 PEC_INFORMATION5, pec.PEC_INFORMATION6 PEC_INFORMATION6, pec.PEC_INFORMATION7 PEC_INFORMATION7, pec.PEC_INFORMATION8 PEC_INFORMATION8, pec.PEC_INFORMATION9 PEC_INFORMATION9, pec.PEC_INFORMATION10 PEC_INFORMATION10, pec.PEC_INFORMATION11 PEC_INFORMATION11, pec.PEC_INFORMATION12 PEC_INFORMATION12, pec.PEC_INFORMATION13 PEC_INFORMATION13, pec.PEC_INFORMATION14 PEC_INFORMATION14, pec.PEC_INFORMATION15 PEC_INFORMATION15, pec.PEC_INFORMATION16 PEC_INFORMATION16, pec.PEC_INFORMATION17 PEC_INFORMATION17, pec.PEC_INFORMATION18 PEC_INFORMATION18, pec.PEC_INFORMATION19 PEC_INFORMATION19, pec.PEC_INFORMATION20 PEC_INFORMATION20, pec.PEC_INFORMATION21 PEC_INFORMATION21, pec.PEC_INFORMATION22 PEC_INFORMATION22, pec.PEC_INFORMATION23 PEC_INFORMATION23, pec.PEC_INFORMATION24 PEC_INFORMATION24, pec.PEC_INFORMATION25 PEC_INFORMATION25, pec.PEC_INFORMATION26 PEC_INFORMATION26, pec.PEC_INFORMATION27 PEC_INFORMATION27, pec.PEC_INFORMATION28 PEC_INFORMATION28, pec.PEC_INFORMATION29 PEC_INFORMATION29, pec.PEC_INFORMATION30 PEC_INFORMATION30, pec.PEC_INFORMATION_NUMBER1 PEC_INFORMATION_NUMBER1, pec.PEC_INFORMATION_NUMBER2 PEC_INFORMATION_NUMBER2, pec.PEC_INFORMATION_NUMBER3 PEC_INFORMATION_NUMBER3, pec.PEC_INFORMATION_NUMBER4 PEC_INFORMATION_NUMBER4, pec.PEC_INFORMATION_NUMBER5 PEC_INFORMATION_NUMBER5, pec.PEC_INFORMATION_NUMBER6 PEC_INFORMATION_NUMBER6, pec.PEC_INFORMATION_NUMBER7 PEC_INFORMATION_NUMBER7, pec.PEC_INFORMATION_NUMBER8 PEC_INFORMATION_NUMBER8, pec.PEC_INFORMATION_NUMBER9 PEC_INFORMATION_NUMBER9, pec.PEC_INFORMATION_NUMBER10 PEC_INFORMATION_NUMBER10, pec.PEC_INFORMATION_NUMBER11 PEC_INFORMATION_NUMBER11, pec.PEC_INFORMATION_NUMBER12 PEC_INFORMATION_NUMBER12, pec.PEC_INFORMATION_NUMBER13 PEC_INFORMATION_NUMBER13, pec.PEC_INFORMATION_NUMBER14 PEC_INFORMATION_NUMBER14, pec.PEC_INFORMATION_NUMBER15 PEC_INFORMATION_NUMBER15, pec.PEC_INFORMATION_NUMBER16 PEC_INFORMATION_NUMBER16, pec.PEC_INFORMATION_NUMBER17 PEC_INFORMATION_NUMBER17, pec.PEC_INFORMATION_NUMBER18 PEC_INFORMATION_NUMBER18, pec.PEC_INFORMATION_NUMBER19 PEC_INFORMATION_NUMBER19, pec.PEC_INFORMATION_NUMBER20 PEC_INFORMATION_NUMBER20, pec.PEC_INFORMATION_DATE1 PEC_INFORMATION_DATE1, pec.PEC_INFORMATION_DATE2 PEC_INFORMATION_DATE2, pec.PEC_INFORMATION_DATE3 PEC_INFORMATION_DATE3, pec.PEC_INFORMATION_DATE4 PEC_INFORMATION_DATE4, pec.PEC_INFORMATION_DATE5 PEC_INFORMATION_DATE5, pec.PEC_INFORMATION_DATE6 PEC_INFORMATION_DATE6, pec.PEC_INFORMATION_DATE7 PEC_INFORMATION_DATE7, pec.PEC_INFORMATION_DATE8 PEC_INFORMATION_DATE8, pec.PEC_INFORMATION_DATE9 PEC_INFORMATION_DATE9, pec.PEC_INFORMATION_DATE10 PEC_INFORMATION_DATE10, pec.PEC_INFORMATION_DATE11 PEC_INFORMATION_DATE11, pec.PEC_INFORMATION_DATE12 PEC_INFORMATION_DATE12, pec.PEC_INFORMATION_DATE13 PEC_INFORMATION_DATE13, pec.PEC_INFORMATION_DATE14 PEC_INFORMATION_DATE14, pec.PEC_INFORMATION_DATE15 PEC_INFORMATION_DATE15 FROM PAY_ELE_CLASSIFICATIONS pec, PAY_ELE_CLASSIFICATIONS_TL pectl WHERE pectl.CLASSIFICATION_ID = pec.CLASSIFICATION_ID AND pectl.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

pec.CLASSIFICATION_ID CLASSIFICATION_ID,

pec.DATE_FROM DATE_FROM,

pec.DATE_TO DATE_TO,

pec.BASE_CLASSIFICATION_NAME BASE_CLASSIFICATION_NAME,

pectl.CLASSIFICATION_NAME CLASSIFICATION_NAME,

pectl.DESCRIPTION DESCRIPTION,

pec.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID,

pec.LEGISLATION_CODE LEGISLATION_CODE,

pec.ENTERPRISE_ID ENTERPRISE_ID,

pec.NON_PAYMENTS_FLAG NON_PAYMENTS_FLAG,

pec.DEFAULT_LOW_PRIORITY DEFAULT_LOW_PRIORITY,

pec.DEFAULT_PRIORITY DEFAULT_PRIORITY,

pec.DEFAULT_HIGH_PRIORITY DEFAULT_HIGH_PRIORITY,

pec.COSTABLE_FLAG COSTABLE_FLAG,

pec.COSTING_DEBIT_OR_CREDIT COSTING_DEBIT_OR_CREDIT,

pec.DISTRIBUTABLE_OVER_FLAG DISTRIBUTABLE_OVER_FLAG,

pec.FREQ_RULE_ENABLED FREQ_RULE_ENABLED,

pec.PROCESS_WHEN_EARNING PROCESS_WHEN_EARNING,

pec.PARENT_CLASSIFICATION_ID PARENT_CLASSIFICATION_ID,

pec.SECONDARY_CLASSIFICATION_FLAG SECONDARY_CLASSIFICATION_FLAG,

pec.CREATE_BY_DEFAULT_FLAG CREATE_BY_DEFAULT_FLAG,

pec.BASE_CLASSIFICATION_ID BASE_CLASSIFICATION_ID,

pec.MODULE_ID MODULE_ID,

pec.CREATED_BY CREATED_BY,

pec.CREATION_DATE CREATION_DATE,

pec.LAST_UPDATED_BY LAST_UPDATED_BY,

pec.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

pec.LAST_UPDATE_DATE LAST_UPDATE_DATE,

pec.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

pec.PEC_INFORMATION_CATEGORY PEC_INFORMATION_CATEGORY,

pec.PEC_INFORMATION1 PEC_INFORMATION1,

pec.PEC_INFORMATION2 PEC_INFORMATION2,

pec.PEC_INFORMATION3 PEC_INFORMATION3,

pec.PEC_INFORMATION4 PEC_INFORMATION4,

pec.PEC_INFORMATION5 PEC_INFORMATION5,

pec.PEC_INFORMATION6 PEC_INFORMATION6,

pec.PEC_INFORMATION7 PEC_INFORMATION7,

pec.PEC_INFORMATION8 PEC_INFORMATION8,

pec.PEC_INFORMATION9 PEC_INFORMATION9,

pec.PEC_INFORMATION10 PEC_INFORMATION10,

pec.PEC_INFORMATION11 PEC_INFORMATION11,

pec.PEC_INFORMATION12 PEC_INFORMATION12,

pec.PEC_INFORMATION13 PEC_INFORMATION13,

pec.PEC_INFORMATION14 PEC_INFORMATION14,

pec.PEC_INFORMATION15 PEC_INFORMATION15,

pec.PEC_INFORMATION16 PEC_INFORMATION16,

pec.PEC_INFORMATION17 PEC_INFORMATION17,

pec.PEC_INFORMATION18 PEC_INFORMATION18,

pec.PEC_INFORMATION19 PEC_INFORMATION19,

pec.PEC_INFORMATION20 PEC_INFORMATION20,

pec.PEC_INFORMATION21 PEC_INFORMATION21,

pec.PEC_INFORMATION22 PEC_INFORMATION22,

pec.PEC_INFORMATION23 PEC_INFORMATION23,

pec.PEC_INFORMATION24 PEC_INFORMATION24,

pec.PEC_INFORMATION25 PEC_INFORMATION25,

pec.PEC_INFORMATION26 PEC_INFORMATION26,

pec.PEC_INFORMATION27 PEC_INFORMATION27,

pec.PEC_INFORMATION28 PEC_INFORMATION28,

pec.PEC_INFORMATION29 PEC_INFORMATION29,

pec.PEC_INFORMATION30 PEC_INFORMATION30,

pec.PEC_INFORMATION_NUMBER1 PEC_INFORMATION_NUMBER1,

pec.PEC_INFORMATION_NUMBER2 PEC_INFORMATION_NUMBER2,

pec.PEC_INFORMATION_NUMBER3 PEC_INFORMATION_NUMBER3,

pec.PEC_INFORMATION_NUMBER4 PEC_INFORMATION_NUMBER4,

pec.PEC_INFORMATION_NUMBER5 PEC_INFORMATION_NUMBER5,

pec.PEC_INFORMATION_NUMBER6 PEC_INFORMATION_NUMBER6,

pec.PEC_INFORMATION_NUMBER7 PEC_INFORMATION_NUMBER7,

pec.PEC_INFORMATION_NUMBER8 PEC_INFORMATION_NUMBER8,

pec.PEC_INFORMATION_NUMBER9 PEC_INFORMATION_NUMBER9,

pec.PEC_INFORMATION_NUMBER10 PEC_INFORMATION_NUMBER10,

pec.PEC_INFORMATION_NUMBER11 PEC_INFORMATION_NUMBER11,

pec.PEC_INFORMATION_NUMBER12 PEC_INFORMATION_NUMBER12,

pec.PEC_INFORMATION_NUMBER13 PEC_INFORMATION_NUMBER13,

pec.PEC_INFORMATION_NUMBER14 PEC_INFORMATION_NUMBER14,

pec.PEC_INFORMATION_NUMBER15 PEC_INFORMATION_NUMBER15,

pec.PEC_INFORMATION_NUMBER16 PEC_INFORMATION_NUMBER16,

pec.PEC_INFORMATION_NUMBER17 PEC_INFORMATION_NUMBER17,

pec.PEC_INFORMATION_NUMBER18 PEC_INFORMATION_NUMBER18,

pec.PEC_INFORMATION_NUMBER19 PEC_INFORMATION_NUMBER19,

pec.PEC_INFORMATION_NUMBER20 PEC_INFORMATION_NUMBER20,

pec.PEC_INFORMATION_DATE1 PEC_INFORMATION_DATE1,

pec.PEC_INFORMATION_DATE2 PEC_INFORMATION_DATE2,

pec.PEC_INFORMATION_DATE3 PEC_INFORMATION_DATE3,

pec.PEC_INFORMATION_DATE4 PEC_INFORMATION_DATE4,

pec.PEC_INFORMATION_DATE5 PEC_INFORMATION_DATE5,

pec.PEC_INFORMATION_DATE6 PEC_INFORMATION_DATE6,

pec.PEC_INFORMATION_DATE7 PEC_INFORMATION_DATE7,

pec.PEC_INFORMATION_DATE8 PEC_INFORMATION_DATE8,

pec.PEC_INFORMATION_DATE9 PEC_INFORMATION_DATE9,

pec.PEC_INFORMATION_DATE10 PEC_INFORMATION_DATE10,

pec.PEC_INFORMATION_DATE11 PEC_INFORMATION_DATE11,

pec.PEC_INFORMATION_DATE12 PEC_INFORMATION_DATE12,

pec.PEC_INFORMATION_DATE13 PEC_INFORMATION_DATE13,

pec.PEC_INFORMATION_DATE14 PEC_INFORMATION_DATE14,

pec.PEC_INFORMATION_DATE15 PEC_INFORMATION_DATE15

FROM

PAY_ELE_CLASSIFICATIONS pec,

PAY_ELE_CLASSIFICATIONS_TL pectl

WHERE

pectl.CLASSIFICATION_ID = pec.CLASSIFICATION_ID AND pectl.LANGUAGE = USERENV('LANG')