ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 5029DD3AEB9F63ADE0630100007FE5A6Y select null action_, null status_, null message_, null modified_columns_, meanv.inv_organization_code organization, meanv.instance_number asset_number, meanv.maintenance_object_id asset_id, meanv.concatenated_segments asset_group, meanv.serial_number asset_serial_number, meanv.descriptive_text description, meanv.category_name asset_category, meanv.owning_department, meanv.asset_criticality criticality, meanv.wip_accounting_class_code wip_accounting_class, meanv.area, decode(meanv.maintainable_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) maintainable, decode(meanv.network_asset_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) asset_route, decode(meanv.operational_log_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) operation_log, meanv.supplier_warranty_exp_date warranty_expiration, meanv.prod_organization_code production_organization, (select msi.concatenated_segments from mtl_system_items_b_kfv msi where msi.inventory_item_id=meanv.equipment_item_id and msi.organization_id=meanv.prod_organization_id) equipment_item, meanv.eqp_serial_number equipment_serial_number, meanv.pn_location_code property_location_code, meanv.fa_asset_number, decode(meanv.fa_sync_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) fa_synchronized, meanv.active_start_date, meanv.active_end_date, xxen_util.meaning(to_char(meanv.eam_item_type),'MTL_EAM_ASSET_TYPE',700) asset_type, meanv.current_status_meaning asset_status, meanv.current_location current_location_address, meanv.parent_instance_number parent_asset_number, meanv.parent_serial_number parent_asset_serial_number, (select cii.instance_id from csi_item_instances cii where meanv.parent_instance_number=cii.instance_number) parent_asset_id, xxen_util.display_flexfield_context(542,'Item Instance Flex Field',meanv.context) attribute_category, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE1',meanv.row_id,meanv.attribute1) attribute1, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE2',meanv.row_id,meanv.attribute2) attribute2, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE3',meanv.row_id,meanv.attribute3) attribute3, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE4',meanv.row_id,meanv.attribute4) attribute4, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE5',meanv.row_id,meanv.attribute5) attribute5, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE6',meanv.row_id,meanv.attribute6) attribute6, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE7',meanv.row_id,meanv.attribute7) attribute7, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE8',meanv.row_id,meanv.attribute8) attribute8, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE9',meanv.row_id,meanv.attribute9) attribute9, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE10',meanv.row_id,meanv.attribute10) attribute10, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE11',meanv.row_id,meanv.attribute11) attribute11, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE12',meanv.row_id,meanv.attribute12) attribute12, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE13',meanv.row_id,meanv.attribute13) attribute13, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE14',meanv.row_id,meanv.attribute14) attribute14, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE15',meanv.row_id,meanv.attribute15) attribute15, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE16',meanv.row_id,meanv.attribute16) attribute16, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE17',meanv.row_id,meanv.attribute17) attribute17, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE18',meanv.row_id,meanv.attribute18) attribute18, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE19',meanv.row_id,meanv.attribute19) attribute19, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE20',meanv.row_id,meanv.attribute20) attribute20, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE21',meanv.row_id,meanv.attribute21) attribute21, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE22',meanv.row_id,meanv.attribute22) attribute22, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE23',meanv.row_id,meanv.attribute23) attribute23, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE24',meanv.row_id,meanv.attribute24) attribute24, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE25',meanv.row_id,meanv.attribute25) attribute25, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE26',meanv.row_id,meanv.attribute26) attribute26, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE27',meanv.row_id,meanv.attribute27) attribute27, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE28',meanv.row_id,meanv.attribute28) attribute28, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE29',meanv.row_id,meanv.attribute29) attribute29, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE30',meanv.row_id,meanv.attribute30) attribute30, to_number(null) upload_row from mtl_eam_asset_numbers_all_v meanv where 1=1 Added read only columns Asset Id, Asset Type, Asset Status, Current Location Address, Parent Asset Number, Parent Asset Serial Number and Parent Asset Id, so that assets can be reconciled against externally supplied source data and their hierarchy, status and location are visible on download. U A xxen_eam_upload.upload_asset_number US EAM Asset Number Upload Create and update Oracle Enterprise Asset Management asset numbers (maintenance assets). Parent Asset Number places the asset in the asset hierarchy; clearing it on an existing asset removes the parent. Parent Asset Serial Number and Parent Asset Id follow the parent asset number and are read only. 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 meanv.category_id=:asset_category LOV custom Y select distinct meanv.category_id id, meanv.category_name value, null description from mtl_eam_asset_numbers_all_v meanv where meanv.category_id is not null and (:$flex$.Organization is null or xxen_util.contains(:$flex$.Organization,meanv.current_organization_id)='Y') order by meanv.category_name US Asset Category 7 70 1=1 meanv.current_status=:asset_status LOV custom Y select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='SERIAL_NUM_STATUS' order by ml.lookup_code US Asset Status 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 Char varchar2 30 Y Y 7 ASSET_ID Number number Y 8 ASSET_GROUP LOV custom varchar2 40 Y select msi.inventory_item_id id, msi.concatenated_segments value, msi.description from mtl_system_items_b_kfv msi, mtl_parameters mp where msi.organization_id=mp.organization_id and mp.organization_code=:$column$.organization and msi.eam_item_type in (1,3) and msi.serial_number_control_code in (2,5,6) order by msi.concatenated_segments Y 9 ASSET_SERIAL_NUMBER Char varchar2 30 Y 10 DESCRIPTION Char varchar2 240 11 ASSET_CATEGORY LOV custom varchar2 163 Y select distinct mck.category_id id, mck.concatenated_segments value, mck.description from mtl_categories_kfv mck, mtl_category_sets_vl mcsv, mtl_item_categories mic, mtl_parameters mp, mtl_system_items_b_kfv msi where mcsv.category_set_name='Enterprise Asset Management' and mcsv.structure_id=mck.structure_id and mck.enabled_flag='Y' and mic.category_set_id=mcsv.category_set_id and mic.category_id=mck.category_id and mic.organization_id=mp.organization_id and mp.organization_code=:$column$.organization and msi.organization_id=mp.organization_id and msi.concatenated_segments=:$column$.asset_group and msi.inventory_item_id=mic.inventory_item_id order by mck.concatenated_segments 12 OWNING_DEPARTMENT LOV custom varchar2 10 Y select bd.department_id id, bd.department_code value, nvl2(bd.department_class_code,bd.department_class_code||': ',null)||bd.description description from bom_departments bd, mtl_parameters mp where bd.organization_id=mp.organization_id and mp.organization_code=:$column$.organization and nvl(bd.disable_date,sysdate+1)>sysdate order by bd.department_code 13 CRITICALITY LOV custom varchar2 80 Y select ml.lookup_code id, ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='MTL_EAM_ASSET_CRITICALITY' and ml.enabled_flag='Y' order by ml.lookup_code 14 WIP_ACCOUNTING_CLASS LOV varchar2 10 WIP Class Code (org dependent) E7CCB27F39561272E0530100007F62B4 Y select distinct wac.class_code value, wac.description from mtl_parameters mp, wip_accounting_classes wac where (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and mp.organization_id=wac.organization_id order by wac.class_code 15 AREA LOV custom varchar2 30 Y select mel.location_id id, mel.location_codes value, mel.description from mtl_eam_locations mel, mtl_parameters mp where mel.organization_id=mp.organization_id and mp.organization_code=:$column$.organization and sysdate between nvl(mel.start_date,sysdate-1) and nvl(mel.end_date,sysdate+1) order by mel.location_codes 16 MAINTAINABLE LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual xxen_util.meaning('Y','YES_NO',0) 17 ASSET_ROUTE LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 18 OPERATION_LOG LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 19 WARRANTY_EXPIRATION Date date 20 PRODUCTION_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) and exists (select null from org_organization_definitions ood where ood.organization_id=mp.organization_id and nvl(ood.disable_date,sysdate)>=sysdate) 21 EQUIPMENT_ITEM LOV custom varchar2 40 Y select msi.inventory_item_id id, msi.concatenated_segments value, msi.description from mtl_system_items_b_kfv msi, mtl_parameters mp where msi.organization_id=mp.organization_id and mp.organization_code=:$column$.production_organization and msi.equipment_type=1 order by msi.concatenated_segments 22 EQUIPMENT_SERIAL_NUMBER LOV custom varchar2 30 Y select msn.serial_number value from mtl_serial_numbers msn, mtl_system_items_b_kfv msi, mtl_parameters mp where msn.current_organization_id=mp.organization_id and mp.organization_code=:$column$.production_organization and msn.inventory_item_id=msi.inventory_item_id and msi.organization_id=msn.current_organization_id and msi.concatenated_segments=:$column$.equipment_item order by msn.serial_number 23 PROPERTY_LOCATION_CODE LOV custom varchar2 90 Y select pla.location_id id, pla.location_code value, pla.active_start_date||' - '||pla.active_end_date description from pn_locations_all pla where sysdate between pla.active_start_date and pla.active_end_date order by pla.location_code 24 FA_ASSET_NUMBER LOV custom varchar2 15 Y select fav.asset_id id, fav.asset_number value, fav.description from fa_additions_vl fav where fav.in_use_flag in ('Y','YES') order by fav.asset_number 25 FA_SYNCHRONIZED LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 26 ACTIVE_START_DATE Date date 27 ACTIVE_END_DATE Date date 28 ASSET_TYPE Char varchar2 80 Y 29 ASSET_STATUS Char varchar2 80 Y 30 CURRENT_LOCATION_ADDRESS Char varchar2 1207 Y 31 PARENT_ASSET_NUMBER LOV custom varchar2 30 Y select cii.instance_id id, cii.instance_number value, nvl(cii.instance_description,msn.descriptive_text) description from mtl_parameters mp, mtl_serial_numbers msn, mtl_system_items_b msib, csi_item_instances cii where mp.organization_code=:$column$.organization and mp.organization_id=msn.current_organization_id and msn.inventory_item_id=msib.inventory_item_id and msn.current_organization_id=msib.organization_id and msib.eam_item_type in (1,3) and msn.inventory_item_id=cii.inventory_item_id and msn.serial_number=cii.serial_number and (:$column$.asset_number is null or cii.instance_number<>:$column$.asset_number) order by cii.instance_number 32 PARENT_ASSET_SERIAL_NUMBER Char varchar2 30 Y 33 PARENT_ASSET_ID Number number Y 34 ATTRIBUTE_CATEGORY LOV custom varchar2 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=542 and fdfcv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by 2 35 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE1' 36 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE2' 37 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE3' 38 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE4' 39 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE5' 40 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE6' 41 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE7' 42 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE8' 43 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE9' 44 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE10' 45 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE11' 46 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE12' 47 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE13' 48 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE14' 49 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE15' 50 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE16' 51 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE17' 52 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE18' 53 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE19' 54 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE20' 55 ATTRIBUTE21 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE21', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE21' 56 ATTRIBUTE22 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE22', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE22' 57 ATTRIBUTE23 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE23', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE23' 58 ATTRIBUTE24 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE24', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE24' 59 ATTRIBUTE25 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE25', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE25' 60 ATTRIBUTE26 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE26', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE26' 61 ATTRIBUTE27 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE27', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE27' 62 ATTRIBUTE28 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE28', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE28' 63 ATTRIBUTE29 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE29', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE29' 64 ATTRIBUTE30 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=>542, p_descriptive_flexfield_name=>'Item Instance Flex Field', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE30', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10, p_attribute11=>:$column$.attribute11, p_attribute12=>:$column$.attribute12, p_attribute13=>:$column$.attribute13, p_attribute14=>:$column$.attribute14, p_attribute15=>:$column$.attribute15, p_attribute16=>:$column$.attribute16, p_attribute17=>:$column$.attribute17, p_attribute18=>:$column$.attribute18, p_attribute19=>:$column$.attribute19, p_attribute20=>:$column$.attribute20, p_attribute21=>:$column$.attribute21, p_attribute22=>:$column$.attribute22, p_attribute23=>:$column$.attribute23, p_attribute24=>:$column$.attribute24, p_attribute25=>:$column$.attribute25, p_attribute26=>:$column$.attribute26, p_attribute27=>:$column$.attribute27, p_attribute28=>:$column$.attribute28, p_attribute29=>:$column$.attribute29, p_attribute30=>:$column$.attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where 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=542 and fdfv.descriptive_flexfield_name='Item Instance Flex Field' and fdfcuv.application_column_name='ATTRIBUTE30' 65 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_inventory_item_id in Number ASSET_GROUP U 4 p_serial_number in Char ASSET_SERIAL_NUMBER U 5 p_descriptive_text in Char DESCRIPTION U 6 p_category_id in Number ASSET_CATEGORY U 7 p_owning_department_id in Number OWNING_DEPARTMENT U 8 p_asset_criticality_code in Char CRITICALITY U 9 p_wip_accounting_class_code in Char WIP_ACCOUNTING_CLASS U 10 p_eam_location_id in Number AREA U 11 p_maintainable_flag in Char MAINTAINABLE U 12 p_network_asset_flag in Char ASSET_ROUTE U 13 p_operational_log_flag in Char OPERATION_LOG U 14 p_supplier_warranty_exp_date in Date WARRANTY_EXPIRATION U 15 p_prod_organization_id in Number PRODUCTION_ORGANIZATION U 16 p_equipment_item_id in Number EQUIPMENT_ITEM U 17 p_eqp_serial_number in Char EQUIPMENT_SERIAL_NUMBER U 18 p_pn_location_id in Number PROPERTY_LOCATION_CODE U 19 p_fa_asset_id in Number FA_ASSET_NUMBER U 20 p_fa_sync_flag in Char FA_SYNCHRONIZED U 21 p_active_start_date in Date ACTIVE_START_DATE U 22 p_active_end_date in Date ACTIVE_END_DATE U 23 p_parent_instance_id in Number PARENT_ASSET_NUMBER U 24 p_attribute_category in Char ATTRIBUTE_CATEGORY U 25 p_attribute1 in Char ATTRIBUTE1 U 26 p_attribute2 in Char ATTRIBUTE2 U 27 p_attribute3 in Char ATTRIBUTE3 U 28 p_attribute4 in Char ATTRIBUTE4 U 29 p_attribute5 in Char ATTRIBUTE5 U 30 p_attribute6 in Char ATTRIBUTE6 U 31 p_attribute7 in Char ATTRIBUTE7 U 32 p_attribute8 in Char ATTRIBUTE8 U 33 p_attribute9 in Char ATTRIBUTE9 U 34 p_attribute10 in Char ATTRIBUTE10 U 35 p_attribute11 in Char ATTRIBUTE11 U 36 p_attribute12 in Char ATTRIBUTE12 U 37 p_attribute13 in Char ATTRIBUTE13 U 38 p_attribute14 in Char ATTRIBUTE14 U 39 p_attribute15 in Char ATTRIBUTE15 U 40 p_attribute16 in Char ATTRIBUTE16 U 41 p_attribute17 in Char ATTRIBUTE17 U 42 p_attribute18 in Char ATTRIBUTE18 U 43 p_attribute19 in Char ATTRIBUTE19 U 44 p_attribute20 in Char ATTRIBUTE20 U 45 p_attribute21 in Char ATTRIBUTE21 U 46 p_attribute22 in Char ATTRIBUTE22 U 47 p_attribute23 in Char ATTRIBUTE23 U 48 p_attribute24 in Char ATTRIBUTE24 U 49 p_attribute25 in Char ATTRIBUTE25 U 50 p_attribute26 in Char ATTRIBUTE26 U 51 p_attribute27 in Char ATTRIBUTE27 U 52 p_attribute28 in Char ATTRIBUTE28 U 53 p_attribute29 in Char ATTRIBUTE29 U 54 p_attribute30 in Char ATTRIBUTE30 U 55 status_ out Char STATUS_CODE_ U 56 message_ out Char MESSAGE_ Error SQL Order By upload_row, organization, asset_number Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, meanv.inv_organization_code organization, meanv.instance_number asset_number, meanv.maintenance_object_id asset_id, meanv.concatenated_segments asset_group, meanv.serial_number asset_serial_number, meanv.descriptive_text description, meanv.category_name asset_category, meanv.owning_department, meanv.asset_criticality criticality, meanv.wip_accounting_class_code wip_accounting_class, meanv.area, decode(meanv.maintainable_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) maintainable, decode(meanv.network_asset_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) asset_route, decode(meanv.operational_log_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) operation_log, meanv.supplier_warranty_exp_date warranty_expiration, meanv.prod_organization_code production_organization, (select msi.concatenated_segments from mtl_system_items_b_kfv msi where msi.inventory_item_id=meanv.equipment_item_id and msi.organization_id=meanv.prod_organization_id) equipment_item, meanv.eqp_serial_number equipment_serial_number, meanv.pn_location_code property_location_code, meanv.fa_asset_number, decode(meanv.fa_sync_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) fa_synchronized, meanv.active_start_date, meanv.active_end_date, xxen_util.meaning(to_char(meanv.eam_item_type),'MTL_EAM_ASSET_TYPE',700) asset_type, meanv.current_status_meaning asset_status, meanv.current_location current_location_address, meanv.parent_instance_number parent_asset_number, meanv.parent_serial_number parent_asset_serial_number, (select cii.instance_id from csi_item_instances cii where meanv.parent_instance_number=cii.instance_number) parent_asset_id, xxen_util.display_flexfield_context(542,'Item Instance Flex Field',meanv.context) attribute_category, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE1',meanv.row_id,meanv.attribute1) attribute1, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE2',meanv.row_id,meanv.attribute2) attribute2, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE3',meanv.row_id,meanv.attribute3) attribute3, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE4',meanv.row_id,meanv.attribute4) attribute4, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE5',meanv.row_id,meanv.attribute5) attribute5, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE6',meanv.row_id,meanv.attribute6) attribute6, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE7',meanv.row_id,meanv.attribute7) attribute7, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE8',meanv.row_id,meanv.attribute8) attribute8, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE9',meanv.row_id,meanv.attribute9) attribute9, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE10',meanv.row_id,meanv.attribute10) attribute10, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE11',meanv.row_id,meanv.attribute11) attribute11, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE12',meanv.row_id,meanv.attribute12) attribute12, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE13',meanv.row_id,meanv.attribute13) attribute13, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE14',meanv.row_id,meanv.attribute14) attribute14, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE15',meanv.row_id,meanv.attribute15) attribute15, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE16',meanv.row_id,meanv.attribute16) attribute16, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE17',meanv.row_id,meanv.attribute17) attribute17, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE18',meanv.row_id,meanv.attribute18) attribute18, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE19',meanv.row_id,meanv.attribute19) attribute19, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE20',meanv.row_id,meanv.attribute20) attribute20, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE21',meanv.row_id,meanv.attribute21) attribute21, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE22',meanv.row_id,meanv.attribute22) attribute22, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE23',meanv.row_id,meanv.attribute23) attribute23, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE24',meanv.row_id,meanv.attribute24) attribute24, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE25',meanv.row_id,meanv.attribute25) attribute25, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE26',meanv.row_id,meanv.attribute26) attribute26, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE27',meanv.row_id,meanv.attribute27) attribute27, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE28',meanv.row_id,meanv.attribute28) attribute28, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE29',meanv.row_id,meanv.attribute29) attribute29, xxen_util.display_flexfield_value(542,'Item Instance Flex Field',meanv.context,'ATTRIBUTE30',meanv.row_id,meanv.attribute30) attribute30, xu.upload_row from xxen_eam_asset_number_u_5289_u xu, mtl_eam_asset_numbers_all_v meanv, mtl_parameters mp where xu.status_code_=xxen_upload.status_success and mp.organization_code=xu.organization and meanv.current_organization_id=mp.organization_id and meanv.instance_number=xu.asset_number