ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8F5049BB0491461688C564EA25195417Y select null action_, null status_, null message_, null modified_columns_, to_number(null) absence_id_out, paa.absence_attendance_id absence_id, pbg.name business_group, papf.employee_number, papf.full_name, paatv.name absence_type, xxen_util.meaning(paatv.absence_category,'ABSENCE_CATEGORY',3) category, (select xxen_util.meaning(paar.name,'ABSENCE_REASON',3) from per_abs_attendance_reasons paar where paa.abs_attendance_reason_id=paar.abs_attendance_reason_id) reason, paa.occurrence, paa.date_notification notified, paa.date_projected_start projected_start, paa.time_projected_start projected_start_time, paa.date_projected_end projected_end, paa.time_projected_end projected_end_time, paa.date_start actual_start, paa.time_start actual_start_time, paa.date_end actual_end, paa.time_end actual_end_time, paa.absence_days duration_days, paa.absence_hours duration_hours, paa.reason_for_notification_delay reason_for_late_notification, xxen_util.yes(paa.accept_late_notification_flag) accept_late_notification, (select papf2.employee_number from per_all_people_f papf2 where paa.authorising_person_id=papf2.person_id and coalesce(paa.date_start,paa.date_projected_start,trunc(sysdate)) between papf2.effective_start_date and papf2.effective_end_date) authorized_by_number, (select papf2.full_name from per_all_people_f papf2 where paa.authorising_person_id=papf2.person_id and coalesce(paa.date_start,paa.date_projected_start,trunc(sysdate)) between papf2.effective_start_date and papf2.effective_end_date) authorized_by_name, (select papf2.employee_number from per_all_people_f papf2 where paa.replacement_person_id=papf2.person_id and coalesce(paa.date_start,paa.date_projected_start,trunc(sysdate)) between papf2.effective_start_date and papf2.effective_end_date) replaced_by_number, (select papf2.full_name from per_all_people_f papf2 where paa.replacement_person_id=papf2.person_id and coalesce(paa.date_start,paa.date_projected_start,trunc(sysdate)) between papf2.effective_start_date and papf2.effective_end_date) replaced_by_name, null delete_absence, xxen_util.display_flexfield_context(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category) abs_attribute_category, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE1',paa.rowid,paa.attribute1) abs_attribute1, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE2',paa.rowid,paa.attribute2) abs_attribute2, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE3',paa.rowid,paa.attribute3) abs_attribute3, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE4',paa.rowid,paa.attribute4) abs_attribute4, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE5',paa.rowid,paa.attribute5) abs_attribute5, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE6',paa.rowid,paa.attribute6) abs_attribute6, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE7',paa.rowid,paa.attribute7) abs_attribute7, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE8',paa.rowid,paa.attribute8) abs_attribute8, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE9',paa.rowid,paa.attribute9) abs_attribute9, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE10',paa.rowid,paa.attribute10) abs_attribute10, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE11',paa.rowid,paa.attribute11) abs_attribute11, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE12',paa.rowid,paa.attribute12) abs_attribute12, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE13',paa.rowid,paa.attribute13) abs_attribute13, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE14',paa.rowid,paa.attribute14) abs_attribute14, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE15',paa.rowid,paa.attribute15) abs_attribute15, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE16',paa.rowid,paa.attribute16) abs_attribute16, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE17',paa.rowid,paa.attribute17) abs_attribute17, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE18',paa.rowid,paa.attribute18) abs_attribute18, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE19',paa.rowid,paa.attribute19) abs_attribute19, xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE20',paa.rowid,paa.attribute20) abs_attribute20, 0 upload_row from per_business_groups pbg, per_all_people_f papf, per_absence_attendances paa, per_abs_attendance_types_vl paatv where 1=1 and pbg.business_group_id=:business_group_id and papf.business_group_id=pbg.business_group_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and papf.person_id=paa.person_id and paa.absence_attendance_type_id=paatv.absence_attendance_type_id Initial version U A xxen_per_upload.create_update_absence US PER Absence Upload Upload to create, update and delete person absences as in the Absence Detail window: absence type and reason, notification, projected and actual dates and times, duration, late notification, authorizer and replacement, and the Additional Absence Details flexfield. A row is matched to an existing absence by the hidden absence id of a downloaded row, otherwise by employee, absence type and start date (actual, or projected when there is no actual start). Absences are created and updated with hr_person_absence_api, which also maintains the element entry of absence types linked to an element. Durations left blank are calculated by the api. Set Delete Absence to Yes to delete a downloaded absence. Enginatics R12 only Upload 1=1 :business_group_id 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 1=1 papf.employee_number=:employee_number LOV custom select papf.employee_number id, papf.employee_number value, papf.full_name description from per_all_people_f papf where papf.business_group_id=:$flex$.Business_Group and papf.employee_number is not null and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date order by papf.employee_number US Employee Number 4 40 1=1 paa.absence_attendance_type_id=:absence_attendance_type_id LOV custom select paatv.absence_attendance_type_id id, paatv.name value, null description from per_abs_attendance_types_vl paatv where paatv.business_group_id=:$flex$.Business_Group order by paatv.name US Absence Type 5 50 1=1 coalesce(paa.date_start,paa.date_projected_start)>=:start_date_from Date US Start Date From 6 60 1=1 coalesce(paa.date_start,paa.date_projected_start)<:start_date_to+1 Date :$flex$.Start_Date_From US Start Date To 52ECB4DD9B704CD0B97004E81F019C2D Create Absences Empty sheet to record new absences. ENGINATICS 3 ABSENCE_TYPE Y 11 ACTUAL_END 12 ACTUAL_END_TIME 9 ACTUAL_START 10 ACTUAL_START_TIME 16 AUTHORIZED_BY_NAME 15 AUTHORIZED_BY_NUMBER 17 BUSINESS_GROUP 4 CATEGORY 13 DURATION_DAYS 14 DURATION_HOURS 1 EMPLOYEE_NUMBER 2 FULL_NAME 6 NOTIFIED 8 PROJECTED_END 7 PROJECTED_START 5 REASON Upload Mode C Y S Site Absence Type Employee Number Start Date From Start Date To 7CBCFA1F7D134E41AB12CDB4E32A7C88 Default The Absence Detail window fields, without the flexfield. ENGINATICS 3 ABSENCE_TYPE Y 19 ACCEPT_LATE_NOTIFICATION 14 ACTUAL_END 15 ACTUAL_END_TIME 12 ACTUAL_START 13 ACTUAL_START_TIME 21 AUTHORIZED_BY_NAME 20 AUTHORIZED_BY_NUMBER 25 BUSINESS_GROUP 4 CATEGORY 24 DELETE_ABSENCE 16 DURATION_DAYS 17 DURATION_HOURS 1 EMPLOYEE_NUMBER 2 FULL_NAME 7 NOTIFIED 6 OCCURRENCE 10 PROJECTED_END 11 PROJECTED_END_TIME 8 PROJECTED_START 9 PROJECTED_START_TIME 5 REASON 18 REASON_FOR_LATE_NOTIFICATION 23 REPLACED_BY_NAME 22 REPLACED_BY_NUMBER Upload Mode C,U S Site 1C3D7B75D9AA44B9BC4A3B78C3118DA7 Delete Absences Downloaded absences with the Delete Absence column to remove them. ENGINATICS 3 ABSENCE_TYPE Y 6 ACTUAL_END 5 ACTUAL_START 9 BUSINESS_GROUP 8 DELETE_ABSENCE 7 DURATION_DAYS 1 EMPLOYEE_NUMBER 2 FULL_NAME 4 PROJECTED_START Upload Mode C,U S Site 99F293A85C2F4FA29D40D50AFC5BE66E Flexfields Absence key with the Additional Absence Details flexfield. ENGINATICS 3 ABSENCE_TYPE Y 8 ABS_ATTRIBUTE1 17 ABS_ATTRIBUTE10 18 ABS_ATTRIBUTE11 19 ABS_ATTRIBUTE12 20 ABS_ATTRIBUTE13 21 ABS_ATTRIBUTE14 22 ABS_ATTRIBUTE15 23 ABS_ATTRIBUTE16 24 ABS_ATTRIBUTE17 25 ABS_ATTRIBUTE18 26 ABS_ATTRIBUTE19 9 ABS_ATTRIBUTE2 27 ABS_ATTRIBUTE20 10 ABS_ATTRIBUTE3 11 ABS_ATTRIBUTE4 12 ABS_ATTRIBUTE5 13 ABS_ATTRIBUTE6 14 ABS_ATTRIBUTE7 15 ABS_ATTRIBUTE8 16 ABS_ATTRIBUTE9 7 ABS_ATTRIBUTE_CATEGORY 5 ACTUAL_START 6 BUSINESS_GROUP 1 EMPLOYEE_NUMBER 2 FULL_NAME 4 PROJECTED_START Upload Mode C,U S Site 7CBCFA1F7D134E41AB12CDB4E32A7C88 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 ABSENCE_ID_OUT Number number Y 6 ABSENCE_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 EMPLOYEE_NUMBER LOV custom varchar2 30 Y select papf.employee_number id, papf.employee_number value, papf.full_name description from per_business_groups pbg, per_all_people_f papf where pbg.name=:$column$.business_group and papf.business_group_id=pbg.business_group_id and papf.employee_number is not null and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date order by papf.employee_number Y 9 FULL_NAME Char varchar2 240 select papf.full_name from per_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$.employee_number and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date Y 10 ABSENCE_TYPE LOV custom varchar2 80 select paatv.absence_attendance_type_id id, paatv.name value, xxen_util.meaning(paatv.absence_category,'ABSENCE_CATEGORY',3) description from per_business_groups pbg, per_abs_attendance_types_vl paatv where pbg.name=:$column$.business_group and paatv.business_group_id=pbg.business_group_id order by paatv.name Cannot be changed on an existing absence. Y 11 CATEGORY Char varchar2 80 select xxen_util.meaning(paatv.absence_category,'ABSENCE_CATEGORY',3) from per_business_groups pbg, per_abs_attendance_types_vl paatv where pbg.name=:$column$.business_group and paatv.business_group_id=pbg.business_group_id and paatv.name=:$column$.absence_type Y 12 REASON LOV custom varchar2 80 select paar.abs_attendance_reason_id id, xxen_util.meaning(paar.name,'ABSENCE_REASON',3) value, null description from per_business_groups pbg, per_abs_attendance_types_vl paatv, per_abs_attendance_reasons paar where pbg.name=:$column$.business_group and paatv.business_group_id=pbg.business_group_id and paatv.name=:$column$.absence_type and paatv.absence_attendance_type_id=paar.absence_attendance_type_id order by 2 13 OCCURRENCE Number number Y 14 NOTIFIED Date date 15 PROJECTED_START Date date 16 PROJECTED_START_TIME Char varchar2 5 Time in the format HH24:MI, for absence types recorded in hours. 17 PROJECTED_END Date date 18 PROJECTED_END_TIME Char varchar2 5 Time in the format HH24:MI, for absence types recorded in hours. 19 ACTUAL_START Date date Either Actual Start or Projected Start is required. 20 ACTUAL_START_TIME Char varchar2 5 Time in the format HH24:MI, for absence types recorded in hours. 21 ACTUAL_END Date date 22 ACTUAL_END_TIME Char varchar2 5 Time in the format HH24:MI, for absence types recorded in hours. 23 DURATION_DAYS Number number Calculated from the dates when left blank. A changed date recalculates it unless it is entered as well. 24 DURATION_HOURS Number number Calculated from the dates and times when left blank. A changed date or time recalculates it unless it is entered as well. 25 REASON_FOR_LATE_NOTIFICATION Char varchar2 2000 26 ACCEPT_LATE_NOTIFICATION LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 27 AUTHORIZED_BY_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.employee_number is not null and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date order by papf.employee_number 28 AUTHORIZED_BY_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$.authorized_by_number and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date Y 29 REPLACED_BY_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.employee_number is not null and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date order by papf.employee_number 30 REPLACED_BY_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$.replaced_by_number and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date Y 31 DELETE_ABSENCE LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Set to Yes to delete the absence. 32 ABS_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_ABSENCE_ATTENDANCES' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 33 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 34 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 35 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 36 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 37 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 38 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 39 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 40 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 41 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 42 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 43 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 44 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 45 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 46 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 47 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 48 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 49 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 50 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 51 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 52 ABS_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_ABSENCE_ATTENDANCES', p_context_name=>:$column$.abs_attribute_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.abs_attribute1, p_attribute2=>:$column$.abs_attribute2, p_attribute3=>:$column$.abs_attribute3, p_attribute4=>:$column$.abs_attribute4, p_attribute5=>:$column$.abs_attribute5, p_attribute6=>:$column$.abs_attribute6, p_attribute7=>:$column$.abs_attribute7, p_attribute8=>:$column$.abs_attribute8, p_attribute9=>:$column$.abs_attribute9, p_attribute10=>:$column$.abs_attribute10, p_attribute11=>:$column$.abs_attribute11, p_attribute12=>:$column$.abs_attribute12, p_attribute13=>:$column$.abs_attribute13, p_attribute14=>:$column$.abs_attribute14, p_attribute15=>:$column$.abs_attribute15, p_attribute16=>:$column$.abs_attribute16, p_attribute17=>:$column$.abs_attribute17, p_attribute18=>:$column$.abs_attribute18, p_attribute19=>:$column$.abs_attribute19, p_attribute20=>:$column$.abs_attribute20)) 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_ABSENCE_ATTENDANCES' 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' 53 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 p_absence_attendance_id_out in/out Number ABSENCE_ID_OUT U 3 p_business_group_id in Number BUSINESS_GROUP U 4 p_employee_number in Char EMPLOYEE_NUMBER U 5 p_absence_attendance_id in Number Y ABSENCE_ID U 6 p_absence_attendance_type_id in Number Y ABSENCE_TYPE U 7 p_abs_attendance_reason_id in Number Y REASON U 8 p_date_notification in Date Y NOTIFIED U 9 p_date_projected_start in Date Y PROJECTED_START U 10 p_time_projected_start in Char Y PROJECTED_START_TIME U 11 p_date_projected_end in Date Y PROJECTED_END U 12 p_time_projected_end in Char Y PROJECTED_END_TIME U 13 p_date_start in Date Y ACTUAL_START U 14 p_time_start in Char Y ACTUAL_START_TIME U 15 p_date_end in Date Y ACTUAL_END U 16 p_time_end in Char Y ACTUAL_END_TIME U 17 p_absence_days in Number Y DURATION_DAYS U 18 p_absence_hours in Number Y DURATION_HOURS U 19 p_reason_for_late_notif in Char Y REASON_FOR_LATE_NOTIFICATION U 20 p_accept_late_notif_flag in Char Y ACCEPT_LATE_NOTIFICATION U 21 p_authorising_person_id in Number Y AUTHORIZED_BY_NUMBER U 22 p_replacement_person_id in Number Y REPLACED_BY_NUMBER U 23 p_delete_absence in Char Y DELETE_ABSENCE U 24 p_abs_attribute_category in Char Y ABS_ATTRIBUTE_CATEGORY U 25 p_abs_attribute1 in Char Y ABS_ATTRIBUTE1 U 26 p_abs_attribute2 in Char Y ABS_ATTRIBUTE2 U 27 p_abs_attribute3 in Char Y ABS_ATTRIBUTE3 U 28 p_abs_attribute4 in Char Y ABS_ATTRIBUTE4 U 29 p_abs_attribute5 in Char Y ABS_ATTRIBUTE5 U 30 p_abs_attribute6 in Char Y ABS_ATTRIBUTE6 U 31 p_abs_attribute7 in Char Y ABS_ATTRIBUTE7 U 32 p_abs_attribute8 in Char Y ABS_ATTRIBUTE8 U 33 p_abs_attribute9 in Char Y ABS_ATTRIBUTE9 U 34 p_abs_attribute10 in Char Y ABS_ATTRIBUTE10 U 35 p_abs_attribute11 in Char Y ABS_ATTRIBUTE11 U 36 p_abs_attribute12 in Char Y ABS_ATTRIBUTE12 U 37 p_abs_attribute13 in Char Y ABS_ATTRIBUTE13 U 38 p_abs_attribute14 in Char Y ABS_ATTRIBUTE14 U 39 p_abs_attribute15 in Char Y ABS_ATTRIBUTE15 U 40 p_abs_attribute16 in Char Y ABS_ATTRIBUTE16 U 41 p_abs_attribute17 in Char Y ABS_ATTRIBUTE17 U 42 p_abs_attribute18 in Char Y ABS_ATTRIBUTE18 U 43 p_abs_attribute19 in Char Y ABS_ATTRIBUTE19 U 44 p_abs_attribute20 in Char Y ABS_ATTRIBUTE20 U 45 status_ out Char STATUS_CODE_ U 46 message_ out Char MESSAGE_ Error SQL Order By upload_row, employee_number, actual_start, projected_start Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.absence_id_out, nvl(paa.absence_attendance_id,xu.absence_id) absence_id, nvl(pbg.name,xu.business_group) business_group, nvl(papf.employee_number,xu.employee_number) employee_number, nvl(papf.full_name,xu.full_name) full_name, nvl(paatv.name,xu.absence_type) absence_type, nvl(xxen_util.meaning(paatv.absence_category,'ABSENCE_CATEGORY',3),xu.category) category, nvl((select xxen_util.meaning(paar.name,'ABSENCE_REASON',3) from per_abs_attendance_reasons paar where paa.abs_attendance_reason_id=paar.abs_attendance_reason_id),xu.reason) reason, nvl(paa.occurrence,xu.occurrence) occurrence, nvl(paa.date_notification,xu.notified) notified, nvl(paa.date_projected_start,xu.projected_start) projected_start, nvl(paa.time_projected_start,xu.projected_start_time) projected_start_time, nvl(paa.date_projected_end,xu.projected_end) projected_end, nvl(paa.time_projected_end,xu.projected_end_time) projected_end_time, nvl(paa.date_start,xu.actual_start) actual_start, nvl(paa.time_start,xu.actual_start_time) actual_start_time, nvl(paa.date_end,xu.actual_end) actual_end, nvl(paa.time_end,xu.actual_end_time) actual_end_time, nvl(paa.absence_days,xu.duration_days) duration_days, nvl(paa.absence_hours,xu.duration_hours) duration_hours, nvl(paa.reason_for_notification_delay,xu.reason_for_late_notification) reason_for_late_notification, nvl(xxen_util.yes(paa.accept_late_notification_flag),xu.accept_late_notification) accept_late_notification, nvl((select papf2.employee_number from per_all_people_f papf2 where paa.authorising_person_id=papf2.person_id and coalesce(paa.date_start,paa.date_projected_start,trunc(sysdate)) between papf2.effective_start_date and papf2.effective_end_date),xu.authorized_by_number) authorized_by_number, nvl((select papf2.full_name from per_all_people_f papf2 where paa.authorising_person_id=papf2.person_id and coalesce(paa.date_start,paa.date_projected_start,trunc(sysdate)) between papf2.effective_start_date and papf2.effective_end_date),xu.authorized_by_name) authorized_by_name, nvl((select papf2.employee_number from per_all_people_f papf2 where paa.replacement_person_id=papf2.person_id and coalesce(paa.date_start,paa.date_projected_start,trunc(sysdate)) between papf2.effective_start_date and papf2.effective_end_date),xu.replaced_by_number) replaced_by_number, nvl((select papf2.full_name from per_all_people_f papf2 where paa.replacement_person_id=papf2.person_id and coalesce(paa.date_start,paa.date_projected_start,trunc(sysdate)) between papf2.effective_start_date and papf2.effective_end_date),xu.replaced_by_name) replaced_by_name, xu.delete_absence, nvl(xxen_util.display_flexfield_context(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category),xu.abs_attribute_category) abs_attribute_category, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE1',paa.rowid,paa.attribute1),xu.abs_attribute1) abs_attribute1, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE2',paa.rowid,paa.attribute2),xu.abs_attribute2) abs_attribute2, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE3',paa.rowid,paa.attribute3),xu.abs_attribute3) abs_attribute3, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE4',paa.rowid,paa.attribute4),xu.abs_attribute4) abs_attribute4, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE5',paa.rowid,paa.attribute5),xu.abs_attribute5) abs_attribute5, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE6',paa.rowid,paa.attribute6),xu.abs_attribute6) abs_attribute6, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE7',paa.rowid,paa.attribute7),xu.abs_attribute7) abs_attribute7, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE8',paa.rowid,paa.attribute8),xu.abs_attribute8) abs_attribute8, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE9',paa.rowid,paa.attribute9),xu.abs_attribute9) abs_attribute9, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE10',paa.rowid,paa.attribute10),xu.abs_attribute10) abs_attribute10, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE11',paa.rowid,paa.attribute11),xu.abs_attribute11) abs_attribute11, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE12',paa.rowid,paa.attribute12),xu.abs_attribute12) abs_attribute12, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE13',paa.rowid,paa.attribute13),xu.abs_attribute13) abs_attribute13, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE14',paa.rowid,paa.attribute14),xu.abs_attribute14) abs_attribute14, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE15',paa.rowid,paa.attribute15),xu.abs_attribute15) abs_attribute15, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE16',paa.rowid,paa.attribute16),xu.abs_attribute16) abs_attribute16, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE17',paa.rowid,paa.attribute17),xu.abs_attribute17) abs_attribute17, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE18',paa.rowid,paa.attribute18),xu.abs_attribute18) abs_attribute18, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE19',paa.rowid,paa.attribute19),xu.abs_attribute19) abs_attribute19, nvl(xxen_util.display_flexfield_value(800,'PER_ABSENCE_ATTENDANCES',paa.attribute_category,'ATTRIBUTE20',paa.rowid,paa.attribute20),xu.abs_attribute20) abs_attribute20, xu.upload_row from xxen_per_absence_upload_3390_u xu, per_absence_attendances paa, per_abs_attendance_types_vl paatv, per_all_people_f papf, per_business_groups pbg where xu.status_code_=xxen_upload.status_success and xu.absence_id_out=paa.absence_attendance_id(+) and paa.absence_attendance_type_id=paatv.absence_attendance_type_id(+) and paa.person_id=papf.person_id(+) and trunc(sysdate) between papf.effective_start_date(+) and papf.effective_end_date(+) and paa.business_group_id=pbg.business_group_id(+)