ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 4EDF8D266D4E3BB2E0630100007F7975Y select null action_, null status_, null message_, null modified_columns_, ffvs.flex_value_set_name, ffvs0.flex_value_set_name parent_flex_value_set, ffv.parent_flex_value_low independent_value, ffv.flex_value, ffvt.flex_value_meaning translated_value, ffvt.description, xxen_util.yes(ffv.enabled_flag) enabled, ffv.start_date_active, ffv.end_date_active, xxen_util.yes(ffv.summary_flag) parent, ffhv.hierarchy_name rollup_group, ffv.hierarchy_level, ffv.compiled_value_attributes, ffvnh.child_flex_value_low child_range_low, ffvnh.child_flex_value_high child_range_high, xxen_util.meaning(ffvnh.range_attribute,'RANGE_ATTRIBUTE',0) range_attribute, ffv.attribute_sort_order, xxen_util.display_flexfield_context(0,'FND_FLEX_VALUES',ffv.value_category) value_category, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE1',ffv.rowid,ffv.attribute1) attribute1, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE2',ffv.rowid,ffv.attribute2) attribute2, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE3',ffv.rowid,ffv.attribute3) attribute3, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE4',ffv.rowid,ffv.attribute4) attribute4, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE5',ffv.rowid,ffv.attribute5) attribute5, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE6',ffv.rowid,ffv.attribute6) attribute6, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE7',ffv.rowid,ffv.attribute7) attribute7, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE8',ffv.rowid,ffv.attribute8) attribute8, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE9',ffv.rowid,ffv.attribute9) attribute9, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE10',ffv.rowid,ffv.attribute10) attribute10, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE11',ffv.rowid,ffv.attribute11) attribute11, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE12',ffv.rowid,ffv.attribute12) attribute12, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE13',ffv.rowid,ffv.attribute13) attribute13, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE14',ffv.rowid,ffv.attribute14) attribute14, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE15',ffv.rowid,ffv.attribute15) attribute15, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE16',ffv.rowid,ffv.attribute16) attribute16, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE17',ffv.rowid,ffv.attribute17) attribute17, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE18',ffv.rowid,ffv.attribute18) attribute18, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE19',ffv.rowid,ffv.attribute19) attribute19, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE20',ffv.rowid,ffv.attribute20) attribute20, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE21',ffv.rowid,ffv.attribute21) attribute21, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE22',ffv.rowid,ffv.attribute22) attribute22, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE23',ffv.rowid,ffv.attribute23) attribute23, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE24',ffv.rowid,ffv.attribute24) attribute24, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE25',ffv.rowid,ffv.attribute25) attribute25, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE26',ffv.rowid,ffv.attribute26) attribute26, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE27',ffv.rowid,ffv.attribute27) attribute27, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE28',ffv.rowid,ffv.attribute28) attribute28, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE29',ffv.rowid,ffv.attribute29) attribute29, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',ffv.value_category,'ATTRIBUTE30',ffv.rowid,ffv.attribute30) attribute30, ffv.attribute31, ffv.attribute32, ffv.attribute33, ffv.attribute34, ffv.attribute35, ffv.attribute36, ffv.attribute37, ffv.attribute38, ffv.attribute39, ffv.attribute40, ffv.attribute41, ffv.attribute42, ffv.attribute43, ffv.attribute44, ffv.attribute45, ffv.attribute46, ffv.attribute47, ffv.attribute48, ffv.attribute49, ffv.attribute50, to_char(null) delete_range, null upload_row from fnd_flex_value_sets ffvs, fnd_flex_value_sets ffvs0, fnd_flex_values ffv, fnd_flex_values_tl ffvt, fnd_flex_hierarchies_vl ffhv, fnd_flex_value_norm_hierarchy ffvnh where 1=1 and ffvs.parent_flex_value_set_id=ffvs0.flex_value_set_id(+) and ffvs.flex_value_set_id=ffv.flex_value_set_id and ffv.flex_value_id=ffvt.flex_value_id and ffvt.language=userenv('lang') and ffv.structured_hierarchy_level=ffhv.hierarchy_id(+) and ffv.flex_value_set_id=ffvnh.flex_value_set_id(+) and ffv.flex_value=ffvnh.parent_flex_value(+) Code style: unused anchors and the predicates duplicating the Upload Mode and Flex Value Set parameters removed. U A xxen_fnd_upload.create_update_flex_value xxen_fnd_upload.validate_flex_value( p_parent=>:$column$.parent, p_child_range_low=>:$column$.child_range_low, p_child_range_high=>:$column$.child_range_high, p_range_attribute=>:$column$.range_attribute, p_delete_range=>:$column$.delete_range ) US FND Flex Value Upload Upload to create and update the values of independent, dependent, translatable independent and translatable dependent value sets, as in the Segment Values form. A row updates the value when it exists in the value set, for a dependent value set under its Independent Value, and creates it otherwise. Parent and Rollup Group can only be set for values of independent value sets. Child Range Low and Child Range High add a child range to a parent value; Delete Range Yes removes it. Compiled Value Attributes holds the segment qualifier values, for example Allow Budgeting, Allow Posting and the account type, one per line. A new value without them gets the qualifiers' default values; a blank cell keeps the stored values of an existing one. After changing parent values or child ranges, submit the concurrent program Compile value set hierarchies for the value set, as the Segment Values form does when it saves. Enginatics Upload 1=1 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 1=1 ffvs.flex_value_set_name=:p_flex_value_set_name LOV custom select ffvs.flex_value_set_name value, xxen_util.meaning(ffvs.validation_type,'SEG_VAL_TYPES',0)||', '||ffvs.description description from fnd_flex_value_sets ffvs where ffvs.validation_type in ('I','D','X','Y') order by ffvs.flex_value_set_name Y US Flex Value Set 3 30 1=1 ffv.flex_value like :flex_value_like Char US Flex Value Like 4 40 1=1 ffv.parent_flex_value_low=:independent_value LOV custom select ffv.flex_value value, ffvv.description from fnd_flex_value_sets ffvs, fnd_flex_value_sets ffvs_dep, fnd_flex_values ffv, fnd_flex_values_vl ffvv where ffvs_dep.flex_value_set_name=:$flex$.Flex_Value_Set and ffvs_dep.parent_flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_id=ffv.flex_value_set_id and ffv.flex_value_id=ffvv.flex_value_id and ffv.enabled_flag='Y' order by ffv.flex_value US Independent Value F61DB1489CD1494AB0B8E24D502741B7 Default All columns except the descriptive flexfield attributes. ENGINATICS 16 ATTRIBUTE_SORT_ORDER 14 CHILD_RANGE_HIGH 13 CHILD_RANGE_LOW 12 COMPILED_VALUE_ATTRIBUTES 17 DELETE_RANGE 5 DESCRIPTION 6 ENABLED 8 END_DATE_ACTIVE 3 FLEX_VALUE 1 FLEX_VALUE_SET_NAME 11 HIERARCHY_LEVEL 2 INDEPENDENT_VALUE 9 PARENT 15 RANGE_ATTRIBUTE 10 ROLLUP_GROUP 7 START_DATE_ACTIVE 4 TRANSLATED_VALUE Y S Site F61DB1489CD1494AB0B8E24D502741B7 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 FLEX_VALUE_SET_NAME LOV custom varchar2 60 select ffvs.flex_value_set_name value, xxen_util.meaning(ffvs.validation_type,'SEG_VAL_TYPES',0)||', '||ffvs.description description from fnd_flex_value_sets ffvs where ffvs.validation_type in ('I','D','X','Y') order by ffvs.flex_value_set_name :$flex$.Flex_Value_Set Y 6 PARENT_FLEX_VALUE_SET Char varchar2 60 Y 7 INDEPENDENT_VALUE LOV custom varchar2 60 select ffv.flex_value value, ffvv.description from fnd_flex_value_sets ffvs, fnd_flex_value_sets ffvs_dep, fnd_flex_values ffv, fnd_flex_values_vl ffvv where ffvs_dep.flex_value_set_name=:$column$.flex_value_set_name and ffvs_dep.validation_type in ('D','Y') and ffvs_dep.parent_flex_value_set_id=ffvs.flex_value_set_id and ffvs.flex_value_set_id=ffv.flex_value_set_id and ffv.flex_value_id=ffvv.flex_value_id and ffv.enabled_flag='Y' order by ffv.flex_value Required for dependent value sets. Select the parent independent value that this value belongs to. 8 FLEX_VALUE Char varchar2 150 Y 9 TRANSLATED_VALUE Char varchar2 150 :$column$.flex_value Translatable display value. Defaults from Flex Value. For non-translatable value sets (Independent/Dependent), this is always equal to the flex value. For translatable value sets (Translatable Independent/Dependent), this can be a different user-facing text. 10 DESCRIPTION Char varchar2 240 11 ENABLED LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual xxen_util.meaning('Y','YES_NO',0) 12 START_DATE_ACTIVE Date date 13 END_DATE_ACTIVE Date date 14 PARENT LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Indicates whether this value is a parent value in a hierarchy. Parent values can have child value ranges assigned. 15 ROLLUP_GROUP LOV custom varchar2 30 select ffhv.hierarchy_name value, ffhv.description from fnd_flex_value_sets ffvs, fnd_flex_hierarchies_vl ffhv where ffvs.flex_value_set_name=:$column$.flex_value_set_name and ffvs.flex_value_set_id=ffhv.flex_value_set_id order by ffhv.hierarchy_name Rollup group (hierarchy) that this value belongs to. Only applicable for value sets with hierarchies defined. 16 HIERARCHY_LEVEL Char varchar2 30 17 COMPILED_VALUE_ATTRIBUTES Char varchar2 2000 Internal compiled attributes string containing enabled flag, budget/posting flags, account type, and third-party flags. Typically auto-maintained by the system. 18 CHILD_RANGE_LOW Char varchar2 60 19 CHILD_RANGE_HIGH Char varchar2 60 20 RANGE_ATTRIBUTE LOV custom varchar2 select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='RANGE_ATTRIBUTE' and flvv.view_application_id=0 and flvv.enabled_flag='Y' and flvv.security_group_id=0 order by flvv.lookup_code 21 ATTRIBUTE_SORT_ORDER Number number 22 VALUE_CATEGORY LOV custom varchar2 select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=fdfv.application_id and fdfcv.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 23 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE1' 24 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE2' 25 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE3' 26 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE4' 27 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE5' 28 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE6' 29 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE7' 30 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE8' 31 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE9' 32 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE10' 33 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE11' 34 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE12' 35 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE13' 36 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE14' 37 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE15' 38 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE16' 39 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE17' 40 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE18' 41 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE19' 42 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=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE20' 43 ATTRIBUTE21 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE21', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE21' 44 ATTRIBUTE22 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE22', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE22' 45 ATTRIBUTE23 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE23', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE23' 46 ATTRIBUTE24 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE24', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE24' 47 ATTRIBUTE25 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE25', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE25' 48 ATTRIBUTE26 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE26', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE26' 49 ATTRIBUTE27 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE27', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE27' 50 ATTRIBUTE28 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE28', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE28' 51 ATTRIBUTE29 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE29', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE29' 52 ATTRIBUTE30 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>0, p_descriptive_flexfield_name=>'FND_FLEX_VALUES', p_context_name=>:$column$.value_category, p_column_name=>'ATTRIBUTE30', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30 )) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=0 and fdfv.descriptive_flexfield_name='FND_FLEX_VALUES' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE30' 53 ATTRIBUTE31 Char varchar2 240 54 ATTRIBUTE32 Char varchar2 240 55 ATTRIBUTE33 Char varchar2 240 56 ATTRIBUTE34 Char varchar2 240 57 ATTRIBUTE35 Char varchar2 240 58 ATTRIBUTE36 Char varchar2 240 59 ATTRIBUTE37 Char varchar2 240 60 ATTRIBUTE38 Char varchar2 240 61 ATTRIBUTE39 Char varchar2 240 62 ATTRIBUTE40 Char varchar2 240 63 ATTRIBUTE41 Char varchar2 240 64 ATTRIBUTE42 Char varchar2 240 65 ATTRIBUTE43 Char varchar2 240 66 ATTRIBUTE44 Char varchar2 240 67 ATTRIBUTE45 Char varchar2 240 68 ATTRIBUTE46 Char varchar2 240 69 ATTRIBUTE47 Char varchar2 240 70 ATTRIBUTE48 Char varchar2 240 71 ATTRIBUTE49 Char varchar2 240 72 ATTRIBUTE50 Char varchar2 240 73 DELETE_RANGE LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Set to Yes to delete this child range. Only applicable for rows with child range values. The parent flex value itself is not deleted. 74 UPLOAD_ROW Char varchar2 Y U 1 p_flex_value_set_name in Char FLEX_VALUE_SET_NAME U 2 p_parent_flex_value_low in Char INDEPENDENT_VALUE U 3 p_flex_value in Char FLEX_VALUE U 4 p_flex_value_meaning in Char TRANSLATED_VALUE U 5 p_description in Char DESCRIPTION U 6 p_enabled_flag in Char ENABLED U 7 p_start_date_active in Date START_DATE_ACTIVE U 8 p_end_date_active in Date END_DATE_ACTIVE U 9 p_summary_flag in Char PARENT U 10 p_structured_hierarchy_level in Number ROLLUP_GROUP U 11 p_hierarchy_level in Char HIERARCHY_LEVEL U 12 p_compiled_value_attributes in Char COMPILED_VALUE_ATTRIBUTES U 13 p_child_range_low in Char CHILD_RANGE_LOW U 14 p_child_range_high in Char CHILD_RANGE_HIGH U 15 p_range_attribute in Char RANGE_ATTRIBUTE U 16 p_attribute_sort_order in Char ATTRIBUTE_SORT_ORDER U 17 p_value_category in Char VALUE_CATEGORY U 18 p_attribute1 in Char ATTRIBUTE1 U 19 p_attribute2 in Char ATTRIBUTE2 U 20 p_attribute3 in Char ATTRIBUTE3 U 21 p_attribute4 in Char ATTRIBUTE4 U 22 p_attribute5 in Char ATTRIBUTE5 U 23 p_attribute6 in Char ATTRIBUTE6 U 24 p_attribute7 in Char ATTRIBUTE7 U 25 p_attribute8 in Char ATTRIBUTE8 U 26 p_attribute9 in Char ATTRIBUTE9 U 27 p_attribute10 in Char ATTRIBUTE10 U 28 p_attribute11 in Char ATTRIBUTE11 U 29 p_attribute12 in Char ATTRIBUTE12 U 30 p_attribute13 in Char ATTRIBUTE13 U 31 p_attribute14 in Char ATTRIBUTE14 U 32 p_attribute15 in Char ATTRIBUTE15 U 33 p_attribute16 in Char ATTRIBUTE16 U 34 p_attribute17 in Char ATTRIBUTE17 U 35 p_attribute18 in Char ATTRIBUTE18 U 36 p_attribute19 in Char ATTRIBUTE19 U 37 p_attribute20 in Char ATTRIBUTE20 U 38 p_attribute21 in Char ATTRIBUTE21 U 39 p_attribute22 in Char ATTRIBUTE22 U 40 p_attribute23 in Char ATTRIBUTE23 U 41 p_attribute24 in Char ATTRIBUTE24 U 42 p_attribute25 in Char ATTRIBUTE25 U 43 p_attribute26 in Char ATTRIBUTE26 U 44 p_attribute27 in Char ATTRIBUTE27 U 45 p_attribute28 in Char ATTRIBUTE28 U 46 p_attribute29 in Char ATTRIBUTE29 U 47 p_attribute30 in Char ATTRIBUTE30 U 48 p_attribute31 in Char ATTRIBUTE31 U 49 p_attribute32 in Char ATTRIBUTE32 U 50 p_attribute33 in Char ATTRIBUTE33 U 51 p_attribute34 in Char ATTRIBUTE34 U 52 p_attribute35 in Char ATTRIBUTE35 U 53 p_attribute36 in Char ATTRIBUTE36 U 54 p_attribute37 in Char ATTRIBUTE37 U 55 p_attribute38 in Char ATTRIBUTE38 U 56 p_attribute39 in Char ATTRIBUTE39 U 57 p_attribute40 in Char ATTRIBUTE40 U 58 p_attribute41 in Char ATTRIBUTE41 U 59 p_attribute42 in Char ATTRIBUTE42 U 60 p_attribute43 in Char ATTRIBUTE43 U 61 p_attribute44 in Char ATTRIBUTE44 U 62 p_attribute45 in Char ATTRIBUTE45 U 63 p_attribute46 in Char ATTRIBUTE46 U 64 p_attribute47 in Char ATTRIBUTE47 U 65 p_attribute48 in Char ATTRIBUTE48 U 66 p_attribute49 in Char ATTRIBUTE49 U 67 p_attribute50 in Char ATTRIBUTE50 U 68 p_delete_range in Char DELETE_RANGE U 69 status_ out Char STATUS_CODE_ U 70 message_ out Char MESSAGE_ Error SQL Order By upload_row, flex_value_set_name, independent_value, flex_value, child_range_low, delete_range Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.ffvs_flex_value_set_name, xu.ffvs0_flex_value_set_name parent_flex_value_set, xu.ffv_parent_flex_value_low independent_value, xu.ffv_flex_value, xu.ffvt_flex_value_meaning translated_value, xu.ffvt_description, xxen_util.yes(xu.ffv_enabled_flag) enabled, xu.ffv_start_date_active, xu.ffv_end_date_active, xxen_util.yes(xu.ffv_summary_flag) parent, xu.ffhv_hierarchy_name rollup_group, xu.ffv_hierarchy_level, xu.ffv_compiled_value_attributes, nvl(ffvnh.child_flex_value_low,xu.child_range_low) child_range_low, nvl(ffvnh.child_flex_value_high,xu.child_range_high) child_range_high, nvl(xxen_util.meaning(ffvnh.range_attribute,'RANGE_ATTRIBUTE',0),xu.range_attribute) range_attribute, xu.ffv_attribute_sort_order, xxen_util.display_flexfield_context(0,'FND_FLEX_VALUES',xu.ffv_value_category) value_category, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE1',xu.ffv_rowid,xu.ffv_attribute1) attribute1, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE2',xu.ffv_rowid,xu.ffv_attribute2) attribute2, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE3',xu.ffv_rowid,xu.ffv_attribute3) attribute3, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE4',xu.ffv_rowid,xu.ffv_attribute4) attribute4, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE5',xu.ffv_rowid,xu.ffv_attribute5) attribute5, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE6',xu.ffv_rowid,xu.ffv_attribute6) attribute6, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE7',xu.ffv_rowid,xu.ffv_attribute7) attribute7, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE8',xu.ffv_rowid,xu.ffv_attribute8) attribute8, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE9',xu.ffv_rowid,xu.ffv_attribute9) attribute9, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE10',xu.ffv_rowid,xu.ffv_attribute10) attribute10, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE11',xu.ffv_rowid,xu.ffv_attribute11) attribute11, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE12',xu.ffv_rowid,xu.ffv_attribute12) attribute12, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE13',xu.ffv_rowid,xu.ffv_attribute13) attribute13, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE14',xu.ffv_rowid,xu.ffv_attribute14) attribute14, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE15',xu.ffv_rowid,xu.ffv_attribute15) attribute15, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE16',xu.ffv_rowid,xu.ffv_attribute16) attribute16, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE17',xu.ffv_rowid,xu.ffv_attribute17) attribute17, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE18',xu.ffv_rowid,xu.ffv_attribute18) attribute18, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE19',xu.ffv_rowid,xu.ffv_attribute19) attribute19, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE20',xu.ffv_rowid,xu.ffv_attribute20) attribute20, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE21',xu.ffv_rowid,xu.ffv_attribute21) attribute21, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE22',xu.ffv_rowid,xu.ffv_attribute22) attribute22, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE23',xu.ffv_rowid,xu.ffv_attribute23) attribute23, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE24',xu.ffv_rowid,xu.ffv_attribute24) attribute24, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE25',xu.ffv_rowid,xu.ffv_attribute25) attribute25, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE26',xu.ffv_rowid,xu.ffv_attribute26) attribute26, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE27',xu.ffv_rowid,xu.ffv_attribute27) attribute27, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE28',xu.ffv_rowid,xu.ffv_attribute28) attribute28, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE29',xu.ffv_rowid,xu.ffv_attribute29) attribute29, xxen_util.display_flexfield_value(0,'FND_FLEX_VALUES',xu.ffv_value_category,'ATTRIBUTE30',xu.ffv_rowid,xu.ffv_attribute30) attribute30, xu.ffv_attribute31, xu.ffv_attribute32, xu.ffv_attribute33, xu.ffv_attribute34, xu.ffv_attribute35, xu.ffv_attribute36, xu.ffv_attribute37, xu.ffv_attribute38, xu.ffv_attribute39, xu.ffv_attribute40, xu.ffv_attribute41, xu.ffv_attribute42, xu.ffv_attribute43, xu.ffv_attribute44, xu.ffv_attribute45, xu.ffv_attribute46, xu.ffv_attribute47, xu.ffv_attribute48, xu.ffv_attribute49, xu.ffv_attribute50, xu.delete_range, xu.upload_row from ( select ffhv.hierarchy_name ffhv_hierarchy_name, ffv.attribute1 ffv_attribute1, ffv.attribute10 ffv_attribute10, ffv.attribute11 ffv_attribute11, ffv.attribute12 ffv_attribute12, ffv.attribute13 ffv_attribute13, ffv.attribute14 ffv_attribute14, ffv.attribute15 ffv_attribute15, ffv.attribute16 ffv_attribute16, ffv.attribute17 ffv_attribute17, ffv.attribute18 ffv_attribute18, ffv.attribute19 ffv_attribute19, ffv.attribute2 ffv_attribute2, ffv.attribute20 ffv_attribute20, ffv.attribute21 ffv_attribute21, ffv.attribute22 ffv_attribute22, ffv.attribute23 ffv_attribute23, ffv.attribute24 ffv_attribute24, ffv.attribute25 ffv_attribute25, ffv.attribute26 ffv_attribute26, ffv.attribute27 ffv_attribute27, ffv.attribute28 ffv_attribute28, ffv.attribute29 ffv_attribute29, ffv.attribute3 ffv_attribute3, ffv.attribute30 ffv_attribute30, ffv.attribute31 ffv_attribute31, ffv.attribute32 ffv_attribute32, ffv.attribute33 ffv_attribute33, ffv.attribute34 ffv_attribute34, ffv.attribute35 ffv_attribute35, ffv.attribute36 ffv_attribute36, ffv.attribute37 ffv_attribute37, ffv.attribute38 ffv_attribute38, ffv.attribute39 ffv_attribute39, ffv.attribute4 ffv_attribute4, ffv.attribute40 ffv_attribute40, ffv.attribute41 ffv_attribute41, ffv.attribute42 ffv_attribute42, ffv.attribute43 ffv_attribute43, ffv.attribute44 ffv_attribute44, ffv.attribute45 ffv_attribute45, ffv.attribute46 ffv_attribute46, ffv.attribute47 ffv_attribute47, ffv.attribute48 ffv_attribute48, ffv.attribute49 ffv_attribute49, ffv.attribute5 ffv_attribute5, ffv.attribute50 ffv_attribute50, ffv.attribute6 ffv_attribute6, ffv.attribute7 ffv_attribute7, ffv.attribute8 ffv_attribute8, ffv.attribute9 ffv_attribute9, ffv.attribute_sort_order ffv_attribute_sort_order, ffv.compiled_value_attributes ffv_compiled_value_attributes, ffv.enabled_flag ffv_enabled_flag, ffv.end_date_active ffv_end_date_active, ffv.flex_value ffv_flex_value, ffv.hierarchy_level ffv_hierarchy_level, ffv.parent_flex_value_low ffv_parent_flex_value_low, ffv.rowid ffv_rowid, ffv.start_date_active ffv_start_date_active, ffv.summary_flag ffv_summary_flag, ffv.value_category ffv_value_category, ffvs.flex_value_set_id ffvs_flex_value_set_id, ffvs.flex_value_set_name ffvs_flex_value_set_name, ffvs0.flex_value_set_name ffvs0_flex_value_set_name, ffvt.description ffvt_description, ffvt.flex_value_meaning ffvt_flex_value_meaning, xu.action_, xu.child_range_high, xu.child_range_low, xu.delete_range, xu.flex_value, xu.message_, xu.modified_columns_, xu.range_attribute, xu.status_, xu.upload_row from xxen_fnd_flex_value_upl_0744_u xu, fnd_flex_value_sets ffvs, fnd_flex_value_sets ffvs0, fnd_flex_values ffv, fnd_flex_values_tl ffvt, fnd_flex_hierarchies_vl ffhv where xu.status_code_=xxen_upload.status_success and xu.flex_value_set_name=ffvs.flex_value_set_name and ffvs.flex_value_set_id=ffv.flex_value_set_id and xu.flex_value=ffv.flex_value and nvl(xu.independent_value,'~')=nvl(ffv.parent_flex_value_low,'~') and ffvs.parent_flex_value_set_id=ffvs0.flex_value_set_id(+) and ffv.flex_value_id=ffvt.flex_value_id and ffvt.language=userenv('lang') and ffv.structured_hierarchy_level=ffhv.hierarchy_id(+) ) xu, --before 12c an outer joined table may reference at most one other table, so the driving tables are wrapped fnd_flex_value_norm_hierarchy ffvnh where xu.ffvs_flex_value_set_id=ffvnh.flex_value_set_id(+) and xu.flex_value=ffvnh.parent_flex_value(+) and nvl(xu.child_range_low,'~')=nvl(ffvnh.child_flex_value_low(+),'~') and nvl(xu.child_range_high,'~')=nvl(ffvnh.child_flex_value_high(+),'~')