ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 408FB30B113240C592AAD4247F801FEEY select null action_, null status_, null message_, null modified_columns_, to_number(null) assignment_id_out, paaf.assignment_id, pbg.name business_group, papf.employee_number, papf.full_name, paaf.assignment_number, xxen_util.yes(paaf.primary_flag) primary_assignment, :effective_date effective_date, null datetrack_mode, (select haouv.name from hr_all_organization_units_vl haouv where paaf.organization_id=haouv.organization_id) organization, (select ppg.group_name from pay_people_groups ppg where paaf.people_group_id=ppg.people_group_id) people_group, (select pjv.name from per_jobs_vl pjv where paaf.job_id=pjv.job_id) job, (select hpf.name from hr_positions_f hpf where paaf.position_id=hpf.position_id and :effective_date between hpf.effective_start_date and hpf.effective_end_date) position, (select pgv.name from per_grades_vl pgv where paaf.grade_id=pgv.grade_id) grade, (select papf2.payroll_name from pay_all_payrolls_f papf2 where paaf.payroll_id=papf2.payroll_id and :effective_date between papf2.effective_start_date and papf2.effective_end_date) payroll, (select hlav.location_code from hr_locations_all_vl hlav where paaf.location_id=hlav.location_id) location, (select pastv.user_status from per_assignment_status_types_v pastv where paaf.assignment_status_type_id=pastv.assignment_status_type_id) assignment_status, xxen_util.meaning(paaf.employment_category,'EMP_CAT',3) assignment_category, xxen_util.meaning(paaf.employee_category,'EMPLOYEE_CATG',3) employee_category, (select papf3.employee_number from per_all_people_f papf3 where paaf.supervisor_id=papf3.person_id and :effective_date between papf3.effective_start_date and papf3.effective_end_date) supervisor_number, (select papf3.full_name from per_all_people_f papf3 where paaf.supervisor_id=papf3.person_id and :effective_date between papf3.effective_start_date and papf3.effective_end_date) supervisor_name, paaf.probation_period, xxen_util.meaning(paaf.probation_unit,'QUALIFYING_UNITS',3) probation_units, paaf.date_probation_end probation_end_date, paaf.notice_period, xxen_util.meaning(paaf.notice_period_uom,'QUALIFYING_UNITS',3) notice_period_units, paaf.normal_hours working_hours, xxen_util.meaning(paaf.frequency,'FREQUENCY',3) frequency, paaf.time_normal_start start_time, paaf.time_normal_finish end_time, xxen_util.meaning(paaf.hourly_salaried_code,'HOURLY_SALARIED_CODE',3) hourly_salaried, xxen_util.yes(paaf.work_at_home) working_at_home, (select hsck.concatenated_segments from hr_soft_coding_keyflex hsck where paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id) statutory_information, (select ppb.name from per_pay_bases ppb where paaf.pay_basis_id=ppb.pay_basis_id) salary_basis, paaf.internal_address_line internal_address, xxen_util.meaning(paaf.change_reason,'EMP_ASSIGN_REASON',3) change_reason, xxen_util.yes(paaf.manager_flag) manager, xxen_util.meaning(paaf.bargaining_unit_code,'BARGAINING_UNIT_CODE',3) bargaining_unit, xxen_util.yes(paaf.labour_union_member_flag) union_member, xxen_util.display_flexfield_context(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category) ass_attribute_category, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE1',paaf.rowid,paaf.ass_attribute1) ass_attribute1, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE2',paaf.rowid,paaf.ass_attribute2) ass_attribute2, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE3',paaf.rowid,paaf.ass_attribute3) ass_attribute3, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE4',paaf.rowid,paaf.ass_attribute4) ass_attribute4, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE5',paaf.rowid,paaf.ass_attribute5) ass_attribute5, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE6',paaf.rowid,paaf.ass_attribute6) ass_attribute6, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE7',paaf.rowid,paaf.ass_attribute7) ass_attribute7, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE8',paaf.rowid,paaf.ass_attribute8) ass_attribute8, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE9',paaf.rowid,paaf.ass_attribute9) ass_attribute9, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE10',paaf.rowid,paaf.ass_attribute10) ass_attribute10, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE11',paaf.rowid,paaf.ass_attribute11) ass_attribute11, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE12',paaf.rowid,paaf.ass_attribute12) ass_attribute12, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE13',paaf.rowid,paaf.ass_attribute13) ass_attribute13, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE14',paaf.rowid,paaf.ass_attribute14) ass_attribute14, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE15',paaf.rowid,paaf.ass_attribute15) ass_attribute15, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE16',paaf.rowid,paaf.ass_attribute16) ass_attribute16, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE17',paaf.rowid,paaf.ass_attribute17) ass_attribute17, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE18',paaf.rowid,paaf.ass_attribute18) ass_attribute18, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE19',paaf.rowid,paaf.ass_attribute19) ass_attribute19, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE20',paaf.rowid,paaf.ass_attribute20) ass_attribute20, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE21',paaf.rowid,paaf.ass_attribute21) ass_attribute21, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE22',paaf.rowid,paaf.ass_attribute22) ass_attribute22, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE23',paaf.rowid,paaf.ass_attribute23) ass_attribute23, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE24',paaf.rowid,paaf.ass_attribute24) ass_attribute24, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE25',paaf.rowid,paaf.ass_attribute25) ass_attribute25, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE26',paaf.rowid,paaf.ass_attribute26) ass_attribute26, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE27',paaf.rowid,paaf.ass_attribute27) ass_attribute27, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE28',paaf.rowid,paaf.ass_attribute28) ass_attribute28, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE29',paaf.rowid,paaf.ass_attribute29) ass_attribute29, xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE30',paaf.rowid,paaf.ass_attribute30) ass_attribute30, 0 upload_row from per_business_groups pbg, per_all_people_f papf, per_all_assignments_f paaf where 1=1 and pbg.business_group_id=:business_group_id and papf.business_group_id=pbg.business_group_id and :effective_date between papf.effective_start_date and papf.effective_end_date and papf.current_employee_flag='Y' and papf.person_id=paaf.person_id and paaf.assignment_type='E' and :effective_date between paaf.effective_start_date and paaf.effective_end_date Initial version - create secondary employee assignments and update employee assignments, their status and the assignment flexfield through hr_assignment_api U A xxen_per_upload.create_update_assignment US PER Person Assignment Upload Upload to create and update employee assignments as in the Assignment window of the People form: organization, job, position, grade, payroll, location, status, categories, supervisor, probation and notice periods, standard conditions, statutory information, salary basis, people group and the Additional Assignment Details flexfield. Changes are made as of the Effective Date. When Datetrack Mode is blank, the assignment is corrected if the Effective Date is its start date, and otherwise a change is inserted from the Effective Date (Update, or Update - Insert when later changes exist). A new row without an existing Assignment Number creates a secondary assignment with hr_assignment_api.create_secondary_emp_asg. The primary assignment is created when the person is hired with the PER Person Upload. A Status of another system status suspends, reactivates or terminates the assignment. People Group and Statutory Information take the concatenated segment values and create new combinations as needed. Enginatics Upload 1=1 :business_group_id :effective_date 1 10 1=1 :p_upload_mode like '%'||xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create||','||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 :business_group_id LOV custom Y select pbg.business_group_id id, pbg.name value, null description from per_business_groups pbg order by pbg.name fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group 3 30 :effective_date Date trunc(sysdate) Y US Effective Date Date the downloaded records are shown as of and the default date the uploaded changes take effect. 4 40 1=1 papf.employee_number=:employee_number LOV custom Y Y select papf.employee_number id, papf.employee_number value, papf.full_name description from per_all_people_f papf where papf.business_group_id=:$flex$.Business_Group and papf.current_employee_flag='Y' and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date order by papf.employee_number US Employee Number 5 50 1=1 paaf.organization_id=:organization_id LOV custom Y select haouv.organization_id id, haouv.name value, null description from hr_all_organization_units_vl haouv where haouv.business_group_id=:$flex$.Business_Group order by haouv.name US Organization 6 60 1=1 paaf.job_id=:job_id LOV custom Y select pjv.job_id id, pjv.name value, null description from per_jobs_vl pjv where pjv.business_group_id=:$flex$.Business_Group order by pjv.name US Job 7 70 1=1 paaf.location_id=:location_id LOV custom Y select hlav.location_id id, hlav.location_code value, hlav.description from hr_locations_all_vl hlav where nvl(hlav.business_group_id,:$flex$.Business_Group)=:$flex$.Business_Group order by hlav.location_code US Location 8 80 1=1 paaf.payroll_id=:payroll_id LOV custom Y select distinct papf2.payroll_id id, papf2.payroll_name value, null description from pay_all_payrolls_f papf2 where papf2.business_group_id=:$flex$.Business_Group order by papf2.payroll_name US Payroll 9 90 1=1 paaf.primary_flag='Y' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Primary Assignments Only 8A26D141309E432598CD5FCFCC2378C1 Assignment Flexfield Maintains the Additional Assignment Details flexfield of existing assignments. ENGINATICS 4 ASSIGNMENT_NUMBER 8 ASS_ATTRIBUTE1 17 ASS_ATTRIBUTE10 18 ASS_ATTRIBUTE11 19 ASS_ATTRIBUTE12 20 ASS_ATTRIBUTE13 21 ASS_ATTRIBUTE14 22 ASS_ATTRIBUTE15 23 ASS_ATTRIBUTE16 24 ASS_ATTRIBUTE17 25 ASS_ATTRIBUTE18 26 ASS_ATTRIBUTE19 9 ASS_ATTRIBUTE2 27 ASS_ATTRIBUTE20 28 ASS_ATTRIBUTE21 29 ASS_ATTRIBUTE22 30 ASS_ATTRIBUTE23 31 ASS_ATTRIBUTE24 32 ASS_ATTRIBUTE25 33 ASS_ATTRIBUTE26 34 ASS_ATTRIBUTE27 35 ASS_ATTRIBUTE28 36 ASS_ATTRIBUTE29 10 ASS_ATTRIBUTE3 37 ASS_ATTRIBUTE30 11 ASS_ATTRIBUTE4 12 ASS_ATTRIBUTE5 13 ASS_ATTRIBUTE6 14 ASS_ATTRIBUTE7 15 ASS_ATTRIBUTE8 16 ASS_ATTRIBUTE9 7 ASS_ATTRIBUTE_CATEGORY 1 BUSINESS_GROUP 6 DATETRACK_MODE 5 EFFECTIVE_DATE Y 2 EMPLOYEE_NUMBER 3 FULL_NAME Upload Mode C,U S Site F62911D307AE4BCDAD9667E3E43D3C59 Create Secondary Assignments Opens an empty sheet to add secondary assignments to existing employees. The primary assignment is created with the person, so use the Default template to complete it. ENGINATICS 13 ASSIGNMENT_CATEGORY 4 ASSIGNMENT_NUMBER Y 12 ASSIGNMENT_STATUS 1 BUSINESS_GROUP 5 EFFECTIVE_DATE 2 EMPLOYEE_NUMBER 17 FREQUENCY 3 FULL_NAME 9 GRADE 7 JOB 11 LOCATION 6 ORGANIZATION 10 PAYROLL 8 POSITION 15 SUPERVISOR_NAME 14 SUPERVISOR_NUMBER 16 WORKING_HOURS Upload Mode C Y S Site Employee Number Job Location Organization Payroll Primary Assignments Only 9C49C6F981CF48CEA33B5A8968440746 Default Creates and updates employee assignments with the fields of the Assignment window, without the flexfield. ENGINATICS 16 ASSIGNMENT_CATEGORY 4 ASSIGNMENT_NUMBER 15 ASSIGNMENT_STATUS 36 BARGAINING_UNIT 1 BUSINESS_GROUP 34 CHANGE_REASON 7 DATETRACK_MODE 6 EFFECTIVE_DATE 17 EMPLOYEE_CATEGORY 2 EMPLOYEE_NUMBER 28 END_TIME 26 FREQUENCY 3 FULL_NAME 12 GRADE 29 HOURLY_SALARIED 33 INTERNAL_ADDRESS 10 JOB 14 LOCATION 35 MANAGER 23 NOTICE_PERIOD 24 NOTICE_PERIOD_UNITS 8 ORGANIZATION 13 PAYROLL 9 PEOPLE_GROUP 11 POSITION 5 PRIMARY_ASSIGNMENT Y 22 PROBATION_END_DATE 20 PROBATION_PERIOD 21 PROBATION_UNITS 32 SALARY_BASIS 27 START_TIME 31 STATUTORY_INFORMATION 19 SUPERVISOR_NAME 18 SUPERVISOR_NUMBER 37 UNION_MEMBER 30 WORKING_AT_HOME 25 WORKING_HOURS Upload Mode C,U S Site 8908630C60284E38B56BA5B7062C1763 Organization and Job Change Transfers and promotions: changes the organization, job, position, grade, location or supervisor as of the Effective Date. ENGINATICS 4 ASSIGNMENT_NUMBER 1 BUSINESS_GROUP 14 CHANGE_REASON 6 DATETRACK_MODE 5 EFFECTIVE_DATE Y 2 EMPLOYEE_NUMBER 3 FULL_NAME 10 GRADE 8 JOB 11 LOCATION 7 ORGANIZATION 9 POSITION 13 SUPERVISOR_NAME 12 SUPERVISOR_NUMBER Upload Mode C,U S Site 9C49C6F981CF48CEA33B5A8968440746 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 ASSIGNMENT_ID_OUT Number number Y 6 ASSIGNMENT_ID Number number Y 7 BUSINESS_GROUP LOV custom varchar2 240 Y select pbg.business_group_id id, pbg.name value, null description from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group order by pbg.name select pbg.name from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group Y Y 8 EMPLOYEE_NUMBER LOV custom varchar2 30 Y Y select papf.employee_number id, papf.employee_number value, papf.full_name description from per_business_groups pbg, per_all_people_f papf where pbg.name=:$column$.business_group and papf.business_group_id=pbg.business_group_id and papf.current_employee_flag='Y' and nvl(:$column$.effective_date,trunc(sysdate)) between papf.effective_start_date and papf.effective_end_date order by papf.employee_number Y 9 FULL_NAME Char varchar2 240 select papf.full_name from per_all_people_f papf, per_business_groups pbg where pbg.name=:$column$.business_group and papf.business_group_id=pbg.business_group_id and papf.employee_number=:$column$.employee_number and nvl(:$column$.effective_date,trunc(sysdate)) between papf.effective_start_date and papf.effective_end_date Y 10 ASSIGNMENT_NUMBER Char varchar2 30 Leave blank on a new row to create a secondary assignment with a generated number. 11 PRIMARY_ASSIGNMENT LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y 12 EFFECTIVE_DATE Date date :$flex$.Effective_Date Date the assignment changes take effect. Defaults from the Effective Date parameter. 13 DATETRACK_MODE LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='PQH_DT_MODE' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and flvv.lookup_code in ('CORRECTION','UPDATE','UPDATE_CHANGE_INSERT','UPDATE_OVERRIDE') order by flvv.meaning Leave blank to correct the assignment when the Effective Date is its start date and to insert a change otherwise. 14 ORGANIZATION LOV custom varchar2 240 Y select haouv.organization_id id, haouv.name value, null description from per_business_groups pbg, hr_all_organization_units_vl haouv where pbg.name=:$column$.business_group and haouv.business_group_id=pbg.business_group_id and nvl(:$column$.effective_date,trunc(sysdate)) between haouv.date_from and nvl(haouv.date_to,nvl(:$column$.effective_date,trunc(sysdate))) and haouv.organization_id in (select hoi.organization_id from hr_organization_information hoi where hoi.org_information_context='CLASS' and hoi.org_information1='HR_ORG' and hoi.org_information2='Y') order by haouv.name Required for a new assignment. 15 PEOPLE_GROUP LOV custom varchar2 240 select distinct ppg.group_name value, null description from per_business_groups pbg, pay_people_groups ppg where pbg.name=:$column$.business_group and ppg.id_flex_num=to_number(pbg.people_group_structure) and ppg.enabled_flag='Y' order by ppg.group_name Concatenated segment values of the People Group flexfield. A new combination is created when it does not exist. 16 JOB LOV custom varchar2 240 Y select pjv.job_id id, pjv.name value, null description from per_business_groups pbg, per_jobs_vl pjv where pbg.name=:$column$.business_group and pjv.business_group_id=pbg.business_group_id and nvl(:$column$.effective_date,trunc(sysdate)) between pjv.date_from and nvl(pjv.date_to,nvl(:$column$.effective_date,trunc(sysdate))) order by pjv.name 17 POSITION LOV custom varchar2 240 Y select hpf.position_id id, hpf.name value, null description from per_business_groups pbg, hr_positions_f hpf where pbg.name=:$column$.business_group and hpf.business_group_id=pbg.business_group_id and nvl(:$column$.effective_date,trunc(sysdate)) between hpf.effective_start_date and hpf.effective_end_date order by hpf.name 18 GRADE LOV custom varchar2 240 Y select pgv.grade_id id, pgv.name value, null description from per_business_groups pbg, per_grades_vl pgv where pbg.name=:$column$.business_group and pgv.business_group_id=pbg.business_group_id and nvl(:$column$.effective_date,trunc(sysdate)) between pgv.date_from and nvl(pgv.date_to,nvl(:$column$.effective_date,trunc(sysdate))) order by pgv.name 19 PAYROLL LOV custom varchar2 80 Y select papf2.payroll_id id, papf2.payroll_name value, null description from per_business_groups pbg, pay_all_payrolls_f papf2 where pbg.name=:$column$.business_group and papf2.business_group_id=pbg.business_group_id and nvl(:$column$.effective_date,trunc(sysdate)) between papf2.effective_start_date and papf2.effective_end_date order by papf2.payroll_name 20 LOCATION LOV custom varchar2 60 Y select hlav.location_id id, hlav.location_code value, hlav.description from per_business_groups pbg, hr_locations_all_vl hlav where pbg.name=:$column$.business_group and nvl(hlav.business_group_id,pbg.business_group_id)=pbg.business_group_id and (hlav.inactive_date is null or hlav.inactive_date>nvl(:$column$.effective_date,trunc(sysdate))) order by hlav.location_code 21 ASSIGNMENT_STATUS LOV custom varchar2 80 Y select pastv.assignment_status_type_id id, pastv.user_status value, xxen_util.meaning(pastv.per_system_status,'PER_ASS_SYS_STATUS',3) description from per_business_groups pbg, per_assignment_status_types_v pastv where pbg.name=:$column$.business_group and nvl(pastv.business_group_id,pbg.business_group_id)=pbg.business_group_id and nvl(pastv.legislation_code,pbg.legislation_code)=pbg.legislation_code and pastv.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN','TERM_ASSIGN') and pastv.active_flag='Y' order by pastv.user_status select pastv.user_status from per_assignment_status_types_v pastv where pastv.assignment_status_type_id=1 A change to a status of another system status suspends, reactivates or terminates the assignment. Terminating ends a secondary assignment on the Effective Date. 22 ASSIGNMENT_CATEGORY LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from per_business_groups pbg, fnd_lookup_values_vl flvv where pbg.name=:$column$.business_group and flvv.lookup_type='EMP_CAT' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and (flvv.tag is null or flvv.tag like '%+'||pbg.legislation_code||'%' or flvv.tag like '-%' and flvv.tag not like '%'||pbg.legislation_code||'%') order by flvv.meaning 23 EMPLOYEE_CATEGORY LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from per_business_groups pbg, fnd_lookup_values_vl flvv where pbg.name=:$column$.business_group and flvv.lookup_type='EMPLOYEE_CATG' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and (flvv.tag is null or flvv.tag like '%+'||pbg.legislation_code||'%' or flvv.tag like '-%' and flvv.tag not like '%'||pbg.legislation_code||'%') order by flvv.meaning 24 SUPERVISOR_NUMBER LOV custom varchar2 30 Y Y select papf.person_id id, papf.employee_number value, papf.full_name description from per_business_groups pbg, per_all_people_f papf where pbg.name=:$column$.business_group and papf.business_group_id=pbg.business_group_id and papf.current_employee_flag='Y' and nvl(:$column$.effective_date,trunc(sysdate)) between papf.effective_start_date and papf.effective_end_date order by papf.employee_number 25 SUPERVISOR_NAME Char varchar2 240 select papf.full_name from per_all_people_f papf, per_business_groups pbg where pbg.name=:$column$.business_group and papf.business_group_id=pbg.business_group_id and papf.employee_number=:$column$.supervisor_number and nvl(:$column$.effective_date,trunc(sysdate)) between papf.effective_start_date and papf.effective_end_date Y 26 PROBATION_PERIOD Number number 27 PROBATION_UNITS LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from per_business_groups pbg, fnd_lookup_values_vl flvv where pbg.name=:$column$.business_group and flvv.lookup_type='QUALIFYING_UNITS' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and (flvv.tag is null or flvv.tag like '%+'||pbg.legislation_code||'%' or flvv.tag like '-%' and flvv.tag not like '%'||pbg.legislation_code||'%') order by flvv.meaning 28 PROBATION_END_DATE Date date 29 NOTICE_PERIOD Number number 30 NOTICE_PERIOD_UNITS LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from per_business_groups pbg, fnd_lookup_values_vl flvv where pbg.name=:$column$.business_group and flvv.lookup_type='QUALIFYING_UNITS' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and (flvv.tag is null or flvv.tag like '%+'||pbg.legislation_code||'%' or flvv.tag like '-%' and flvv.tag not like '%'||pbg.legislation_code||'%') order by flvv.meaning 31 WORKING_HOURS Number number 32 FREQUENCY LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from per_business_groups pbg, fnd_lookup_values_vl flvv where pbg.name=:$column$.business_group and flvv.lookup_type='FREQUENCY' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and (flvv.tag is null or flvv.tag like '%+'||pbg.legislation_code||'%' or flvv.tag like '-%' and flvv.tag not like '%'||pbg.legislation_code||'%') order by flvv.meaning 33 START_TIME Char varchar2 5 Normal start time in the format HH24:MI. 34 END_TIME Char varchar2 5 Normal end time in the format HH24:MI. 35 HOURLY_SALARIED LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from per_business_groups pbg, fnd_lookup_values_vl flvv where pbg.name=:$column$.business_group and flvv.lookup_type='HOURLY_SALARIED_CODE' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and (flvv.tag is null or flvv.tag like '%+'||pbg.legislation_code||'%' or flvv.tag like '-%' and flvv.tag not like '%'||pbg.legislation_code||'%') order by flvv.meaning 36 WORKING_AT_HOME LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 37 STATUTORY_INFORMATION LOV custom varchar2 240 select distinct hsck.concatenated_segments value, null description from per_business_groups pbg, pay_legislation_rules plr, hr_soft_coding_keyflex hsck where pbg.name=:$column$.business_group and plr.legislation_code=pbg.legislation_code and plr.rule_type='S' and hsck.id_flex_num=to_number(plr.rule_mode) and hsck.enabled_flag='Y' order by hsck.concatenated_segments Concatenated segment values of the Soft Coded flexfield of the business group's legislation, e.g. the GRE for the United States. A new combination is created when it does not exist. 38 SALARY_BASIS LOV custom varchar2 80 Y select ppb.pay_basis_id id, ppb.name value, null description from per_business_groups pbg, per_pay_bases ppb where pbg.name=:$column$.business_group and ppb.business_group_id=pbg.business_group_id order by ppb.name 39 INTERNAL_ADDRESS Char varchar2 80 40 CHANGE_REASON LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from per_business_groups pbg, fnd_lookup_values_vl flvv where pbg.name=:$column$.business_group and flvv.lookup_type='EMP_ASSIGN_REASON' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and (flvv.tag is null or flvv.tag like '%+'||pbg.legislation_code||'%' or flvv.tag like '-%' and flvv.tag not like '%'||pbg.legislation_code||'%') order by flvv.meaning 41 MANAGER LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 42 BARGAINING_UNIT LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from per_business_groups pbg, fnd_lookup_values_vl flvv where pbg.name=:$column$.business_group and flvv.lookup_type='BARGAINING_UNIT_CODE' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and (flvv.tag is null or flvv.tag like '%+'||pbg.legislation_code||'%' or flvv.tag like '-%' and flvv.tag not like '%'||pbg.legislation_code||'%') order by flvv.meaning 43 UNION_MEMBER LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 44 ASS_ATTRIBUTE_CATEGORY LOV custom varchar2 80 Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=800 and fdfcv.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 45 ASS_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE1', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE1' 46 ASS_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE2', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE2' 47 ASS_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE3', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE3' 48 ASS_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE4', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE4' 49 ASS_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE5', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE5' 50 ASS_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE6', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE6' 51 ASS_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE7', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE7' 52 ASS_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE8', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE8' 53 ASS_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE9', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE9' 54 ASS_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE10', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE10' 55 ASS_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE11', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE11' 56 ASS_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE12', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE12' 57 ASS_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE13', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE13' 58 ASS_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE14', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE14' 59 ASS_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE15', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE15' 60 ASS_ATTRIBUTE16 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE16', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE16' 61 ASS_ATTRIBUTE17 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE17', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE17' 62 ASS_ATTRIBUTE18 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE18', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE18' 63 ASS_ATTRIBUTE19 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE19', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE19' 64 ASS_ATTRIBUTE20 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE20', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE20' 65 ASS_ATTRIBUTE21 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE21', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE21' 66 ASS_ATTRIBUTE22 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE22', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE22' 67 ASS_ATTRIBUTE23 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE23', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE23' 68 ASS_ATTRIBUTE24 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE24', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE24' 69 ASS_ATTRIBUTE25 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE25', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE25' 70 ASS_ATTRIBUTE26 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE26', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE26' 71 ASS_ATTRIBUTE27 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE27', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE27' 72 ASS_ATTRIBUTE28 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE28', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE28' 73 ASS_ATTRIBUTE29 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE29', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE29' 74 ASS_ATTRIBUTE30 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'PER_ASSIGNMENTS', p_context_name=>:$column$.ass_attribute_category, p_column_name=>'ASS_ATTRIBUTE30', p_attribute1=>:$column$.ass_attribute1, p_attribute2=>:$column$.ass_attribute2, p_attribute3=>:$column$.ass_attribute3, p_attribute4=>:$column$.ass_attribute4, p_attribute5=>:$column$.ass_attribute5, p_attribute6=>:$column$.ass_attribute6, p_attribute7=>:$column$.ass_attribute7, p_attribute8=>:$column$.ass_attribute8, p_attribute9=>:$column$.ass_attribute9, p_attribute10=>:$column$.ass_attribute10, p_attribute11=>:$column$.ass_attribute11, p_attribute12=>:$column$.ass_attribute12, p_attribute13=>:$column$.ass_attribute13, p_attribute14=>:$column$.ass_attribute14, p_attribute15=>:$column$.ass_attribute15, p_attribute16=>:$column$.ass_attribute16, p_attribute17=>:$column$.ass_attribute17, p_attribute18=>:$column$.ass_attribute18, p_attribute19=>:$column$.ass_attribute19, p_attribute20=>:$column$.ass_attribute20, p_attribute21=>:$column$.ass_attribute21, p_attribute22=>:$column$.ass_attribute22, p_attribute23=>:$column$.ass_attribute23, p_attribute24=>:$column$.ass_attribute24, p_attribute25=>:$column$.ass_attribute25, p_attribute26=>:$column$.ass_attribute26, p_attribute27=>:$column$.ass_attribute27, p_attribute28=>:$column$.ass_attribute28, p_attribute29=>:$column$.ass_attribute29, p_attribute30=>:$column$.ass_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_ASSIGNMENTS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ASS_ATTRIBUTE30' 75 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 p_assignment_id_out in/out Number ASSIGNMENT_ID_OUT U 3 p_business_group_id in Number BUSINESS_GROUP U 4 p_employee_number in Char EMPLOYEE_NUMBER U 5 p_assignment_number in Char ASSIGNMENT_NUMBER U 6 p_assignment_id in Number ASSIGNMENT_ID U 7 p_effective_date in Date EFFECTIVE_DATE U 8 p_datetrack_mode in Char DATETRACK_MODE U 9 p_organization_id in Number ORGANIZATION U 10 p_people_group in Char PEOPLE_GROUP U 11 p_job_id in Number JOB U 12 p_position_id in Number POSITION U 13 p_grade_id in Number GRADE U 14 p_payroll_id in Number PAYROLL U 15 p_location_id in Number LOCATION U 16 p_assignment_status_type_id in Number ASSIGNMENT_STATUS U 17 p_employment_category in Char ASSIGNMENT_CATEGORY U 18 p_employee_category in Char EMPLOYEE_CATEGORY U 19 p_supervisor_id in Number SUPERVISOR_NUMBER U 20 p_probation_period in Number PROBATION_PERIOD U 21 p_probation_unit in Char PROBATION_UNITS U 22 p_date_probation_end in Date PROBATION_END_DATE U 23 p_notice_period in Number NOTICE_PERIOD U 24 p_notice_period_uom in Char NOTICE_PERIOD_UNITS U 25 p_normal_hours in Number WORKING_HOURS U 26 p_frequency in Char FREQUENCY U 27 p_time_normal_start in Char START_TIME U 28 p_time_normal_finish in Char END_TIME U 29 p_hourly_salaried_code in Char HOURLY_SALARIED U 30 p_work_at_home in Char WORKING_AT_HOME U 31 p_statutory_information in Char STATUTORY_INFORMATION U 32 p_pay_basis_id in Number SALARY_BASIS U 33 p_internal_address_line in Char INTERNAL_ADDRESS U 34 p_change_reason in Char CHANGE_REASON U 35 p_manager_flag in Char MANAGER U 36 p_bargaining_unit_code in Char BARGAINING_UNIT U 37 p_labour_union_member_flag in Char UNION_MEMBER U 38 p_ass_attribute_category in Char ASS_ATTRIBUTE_CATEGORY U 39 p_ass_attribute1 in Char ASS_ATTRIBUTE1 U 40 p_ass_attribute2 in Char ASS_ATTRIBUTE2 U 41 p_ass_attribute3 in Char ASS_ATTRIBUTE3 U 42 p_ass_attribute4 in Char ASS_ATTRIBUTE4 U 43 p_ass_attribute5 in Char ASS_ATTRIBUTE5 U 44 p_ass_attribute6 in Char ASS_ATTRIBUTE6 U 45 p_ass_attribute7 in Char ASS_ATTRIBUTE7 U 46 p_ass_attribute8 in Char ASS_ATTRIBUTE8 U 47 p_ass_attribute9 in Char ASS_ATTRIBUTE9 U 48 p_ass_attribute10 in Char ASS_ATTRIBUTE10 U 49 p_ass_attribute11 in Char ASS_ATTRIBUTE11 U 50 p_ass_attribute12 in Char ASS_ATTRIBUTE12 U 51 p_ass_attribute13 in Char ASS_ATTRIBUTE13 U 52 p_ass_attribute14 in Char ASS_ATTRIBUTE14 U 53 p_ass_attribute15 in Char ASS_ATTRIBUTE15 U 54 p_ass_attribute16 in Char ASS_ATTRIBUTE16 U 55 p_ass_attribute17 in Char ASS_ATTRIBUTE17 U 56 p_ass_attribute18 in Char ASS_ATTRIBUTE18 U 57 p_ass_attribute19 in Char ASS_ATTRIBUTE19 U 58 p_ass_attribute20 in Char ASS_ATTRIBUTE20 U 59 p_ass_attribute21 in Char ASS_ATTRIBUTE21 U 60 p_ass_attribute22 in Char ASS_ATTRIBUTE22 U 61 p_ass_attribute23 in Char ASS_ATTRIBUTE23 U 62 p_ass_attribute24 in Char ASS_ATTRIBUTE24 U 63 p_ass_attribute25 in Char ASS_ATTRIBUTE25 U 64 p_ass_attribute26 in Char ASS_ATTRIBUTE26 U 65 p_ass_attribute27 in Char ASS_ATTRIBUTE27 U 66 p_ass_attribute28 in Char ASS_ATTRIBUTE28 U 67 p_ass_attribute29 in Char ASS_ATTRIBUTE29 U 68 p_ass_attribute30 in Char ASS_ATTRIBUTE30 U 69 status_ out Char STATUS_CODE_ U 70 message_ out Char MESSAGE_ Error SQL Order By upload_row, business_group, employee_number, assignment_number Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.assignment_id_out, nvl(paaf.assignment_id,xu.assignment_id) assignment_id, nvl(pbg.name,xu.business_group) business_group, nvl(papf.employee_number,xu.employee_number) employee_number, nvl(papf.full_name,xu.full_name) full_name, nvl(paaf.assignment_number,xu.assignment_number) assignment_number, nvl(xxen_util.yes(paaf.primary_flag),xu.primary_assignment) primary_assignment, xu.effective_date, xu.datetrack_mode, nvl((select haouv.name from hr_all_organization_units_vl haouv where paaf.organization_id=haouv.organization_id),xu.organization) organization, nvl((select ppg.group_name from pay_people_groups ppg where paaf.people_group_id=ppg.people_group_id),xu.people_group) people_group, nvl((select pjv.name from per_jobs_vl pjv where paaf.job_id=pjv.job_id),xu.job) job, nvl((select hpf.name from hr_positions_f hpf where paaf.position_id=hpf.position_id and xu.row_date between hpf.effective_start_date and hpf.effective_end_date),xu.position) position, nvl((select pgv.name from per_grades_vl pgv where paaf.grade_id=pgv.grade_id),xu.grade) grade, nvl((select papf2.payroll_name from pay_all_payrolls_f papf2 where paaf.payroll_id=papf2.payroll_id and xu.row_date between papf2.effective_start_date and papf2.effective_end_date),xu.payroll) payroll, nvl((select hlav.location_code from hr_locations_all_vl hlav where paaf.location_id=hlav.location_id),xu.location) location, nvl((select pastv.user_status from per_assignment_status_types_v pastv where paaf.assignment_status_type_id=pastv.assignment_status_type_id),xu.assignment_status) assignment_status, nvl(xxen_util.meaning(paaf.employment_category,'EMP_CAT',3),xu.assignment_category) assignment_category, nvl(xxen_util.meaning(paaf.employee_category,'EMPLOYEE_CATG',3),xu.employee_category) employee_category, nvl((select papf3.employee_number from per_all_people_f papf3 where paaf.supervisor_id=papf3.person_id and xu.row_date between papf3.effective_start_date and papf3.effective_end_date),xu.supervisor_number) supervisor_number, nvl((select papf3.full_name from per_all_people_f papf3 where paaf.supervisor_id=papf3.person_id and xu.row_date between papf3.effective_start_date and papf3.effective_end_date),xu.supervisor_name) supervisor_name, nvl(paaf.probation_period,xu.probation_period) probation_period, nvl(xxen_util.meaning(paaf.probation_unit,'QUALIFYING_UNITS',3),xu.probation_units) probation_units, nvl(paaf.date_probation_end,xu.probation_end_date) probation_end_date, nvl(paaf.notice_period,xu.notice_period) notice_period, nvl(xxen_util.meaning(paaf.notice_period_uom,'QUALIFYING_UNITS',3),xu.notice_period_units) notice_period_units, nvl(paaf.normal_hours,xu.working_hours) working_hours, nvl(xxen_util.meaning(paaf.frequency,'FREQUENCY',3),xu.frequency) frequency, nvl(paaf.time_normal_start,xu.start_time) start_time, nvl(paaf.time_normal_finish,xu.end_time) end_time, nvl(xxen_util.meaning(paaf.hourly_salaried_code,'HOURLY_SALARIED_CODE',3),xu.hourly_salaried) hourly_salaried, nvl(xxen_util.yes(paaf.work_at_home),xu.working_at_home) working_at_home, nvl((select hsck.concatenated_segments from hr_soft_coding_keyflex hsck where paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id),xu.statutory_information) statutory_information, nvl((select ppb.name from per_pay_bases ppb where paaf.pay_basis_id=ppb.pay_basis_id),xu.salary_basis) salary_basis, nvl(paaf.internal_address_line,xu.internal_address) internal_address, nvl(xxen_util.meaning(paaf.change_reason,'EMP_ASSIGN_REASON',3),xu.change_reason) change_reason, nvl(xxen_util.yes(paaf.manager_flag),xu.manager) manager, nvl(xxen_util.meaning(paaf.bargaining_unit_code,'BARGAINING_UNIT_CODE',3),xu.bargaining_unit) bargaining_unit, nvl(xxen_util.yes(paaf.labour_union_member_flag),xu.union_member) union_member, nvl(xxen_util.display_flexfield_context(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category),xu.ass_attribute_category) ass_attribute_category, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE1',paaf.rowid,paaf.ass_attribute1),xu.ass_attribute1) ass_attribute1, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE2',paaf.rowid,paaf.ass_attribute2),xu.ass_attribute2) ass_attribute2, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE3',paaf.rowid,paaf.ass_attribute3),xu.ass_attribute3) ass_attribute3, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE4',paaf.rowid,paaf.ass_attribute4),xu.ass_attribute4) ass_attribute4, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE5',paaf.rowid,paaf.ass_attribute5),xu.ass_attribute5) ass_attribute5, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE6',paaf.rowid,paaf.ass_attribute6),xu.ass_attribute6) ass_attribute6, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE7',paaf.rowid,paaf.ass_attribute7),xu.ass_attribute7) ass_attribute7, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE8',paaf.rowid,paaf.ass_attribute8),xu.ass_attribute8) ass_attribute8, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE9',paaf.rowid,paaf.ass_attribute9),xu.ass_attribute9) ass_attribute9, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE10',paaf.rowid,paaf.ass_attribute10),xu.ass_attribute10) ass_attribute10, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE11',paaf.rowid,paaf.ass_attribute11),xu.ass_attribute11) ass_attribute11, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE12',paaf.rowid,paaf.ass_attribute12),xu.ass_attribute12) ass_attribute12, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE13',paaf.rowid,paaf.ass_attribute13),xu.ass_attribute13) ass_attribute13, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE14',paaf.rowid,paaf.ass_attribute14),xu.ass_attribute14) ass_attribute14, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE15',paaf.rowid,paaf.ass_attribute15),xu.ass_attribute15) ass_attribute15, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE16',paaf.rowid,paaf.ass_attribute16),xu.ass_attribute16) ass_attribute16, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE17',paaf.rowid,paaf.ass_attribute17),xu.ass_attribute17) ass_attribute17, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE18',paaf.rowid,paaf.ass_attribute18),xu.ass_attribute18) ass_attribute18, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE19',paaf.rowid,paaf.ass_attribute19),xu.ass_attribute19) ass_attribute19, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE20',paaf.rowid,paaf.ass_attribute20),xu.ass_attribute20) ass_attribute20, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE21',paaf.rowid,paaf.ass_attribute21),xu.ass_attribute21) ass_attribute21, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE22',paaf.rowid,paaf.ass_attribute22),xu.ass_attribute22) ass_attribute22, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE23',paaf.rowid,paaf.ass_attribute23),xu.ass_attribute23) ass_attribute23, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE24',paaf.rowid,paaf.ass_attribute24),xu.ass_attribute24) ass_attribute24, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE25',paaf.rowid,paaf.ass_attribute25),xu.ass_attribute25) ass_attribute25, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE26',paaf.rowid,paaf.ass_attribute26),xu.ass_attribute26) ass_attribute26, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE27',paaf.rowid,paaf.ass_attribute27),xu.ass_attribute27) ass_attribute27, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE28',paaf.rowid,paaf.ass_attribute28),xu.ass_attribute28) ass_attribute28, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE29',paaf.rowid,paaf.ass_attribute29),xu.ass_attribute29) ass_attribute29, nvl(xxen_util.display_flexfield_value(800,'PER_ASSIGNMENTS',paaf.ass_attribute_category,'ASS_ATTRIBUTE30',paaf.rowid,paaf.ass_attribute30),xu.ass_attribute30) ass_attribute30, xu.upload_row from ( select xu.*, nvl(xu.effective_date,trunc(sysdate)) row_date from xxen_per_person_assignm_1553_u xu where xu.status_code_=xxen_upload.status_success ) xu, per_all_assignments_f paaf, per_all_people_f papf, per_business_groups pbg where xu.assignment_id_out=paaf.assignment_id(+) and xu.row_date between paaf.effective_start_date(+) and paaf.effective_end_date(+) and paaf.person_id=papf.person_id(+) and paaf.effective_start_date between papf.effective_start_date(+) and papf.effective_end_date(+) and paaf.business_group_id=pbg.business_group_id(+)