ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C7E26384749243C59D54D60277052AA0Y select null action_, null status_, null message_, null modified_columns_, meanv.inv_organization_code organization, meanv.instance_number asset_number, meanv.concatenated_segments asset_group, xxen_util.display_flexfield_context(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category) attribute_group, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE1',meaav.rowid,meaav.c_attribute1) attribute1, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE2',meaav.rowid,meaav.c_attribute2) attribute2, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE3',meaav.rowid,meaav.c_attribute3) attribute3, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE4',meaav.rowid,meaav.c_attribute4) attribute4, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE5',meaav.rowid,meaav.c_attribute5) attribute5, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE6',meaav.rowid,meaav.c_attribute6) attribute6, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE7',meaav.rowid,meaav.c_attribute7) attribute7, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE8',meaav.rowid,meaav.c_attribute8) attribute8, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE9',meaav.rowid,meaav.c_attribute9) attribute9, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE10',meaav.rowid,meaav.c_attribute10) attribute10, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE11',meaav.rowid,meaav.c_attribute11) attribute11, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE12',meaav.rowid,meaav.c_attribute12) attribute12, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE13',meaav.rowid,meaav.c_attribute13) attribute13, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE14',meaav.rowid,meaav.c_attribute14) attribute14, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE15',meaav.rowid,meaav.c_attribute15) attribute15, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE16',meaav.rowid,meaav.c_attribute16) attribute16, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE17',meaav.rowid,meaav.c_attribute17) attribute17, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE18',meaav.rowid,meaav.c_attribute18) attribute18, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE19',meaav.rowid,meaav.c_attribute19) attribute19, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE20',meaav.rowid,meaav.c_attribute20) attribute20, meaav.n_attribute1 number_attribute1, meaav.n_attribute2 number_attribute2, meaav.n_attribute3 number_attribute3, meaav.n_attribute4 number_attribute4, meaav.n_attribute5 number_attribute5, meaav.n_attribute6 number_attribute6, meaav.n_attribute7 number_attribute7, meaav.n_attribute8 number_attribute8, meaav.n_attribute9 number_attribute9, meaav.n_attribute10 number_attribute10, meaav.d_attribute1 date_attribute1, meaav.d_attribute2 date_attribute2, meaav.d_attribute3 date_attribute3, meaav.d_attribute4 date_attribute4, meaav.d_attribute5 date_attribute5, meaav.d_attribute6 date_attribute6, meaav.d_attribute7 date_attribute7, meaav.d_attribute8 date_attribute8, meaav.d_attribute9 date_attribute9, meaav.d_attribute10 date_attribute10, to_number(null) upload_row from mtl_eam_asset_numbers_all_v meanv, mtl_eam_asset_attr_values meaav where 1=1 and meanv.inventory_item_id=meaav.inventory_item_id and meanv.serial_number=meaav.serial_number New upload for the asset attribute values (attribute groups) of asset and rebuildable numbers. U A xxen_eam_upload.upload_asset_attribute US EAM Asset Attribute Upload Create and update Oracle Enterprise Asset Management asset attribute values, the attribute group values of an asset or rebuildable number. Attribute groups are assigned to an asset group (Enterprise Asset Management: Asset Groups, Attributes) and their values are entered per asset number in the Asset Attributes window. Each row uploads one attribute group of one asset number, so an asset with several attribute groups has one row per group. The attribute columns follow the flexfield segments of the selected attribute group: Attribute 1-20 hold the character segments, Number Attribute 1-10 the number segments and Date Attribute 1-10 the date segments. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 1=1 meanv.current_organization_id=:p_organization LOV custom Y select mp.organization_id id, mp.organization_code value, haou.name description from mtl_parameters mp, hr_all_organization_units haou where mp.eam_enabled_flag='Y' and mp.organization_id=haou.organization_id order by mp.organization_code US Organization 3 30 1=1 meanv.instance_number>=:asset_number_from Char US Asset Number From 4 40 1=1 meanv.instance_number<=:asset_number_to Char :$flex$.asset_number_from US Asset Number To 5 50 1=1 meanv.concatenated_segments=:asset_group LOV custom Y select distinct meanv.concatenated_segments id, meanv.concatenated_segments value, null description from mtl_eam_asset_numbers_all_v meanv where (:$flex$.Organization is null or xxen_util.contains(:$flex$.Organization,meanv.current_organization_id)='Y') order by meanv.concatenated_segments US Asset Group 6 60 1=1 meaav.attribute_category=:attribute_group LOV custom Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=401 and fdfcv.descriptive_flexfield_name='MTL_EAM_ASSET_ATTR_VALUES' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name US Attribute Group 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 ORGANIZATION LOV varchar2 3 INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code select mp.organization_id id, mp.organization_code value from mtl_parameters mp where mp.eam_enabled_flag='Y' and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) Y 6 ASSET_NUMBER LOV custom varchar2 30 Y select meanv.instance_number value, meanv.descriptive_text description from mtl_parameters mp, mtl_eam_asset_numbers_all_v meanv where mp.organization_code=:$column$.organization and mp.organization_id=meanv.current_organization_id order by meanv.instance_number Y 7 ASSET_GROUP Char varchar2 select meanv.concatenated_segments from mtl_parameters mp, mtl_eam_asset_numbers_all_v meanv where mp.organization_code=:$column$.organization and mp.organization_id=meanv.current_organization_id and meanv.instance_number=:$column$.asset_number Y 8 ATTRIBUTE_GROUP LOV custom varchar2 Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, fdfcv.description from mtl_parameters mp, mtl_eam_asset_numbers_all_v meanv, mtl_eam_asset_attr_groups meaag, fnd_descr_flex_contexts_vl fdfcv where mp.organization_code=:$column$.organization and mp.organization_id=meanv.current_organization_id and meanv.instance_number=:$column$.asset_number and meanv.inventory_item_id=meaag.inventory_item_id and meanv.current_organization_id=meaag.organization_id and meaag.enabled_flag='Y' and meaag.application_id=fdfcv.application_id and meaag.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and meaag.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name Y 9 ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE1' 10 ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE2' 11 ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE3' 12 ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE4' 13 ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE5' 14 ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE6' 15 ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE7' 16 ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE8' 17 ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE9' 18 ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE10' 19 ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE11' 20 ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE12' 21 ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE13' 22 ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE14' 23 ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE15' 24 ATTRIBUTE16 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE16' 25 ATTRIBUTE17 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE17' 26 ATTRIBUTE18 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE18' 27 ATTRIBUTE19 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE19' 28 ATTRIBUTE20 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_EAM_ASSET_ATTR_VALUES', p_context_name=>:$column$.attribute_group, p_column_name=>'C_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) ) 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 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='C_ATTRIBUTE20' 29 NUMBER_ATTRIBUTE1 Number number 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='N_ATTRIBUTE1' 30 NUMBER_ATTRIBUTE2 Number number 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='N_ATTRIBUTE2' 31 NUMBER_ATTRIBUTE3 Number number 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='N_ATTRIBUTE3' 32 NUMBER_ATTRIBUTE4 Number number 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='N_ATTRIBUTE4' 33 NUMBER_ATTRIBUTE5 Number number 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='N_ATTRIBUTE5' 34 NUMBER_ATTRIBUTE6 Number number 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='N_ATTRIBUTE6' 35 NUMBER_ATTRIBUTE7 Number number 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='N_ATTRIBUTE7' 36 NUMBER_ATTRIBUTE8 Number number 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='N_ATTRIBUTE8' 37 NUMBER_ATTRIBUTE9 Number number 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='N_ATTRIBUTE9' 38 NUMBER_ATTRIBUTE10 Number number 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='N_ATTRIBUTE10' 39 DATE_ATTRIBUTE1 Date date 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='D_ATTRIBUTE1' 40 DATE_ATTRIBUTE2 Date date 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='D_ATTRIBUTE2' 41 DATE_ATTRIBUTE3 Date date 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='D_ATTRIBUTE3' 42 DATE_ATTRIBUTE4 Date date 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='D_ATTRIBUTE4' 43 DATE_ATTRIBUTE5 Date date 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='D_ATTRIBUTE5' 44 DATE_ATTRIBUTE6 Date date 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='D_ATTRIBUTE6' 45 DATE_ATTRIBUTE7 Date date 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='D_ATTRIBUTE7' 46 DATE_ATTRIBUTE8 Date date 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='D_ATTRIBUTE8' 47 DATE_ATTRIBUTE9 Date date 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='D_ATTRIBUTE9' 48 DATE_ATTRIBUTE10 Date date 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_EAM_ASSET_ATTR_VALUES' and fdfcuv.application_column_name='D_ATTRIBUTE10' 49 UPLOAD_ROW Number number Y U 1 p_organization_id in Number ORGANIZATION U 2 p_asset_number in Char ASSET_NUMBER U 3 p_attribute_category in Char ATTRIBUTE_GROUP U 4 p_attribute1 in Char ATTRIBUTE1 U 5 p_attribute2 in Char ATTRIBUTE2 U 6 p_attribute3 in Char ATTRIBUTE3 U 7 p_attribute4 in Char ATTRIBUTE4 U 8 p_attribute5 in Char ATTRIBUTE5 U 9 p_attribute6 in Char ATTRIBUTE6 U 10 p_attribute7 in Char ATTRIBUTE7 U 11 p_attribute8 in Char ATTRIBUTE8 U 12 p_attribute9 in Char ATTRIBUTE9 U 13 p_attribute10 in Char ATTRIBUTE10 U 14 p_attribute11 in Char ATTRIBUTE11 U 15 p_attribute12 in Char ATTRIBUTE12 U 16 p_attribute13 in Char ATTRIBUTE13 U 17 p_attribute14 in Char ATTRIBUTE14 U 18 p_attribute15 in Char ATTRIBUTE15 U 19 p_attribute16 in Char ATTRIBUTE16 U 20 p_attribute17 in Char ATTRIBUTE17 U 21 p_attribute18 in Char ATTRIBUTE18 U 22 p_attribute19 in Char ATTRIBUTE19 U 23 p_attribute20 in Char ATTRIBUTE20 U 24 p_number_attribute1 in Number NUMBER_ATTRIBUTE1 U 25 p_number_attribute2 in Number NUMBER_ATTRIBUTE2 U 26 p_number_attribute3 in Number NUMBER_ATTRIBUTE3 U 27 p_number_attribute4 in Number NUMBER_ATTRIBUTE4 U 28 p_number_attribute5 in Number NUMBER_ATTRIBUTE5 U 29 p_number_attribute6 in Number NUMBER_ATTRIBUTE6 U 30 p_number_attribute7 in Number NUMBER_ATTRIBUTE7 U 31 p_number_attribute8 in Number NUMBER_ATTRIBUTE8 U 32 p_number_attribute9 in Number NUMBER_ATTRIBUTE9 U 33 p_number_attribute10 in Number NUMBER_ATTRIBUTE10 U 34 p_date_attribute1 in Date DATE_ATTRIBUTE1 U 35 p_date_attribute2 in Date DATE_ATTRIBUTE2 U 36 p_date_attribute3 in Date DATE_ATTRIBUTE3 U 37 p_date_attribute4 in Date DATE_ATTRIBUTE4 U 38 p_date_attribute5 in Date DATE_ATTRIBUTE5 U 39 p_date_attribute6 in Date DATE_ATTRIBUTE6 U 40 p_date_attribute7 in Date DATE_ATTRIBUTE7 U 41 p_date_attribute8 in Date DATE_ATTRIBUTE8 U 42 p_date_attribute9 in Date DATE_ATTRIBUTE9 U 43 p_date_attribute10 in Date DATE_ATTRIBUTE10 U 44 status_ out Char STATUS_CODE_ U 45 message_ out Char MESSAGE_ Error SQL Order By upload_row, organization, asset_number, attribute_group Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, meanv.inv_organization_code organization, meanv.instance_number asset_number, meanv.concatenated_segments asset_group, xxen_util.display_flexfield_context(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category) attribute_group, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE1',meaav.rowid,meaav.c_attribute1) attribute1, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE2',meaav.rowid,meaav.c_attribute2) attribute2, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE3',meaav.rowid,meaav.c_attribute3) attribute3, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE4',meaav.rowid,meaav.c_attribute4) attribute4, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE5',meaav.rowid,meaav.c_attribute5) attribute5, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE6',meaav.rowid,meaav.c_attribute6) attribute6, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE7',meaav.rowid,meaav.c_attribute7) attribute7, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE8',meaav.rowid,meaav.c_attribute8) attribute8, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE9',meaav.rowid,meaav.c_attribute9) attribute9, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE10',meaav.rowid,meaav.c_attribute10) attribute10, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE11',meaav.rowid,meaav.c_attribute11) attribute11, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE12',meaav.rowid,meaav.c_attribute12) attribute12, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE13',meaav.rowid,meaav.c_attribute13) attribute13, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE14',meaav.rowid,meaav.c_attribute14) attribute14, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE15',meaav.rowid,meaav.c_attribute15) attribute15, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE16',meaav.rowid,meaav.c_attribute16) attribute16, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE17',meaav.rowid,meaav.c_attribute17) attribute17, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE18',meaav.rowid,meaav.c_attribute18) attribute18, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE19',meaav.rowid,meaav.c_attribute19) attribute19, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ATTR_VALUES',meaav.attribute_category,'C_ATTRIBUTE20',meaav.rowid,meaav.c_attribute20) attribute20, meaav.n_attribute1 number_attribute1, meaav.n_attribute2 number_attribute2, meaav.n_attribute3 number_attribute3, meaav.n_attribute4 number_attribute4, meaav.n_attribute5 number_attribute5, meaav.n_attribute6 number_attribute6, meaav.n_attribute7 number_attribute7, meaav.n_attribute8 number_attribute8, meaav.n_attribute9 number_attribute9, meaav.n_attribute10 number_attribute10, meaav.d_attribute1 date_attribute1, meaav.d_attribute2 date_attribute2, meaav.d_attribute3 date_attribute3, meaav.d_attribute4 date_attribute4, meaav.d_attribute5 date_attribute5, meaav.d_attribute6 date_attribute6, meaav.d_attribute7 date_attribute7, meaav.d_attribute8 date_attribute8, meaav.d_attribute9 date_attribute9, meaav.d_attribute10 date_attribute10, xu.upload_row from xxen_eam_asset_attribut_7864_u xu, mtl_parameters mp, mtl_eam_asset_numbers_all_v meanv, mtl_eam_asset_attr_values meaav, fnd_descr_flex_contexts_vl fdfcv where xu.status_code_=xxen_upload.status_success and xu.organization=mp.organization_code and mp.organization_id=meanv.current_organization_id and xu.asset_number=meanv.instance_number and meanv.inventory_item_id=meaav.inventory_item_id and meanv.serial_number=meaav.serial_number and xu.attribute_group=fdfcv.descriptive_flex_context_name and fdfcv.application_id=401 and fdfcv.descriptive_flexfield_name='MTL_EAM_ASSET_ATTR_VALUES' and fdfcv.descriptive_flex_context_code=meaav.attribute_category