View: HR_SUP_LOV_V

Product:	PER - Human Resources
Description:	Used to support user interface.
Implementation/DBA Data:	APPS.HR_SUP_LOV_V

View Text

SELECT DISTINCT PPF.FULL_NAME FULL_NAME
, PPF.LAST_NAME LAST_NAME
, PPF.FIRST_NAME FIRST_NAME
, PPF.ORDER_NAME ORDER_NAME
, PPF.PERSON_ID PERSON_ID
, PPF.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PPF.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PPF.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, DECODE (HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD ('PER_ALL_PEOPLE_F'
, PPF.PERSON_ID
, PPF.PERSON_TYPE_ID
, PPF.EMPLOYEE_NUMBER
, PPF.APPLICANT_NUMBER)) INSIDE_PROFILE
, PPF.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, JBT.NAME JOB_NAME
, ORG.NAME ORGANIZATION
, PPF.EMAIL_ADDRESS EMAIL_ADDRESS
, BUS.NAME BUSINESS_GROUP
, PAF.EFFECTIVE_START_DATE ASN_EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE ASN_EFFECTIVE_END_DATE
, PAF.ASSIGNMENT_NUMBER
, PPF.NPW_NUMBER
, PPF.CURRENT_NPW_FLAG
, PPF.CURRENT_EMPLOYEE_FLAG
, PAF.ASSIGNMENT_TYPE
FROM PER_ALL_PEOPLE_F PPF
, PER_ALL_ASSIGNMENTS_F PAF
, PER_JOBS_TL JBT
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, HR_ALL_ORGANIZATION_UNITS_TL BUS
WHERE ( PPF.CURRENT_EMPLOYEE_FLAG = 'Y' OR PPF.CURRENT_NPW_FLAG = 'Y'
AND NVL(FND_PROFILE.VALUE('HR_TREAT_CWK_AS_EMP')
, 'N') = 'Y')
AND PPF.PERSON_ID = PAF.PERSON_ID
AND PAF.PRIMARY_FLAG = 'Y'
AND PAF.ASSIGNMENT_TYPE IN ('E'
, 'C')
AND PAF.BUSINESS_GROUP_ID = BUS.ORGANIZATION_ID
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