PER_ASSIGN_WORK_MEASURES_F_V

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: VIEW

Columns

Name

ASSIGN_WORK_MEASURE_ID

BUSINESS_GROUP_ID

ASSIGNMENT_ID

UNIT

VALUE

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

OBJECT_VERSION_NUMBER

ADDS_TO_BUDGET

AWM_ATTRIBUTE_CATEGORY

AWM_ATTRIBUTE1

AWM_ATTRIBUTE2

AWM_ATTRIBUTE3

AWM_ATTRIBUTE4

AWM_ATTRIBUTE5

AWM_ATTRIBUTE6

AWM_ATTRIBUTE7

AWM_ATTRIBUTE8

AWM_ATTRIBUTE9

AWM_ATTRIBUTE10

AWM_ATTRIBUTE11

AWM_ATTRIBUTE12

AWM_ATTRIBUTE13

AWM_ATTRIBUTE14

AWM_ATTRIBUTE15

AWM_ATTRIBUTE16

AWM_ATTRIBUTE17

AWM_ATTRIBUTE18

AWM_ATTRIBUTE19

AWM_ATTRIBUTE20

AWM_ATTRIBUTE21

AWM_ATTRIBUTE22

AWM_ATTRIBUTE23

AWM_ATTRIBUTE24

AWM_ATTRIBUTE25

AWM_ATTRIBUTE26

AWM_ATTRIBUTE27

AWM_ATTRIBUTE28

AWM_ATTRIBUTE29

AWM_ATTRIBUTE30

ACTION_OCCURRENCE_ID

AWM_ATTRIBUTE_NUMBER1

AWM_ATTRIBUTE_NUMBER2

AWM_ATTRIBUTE_NUMBER3

AWM_ATTRIBUTE_NUMBER4

AWM_ATTRIBUTE_NUMBER5

AWM_ATTRIBUTE_NUMBER6

AWM_ATTRIBUTE_NUMBER7

AWM_ATTRIBUTE_NUMBER8

AWM_ATTRIBUTE_NUMBER9

AWM_ATTRIBUTE_NUMBER10

AWM_ATTRIBUTE_NUMBER11

AWM_ATTRIBUTE_NUMBER12

AWM_ATTRIBUTE_NUMBER13

AWM_ATTRIBUTE_NUMBER14

AWM_ATTRIBUTE_NUMBER15

AWM_ATTRIBUTE_NUMBER16

AWM_ATTRIBUTE_NUMBER17

AWM_ATTRIBUTE_NUMBER18

AWM_ATTRIBUTE_NUMBER19

AWM_ATTRIBUTE_NUMBER20

AWM_ATTRIBUTE_DATE1

AWM_ATTRIBUTE_DATE2

AWM_ATTRIBUTE_DATE3

AWM_ATTRIBUTE_DATE4

AWM_ATTRIBUTE_DATE5

AWM_ATTRIBUTE_DATE6

AWM_ATTRIBUTE_DATE7

AWM_ATTRIBUTE_DATE8

AWM_ATTRIBUTE_DATE9

AWM_ATTRIBUTE_DATE10

AWM_ATTRIBUTE_DATE11

AWM_ATTRIBUTE_DATE12

AWM_ATTRIBUTE_DATE13

AWM_ATTRIBUTE_DATE14

AWM_ATTRIBUTE_DATE15

Query

SQL_Statement

SELECT

ASSIGN_WORK_MEASURE_ID,

BUSINESS_GROUP_ID,

ASSIGNMENT_ID,

UNIT,

VALUE,

LAST_UPDATE_DATE,

LAST_UPDATED_BY,

LAST_UPDATE_LOGIN,

CREATED_BY,

CREATION_DATE,

EFFECTIVE_START_DATE,

EFFECTIVE_END_DATE,

OBJECT_VERSION_NUMBER,

ADDS_TO_BUDGET,

AWM_ATTRIBUTE_CATEGORY,

AWM_ATTRIBUTE1,

AWM_ATTRIBUTE2,

AWM_ATTRIBUTE3,

AWM_ATTRIBUTE4,

AWM_ATTRIBUTE5,

AWM_ATTRIBUTE6,

AWM_ATTRIBUTE7,

AWM_ATTRIBUTE8,

AWM_ATTRIBUTE9,

AWM_ATTRIBUTE10,

AWM_ATTRIBUTE11,

AWM_ATTRIBUTE12,

AWM_ATTRIBUTE13,

AWM_ATTRIBUTE14,

AWM_ATTRIBUTE15,

AWM_ATTRIBUTE16,

AWM_ATTRIBUTE17,

AWM_ATTRIBUTE18,

AWM_ATTRIBUTE19,

AWM_ATTRIBUTE20,

AWM_ATTRIBUTE21,

AWM_ATTRIBUTE22,

AWM_ATTRIBUTE23,

AWM_ATTRIBUTE24,

AWM_ATTRIBUTE25,

AWM_ATTRIBUTE26,

AWM_ATTRIBUTE27,

AWM_ATTRIBUTE28,

AWM_ATTRIBUTE29,

AWM_ATTRIBUTE30,

ACTION_OCCURRENCE_ID,

AWM_ATTRIBUTE_NUMBER1,

AWM_ATTRIBUTE_NUMBER2,

AWM_ATTRIBUTE_NUMBER3,

AWM_ATTRIBUTE_NUMBER4,

AWM_ATTRIBUTE_NUMBER5,

AWM_ATTRIBUTE_NUMBER6,

AWM_ATTRIBUTE_NUMBER7,

AWM_ATTRIBUTE_NUMBER8,

AWM_ATTRIBUTE_NUMBER9,

AWM_ATTRIBUTE_NUMBER10,

AWM_ATTRIBUTE_NUMBER11,

AWM_ATTRIBUTE_NUMBER12,

AWM_ATTRIBUTE_NUMBER13,

AWM_ATTRIBUTE_NUMBER14,

AWM_ATTRIBUTE_NUMBER15,

AWM_ATTRIBUTE_NUMBER16,

AWM_ATTRIBUTE_NUMBER17,

AWM_ATTRIBUTE_NUMBER18,

AWM_ATTRIBUTE_NUMBER19,

AWM_ATTRIBUTE_NUMBER20,

AWM_ATTRIBUTE_DATE1,

AWM_ATTRIBUTE_DATE2,

AWM_ATTRIBUTE_DATE3,

AWM_ATTRIBUTE_DATE4,

AWM_ATTRIBUTE_DATE5,

AWM_ATTRIBUTE_DATE6,

AWM_ATTRIBUTE_DATE7,

AWM_ATTRIBUTE_DATE8,

AWM_ATTRIBUTE_DATE9,

AWM_ATTRIBUTE_DATE10,

AWM_ATTRIBUTE_DATE11,

AWM_ATTRIBUTE_DATE12,

AWM_ATTRIBUTE_DATE13,

AWM_ATTRIBUTE_DATE14,

AWM_ATTRIBUTE_DATE15

FROM

PER_ASSIGN_WORK_MEASURES_F