VIEW: HR.PER_EMPDIR_ASSIGNMENTS#

Source

View Text - Preformatted

select ORIG_SYSTEM ORIG_SYSTEM, ORIG_SYSTEM_ID ORIG_SYSTEM_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, POSITION_ID POSITION_ID, JOB_ID JOB_ID, LOCATION_ID LOCATION_ID, SUPERVISOR_ID SUPERVISOR_ID, SUPERVISOR_ASSIGNMENT_ID SUPERVISOR_ASSIGNMENT_ID, PERSON_ID PERSON_ID, ORGANIZATION_ID ORGANIZATION_ID, PRIMARY_FLAG PRIMARY_FLAG, ACTIVE ACTIVE, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER, DISCRETIONARY_TITLE DISCRETIONARY_TITLE, EMPLOYEE_CATEGORY EMPLOYEE_CATEGORY, EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY, ASSIGNMENT_CATEGORY ASSIGNMENT_CATEGORY, WORK_AT_HOME WORK_AT_HOME, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PARTITION_ID PARTITION_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, ASS_ATTRIBUTE_CATEGORY ASS_ATTRIBUTE_CATEGORY, ASS_ATTRIBUTE1 ASS_ATTRIBUTE1, ASS_ATTRIBUTE2 ASS_ATTRIBUTE2, ASS_ATTRIBUTE3 ASS_ATTRIBUTE3, ASS_ATTRIBUTE4 ASS_ATTRIBUTE4, ASS_ATTRIBUTE5 ASS_ATTRIBUTE5, ASS_ATTRIBUTE6 ASS_ATTRIBUTE6, ASS_ATTRIBUTE7 ASS_ATTRIBUTE7, ASS_ATTRIBUTE8 ASS_ATTRIBUTE8, ASS_ATTRIBUTE9 ASS_ATTRIBUTE9, ASS_ATTRIBUTE10 ASS_ATTRIBUTE10, ASS_ATTRIBUTE11 ASS_ATTRIBUTE11, ASS_ATTRIBUTE12 ASS_ATTRIBUTE12, ASS_ATTRIBUTE13 ASS_ATTRIBUTE13, ASS_ATTRIBUTE14 ASS_ATTRIBUTE14, ASS_ATTRIBUTE15 ASS_ATTRIBUTE15, ASS_ATTRIBUTE16 ASS_ATTRIBUTE16, ASS_ATTRIBUTE17 ASS_ATTRIBUTE17, ASS_ATTRIBUTE18 ASS_ATTRIBUTE18, ASS_ATTRIBUTE19 ASS_ATTRIBUTE19, ASS_ATTRIBUTE20 ASS_ATTRIBUTE20, ASS_ATTRIBUTE21 ASS_ATTRIBUTE21, ASS_ATTRIBUTE22 ASS_ATTRIBUTE22, ASS_ATTRIBUTE23 ASS_ATTRIBUTE23, ASS_ATTRIBUTE24 ASS_ATTRIBUTE24, ASS_ATTRIBUTE25 ASS_ATTRIBUTE25, ASS_ATTRIBUTE26 ASS_ATTRIBUTE26, ASS_ATTRIBUTE27 ASS_ATTRIBUTE27, ASS_ATTRIBUTE28 ASS_ATTRIBUTE28, ASS_ATTRIBUTE29 ASS_ATTRIBUTE29, ASS_ATTRIBUTE30 ASS_ATTRIBUTE30 from "HR"."PER_EMPDIR_ASSIGNMENTS"

View Text - HTML Formatted

SELECT ORIG_SYSTEM ORIG_SYSTEM
, ORIG_SYSTEM_ID ORIG_SYSTEM_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, POSITION_ID POSITION_ID
, JOB_ID JOB_ID
, LOCATION_ID LOCATION_ID
, SUPERVISOR_ID SUPERVISOR_ID
, SUPERVISOR_ASSIGNMENT_ID SUPERVISOR_ASSIGNMENT_ID
, PERSON_ID PERSON_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PRIMARY_FLAG PRIMARY_FLAG
, ACTIVE ACTIVE
, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, DISCRETIONARY_TITLE DISCRETIONARY_TITLE
, EMPLOYEE_CATEGORY EMPLOYEE_CATEGORY
, EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY
, ASSIGNMENT_CATEGORY ASSIGNMENT_CATEGORY
, WORK_AT_HOME WORK_AT_HOME
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PARTITION_ID PARTITION_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, ASS_ATTRIBUTE_CATEGORY ASS_ATTRIBUTE_CATEGORY
, ASS_ATTRIBUTE1 ASS_ATTRIBUTE1
, ASS_ATTRIBUTE2 ASS_ATTRIBUTE2
, ASS_ATTRIBUTE3 ASS_ATTRIBUTE3
, ASS_ATTRIBUTE4 ASS_ATTRIBUTE4
, ASS_ATTRIBUTE5 ASS_ATTRIBUTE5
, ASS_ATTRIBUTE6 ASS_ATTRIBUTE6
, ASS_ATTRIBUTE7 ASS_ATTRIBUTE7
, ASS_ATTRIBUTE8 ASS_ATTRIBUTE8
, ASS_ATTRIBUTE9 ASS_ATTRIBUTE9
, ASS_ATTRIBUTE10 ASS_ATTRIBUTE10
, ASS_ATTRIBUTE11 ASS_ATTRIBUTE11
, ASS_ATTRIBUTE12 ASS_ATTRIBUTE12
, ASS_ATTRIBUTE13 ASS_ATTRIBUTE13
, ASS_ATTRIBUTE14 ASS_ATTRIBUTE14
, ASS_ATTRIBUTE15 ASS_ATTRIBUTE15
, ASS_ATTRIBUTE16 ASS_ATTRIBUTE16
, ASS_ATTRIBUTE17 ASS_ATTRIBUTE17
, ASS_ATTRIBUTE18 ASS_ATTRIBUTE18
, ASS_ATTRIBUTE19 ASS_ATTRIBUTE19
, ASS_ATTRIBUTE20 ASS_ATTRIBUTE20
, ASS_ATTRIBUTE21 ASS_ATTRIBUTE21
, ASS_ATTRIBUTE22 ASS_ATTRIBUTE22
, ASS_ATTRIBUTE23 ASS_ATTRIBUTE23
, ASS_ATTRIBUTE24 ASS_ATTRIBUTE24
, ASS_ATTRIBUTE25 ASS_ATTRIBUTE25
, ASS_ATTRIBUTE26 ASS_ATTRIBUTE26
, ASS_ATTRIBUTE27 ASS_ATTRIBUTE27
, ASS_ATTRIBUTE28 ASS_ATTRIBUTE28
, ASS_ATTRIBUTE29 ASS_ATTRIBUTE29
, ASS_ATTRIBUTE30 ASS_ATTRIBUTE30
FROM "HR"."PER_EMPDIR_ASSIGNMENTS"