INV_EMPLOYEES_CURRENT

Details

Schema: FUSION
Object owner: INV
Object type: VIEW

Columns

Name
ORGANIZATION_ID BUSINESS_GROUP_ID ORG_ID PERSON_ID ASSIGNMENT_ID LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY WORKER_NUMBER FULL_NAME FIRST_NAME MIDDLE_NAMES LAST_NAME TITLE LOCATION_ID SUPERVISOR_ID SET_OF_BOOKS_ID DEFAULT_CODE_COMB_ID ACTUAL_TERMINATION_DATE EMAIL_ADDRESS ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE_CATEGORY GLOBAL_NAME

Name

ORGANIZATION_ID

BUSINESS_GROUP_ID

ORG_ID

PERSON_ID

ASSIGNMENT_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATION_DATE

CREATED_BY

WORKER_NUMBER

FULL_NAME

FIRST_NAME

MIDDLE_NAMES

LAST_NAME

TITLE

LOCATION_ID

SUPERVISOR_ID

SET_OF_BOOKS_ID

DEFAULT_CODE_COMB_ID

ACTUAL_TERMINATION_DATE

EMAIL_ADDRESS

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE_CATEGORY

GLOBAL_NAME

Query

SQL_Statement
SELECT org.organization_id,p.business_group_id,p.organization_id org_id,p.person_id,p.assignment_id,p.last_update_date,p.last_updated_by,p.last_update_login,p.creation_date,p.created_by,p.worker_number,p.full_name,p.first_name,p.middle_names,p.last_name,p.title,p.location_id,p.supervisor_id,p.set_of_books_id,p.default_code_comb_id,p.actual_termination_date,p.email_address,p.attribute1,p.attribute2,p.attribute3,p.attribute4,p.attribute5,p.attribute6,p.attribute7,p.attribute8,p.attribute9,p.attribute10,p.attribute11,p.attribute12,p.attribute13,p.attribute14,p.attribute15,p.attribute16,p.attribute17,p.attribute18,p.attribute19,p.attribute20,p.attribute_category,p.global_name FROM per_employees_current_x p,hr_organization_units org WHERE org.business_group_id=p.business_group_id+0 UNION SELECT org.organization_id,cw.business_group_id,cw.organization_id org_id,cw.person_id,cw.assignment_id,cw.last_update_date, cw.last_updated_by,cw.last_update_login,cw.creation_date,cw.created_by,cw.worker_number,cw.full_name,cw.first_name,cw.middle_names,cw.last_name,null as title,cw.location_id,cw.supervisor_id,cw.set_of_books_id,cw.default_code_comb_id,cw.actual_termination_date,cw.email_address,cw.attribute1,cw.attribute2,cw.attribute3,cw.attribute4,cw.attribute5,cw.attribute6,cw.attribute7,cw.attribute8,cw.attribute9,cw.attribute10,cw.attribute11,cw.attribute12,cw.attribute13,cw.attribute14,cw.attribute15,cw.attribute16,cw.attribute17,cw.attribute18,cw.attribute19,cw.attribute20,cw.attribute_category,cw.global_name FROM PER_CONT_WORKERS_CURRENT_X cw,hr_organization_units org WHERE org.business_group_id = cw.business_group_id + 0

SQL_Statement

SELECT org.organization_id,p.business_group_id,p.organization_id org_id,p.person_id,p.assignment_id,p.last_update_date,p.last_updated_by,p.last_update_login,p.creation_date,p.created_by,p.worker_number,p.full_name,p.first_name,p.middle_names,p.last_name,p.title,p.location_id,p.supervisor_id,p.set_of_books_id,p.default_code_comb_id,p.actual_termination_date,p.email_address,p.attribute1,p.attribute2,p.attribute3,p.attribute4,p.attribute5,p.attribute6,p.attribute7,p.attribute8,p.attribute9,p.attribute10,p.attribute11,p.attribute12,p.attribute13,p.attribute14,p.attribute15,p.attribute16,p.attribute17,p.attribute18,p.attribute19,p.attribute20,p.attribute_category,p.global_name FROM per_employees_current_x p,hr_organization_units org WHERE org.business_group_id=p.business_group_id+0

UNION

SELECT org.organization_id,cw.business_group_id,cw.organization_id org_id,cw.person_id,cw.assignment_id,cw.last_update_date, cw.last_updated_by,cw.last_update_login,cw.creation_date,cw.created_by,cw.worker_number,cw.full_name,cw.first_name,cw.middle_names,cw.last_name,null as title,cw.location_id,cw.supervisor_id,cw.set_of_books_id,cw.default_code_comb_id,cw.actual_termination_date,cw.email_address,cw.attribute1,cw.attribute2,cw.attribute3,cw.attribute4,cw.attribute5,cw.attribute6,cw.attribute7,cw.attribute8,cw.attribute9,cw.attribute10,cw.attribute11,cw.attribute12,cw.attribute13,cw.attribute14,cw.attribute15,cw.attribute16,cw.attribute17,cw.attribute18,cw.attribute19,cw.attribute20,cw.attribute_category,cw.global_name

FROM PER_CONT_WORKERS_CURRENT_X cw,hr_organization_units org WHERE org.business_group_id = cw.business_group_id + 0