ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 3358D96CDF154745BAC970EFBC04FC36Y select null action_, null status_, null message_, null modified_columns_, to_number(null) job_id_out, pj.job_id, pbg.name business_group, (select pjg.displayed_name from per_job_groups pjg where pj.job_group_id=pjg.job_group_id) job_group, pjt.name, pj.date_from, pj.date_to, pj.approval_authority, xxen_util.yes(pj.emp_rights_flag) additional_employment_rights, xxen_util.yes(pj.benchmark_job_flag) benchmark_job, (select pjt2.name from per_jobs_tl pjt2 where pj.benchmark_job_id=pjt2.job_id and pjt2.language=userenv('lang')) benchmark_job_name, xxen_util.display_flexfield_context(800,'PER_JOBS',pj.attribute_category) job_attribute_category, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE1',pj.rowid,pj.attribute1) job_attribute1, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE2',pj.rowid,pj.attribute2) job_attribute2, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE3',pj.rowid,pj.attribute3) job_attribute3, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE4',pj.rowid,pj.attribute4) job_attribute4, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE5',pj.rowid,pj.attribute5) job_attribute5, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE6',pj.rowid,pj.attribute6) job_attribute6, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE7',pj.rowid,pj.attribute7) job_attribute7, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE8',pj.rowid,pj.attribute8) job_attribute8, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE9',pj.rowid,pj.attribute9) job_attribute9, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE10',pj.rowid,pj.attribute10) job_attribute10, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE11',pj.rowid,pj.attribute11) job_attribute11, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE12',pj.rowid,pj.attribute12) job_attribute12, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE13',pj.rowid,pj.attribute13) job_attribute13, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE14',pj.rowid,pj.attribute14) job_attribute14, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE15',pj.rowid,pj.attribute15) job_attribute15, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE16',pj.rowid,pj.attribute16) job_attribute16, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE17',pj.rowid,pj.attribute17) job_attribute17, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE18',pj.rowid,pj.attribute18) job_attribute18, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE19',pj.rowid,pj.attribute19) job_attribute19, xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE20',pj.rowid,pj.attribute20) job_attribute20, 0 upload_row from per_business_groups pbg, per_jobs pj, per_jobs_tl pjt where 1=1 and pbg.business_group_id=:business_group_id and pj.business_group_id=pbg.business_group_id and pj.job_id=pjt.job_id and pjt.language=userenv('lang') Initial version U A xxen_per_upload.create_update_job US PER Job Upload Upload to create and update jobs as in the Job window (Define Job): job group, name, dates, approval authority, additional employment rights, benchmark job and the Additional Job Details flexfield. A row whose Name does not exist in the job group creates the job with hr_job_api.create_job. Name is the concatenated Job flexfield segments of the job group's structure; changing it on a downloaded row renames the job. End a job by entering its Date To. Evaluation, requirements and valid grades of the Job window are not part of the upload. 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 pj.job_group_id=:job_group_id LOV custom select pjg.job_group_id id, pjg.displayed_name value, null description from per_job_groups pjg where pjg.business_group_id=:$flex$.Business_Group or pjg.master_flag='Y' order by pjg.displayed_name US Job Group 4 40 1=1 pj.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 5 50 1=1 nvl(pj.date_to,sysdate)>=trunc(sysdate) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Active Jobs Only 4002D5C685A34CCD8A8C0D1C595C4B4F Create Jobs Empty sheet to create new jobs. ENGINATICS 6 ADDITIONAL_EMPLOYMENT_RIGHTS 5 APPROVAL_AUTHORITY 7 BENCHMARK_JOB 8 BENCHMARK_JOB_NAME 9 BUSINESS_GROUP 3 DATE_FROM Y 4 DATE_TO 1 JOB_GROUP 2 NAME Upload Mode C Y S Site Active Jobs Only Job Job Group 38A74E89C4AB4246928AF6BD88EFED86 Default The Job window fields, without the flexfield. ENGINATICS 6 ADDITIONAL_EMPLOYMENT_RIGHTS 5 APPROVAL_AUTHORITY 7 BENCHMARK_JOB 8 BENCHMARK_JOB_NAME 9 BUSINESS_GROUP 3 DATE_FROM Y 4 DATE_TO 1 JOB_GROUP 2 NAME Upload Mode C,U S Site D19B35610DFC437CBEFAE4F4E2DC3923 Flexfields Job name with the Additional Job Details flexfield. ENGINATICS 3 BUSINESS_GROUP 5 JOB_ATTRIBUTE1 14 JOB_ATTRIBUTE10 15 JOB_ATTRIBUTE11 16 JOB_ATTRIBUTE12 17 JOB_ATTRIBUTE13 18 JOB_ATTRIBUTE14 19 JOB_ATTRIBUTE15 20 JOB_ATTRIBUTE16 21 JOB_ATTRIBUTE17 22 JOB_ATTRIBUTE18 23 JOB_ATTRIBUTE19 6 JOB_ATTRIBUTE2 24 JOB_ATTRIBUTE20 7 JOB_ATTRIBUTE3 8 JOB_ATTRIBUTE4 9 JOB_ATTRIBUTE5 10 JOB_ATTRIBUTE6 11 JOB_ATTRIBUTE7 12 JOB_ATTRIBUTE8 13 JOB_ATTRIBUTE9 4 JOB_ATTRIBUTE_CATEGORY Y 1 JOB_GROUP 2 NAME Upload Mode C,U S Site 38A74E89C4AB4246928AF6BD88EFED86 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 JOB_ID_OUT Number number Y 6 JOB_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 JOB_GROUP LOV custom varchar2 30 select pjg.job_group_id id, pjg.displayed_name value, null description from per_business_groups pbg, per_job_groups pjg where pbg.name=:$column$.business_group and (pjg.business_group_id=pbg.business_group_id or pjg.master_flag='Y') order by pjg.displayed_name select pjg.displayed_name from per_job_groups pjg where pjg.business_group_id=:$flex$.Business_Group and pjg.internal_name='HR_'||pjg.business_group_id Job group the job belongs to, which determines its Job Name flexfield structure. Cannot be changed on an existing job. Y 9 NAME Char varchar2 240 Job name as the concatenated segments of the Job flexfield. A new name creates the job, or renames it when the row carries a downloaded job. Y 10 DATE_FROM Date date Y 11 DATE_TO Date date 12 APPROVAL_AUTHORITY Number number 13 ADDITIONAL_EMPLOYMENT_RIGHTS LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 14 BENCHMARK_JOB LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 15 BENCHMARK_JOB_NAME 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 pjv.benchmark_job_flag='Y' order by pjv.name 16 JOB_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_JOBS' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 17 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 18 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 19 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 20 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 21 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 22 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 23 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 24 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 25 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 26 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 27 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 28 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 29 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 30 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 31 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 32 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 33 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 34 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 35 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 36 JOB_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_JOBS', p_context_name=>:$column$.job_attribute_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.job_attribute1, p_attribute2=>:$column$.job_attribute2, p_attribute3=>:$column$.job_attribute3, p_attribute4=>:$column$.job_attribute4, p_attribute5=>:$column$.job_attribute5, p_attribute6=>:$column$.job_attribute6, p_attribute7=>:$column$.job_attribute7, p_attribute8=>:$column$.job_attribute8, p_attribute9=>:$column$.job_attribute9, p_attribute10=>:$column$.job_attribute10, p_attribute11=>:$column$.job_attribute11, p_attribute12=>:$column$.job_attribute12, p_attribute13=>:$column$.job_attribute13, p_attribute14=>:$column$.job_attribute14, p_attribute15=>:$column$.job_attribute15, p_attribute16=>:$column$.job_attribute16, p_attribute17=>:$column$.job_attribute17, p_attribute18=>:$column$.job_attribute18, p_attribute19=>:$column$.job_attribute19, p_attribute20=>:$column$.job_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_JOBS' 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' 37 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 p_job_id_out in/out Number JOB_ID_OUT U 3 p_business_group_id in Number BUSINESS_GROUP U 4 p_job_id in Number Y JOB_ID U 5 p_job_group_id in Number Y JOB_GROUP U 6 p_name in Char Y NAME U 7 p_date_from in Date Y DATE_FROM U 8 p_date_to in Date Y DATE_TO U 9 p_approval_authority in Number Y APPROVAL_AUTHORITY U 10 p_emp_rights_flag in Char Y ADDITIONAL_EMPLOYMENT_RIGHTS U 11 p_benchmark_job_flag in Char Y BENCHMARK_JOB U 12 p_benchmark_job_id in Number Y BENCHMARK_JOB_NAME U 13 p_job_attribute_category in Char Y JOB_ATTRIBUTE_CATEGORY U 14 p_job_attribute1 in Char Y JOB_ATTRIBUTE1 U 15 p_job_attribute2 in Char Y JOB_ATTRIBUTE2 U 16 p_job_attribute3 in Char Y JOB_ATTRIBUTE3 U 17 p_job_attribute4 in Char Y JOB_ATTRIBUTE4 U 18 p_job_attribute5 in Char Y JOB_ATTRIBUTE5 U 19 p_job_attribute6 in Char Y JOB_ATTRIBUTE6 U 20 p_job_attribute7 in Char Y JOB_ATTRIBUTE7 U 21 p_job_attribute8 in Char Y JOB_ATTRIBUTE8 U 22 p_job_attribute9 in Char Y JOB_ATTRIBUTE9 U 23 p_job_attribute10 in Char Y JOB_ATTRIBUTE10 U 24 p_job_attribute11 in Char Y JOB_ATTRIBUTE11 U 25 p_job_attribute12 in Char Y JOB_ATTRIBUTE12 U 26 p_job_attribute13 in Char Y JOB_ATTRIBUTE13 U 27 p_job_attribute14 in Char Y JOB_ATTRIBUTE14 U 28 p_job_attribute15 in Char Y JOB_ATTRIBUTE15 U 29 p_job_attribute16 in Char Y JOB_ATTRIBUTE16 U 30 p_job_attribute17 in Char Y JOB_ATTRIBUTE17 U 31 p_job_attribute18 in Char Y JOB_ATTRIBUTE18 U 32 p_job_attribute19 in Char Y JOB_ATTRIBUTE19 U 33 p_job_attribute20 in Char Y JOB_ATTRIBUTE20 U 34 status_ out Char STATUS_CODE_ U 35 message_ out Char MESSAGE_ Error SQL Order By upload_row, job_group, name Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.job_id_out, nvl(pj.job_id,xu.job_id) job_id, nvl(pbg.name,xu.business_group) business_group, nvl((select pjg.displayed_name from per_job_groups pjg where pj.job_group_id=pjg.job_group_id),xu.job_group) job_group, nvl(pjt.name,xu.name) name, nvl(pj.date_from,xu.date_from) date_from, nvl(pj.date_to,xu.date_to) date_to, nvl(pj.approval_authority,xu.approval_authority) approval_authority, nvl(xxen_util.yes(pj.emp_rights_flag),xu.additional_employment_rights) additional_employment_rights, nvl(xxen_util.yes(pj.benchmark_job_flag),xu.benchmark_job) benchmark_job, nvl((select pjt2.name from per_jobs_tl pjt2 where pj.benchmark_job_id=pjt2.job_id and pjt2.language=userenv('lang')),xu.benchmark_job_name) benchmark_job_name, nvl(xxen_util.display_flexfield_context(800,'PER_JOBS',pj.attribute_category),xu.job_attribute_category) job_attribute_category, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE1',pj.rowid,pj.attribute1),xu.job_attribute1) job_attribute1, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE2',pj.rowid,pj.attribute2),xu.job_attribute2) job_attribute2, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE3',pj.rowid,pj.attribute3),xu.job_attribute3) job_attribute3, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE4',pj.rowid,pj.attribute4),xu.job_attribute4) job_attribute4, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE5',pj.rowid,pj.attribute5),xu.job_attribute5) job_attribute5, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE6',pj.rowid,pj.attribute6),xu.job_attribute6) job_attribute6, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE7',pj.rowid,pj.attribute7),xu.job_attribute7) job_attribute7, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE8',pj.rowid,pj.attribute8),xu.job_attribute8) job_attribute8, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE9',pj.rowid,pj.attribute9),xu.job_attribute9) job_attribute9, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE10',pj.rowid,pj.attribute10),xu.job_attribute10) job_attribute10, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE11',pj.rowid,pj.attribute11),xu.job_attribute11) job_attribute11, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE12',pj.rowid,pj.attribute12),xu.job_attribute12) job_attribute12, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE13',pj.rowid,pj.attribute13),xu.job_attribute13) job_attribute13, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE14',pj.rowid,pj.attribute14),xu.job_attribute14) job_attribute14, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE15',pj.rowid,pj.attribute15),xu.job_attribute15) job_attribute15, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE16',pj.rowid,pj.attribute16),xu.job_attribute16) job_attribute16, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE17',pj.rowid,pj.attribute17),xu.job_attribute17) job_attribute17, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE18',pj.rowid,pj.attribute18),xu.job_attribute18) job_attribute18, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE19',pj.rowid,pj.attribute19),xu.job_attribute19) job_attribute19, nvl(xxen_util.display_flexfield_value(800,'PER_JOBS',pj.attribute_category,'ATTRIBUTE20',pj.rowid,pj.attribute20),xu.job_attribute20) job_attribute20, xu.upload_row from xxen_per_job_upload_8137_u xu, per_jobs pj, per_jobs_tl pjt, per_business_groups pbg where xu.status_code_=xxen_upload.status_success and xu.job_id_out=pj.job_id(+) and pj.job_id=pjt.job_id(+) and pjt.language(+)=userenv('lang') and pj.business_group_id=pbg.business_group_id(+)