ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 191F60EAAC204CC58DC56E0BA44A5BA4Y select null action_, null status_, null message_, null modified_columns_, haouv.name operating_unit, adsa.distribution_set_name distribution_set, (select alc.displayed_field from ap_lookup_codes alc where alc.lookup_type='NLS TRANSLATION' and alc.lookup_code='PERCENT DIST '||adsa.total_percent_distribution) set_type, adsa.description, adsa.inactive_date inactive_on, xxen_util.display_flexfield_context(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category) set_attribute_category, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE1',adsa.rowid,adsa.attribute1) set_attribute1, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE2',adsa.rowid,adsa.attribute2) set_attribute2, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE3',adsa.rowid,adsa.attribute3) set_attribute3, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE4',adsa.rowid,adsa.attribute4) set_attribute4, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE5',adsa.rowid,adsa.attribute5) set_attribute5, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE6',adsa.rowid,adsa.attribute6) set_attribute6, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE7',adsa.rowid,adsa.attribute7) set_attribute7, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE8',adsa.rowid,adsa.attribute8) set_attribute8, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE9',adsa.rowid,adsa.attribute9) set_attribute9, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE10',adsa.rowid,adsa.attribute10) set_attribute10, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE11',adsa.rowid,adsa.attribute11) set_attribute11, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE12',adsa.rowid,adsa.attribute12) set_attribute12, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE13',adsa.rowid,adsa.attribute13) set_attribute13, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE14',adsa.rowid,adsa.attribute14) set_attribute14, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE15',adsa.rowid,adsa.attribute15) set_attribute15, adsla.distribution_set_line_number line_number, adsla.percent_distribution percentage, gcck.concatenated_segments account, xxen_util.segments_description(gcck.code_combination_id) account_description, adsla.description line_description, adsla.type_1099 income_tax_type, ppa.segment1 project, pt.task_number task, adsla.expenditure_type, haouv_exp.name expenditure_organization, xxen_util.display_flexfield_context(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category) line_attribute_category, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE1',adsla.rowid,adsla.attribute1) line_attribute1, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE2',adsla.rowid,adsla.attribute2) line_attribute2, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE3',adsla.rowid,adsla.attribute3) line_attribute3, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE4',adsla.rowid,adsla.attribute4) line_attribute4, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE5',adsla.rowid,adsla.attribute5) line_attribute5, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE6',adsla.rowid,adsla.attribute6) line_attribute6, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE7',adsla.rowid,adsla.attribute7) line_attribute7, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE8',adsla.rowid,adsla.attribute8) line_attribute8, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE9',adsla.rowid,adsla.attribute9) line_attribute9, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE10',adsla.rowid,adsla.attribute10) line_attribute10, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE11',adsla.rowid,adsla.attribute11) line_attribute11, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE12',adsla.rowid,adsla.attribute12) line_attribute12, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE13',adsla.rowid,adsla.attribute13) line_attribute13, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE14',adsla.rowid,adsla.attribute14) line_attribute14, xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE15',adsla.rowid,adsla.attribute15) line_attribute15, null delete_line, adsa.distribution_set_id, null upload_row from ap_distribution_sets_all adsa, hr_all_organization_units_vl haouv, ap_distribution_set_lines_all adsla, gl_code_combinations_kfv gcck, pa_projects_all ppa, pa_tasks pt, hr_all_organization_units_vl haouv_exp where 1=1 and adsa.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and adsa.org_id=haouv.organization_id and adsa.distribution_set_id=adsla.distribution_set_id(+) and adsla.dist_code_combination_id=gcck.code_combination_id(+) and adsla.project_id=ppa.project_id(+) and adsla.task_id=pt.task_id(+) and adsla.expenditure_organization_id=haouv_exp.organization_id(+) Initial version: create and update distribution sets and lines, delete lines, as in the Distribution Sets form. Sets are processed atomically with the 0 or 100 percent total check. U A xxen_ap_upload.upload_distribution_set US AP Distribution Set Upload Creates and updates Payables distribution sets and their lines - the Excel equivalent of the Distribution Sets form (Setup > Invoice > Distribution Sets). Each row is one distribution set line, with the distribution set header columns repeated on every line. The header values are taken from the first row of each distribution set. Leave the line columns blank to create or update a distribution set header only. Each distribution set is processed as a whole: the percentages of all its lines, including existing lines not in the upload file, must add up to 100 (Full) or to 0 (Skeleton), otherwise none of its rows are saved. The same applies when any other line of the set fails validation. Line Number identifies the line within the distribution set. Set Delete Line to Yes to delete a line. A distribution set cannot be deleted, as in the form - enter an Inactive On date instead. For project related lines, enter Project, Task, Expenditure Type and Expenditure Organization. The account is then derived by the Projects account generator, exactly as in the form. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 3 30 1=1 adsa.distribution_set_name=:distribution_set LOV custom Y select distinct adsa.distribution_set_name value, adsa.description from ap_distribution_sets_all adsa, hr_all_organization_units_vl haouv where adsa.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and adsa.org_id=haouv.organization_id and (:$flex$.operating_unit is null or haouv.name=:$flex$.operating_unit) order by adsa.distribution_set_name US Distribution Set 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 OPERATING_UNIT LOV varchar2 240 HR Operating Unit for Upload F263DDA3FBF60F8FE0530100007F75CD Y select hou.organization_id id, hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.operating_unit is null or hou.name=:$flex$.operating_unit) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name :$flex$.operating_unit Y Y 6 DISTRIBUTION_SET Char varchar2 50 Y 7 SET_TYPE Char varchar2 80 Full when the line percentages add up to 100, Skeleton when they add up to 0. Y 8 DESCRIPTION Char varchar2 240 9 INACTIVE_ON Date date 10 SET_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfv.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and fdfv.application_id=200 and fdfv.application_id=fdfcv.application_id and fdfv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 11 SET_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE1' 12 SET_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE2' 13 SET_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE3' 14 SET_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE4' 15 SET_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE5' 16 SET_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE6' 17 SET_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE7' 18 SET_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE8' 19 SET_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE9' 20 SET_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE10' 21 SET_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE11' 22 SET_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE12' 23 SET_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE13' 24 SET_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE14' 25 SET_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.set_attribute1, p_attribute2 => :$column$.set_attribute2, p_attribute3 => :$column$.set_attribute3, p_attribute4 => :$column$.set_attribute4, p_attribute5 => :$column$.set_attribute5, p_attribute6 => :$column$.set_attribute6, p_attribute7 => :$column$.set_attribute7, p_attribute8 => :$column$.set_attribute8, p_attribute9 => :$column$.set_attribute9, p_attribute10 => :$column$.set_attribute10, p_attribute11 => :$column$.set_attribute11, p_attribute12 => :$column$.set_attribute12, p_attribute13 => :$column$.set_attribute13, p_attribute14 => :$column$.set_attribute14, p_attribute15 => :$column$.set_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SETS' and dffcu.application_column_name='ATTRIBUTE15' 26 LINE_NUMBER Number number Identifies the line within the distribution set. Leave all line columns blank to process the distribution set header only. 27 PERCENTAGE Number number The percentages of all lines of a distribution set must add up to 100 (Full) or to 0 (Skeleton). 28 ACCOUNT LOV custom varchar2 2000 Y select gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from hr_operating_units hou, gl_ledgers gl, gl_code_combinations_kfv gcck where hou.name=:$column$.operating_unit and to_number(hou.set_of_books_id)=gl.ledger_id and gl.chart_of_accounts_id=gcck.chart_of_accounts_id and gcck.enabled_flag='Y' and gcck.summary_flag='N' and gcck.detail_posting_allowed='Y' and trunc(sysdate) between nvl(gcck.start_date_active,trunc(sysdate)) and nvl(gcck.end_date_active,trunc(sysdate)) order by value Required unless the line is project related. For project related lines, the account is derived by the Projects account generator. 29 ACCOUNT_DESCRIPTION Char varchar2 2000 select xxen_util.segments_description(gcck.code_combination_id) from hr_operating_units hou, gl_ledgers gl, gl_code_combinations_kfv gcck where hou.name=:$column$.operating_unit and to_number(hou.set_of_books_id)=gl.ledger_id and gl.chart_of_accounts_id=gcck.chart_of_accounts_id and gcck.concatenated_segments=:$column$.account Y 30 LINE_DESCRIPTION Char varchar2 240 31 INCOME_TAX_TYPE LOV custom varchar2 10 Y select aitt.income_tax_type value, aitt.description from ap_income_tax_types aitt where nvl(aitt.inactive_date,sysdate+1)>sysdate order by upper(aitt.income_tax_type) 32 PROJECT LOV custom varchar2 25 Y select ppev.project_number value, ppev.project_name description from pa_projects_expend_v ppev order by ppev.project_number_sort_order Project, Task, Expenditure Type and Expenditure Organization are entered together for a project related line. 33 TASK LOV custom varchar2 25 Y select ptev.task_number value, ptev.task_name description from pa_projects_expend_v ppev, pa_tasks_expend_v ptev where ppev.project_number=:$column$.project and ppev.project_id=ptev.project_id order by ptev.wbs_sort_order 34 EXPENDITURE_TYPE LOV custom varchar2 30 Y select petev.expenditure_type value, petev.description from pa_expenditure_types_expend_v petev where petev.system_linkage_function='VI' and sysdate between petev.expnd_typ_start_date_active and nvl(petev.expnd_typ_end_date_active,sysdate) and sysdate between petev.sys_link_start_date_active and nvl(petev.sys_link_end_date_active,sysdate) order by petev.expenditure_type 35 EXPENDITURE_ORGANIZATION LOV custom varchar2 240 Y select distinct poev.name value, null description from hr_operating_units hou, financials_system_params_all fspa, pa_organizations_expend_v poev where hou.name=:$column$.operating_unit and hou.organization_id=fspa.org_id and fspa.business_group_id=poev.business_group_id and poev.active_flag='Y' and sysdate between poev.date_from and nvl(poev.date_to,sysdate+1) order by poev.name 36 LINE_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfv.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and fdfv.application_id=200 and fdfv.application_id=fdfcv.application_id and fdfv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 37 LINE_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE1' 38 LINE_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE2' 39 LINE_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE3' 40 LINE_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE4' 41 LINE_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE5' 42 LINE_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE6' 43 LINE_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE7' 44 LINE_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE8' 45 LINE_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE9' 46 LINE_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE10' 47 LINE_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE11' 48 LINE_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE12' 49 LINE_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE13' 50 LINE_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE14' 51 LINE_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_DISTRIBUTION_SET_LINES', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=200 and dff.descriptive_flexfield_name='AP_DISTRIBUTION_SET_LINES' and dffcu.application_column_name='ATTRIBUTE15' 52 DELETE_LINE LOV custom varchar2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.distribution_set_id is not null and :$column$.line_number is not null Deletes the distribution set line. A distribution set itself cannot be deleted - enter an Inactive On date instead. 53 DISTRIBUTION_SET_ID Number number Y 54 UPLOAD_ROW Char varchar2 Y Error SQL Order By upload_row, operating_unit, distribution_set, line_number Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, nvl(haouv.name,xu.operating_unit) operating_unit, nvl(adsa.distribution_set_name,xu.distribution_set) distribution_set, nvl((select alc.displayed_field from ap_lookup_codes alc where alc.lookup_type='NLS TRANSLATION' and alc.lookup_code='PERCENT DIST '||adsa.total_percent_distribution),xu.set_type) set_type, nvl(adsa.description,xu.description) description, nvl(adsa.inactive_date,xu.inactive_on) inactive_on, nvl(xxen_util.display_flexfield_context(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category),xu.set_attribute_category) set_attribute_category, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE1',adsa.rowid,adsa.attribute1),xu.set_attribute1) set_attribute1, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE2',adsa.rowid,adsa.attribute2),xu.set_attribute2) set_attribute2, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE3',adsa.rowid,adsa.attribute3),xu.set_attribute3) set_attribute3, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE4',adsa.rowid,adsa.attribute4),xu.set_attribute4) set_attribute4, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE5',adsa.rowid,adsa.attribute5),xu.set_attribute5) set_attribute5, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE6',adsa.rowid,adsa.attribute6),xu.set_attribute6) set_attribute6, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE7',adsa.rowid,adsa.attribute7),xu.set_attribute7) set_attribute7, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE8',adsa.rowid,adsa.attribute8),xu.set_attribute8) set_attribute8, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE9',adsa.rowid,adsa.attribute9),xu.set_attribute9) set_attribute9, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE10',adsa.rowid,adsa.attribute10),xu.set_attribute10) set_attribute10, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE11',adsa.rowid,adsa.attribute11),xu.set_attribute11) set_attribute11, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE12',adsa.rowid,adsa.attribute12),xu.set_attribute12) set_attribute12, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE13',adsa.rowid,adsa.attribute13),xu.set_attribute13) set_attribute13, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE14',adsa.rowid,adsa.attribute14),xu.set_attribute14) set_attribute14, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SETS',adsa.attribute_category,'ATTRIBUTE15',adsa.rowid,adsa.attribute15),xu.set_attribute15) set_attribute15, nvl(adsla.distribution_set_line_number,xu.line_number) line_number, nvl(adsla.percent_distribution,xu.percentage) percentage, nvl(gcck.concatenated_segments,xu.account) account, nvl(xxen_util.segments_description(gcck.code_combination_id),xu.account_description) account_description, nvl(adsla.description,xu.line_description) line_description, nvl(adsla.type_1099,xu.income_tax_type) income_tax_type, nvl(ppa.segment1,xu.project) project, nvl(pt.task_number,xu.task) task, nvl(adsla.expenditure_type,xu.expenditure_type) expenditure_type, nvl(haouv_exp.name,xu.expenditure_organization) expenditure_organization, nvl(xxen_util.display_flexfield_context(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category),xu.line_attribute_category) line_attribute_category, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE1',adsla.rowid,adsla.attribute1),xu.line_attribute1) line_attribute1, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE2',adsla.rowid,adsla.attribute2),xu.line_attribute2) line_attribute2, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE3',adsla.rowid,adsla.attribute3),xu.line_attribute3) line_attribute3, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE4',adsla.rowid,adsla.attribute4),xu.line_attribute4) line_attribute4, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE5',adsla.rowid,adsla.attribute5),xu.line_attribute5) line_attribute5, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE6',adsla.rowid,adsla.attribute6),xu.line_attribute6) line_attribute6, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE7',adsla.rowid,adsla.attribute7),xu.line_attribute7) line_attribute7, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE8',adsla.rowid,adsla.attribute8),xu.line_attribute8) line_attribute8, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE9',adsla.rowid,adsla.attribute9),xu.line_attribute9) line_attribute9, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE10',adsla.rowid,adsla.attribute10),xu.line_attribute10) line_attribute10, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE11',adsla.rowid,adsla.attribute11),xu.line_attribute11) line_attribute11, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE12',adsla.rowid,adsla.attribute12),xu.line_attribute12) line_attribute12, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE13',adsla.rowid,adsla.attribute13),xu.line_attribute13) line_attribute13, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE14',adsla.rowid,adsla.attribute14),xu.line_attribute14) line_attribute14, nvl(xxen_util.display_flexfield_value(200,'AP_DISTRIBUTION_SET_LINES',adsla.attribute_category,'ATTRIBUTE15',adsla.rowid,adsla.attribute15),xu.line_attribute15) line_attribute15, xu.delete_line, xu.distribution_set_id, xu.upload_row from xxen_ap_distribution_se_0098_u xu, ap_distribution_sets_all adsa, hr_all_organization_units_vl haouv, ap_distribution_set_lines_all adsla, gl_code_combinations_kfv gcck, pa_projects_all ppa, pa_tasks pt, hr_all_organization_units_vl haouv_exp where xu.status_code_=xxen_upload.status_success and xu.distribution_set_id=adsa.distribution_set_id(+) and adsa.org_id=haouv.organization_id(+) and xu.distribution_set_id=adsla.distribution_set_id(+) and xu.line_number=adsla.distribution_set_line_number(+) and adsla.dist_code_combination_id=gcck.code_combination_id(+) and adsla.project_id=ppa.project_id(+) and adsla.task_id=pt.task_id(+) and adsla.expenditure_organization_id=haouv_exp.organization_id(+)