ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 424F88C4F6504F5187F120FE0D7496FAY select null action_, null status_, null message_, null modified_columns_, fifsv.id_flex_structure_name structure_name, mcbk.concatenated_segments category, mcv.description, mcv.disable_date inactive_on, xxen_util.yes(mcv.web_status) enabled_for_iprocurement, xxen_util.yes(decode(mcv.supplier_enabled_flag,'N',null,'Y')) viewable_by_supplier, xxen_util.display_flexfield_context(401,'MTL_CATEGORIES',mcv.attribute_category) flexfield_context, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE1',mcv.row_id,mcv.attribute1) cat_attribute1, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE2',mcv.row_id,mcv.attribute2) cat_attribute2, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE3',mcv.row_id,mcv.attribute3) cat_attribute3, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE4',mcv.row_id,mcv.attribute4) cat_attribute4, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE5',mcv.row_id,mcv.attribute5) cat_attribute5, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE6',mcv.row_id,mcv.attribute6) cat_attribute6, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE7',mcv.row_id,mcv.attribute7) cat_attribute7, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE8',mcv.row_id,mcv.attribute8) cat_attribute8, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE9',mcv.row_id,mcv.attribute9) cat_attribute9, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE10',mcv.row_id,mcv.attribute10) cat_attribute10, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE11',mcv.row_id,mcv.attribute11) cat_attribute11, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE12',mcv.row_id,mcv.attribute12) cat_attribute12, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE13',mcv.row_id,mcv.attribute13) cat_attribute13, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE14',mcv.row_id,mcv.attribute14) cat_attribute14, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE15',mcv.row_id,mcv.attribute15) cat_attribute15, to_number(null) upload_row from fnd_id_flex_structures_vl fifsv, mtl_categories_b_kfv mcbk, mtl_categories_vl mcv where 1=1 and fifsv.application_id=401 and fifsv.id_flex_code='MCAT' and fifsv.id_flex_num=mcbk.structure_id and mcbk.category_id=mcv.category_id Initial version U A xxen_inv_upload.upload_category US INV Category Upload Creates and updates item category codes as the Categories window (Setup > Items > Categories > Category Codes): description, inactive date, iProcurement flags and the descriptive flexfield. Enter the category as its concatenated segments, separated by the structure's segment delimiter (for example COMPUTER.MONITOR). Each segment is validated against its value set. Categories cannot be deleted, and the segments of an existing category cannot be changed, as in the form. A category can only be made not viewable by suppliers in the purchasing category structure, and the default category of a category set cannot be made inactive. 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 fifsv.id_flex_structure_name=:structure_name LOV custom select fifsv.id_flex_structure_name value, fifsv.description from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MCAT' and fifsv.enabled_flag='Y' order by fifsv.id_flex_structure_name US Structure Name 3 30 1=1 mcbk.category_id in (select mcsvc.category_id from mtl_category_sets_vl mcsv, mtl_category_set_valid_cats mcsvc where mcsv.category_set_name=:category_set and mcsv.category_set_id=mcsvc.category_set_id) LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name US Category Set 4 40 1=1 mcbk.concatenated_segments like :category LOV custom Y select mcbk.concatenated_segments value, mcv.description from fnd_id_flex_structures_vl fifsv, mtl_categories_b_kfv mcbk, mtl_categories_vl mcv where fifsv.application_id=401 and fifsv.id_flex_code='MCAT' and (:$flex$.structure_name is null or fifsv.id_flex_structure_name=:$flex$.structure_name) and fifsv.id_flex_num=mcbk.structure_id and mcbk.category_id=mcv.category_id order by mcbk.concatenated_segments US Category 41C1087D52094833BED8010ED1EDD6F5 Create Categories Opens an empty sheet to create new category codes. ENGINATICS 2 CATEGORY Y 3 DESCRIPTION 4 ENABLED_FOR_IPROCUREMENT 1 STRUCTURE_NAME 5 VIEWABLE_BY_SUPPLIER Upload Mode C Y S Site Category Category Set Structure Name 446626B706A74D9CAF7EF4757F0994BE Default Creates and updates category codes, without the descriptive flexfield. ENGINATICS 2 CATEGORY Y 3 DESCRIPTION 5 ENABLED_FOR_IPROCUREMENT 4 INACTIVE_ON 1 STRUCTURE_NAME 6 VIEWABLE_BY_SUPPLIER Upload Mode C,U S Site FA0A3E1CB85242D6B70497852A30501B Flexfields Creates and updates category codes including the descriptive flexfield. ENGINATICS 2 CATEGORY Y 8 CAT_ATTRIBUTE1 17 CAT_ATTRIBUTE10 18 CAT_ATTRIBUTE11 19 CAT_ATTRIBUTE12 20 CAT_ATTRIBUTE13 21 CAT_ATTRIBUTE14 22 CAT_ATTRIBUTE15 9 CAT_ATTRIBUTE2 10 CAT_ATTRIBUTE3 11 CAT_ATTRIBUTE4 12 CAT_ATTRIBUTE5 13 CAT_ATTRIBUTE6 14 CAT_ATTRIBUTE7 15 CAT_ATTRIBUTE8 16 CAT_ATTRIBUTE9 3 DESCRIPTION 5 ENABLED_FOR_IPROCUREMENT 7 FLEXFIELD_CONTEXT 4 INACTIVE_ON 1 STRUCTURE_NAME 6 VIEWABLE_BY_SUPPLIER Upload Mode C,U S Site 446626B706A74D9CAF7EF4757F0994BE 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 STRUCTURE_NAME LOV custom varchar2 select fifsv.id_flex_num id, fifsv.id_flex_structure_name value, fifsv.description from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MCAT' and fifsv.enabled_flag='Y' order by fifsv.id_flex_structure_name :$flex$.structure_name Y Y 6 CATEGORY LOV custom varchar2 Y select mcbk.concatenated_segments value, mcv.description from fnd_id_flex_structures_vl fifsv, mtl_categories_b_kfv mcbk, mtl_categories_vl mcv where fifsv.application_id=401 and fifsv.id_flex_code='MCAT' and fifsv.id_flex_structure_name=:$column$.structure_name and fifsv.id_flex_num=mcbk.structure_id and mcbk.category_id=mcv.category_id order by mcbk.concatenated_segments Concatenated category segments, separated by the segment delimiter of the structure. Y Y 7 DESCRIPTION Char varchar2 8 INACTIVE_ON Date date 9 ENABLED_FOR_IPROCUREMENT LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 10 VIEWABLE_BY_SUPPLIER 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) 11 FLEXFIELD_CONTEXT LOV custom varchar2 select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=401 and fdfcv.descriptive_flexfield_name='MTL_CATEGORIES' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 12 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE1' 13 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE2' 14 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE3' 15 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE4' 16 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE5' 17 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE6' 18 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE7' 19 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE8' 20 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE9' 21 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE10' 22 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE11' 23 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE12' 24 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE13' 25 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE14' 26 CAT_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=>401, p_descriptive_flexfield_name=>'MTL_CATEGORIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.cat_attribute1, p_attribute2=>:$column$.cat_attribute2, p_attribute3=>:$column$.cat_attribute3, p_attribute4=>:$column$.cat_attribute4, p_attribute5=>:$column$.cat_attribute5, p_attribute6=>:$column$.cat_attribute6, p_attribute7=>:$column$.cat_attribute7, p_attribute8=>:$column$.cat_attribute8, p_attribute9=>:$column$.cat_attribute9, p_attribute10=>:$column$.cat_attribute10, p_attribute11=>:$column$.cat_attribute11, p_attribute12=>:$column$.cat_attribute12, p_attribute13=>:$column$.cat_attribute13, p_attribute14=>:$column$.cat_attribute14, p_attribute15=>:$column$.cat_attribute15 ) ) lov 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_CATEGORIES' and fdfcuv.application_column_name = 'ATTRIBUTE15' 27 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 p_structure_id in Number STRUCTURE_NAME U 5 p_category in Char CATEGORY U 6 p_description in Char Y DESCRIPTION U 7 p_inactive_on in Date Y INACTIVE_ON U 8 p_enabled_for_iprocurement in Char Y ENABLED_FOR_IPROCUREMENT U 9 p_viewable_by_supplier in Char Y VIEWABLE_BY_SUPPLIER U 10 p_attribute_category in Char Y FLEXFIELD_CONTEXT U 11 p_cat_attribute1 in Char Y CAT_ATTRIBUTE1 U 12 p_cat_attribute2 in Char Y CAT_ATTRIBUTE2 U 13 p_cat_attribute3 in Char Y CAT_ATTRIBUTE3 U 14 p_cat_attribute4 in Char Y CAT_ATTRIBUTE4 U 15 p_cat_attribute5 in Char Y CAT_ATTRIBUTE5 U 16 p_cat_attribute6 in Char Y CAT_ATTRIBUTE6 U 17 p_cat_attribute7 in Char Y CAT_ATTRIBUTE7 U 18 p_cat_attribute8 in Char Y CAT_ATTRIBUTE8 U 19 p_cat_attribute9 in Char Y CAT_ATTRIBUTE9 U 20 p_cat_attribute10 in Char Y CAT_ATTRIBUTE10 U 21 p_cat_attribute11 in Char Y CAT_ATTRIBUTE11 U 22 p_cat_attribute12 in Char Y CAT_ATTRIBUTE12 U 23 p_cat_attribute13 in Char Y CAT_ATTRIBUTE13 U 24 p_cat_attribute14 in Char Y CAT_ATTRIBUTE14 U 25 p_cat_attribute15 in Char Y CAT_ATTRIBUTE15 Error SQL Order By upload_row, structure_name, category Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, fifsv.id_flex_structure_name structure_name, mcbk.concatenated_segments category, mcv.description, mcv.disable_date inactive_on, xxen_util.yes(mcv.web_status) enabled_for_iprocurement, xxen_util.yes(decode(mcv.supplier_enabled_flag,'N',null,'Y')) viewable_by_supplier, xxen_util.display_flexfield_context(401,'MTL_CATEGORIES',mcv.attribute_category) flexfield_context, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE1',mcv.row_id,mcv.attribute1) cat_attribute1, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE2',mcv.row_id,mcv.attribute2) cat_attribute2, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE3',mcv.row_id,mcv.attribute3) cat_attribute3, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE4',mcv.row_id,mcv.attribute4) cat_attribute4, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE5',mcv.row_id,mcv.attribute5) cat_attribute5, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE6',mcv.row_id,mcv.attribute6) cat_attribute6, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE7',mcv.row_id,mcv.attribute7) cat_attribute7, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE8',mcv.row_id,mcv.attribute8) cat_attribute8, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE9',mcv.row_id,mcv.attribute9) cat_attribute9, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE10',mcv.row_id,mcv.attribute10) cat_attribute10, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE11',mcv.row_id,mcv.attribute11) cat_attribute11, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE12',mcv.row_id,mcv.attribute12) cat_attribute12, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE13',mcv.row_id,mcv.attribute13) cat_attribute13, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE14',mcv.row_id,mcv.attribute14) cat_attribute14, xxen_util.display_flexfield_value(401,'MTL_CATEGORIES',mcv.attribute_category,'ATTRIBUTE15',mcv.row_id,mcv.attribute15) cat_attribute15, xu.upload_row from xxen_inv_category_uploa_5321_u xu, fnd_id_flex_structures_vl fifsv, mtl_categories_b_kfv mcbk, mtl_categories_vl mcv where xu.status_code_=xxen_upload.status_success and fifsv.application_id=401 and fifsv.id_flex_code='MCAT' and xu.structure_name=fifsv.id_flex_structure_name and fifsv.id_flex_num=mcbk.structure_id and xu.category=mcbk.concatenated_segments and mcbk.category_id=mcv.category_id