ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 204B7601C57441EEA82E86A5B860AC62Y select null action_, null status_, null message_, null modified_columns_, to_number(null) position_id_out, hapf.position_id, pbg.name business_group, :effective_date effective_date, null datetrack_mode, hapft.name, hapf.date_effective start_date, xxen_util.meaning(hapf.position_type,'POSITION_TYPE',3) position_type, xxen_util.yes(hapf.permanent_temporary_flag) permanent, xxen_util.yes(hapf.seasonal_flag) seasonal, (select haouv.name from hr_all_organization_units_vl haouv where hapf.organization_id=haouv.organization_id) organization, (select pjv.name from per_jobs_vl pjv where hapf.job_id=pjv.job_id) job, (select pstv.shared_type_name from per_shared_types_vl pstv where hapf.availability_status_id=pstv.shared_type_id) hiring_status, (select hlav.location_code from hr_locations_all_vl hlav where hapf.location_id=hlav.location_id) location, hapf.fte, hapf.max_persons headcount, xxen_util.meaning(hapf.bargaining_unit_cd,'BARGAINING_UNIT_CODE',3) bargaining_unit, hapf.earliest_hire_date, hapf.fill_by_date, xxen_util.yes(hapf.permit_recruitment_flag) permit_recruiting, (select papf2.payroll_name from pay_all_payrolls_f papf2 where hapf.pay_freq_payroll_id=papf2.payroll_id and :effective_date between papf2.effective_start_date and papf2.effective_end_date) payroll, (select ppb.name from per_pay_bases ppb where hapf.pay_basis_id=ppb.pay_basis_id) salary_basis, (select pgv.name from per_grades_vl pgv where hapf.entry_grade_id=pgv.grade_id) entry_grade, hapf.probation_period probation_duration, xxen_util.meaning(hapf.probation_period_unit_cd,'FREQUENCY',3) probation_units, hapf.overlap_period overlap_duration, xxen_util.meaning(hapf.overlap_unit_cd,'FREQUENCY',3) overlap_units, hapf.working_hours, xxen_util.meaning(hapf.frequency,'FREQUENCY',3) frequency, hapf.time_normal_start start_time, hapf.time_normal_finish end_time, (select papf.employee_number from per_all_people_f papf where hapf.supervisor_id=papf.person_id and :effective_date between papf.effective_start_date and papf.effective_end_date) supervisor_number, (select papf.full_name from per_all_people_f papf where hapf.supervisor_id=papf.person_id and :effective_date between papf.effective_start_date and papf.effective_end_date) supervisor_name, xxen_util.yes(hapf.replacement_required_flag) replacement_required, (select hapft2.name from hr_all_positions_f_tl hapft2 where hapf.supervisor_position_id=hapft2.position_id and hapft2.language=userenv('lang')) supervisor_position, (select hapft2.name from hr_all_positions_f_tl hapft2 where hapf.relief_position_id=hapft2.position_id and hapft2.language=userenv('lang')) relief_position, (select hapft2.name from hr_all_positions_f_tl hapft2 where hapf.successor_position_id=hapft2.position_id and hapft2.language=userenv('lang')) successor_position, xxen_util.display_flexfield_context(800,'PER_POSITIONS',hapf.attribute_category) pos_attribute_category, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE1',hapf.rowid,hapf.attribute1) pos_attribute1, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE2',hapf.rowid,hapf.attribute2) pos_attribute2, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE3',hapf.rowid,hapf.attribute3) pos_attribute3, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE4',hapf.rowid,hapf.attribute4) pos_attribute4, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE5',hapf.rowid,hapf.attribute5) pos_attribute5, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE6',hapf.rowid,hapf.attribute6) pos_attribute6, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE7',hapf.rowid,hapf.attribute7) pos_attribute7, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE8',hapf.rowid,hapf.attribute8) pos_attribute8, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE9',hapf.rowid,hapf.attribute9) pos_attribute9, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE10',hapf.rowid,hapf.attribute10) pos_attribute10, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE11',hapf.rowid,hapf.attribute11) pos_attribute11, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE12',hapf.rowid,hapf.attribute12) pos_attribute12, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE13',hapf.rowid,hapf.attribute13) pos_attribute13, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE14',hapf.rowid,hapf.attribute14) pos_attribute14, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE15',hapf.rowid,hapf.attribute15) pos_attribute15, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE16',hapf.rowid,hapf.attribute16) pos_attribute16, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE17',hapf.rowid,hapf.attribute17) pos_attribute17, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE18',hapf.rowid,hapf.attribute18) pos_attribute18, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE19',hapf.rowid,hapf.attribute19) pos_attribute19, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE20',hapf.rowid,hapf.attribute20) pos_attribute20, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE21',hapf.rowid,hapf.attribute21) pos_attribute21, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE22',hapf.rowid,hapf.attribute22) pos_attribute22, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE23',hapf.rowid,hapf.attribute23) pos_attribute23, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE24',hapf.rowid,hapf.attribute24) pos_attribute24, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE25',hapf.rowid,hapf.attribute25) pos_attribute25, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE26',hapf.rowid,hapf.attribute26) pos_attribute26, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE27',hapf.rowid,hapf.attribute27) pos_attribute27, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE28',hapf.rowid,hapf.attribute28) pos_attribute28, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE29',hapf.rowid,hapf.attribute29) pos_attribute29, xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE30',hapf.rowid,hapf.attribute30) pos_attribute30, 0 upload_row from per_business_groups pbg, hr_all_positions_f hapf, hr_all_positions_f_tl hapft where 1=1 and pbg.business_group_id=:business_group_id and hapf.business_group_id=pbg.business_group_id and :effective_date between hapf.effective_start_date and hapf.effective_end_date and hapf.position_id=hapft.position_id and hapft.language=userenv('lang') Initial version U A xxen_per_upload.create_update_position US PER Position Upload Upload to create and update positions as in the Position window (Define Position): name, type, organization, job, hiring status, location, FTE and headcount, hiring information, work terms, supervisor, relief and successor positions and the Additional Position Details flexfield. Positions are date tracked. Changes are made as of the Effective Date: when Datetrack Mode is blank, the position is corrected if the Effective Date is the start date of its current record, and otherwise a change is inserted from the Effective Date. A row whose Name does not exist in the business group creates the position with hr_position_api.create_position. Name is the concatenated Position flexfield segments; changing it on a downloaded row renames the position. Organization and job cannot be changed once the position exists. Enginatics R12 only 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 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 FND Business Groups D7815153ACE3306DE0530100007FD65A select pbg.business_group_id id, pbg.name value, pbg.short_name description from per_business_groups pbg 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 positions are shown as of and the default date the uploaded changes take effect. 4 40 1=1 hapf.position_id=:position_id LOV custom select hapft.position_id id, hapft.name value, null description from hr_all_positions_f_tl hapft where hapft.language=userenv('lang') and hapft.position_id in (select hapf.position_id from hr_all_positions_f hapf where hapf.business_group_id=:$flex$.Business_Group) order by hapft.name US Position 5 50 1=1 hapf.organization_id=:organization_id LOV custom 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 hapf.job_id=:job_id LOV custom 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 hapf.availability_status_id=:availability_status_id LOV custom select pstv.shared_type_id id, pstv.shared_type_name value, null description from per_shared_types_vl pstv where pstv.lookup_type='POSITION_AVAILABILITY_STATUS' and nvl(pstv.business_group_id,:$flex$.Business_Group)=:$flex$.Business_Group order by pstv.shared_type_name US Hiring Status FD4A1378BA6E42388C2B48C64B7DE86C Create Positions Empty sheet to create new positions. ENGINATICS 17 BUSINESS_GROUP 18 EFFECTIVE_DATE 15 END_TIME 13 FREQUENCY 10 FTE 11 HEADCOUNT 8 HIRING_STATUS 7 JOB 9 LOCATION 1 NAME 6 ORGANIZATION 4 PERMANENT 3 POSITION_TYPE 5 SEASONAL 2 START_DATE Y 14 START_TIME 16 SUPERVISOR_POSITION 12 WORKING_HOURS Upload Mode C Y S Site Hiring Status Job Organization Position C566C892D48D4C2C80458FEB3E072140 Default The Position window fields, without the flexfields. ENGINATICS 14 BARGAINING_UNIT 35 BUSINESS_GROUP 3 DATETRACK_MODE 15 EARLIEST_HIRE_DATE 2 EFFECTIVE_DATE Y 28 END_TIME 20 ENTRY_GRADE 16 FILL_BY_DATE 26 FREQUENCY 12 FTE 13 HEADCOUNT 10 HIRING_STATUS 9 JOB 11 LOCATION 1 NAME 8 ORGANIZATION 23 OVERLAP_DURATION 24 OVERLAP_UNITS 18 PAYROLL 6 PERMANENT 17 PERMIT_RECRUITING 5 POSITION_TYPE 21 PROBATION_DURATION 22 PROBATION_UNITS 33 RELIEF_POSITION 31 REPLACEMENT_REQUIRED 19 SALARY_BASIS 7 SEASONAL 4 START_DATE 27 START_TIME 34 SUCCESSOR_POSITION 30 SUPERVISOR_NAME 29 SUPERVISOR_NUMBER 32 SUPERVISOR_POSITION 25 WORKING_HOURS Upload Mode C,U S Site 5B02B78595F74D7B95997C2F9E99CEC2 Flexfields Position name with the Additional Position Details flexfield. ENGINATICS 4 BUSINESS_GROUP 3 DATETRACK_MODE 2 EFFECTIVE_DATE Y 1 NAME 6 POS_ATTRIBUTE1 15 POS_ATTRIBUTE10 16 POS_ATTRIBUTE11 17 POS_ATTRIBUTE12 18 POS_ATTRIBUTE13 19 POS_ATTRIBUTE14 20 POS_ATTRIBUTE15 21 POS_ATTRIBUTE16 22 POS_ATTRIBUTE17 23 POS_ATTRIBUTE18 24 POS_ATTRIBUTE19 7 POS_ATTRIBUTE2 25 POS_ATTRIBUTE20 26 POS_ATTRIBUTE21 27 POS_ATTRIBUTE22 28 POS_ATTRIBUTE23 29 POS_ATTRIBUTE24 30 POS_ATTRIBUTE25 31 POS_ATTRIBUTE26 32 POS_ATTRIBUTE27 33 POS_ATTRIBUTE28 34 POS_ATTRIBUTE29 8 POS_ATTRIBUTE3 35 POS_ATTRIBUTE30 9 POS_ATTRIBUTE4 10 POS_ATTRIBUTE5 11 POS_ATTRIBUTE6 12 POS_ATTRIBUTE7 13 POS_ATTRIBUTE8 14 POS_ATTRIBUTE9 5 POS_ATTRIBUTE_CATEGORY Upload Mode C,U S Site CCBBEC9BD32546DEBD961624411B5DB3 Hiring Status and Headcount Mass change of the hiring status, FTE and headcount as of the Effective Date. ENGINATICS 9 BUSINESS_GROUP 3 DATETRACK_MODE 2 EFFECTIVE_DATE Y 7 FTE 8 HEADCOUNT 6 HIRING_STATUS 5 JOB 1 NAME 4 ORGANIZATION Upload Mode C,U S Site C566C892D48D4C2C80458FEB3E072140 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 POSITION_ID_OUT Number number Y 6 POSITION_ID Number number Y 7 BUSINESS_GROUP LOV custom varchar2 240 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 EFFECTIVE_DATE Date date :$flex$.Effective_Date Date the position changes take effect. Defaults from the Effective Date parameter. 9 DATETRACK_MODE LOV varchar2 80 PER Datetrack Mode C2B369C438934DD881605CB3FC10EF14 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 position when the Effective Date is its start date and to insert a change otherwise. 10 NAME Char varchar2 240 Position name as the concatenated segments of the Position flexfield. A new name creates the position, or renames it when the row carries a downloaded position. Y 11 START_DATE Date date Date the position becomes effective. Defaults to the Effective Date for a new position. 12 POSITION_TYPE LOV custom varchar2 80 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='POSITION_TYPE' 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 13 PERMANENT LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 14 SEASONAL LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 15 ORGANIZATION LOV custom varchar2 240 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 haouv.internal_external_flag='INT' and nvl(:$column$.start_date,nvl(:$column$.effective_date,trunc(sysdate))) between haouv.date_from and nvl(haouv.date_to,nvl(:$column$.start_date,nvl(:$column$.effective_date,trunc(sysdate)))) order by haouv.name Required for a new position. Cannot be changed on an existing position. 16 JOB LOV custom varchar2 240 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$.start_date,nvl(:$column$.effective_date,trunc(sysdate))) between pjv.date_from and nvl(pjv.date_to,nvl(:$column$.start_date,nvl(:$column$.effective_date,trunc(sysdate)))) order by pjv.name Required for a new position. Cannot be changed on an existing position. 17 HIRING_STATUS LOV custom varchar2 80 select pstv.shared_type_id id, pstv.shared_type_name value, xxen_util.meaning(pstv.system_type_cd,'POSITION_AVAILABILITY_STATUS',3) description from per_business_groups pbg, per_shared_types_vl pstv where pbg.name=:$column$.business_group and pstv.lookup_type='POSITION_AVAILABILITY_STATUS' and nvl(pstv.business_group_id,pbg.business_group_id)=pbg.business_group_id order by pstv.shared_type_name 18 LOCATION LOV custom varchar2 60 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 19 FTE Number number 20 HEADCOUNT Number number 21 BARGAINING_UNIT LOV custom varchar2 80 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 22 EARLIEST_HIRE_DATE Date date 23 FILL_BY_DATE Date date 24 PERMIT_RECRUITING LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 25 PAYROLL LOV custom varchar2 80 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 26 SALARY_BASIS LOV custom varchar2 80 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 27 ENTRY_GRADE LOV custom varchar2 240 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 28 PROBATION_DURATION Number number 29 PROBATION_UNITS LOV custom varchar2 80 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 30 OVERLAP_DURATION Number number 31 OVERLAP_UNITS LOV custom varchar2 80 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 32 WORKING_HOURS Number number 33 FREQUENCY LOV custom varchar2 80 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 34 START_TIME Char varchar2 5 Normal start time in the format HH24:MI. 35 END_TIME Char varchar2 5 Normal end time in the format HH24:MI. 36 SUPERVISOR_NUMBER LOV custom varchar2 30 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 37 SUPERVISOR_NAME Char varchar2 240 select papf.full_name 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.employee_number=:$column$.supervisor_number and nvl(:$column$.effective_date,trunc(sysdate)) between papf.effective_start_date and papf.effective_end_date Y 38 REPLACEMENT_REQUIRED LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 39 SUPERVISOR_POSITION LOV custom varchar2 240 select hapf.position_id id, hapft.name value, null description from per_business_groups pbg, hr_all_positions_f hapf, hr_all_positions_f_tl hapft where pbg.name=:$column$.business_group and hapf.business_group_id=pbg.business_group_id and nvl(:$column$.effective_date,trunc(sysdate)) between hapf.effective_start_date and hapf.effective_end_date and hapf.position_id=hapft.position_id and hapft.language=userenv('lang') order by hapft.name 40 RELIEF_POSITION LOV custom varchar2 240 select hapf.position_id id, hapft.name value, null description from per_business_groups pbg, hr_all_positions_f hapf, hr_all_positions_f_tl hapft where pbg.name=:$column$.business_group and hapf.business_group_id=pbg.business_group_id and nvl(:$column$.effective_date,trunc(sysdate)) between hapf.effective_start_date and hapf.effective_end_date and hapf.position_id=hapft.position_id and hapft.language=userenv('lang') order by hapft.name 41 SUCCESSOR_POSITION LOV custom varchar2 240 select hapf.position_id id, hapft.name value, null description from per_business_groups pbg, hr_all_positions_f hapf, hr_all_positions_f_tl hapft where pbg.name=:$column$.business_group and hapf.business_group_id=pbg.business_group_id and nvl(:$column$.effective_date,trunc(sysdate)) between hapf.effective_start_date and hapf.effective_end_date and hapf.position_id=hapft.position_id and hapft.language=userenv('lang') order by hapft.name 42 POS_ATTRIBUTE_CATEGORY LOV custom varchar2 80 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_POSITIONS' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 43 POS_ATTRIBUTE1 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE1' 44 POS_ATTRIBUTE2 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE2' 45 POS_ATTRIBUTE3 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE3' 46 POS_ATTRIBUTE4 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE4' 47 POS_ATTRIBUTE5 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE5' 48 POS_ATTRIBUTE6 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE6' 49 POS_ATTRIBUTE7 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE7' 50 POS_ATTRIBUTE8 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE8' 51 POS_ATTRIBUTE9 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE9' 52 POS_ATTRIBUTE10 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE10' 53 POS_ATTRIBUTE11 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE11' 54 POS_ATTRIBUTE12 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE12' 55 POS_ATTRIBUTE13 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE13' 56 POS_ATTRIBUTE14 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE14' 57 POS_ATTRIBUTE15 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE15' 58 POS_ATTRIBUTE16 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE16' 59 POS_ATTRIBUTE17 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE17' 60 POS_ATTRIBUTE18 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE18' 61 POS_ATTRIBUTE19 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE19' 62 POS_ATTRIBUTE20 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE20' 63 POS_ATTRIBUTE21 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE21', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE21' 64 POS_ATTRIBUTE22 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE22', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE22' 65 POS_ATTRIBUTE23 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE23', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE23' 66 POS_ATTRIBUTE24 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE24', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE24' 67 POS_ATTRIBUTE25 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE25', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE25' 68 POS_ATTRIBUTE26 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE26', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE26' 69 POS_ATTRIBUTE27 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE27', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE27' 70 POS_ATTRIBUTE28 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE28', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE28' 71 POS_ATTRIBUTE29 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE29', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE29' 72 POS_ATTRIBUTE30 LOV custom varchar2 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_POSITIONS', p_context_name=>:$column$.pos_attribute_category, p_column_name=>'ATTRIBUTE30', p_attribute1=>:$column$.pos_attribute1, p_attribute2=>:$column$.pos_attribute2, p_attribute3=>:$column$.pos_attribute3, p_attribute4=>:$column$.pos_attribute4, p_attribute5=>:$column$.pos_attribute5, p_attribute6=>:$column$.pos_attribute6, p_attribute7=>:$column$.pos_attribute7, p_attribute8=>:$column$.pos_attribute8, p_attribute9=>:$column$.pos_attribute9, p_attribute10=>:$column$.pos_attribute10, p_attribute11=>:$column$.pos_attribute11, p_attribute12=>:$column$.pos_attribute12, p_attribute13=>:$column$.pos_attribute13, p_attribute14=>:$column$.pos_attribute14, p_attribute15=>:$column$.pos_attribute15, p_attribute16=>:$column$.pos_attribute16, p_attribute17=>:$column$.pos_attribute17, p_attribute18=>:$column$.pos_attribute18, p_attribute19=>:$column$.pos_attribute19, p_attribute20=>:$column$.pos_attribute20, p_attribute21=>:$column$.pos_attribute21, p_attribute22=>:$column$.pos_attribute22, p_attribute23=>:$column$.pos_attribute23, p_attribute24=>:$column$.pos_attribute24, p_attribute25=>:$column$.pos_attribute25, p_attribute26=>:$column$.pos_attribute26, p_attribute27=>:$column$.pos_attribute27, p_attribute28=>:$column$.pos_attribute28, p_attribute29=>:$column$.pos_attribute29, p_attribute30=>:$column$.pos_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_POSITIONS' 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='ATTRIBUTE30' 73 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 p_position_id_out in/out Number POSITION_ID_OUT U 3 p_business_group_id in Number BUSINESS_GROUP U 4 p_position_id in Number Y POSITION_ID U 5 p_effective_date in Date Y EFFECTIVE_DATE U 6 p_datetrack_mode in Char Y DATETRACK_MODE U 7 p_name in Char Y NAME U 8 p_date_effective in Date Y START_DATE U 9 p_position_type in Char Y POSITION_TYPE U 10 p_permanent_temporary_flag in Char Y PERMANENT U 11 p_seasonal_flag in Char Y SEASONAL U 12 p_organization_id in Number Y ORGANIZATION U 13 p_job_id in Number Y JOB U 14 p_availability_status_id in Number Y HIRING_STATUS U 15 p_location_id in Number Y LOCATION U 16 p_fte in Number Y FTE U 17 p_max_persons in Number Y HEADCOUNT U 18 p_bargaining_unit_cd in Char Y BARGAINING_UNIT U 19 p_earliest_hire_date in Date Y EARLIEST_HIRE_DATE U 20 p_fill_by_date in Date Y FILL_BY_DATE U 21 p_permit_recruitment_flag in Char Y PERMIT_RECRUITING U 22 p_pay_freq_payroll_id in Number Y PAYROLL U 23 p_pay_basis_id in Number Y SALARY_BASIS U 24 p_entry_grade_id in Number Y ENTRY_GRADE U 25 p_probation_period in Number Y PROBATION_DURATION U 26 p_probation_period_unit_cd in Char Y PROBATION_UNITS U 27 p_overlap_period in Number Y OVERLAP_DURATION U 28 p_overlap_unit_cd in Char Y OVERLAP_UNITS U 29 p_working_hours in Number Y WORKING_HOURS U 30 p_frequency in Char Y FREQUENCY U 31 p_time_normal_start in Char Y START_TIME U 32 p_time_normal_finish in Char Y END_TIME U 33 p_supervisor_id in Number Y SUPERVISOR_NUMBER U 34 p_replacement_required_flag in Char Y REPLACEMENT_REQUIRED U 35 p_supervisor_position_id in Number Y SUPERVISOR_POSITION U 36 p_relief_position_id in Number Y RELIEF_POSITION U 37 p_successor_position_id in Number Y SUCCESSOR_POSITION U 38 p_pos_attribute_category in Char Y POS_ATTRIBUTE_CATEGORY U 39 p_pos_attribute1 in Char Y POS_ATTRIBUTE1 U 40 p_pos_attribute2 in Char Y POS_ATTRIBUTE2 U 41 p_pos_attribute3 in Char Y POS_ATTRIBUTE3 U 42 p_pos_attribute4 in Char Y POS_ATTRIBUTE4 U 43 p_pos_attribute5 in Char Y POS_ATTRIBUTE5 U 44 p_pos_attribute6 in Char Y POS_ATTRIBUTE6 U 45 p_pos_attribute7 in Char Y POS_ATTRIBUTE7 U 46 p_pos_attribute8 in Char Y POS_ATTRIBUTE8 U 47 p_pos_attribute9 in Char Y POS_ATTRIBUTE9 U 48 p_pos_attribute10 in Char Y POS_ATTRIBUTE10 U 49 p_pos_attribute11 in Char Y POS_ATTRIBUTE11 U 50 p_pos_attribute12 in Char Y POS_ATTRIBUTE12 U 51 p_pos_attribute13 in Char Y POS_ATTRIBUTE13 U 52 p_pos_attribute14 in Char Y POS_ATTRIBUTE14 U 53 p_pos_attribute15 in Char Y POS_ATTRIBUTE15 U 54 p_pos_attribute16 in Char Y POS_ATTRIBUTE16 U 55 p_pos_attribute17 in Char Y POS_ATTRIBUTE17 U 56 p_pos_attribute18 in Char Y POS_ATTRIBUTE18 U 57 p_pos_attribute19 in Char Y POS_ATTRIBUTE19 U 58 p_pos_attribute20 in Char Y POS_ATTRIBUTE20 U 59 p_pos_attribute21 in Char Y POS_ATTRIBUTE21 U 60 p_pos_attribute22 in Char Y POS_ATTRIBUTE22 U 61 p_pos_attribute23 in Char Y POS_ATTRIBUTE23 U 62 p_pos_attribute24 in Char Y POS_ATTRIBUTE24 U 63 p_pos_attribute25 in Char Y POS_ATTRIBUTE25 U 64 p_pos_attribute26 in Char Y POS_ATTRIBUTE26 U 65 p_pos_attribute27 in Char Y POS_ATTRIBUTE27 U 66 p_pos_attribute28 in Char Y POS_ATTRIBUTE28 U 67 p_pos_attribute29 in Char Y POS_ATTRIBUTE29 U 68 p_pos_attribute30 in Char Y POS_ATTRIBUTE30 U 69 status_ out Char STATUS_CODE_ U 70 message_ out Char MESSAGE_ Error SQL Order By upload_row, name Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.position_id_out, nvl(hapf.position_id,xu.position_id) position_id, nvl(pbg.name,xu.business_group) business_group, xu.effective_date, xu.datetrack_mode, nvl(hapft.name,xu.name) name, nvl(hapf.date_effective,xu.start_date) start_date, nvl(xxen_util.meaning(hapf.position_type,'POSITION_TYPE',3),xu.position_type) position_type, nvl(xxen_util.yes(hapf.permanent_temporary_flag),xu.permanent) permanent, nvl(xxen_util.yes(hapf.seasonal_flag),xu.seasonal) seasonal, nvl((select haouv.name from hr_all_organization_units_vl haouv where hapf.organization_id=haouv.organization_id),xu.organization) organization, nvl((select pjv.name from per_jobs_vl pjv where hapf.job_id=pjv.job_id),xu.job) job, nvl((select pstv.shared_type_name from per_shared_types_vl pstv where hapf.availability_status_id=pstv.shared_type_id),xu.hiring_status) hiring_status, nvl((select hlav.location_code from hr_locations_all_vl hlav where hapf.location_id=hlav.location_id),xu.location) location, nvl(hapf.fte,xu.fte) fte, nvl(hapf.max_persons,xu.headcount) headcount, nvl(xxen_util.meaning(hapf.bargaining_unit_cd,'BARGAINING_UNIT_CODE',3),xu.bargaining_unit) bargaining_unit, nvl(hapf.earliest_hire_date,xu.earliest_hire_date) earliest_hire_date, nvl(hapf.fill_by_date,xu.fill_by_date) fill_by_date, nvl(xxen_util.yes(hapf.permit_recruitment_flag),xu.permit_recruiting) permit_recruiting, nvl((select papf2.payroll_name from pay_all_payrolls_f papf2 where hapf.pay_freq_payroll_id=papf2.payroll_id and xu.row_date between papf2.effective_start_date and papf2.effective_end_date),xu.payroll) payroll, nvl((select ppb.name from per_pay_bases ppb where hapf.pay_basis_id=ppb.pay_basis_id),xu.salary_basis) salary_basis, nvl((select pgv.name from per_grades_vl pgv where hapf.entry_grade_id=pgv.grade_id),xu.entry_grade) entry_grade, nvl(hapf.probation_period,xu.probation_duration) probation_duration, nvl(xxen_util.meaning(hapf.probation_period_unit_cd,'FREQUENCY',3),xu.probation_units) probation_units, nvl(hapf.overlap_period,xu.overlap_duration) overlap_duration, nvl(xxen_util.meaning(hapf.overlap_unit_cd,'FREQUENCY',3),xu.overlap_units) overlap_units, nvl(hapf.working_hours,xu.working_hours) working_hours, nvl(xxen_util.meaning(hapf.frequency,'FREQUENCY',3),xu.frequency) frequency, nvl(hapf.time_normal_start,xu.start_time) start_time, nvl(hapf.time_normal_finish,xu.end_time) end_time, nvl((select papf.employee_number from per_all_people_f papf where hapf.supervisor_id=papf.person_id and xu.row_date between papf.effective_start_date and papf.effective_end_date),xu.supervisor_number) supervisor_number, nvl((select papf.full_name from per_all_people_f papf where hapf.supervisor_id=papf.person_id and xu.row_date between papf.effective_start_date and papf.effective_end_date),xu.supervisor_name) supervisor_name, nvl(xxen_util.yes(hapf.replacement_required_flag),xu.replacement_required) replacement_required, nvl((select hapft2.name from hr_all_positions_f_tl hapft2 where hapf.supervisor_position_id=hapft2.position_id and hapft2.language=userenv('lang')),xu.supervisor_position) supervisor_position, nvl((select hapft2.name from hr_all_positions_f_tl hapft2 where hapf.relief_position_id=hapft2.position_id and hapft2.language=userenv('lang')),xu.relief_position) relief_position, nvl((select hapft2.name from hr_all_positions_f_tl hapft2 where hapf.successor_position_id=hapft2.position_id and hapft2.language=userenv('lang')),xu.successor_position) successor_position, nvl(xxen_util.display_flexfield_context(800,'PER_POSITIONS',hapf.attribute_category),xu.pos_attribute_category) pos_attribute_category, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE1',hapf.rowid,hapf.attribute1),xu.pos_attribute1) pos_attribute1, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE2',hapf.rowid,hapf.attribute2),xu.pos_attribute2) pos_attribute2, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE3',hapf.rowid,hapf.attribute3),xu.pos_attribute3) pos_attribute3, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE4',hapf.rowid,hapf.attribute4),xu.pos_attribute4) pos_attribute4, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE5',hapf.rowid,hapf.attribute5),xu.pos_attribute5) pos_attribute5, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE6',hapf.rowid,hapf.attribute6),xu.pos_attribute6) pos_attribute6, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE7',hapf.rowid,hapf.attribute7),xu.pos_attribute7) pos_attribute7, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE8',hapf.rowid,hapf.attribute8),xu.pos_attribute8) pos_attribute8, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE9',hapf.rowid,hapf.attribute9),xu.pos_attribute9) pos_attribute9, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE10',hapf.rowid,hapf.attribute10),xu.pos_attribute10) pos_attribute10, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE11',hapf.rowid,hapf.attribute11),xu.pos_attribute11) pos_attribute11, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE12',hapf.rowid,hapf.attribute12),xu.pos_attribute12) pos_attribute12, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE13',hapf.rowid,hapf.attribute13),xu.pos_attribute13) pos_attribute13, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE14',hapf.rowid,hapf.attribute14),xu.pos_attribute14) pos_attribute14, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE15',hapf.rowid,hapf.attribute15),xu.pos_attribute15) pos_attribute15, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE16',hapf.rowid,hapf.attribute16),xu.pos_attribute16) pos_attribute16, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE17',hapf.rowid,hapf.attribute17),xu.pos_attribute17) pos_attribute17, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE18',hapf.rowid,hapf.attribute18),xu.pos_attribute18) pos_attribute18, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE19',hapf.rowid,hapf.attribute19),xu.pos_attribute19) pos_attribute19, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE20',hapf.rowid,hapf.attribute20),xu.pos_attribute20) pos_attribute20, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE21',hapf.rowid,hapf.attribute21),xu.pos_attribute21) pos_attribute21, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE22',hapf.rowid,hapf.attribute22),xu.pos_attribute22) pos_attribute22, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE23',hapf.rowid,hapf.attribute23),xu.pos_attribute23) pos_attribute23, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE24',hapf.rowid,hapf.attribute24),xu.pos_attribute24) pos_attribute24, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE25',hapf.rowid,hapf.attribute25),xu.pos_attribute25) pos_attribute25, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE26',hapf.rowid,hapf.attribute26),xu.pos_attribute26) pos_attribute26, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE27',hapf.rowid,hapf.attribute27),xu.pos_attribute27) pos_attribute27, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE28',hapf.rowid,hapf.attribute28),xu.pos_attribute28) pos_attribute28, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE29',hapf.rowid,hapf.attribute29),xu.pos_attribute29) pos_attribute29, nvl(xxen_util.display_flexfield_value(800,'PER_POSITIONS',hapf.attribute_category,'ATTRIBUTE30',hapf.rowid,hapf.attribute30),xu.pos_attribute30) pos_attribute30, xu.upload_row from ( select xu.*, nvl(xu.effective_date,trunc(sysdate)) row_date from xxen_per_position_uploa_9584_u xu where xu.status_code_=xxen_upload.status_success ) xu, hr_all_positions_f hapf, hr_all_positions_f_tl hapft, per_business_groups pbg where xu.position_id_out=hapf.position_id(+) and xu.row_date between hapf.effective_start_date(+) and hapf.effective_end_date(+) and hapf.position_id=hapft.position_id(+) and hapft.language(+)=userenv('lang') and hapf.business_group_id=pbg.business_group_id(+)