VIEW: APPS.PER_LETTER_REQ_LINES_LOV

Source

View Text - Preformatted

SELECT ASS.ASSIGNMENT_STATUS_TYPE_ID , PP.FULL_NAME , PP.ORDER_NAME , PP.EMPLOYEE_NUMBER , PP.APPLICANT_NUMBER , PP.NPW_NUMBER , hr_person_type_usage_info.get_user_person_type(PP.effective_start_date, PP.person_id) USER_PERSON_TYPE , ASS.ASSIGNMENT_ID , PP.PERSON_ID , ORGTL.NAME , GRP.GROUP_NAME , JBT.NAME , PFT.NAME , GDT.NAME , hr_general.decode_location(ASS.location_id) , ASS.BUSINESS_GROUP_ID + 0, ASS.VACANCY_ID FROM PER_ASSIGNMENTS ASS, HR_ALL_ORGANIZATION_UNITS ORG, HR_ALL_ORGANIZATION_UNITS_TL ORGTL, PAY_PEOPLE_GROUPS GRP, PER_JOBS_TL JBT, HR_ALL_POSITIONS_F_TL PFT, PER_GRADES_TL GDT, PER_ALL_PEOPLE PP WHERE ASS.PERSON_ID = PP.PERSON_ID AND ASS.ORGANIZATION_ID = ORG.ORGANIZATION_ID AND ASS.PEOPLE_GROUP_ID = GRP.PEOPLE_GROUP_ID (+) AND ASS.JOB_ID = JBT.JOB_ID (+) AND JBT.LANGUAGE(+) = userenv('LANG') AND ASS.POSITION_ID = PFT.POSITION_ID (+) AND PFT.LANGUAGE(+) = userenv('LANG') AND ASS.GRADE_ID = GDT.GRADE_ID (+) AND GDT.LANGUAGE(+) = userenv('LANG') AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID AND ORGTL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT ASS.ASSIGNMENT_STATUS_TYPE_ID
, PP.FULL_NAME
, PP.ORDER_NAME
, PP.EMPLOYEE_NUMBER
, PP.APPLICANT_NUMBER
, PP.NPW_NUMBER
, HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(PP.EFFECTIVE_START_DATE
, PP.PERSON_ID) USER_PERSON_TYPE
, ASS.ASSIGNMENT_ID
, PP.PERSON_ID
, ORGTL.NAME
, GRP.GROUP_NAME
, JBT.NAME
, PFT.NAME
, GDT.NAME
, HR_GENERAL.DECODE_LOCATION(ASS.LOCATION_ID)
, ASS.BUSINESS_GROUP_ID + 0
, ASS.VACANCY_ID
FROM PER_ASSIGNMENTS ASS
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
, PAY_PEOPLE_GROUPS GRP
, PER_JOBS_TL JBT
, HR_ALL_POSITIONS_F_TL PFT
, PER_GRADES_TL GDT
, PER_ALL_PEOPLE PP
WHERE ASS.PERSON_ID = PP.PERSON_ID
AND ASS.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND ASS.PEOPLE_GROUP_ID = GRP.PEOPLE_GROUP_ID (+)
AND ASS.JOB_ID = JBT.JOB_ID (+)
AND JBT.LANGUAGE(+) = USERENV('LANG')
AND ASS.POSITION_ID = PFT.POSITION_ID (+)
AND PFT.LANGUAGE(+) = USERENV('LANG')
AND ASS.GRADE_ID = GDT.GRADE_ID (+)
AND GDT.LANGUAGE(+) = USERENV('LANG')
AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID
AND ORGTL.LANGUAGE = USERENV('LANG')