VIEW: APPS.HR_SUP_LOV_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')