[Home] [Help]
View: HR_ASSIGN_LOV_V
Product: | PER - Human Resources |
Description: | Used to support user interface |
Implementation/DBA Data: |
APPS.HR_ASSIGN_LOV_V
|
View Text
SELECT DISTINCT PEO.FULL_NAME FULL_NAME
, PEO.PERSON_ID PERSON_ID
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEO.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PEO.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, JBT.NAME JOB_NAME
, ORG.NAME ORGANIZATION
, PEO.EMAIL_ADDRESS EMAIL_ADDRESS
, BUS.NAME BUSINESS_GROUP
, PAF.EFFECTIVE_START_DATE ASN_EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE ASN_EFFECTIVE_END_DATE
FROM PER_ALL_PEOPLE_F PEO
, PER_ALL_ASSIGNMENTS_F PAF
, PER_JOBS_TL JBT
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, HR_ALL_ORGANIZATION_UNITS_TL BUS
WHERE PEO.PERSON_ID IN ( SELECT PERSON_ID
FROM PER_ALL_ASSIGNMENTS_F
WHERE ASSIGNMENT_TYPE ='E'
AND PRIMARY_FLAG = 'Y')
AND PEO.PERSON_TYPE_ID IN ( SELECT PERSON_TYPE_ID
FROM PER_PERSON_TYPES
WHERE SYSTEM_PERSON_TYPE IN('EMP'
, 'EMP_APL'))
AND PEO.PERSON_ID = PAF.PERSON_ID
AND PAF.BUSINESS_GROUP_ID = BUS.ORGANIZATION_ID
AND PAF.PRIMARY_FLAG = 'Y'
AND PAF.ASSIGNMENT_TYPE = 'E'
AND BUS.LANGUAGE = USERENV('LANG')
AND PAF.JOB_ID = JBT.JOB_ID (+)
AND JBT.LANGUAGE(+) = USERENV('LANG')
AND PAF.ORGANIZATION_ID = ORG.ORGANIZATION_ID (+)
AND ORG.LANGUAGE = USERENV('LANG')
Columns
Name |
FULL_NAME |
PERSON_ID |
BUSINESS_GROUP_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
EMPLOYEE_NUMBER |
JOB_NAME |
ORGANIZATION |
EMAIL_ADDRESS |
BUSINESS_GROUP |
ASN_EFFECTIVE_START_DATE |
ASN_EFFECTIVE_END_DATE |