ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode 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 US 8E2FF36EDEB279D2E0530100007F1FF2 INV Organization Code 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 AR جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente JA すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。 KO 현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual RU Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре. S Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır US All active inventory organization codes excluding master organizations, restricted to the current user's org access view ZHS 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 3D7DD2FF8533436AA472437688E5A144Y select null action_, null status_, null message_, null modified_columns_, mp.organization_code maintenance_organization, msi_act.concatenated_segments activity, xxen_util.meaning(to_char(decode(meaa.maintenance_object_type,2,decode(msi_grp.eam_item_type,1,1,3),3,decode(msi_grp.eam_item_type,1,1,3),nvl(msi_grp.eam_item_type,1))),'MTL_EAM_ITEM_TYPE',700) asset_type, msi_grp.concatenated_segments asset_group, cii.instance_number asset_number, meaa.start_date_active from_date, meaa.end_date_active to_date, xxen_util.meaning(meaa.priority_code,'WIP_EAM_ACTIVITY_PRIORITY',700) priority, xxen_util.meaning(meaa.activity_cause_code,'MTL_EAM_ACTIVITY_CAUSE',700) activity_cause, xxen_util.meaning(meaa.activity_type_code,'MTL_EAM_ACTIVITY_TYPE',700) activity_type, xxen_util.meaning(meaa.shutdown_type_code,'BOM_EAM_SHUTDOWN_TYPE',700) shutdown_type, xxen_util.meaning(meaa.activity_source_code,'MTL_EAM_ACTIVITY_SOURCE',700) activity_source, bd.department_code owning_department, meaa.class_code wip_accounting_class, decode(meaa.tagging_required_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) tagging_required, xxen_util.display_flexfield_context(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category) attribute_category, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE1',meaa.rowid,meaa.attribute1) attribute1, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE2',meaa.rowid,meaa.attribute2) attribute2, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE3',meaa.rowid,meaa.attribute3) attribute3, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE4',meaa.rowid,meaa.attribute4) attribute4, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE5',meaa.rowid,meaa.attribute5) attribute5, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE6',meaa.rowid,meaa.attribute6) attribute6, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE7',meaa.rowid,meaa.attribute7) attribute7, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE8',meaa.rowid,meaa.attribute8) attribute8, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE9',meaa.rowid,meaa.attribute9) attribute9, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE10',meaa.rowid,meaa.attribute10) attribute10, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE11',meaa.rowid,meaa.attribute11) attribute11, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE12',meaa.rowid,meaa.attribute12) attribute12, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE13',meaa.rowid,meaa.attribute13) attribute13, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE14',meaa.rowid,meaa.attribute14) attribute14, xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE15',meaa.rowid,meaa.attribute15) attribute15, meaa.activity_association_id assoc_row_id, to_number(null) upload_row from inv.mtl_eam_asset_activities meaa, mtl_parameters mp, mtl_system_items_b_kfv msi_act, mtl_system_items_b_kfv msi_grp, csi_item_instances cii, bom_departments bd where :p_upload_mode like '%' || xxen_upload.action_update and nvl(meaa.tmpl_flag,'N')='N' and meaa.organization_id=mp.organization_id and meaa.asset_activity_id=msi_act.inventory_item_id and meaa.organization_id=msi_act.organization_id and meaa.inventory_item_id=msi_grp.inventory_item_id(+) and meaa.organization_id=msi_grp.organization_id(+) and decode(meaa.maintenance_object_type,3,meaa.maintenance_object_id,null)=cii.instance_id(+) and meaa.owning_department_id=bd.department_id(+) and 1=1 U A xxen_eam_upload.upload_activity_assoc US EAM Asset Activity Association Upload EAM Asset Activity Association Upload ===================================== - Create new associations between an Activity item and an Asset Group, specific Asset Number (serial instance), or Rebuildable item. - Update existing association attributes (dates, priority, owning department, WIP class, DFF, etc.). - Deletion is not supported by the public API in v1. Prerequisites ============= - The Activity item (eam_item_type=2) must already exist in the maintenance organization. Use the INV Item Upload to create Activity items. - For Asset Group associations, the Asset Group (eam_item_type=1) and its serialised instance (csi_item_instances) must exist. - For Rebuildable (serial) associations, the Rebuildable item (eam_item_type=3) and instance must exist. - For Rebuildable (non-serial) associations, only the Rebuildable item is required. Natural business key for create/update detection: (Asset Activity + Maintenance Object Type + Maintenance Object Id) which maps to (Activity + Asset Group or Asset Number). Enginatics Upload 1=1 :p_upload_mode 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 mp.organization_code=:p_maint_org LOV custom Y select mp.organization_code value, ood.organization_name description from mtl_parameters mp, org_organization_definitions ood where 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 mp.organization_id=ood.organization_id and mp.maint_organization_id=mp.organization_id and nvl(ood.disable_date,sysdate)>=sysdate order by mp.organization_code US Maintenance Organization 3 30 1=1 msi_act.concatenated_segments=:p_activity LOV custom Y select msi.concatenated_segments value, msi.description from mtl_system_items_b_kfv msi, mtl_parameters mp where msi.eam_item_type=2 and msi.organization_id=mp.organization_id and mp.maint_organization_id=mp.organization_id and mp.organization_code=:$flex$.Maintenance_Organization order by msi.concatenated_segments US Activity 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 MAINTENANCE_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 :$flex$.Maintenance_Organization Y 6 ACTIVITY 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.eam_item_type=2 and msi.organization_id=mp.organization_id and mp.maint_organization_id=mp.organization_id and mp.organization_code=:$column$.maintenance_organization order by msi.concatenated_segments :$flex$.Activity Y 7 ASSET_TYPE LOV custom varchar2 Y select ml.lookup_code id, ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='MTL_EAM_ITEM_TYPE' and ml.lookup_code in (1,3) and sysdate between nvl(ml.start_date_active,sysdate) and nvl(ml.end_date_active,sysdate) and nvl(ml.enabled_flag,'N')='Y' order by ml.lookup_code 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$.maintenance_organization and msi.eam_item_type in (1,3) and msi.serial_number_control_code<>1 order by msi.concatenated_segments 9 ASSET_NUMBER LOV custom varchar2 30 Y select cii.instance_id id, cii.instance_number value, msik.concatenated_segments||nvl2(cii.serial_number,' - '||cii.serial_number,null) description from mtl_parameters mp, csi_item_instances cii, mtl_system_items_kfv msik where mp.organization_code=:$column$.maintenance_organization and mp.organization_id=cii.last_vld_organization_id and sysdate between nvl(cii.active_start_date,sysdate) and nvl(cii.active_end_date,sysdate) and cii.last_vld_organization_id=msik.organization_id and cii.inventory_item_id=msik.inventory_item_id and msik.eam_item_type in (1,3) and msik.serial_number_control_code<>1 and (:$column$.asset_group is null or msik.concatenated_segments=:$column$.asset_group) order by cii.instance_number 10 FROM_DATE Date date 11 TO_DATE Date date 12 PRIORITY LOV custom varchar2 Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='WIP_EAM_ACTIVITY_PRIORITY' and sysdate between nvl(ml.start_date_active,sysdate) and nvl(ml.end_date_active,sysdate) and nvl(ml.enabled_flag,'N')='Y' order by ml.meaning 13 ACTIVITY_CAUSE LOV custom varchar2 Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='MTL_EAM_ACTIVITY_CAUSE' and sysdate between nvl(ml.start_date_active,sysdate) and nvl(ml.end_date_active,sysdate) and nvl(ml.enabled_flag,'N')='Y' order by ml.meaning 14 ACTIVITY_TYPE LOV custom varchar2 Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='MTL_EAM_ACTIVITY_TYPE' and sysdate between nvl(ml.start_date_active,sysdate) and nvl(ml.end_date_active,sysdate) and nvl(ml.enabled_flag,'N')='Y' order by ml.meaning 15 SHUTDOWN_TYPE LOV custom varchar2 Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='BOM_EAM_SHUTDOWN_TYPE' and sysdate between nvl(ml.start_date_active,sysdate) and nvl(ml.end_date_active,sysdate) and nvl(ml.enabled_flag,'N')='Y' order by ml.meaning 16 ACTIVITY_SOURCE LOV custom varchar2 Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='MTL_EAM_ACTIVITY_SOURCE' and sysdate between nvl(ml.start_date_active,sysdate) and nvl(ml.end_date_active,sysdate) and nvl(ml.enabled_flag,'N')='Y' order by ml.meaning 17 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$.maintenance_organization and nvl(bd.disable_date,sysdate+1)>sysdate order by bd.department_code 18 WIP_ACCOUNTING_CLASS LOV custom varchar2 10 Y select wac.class_code value, wac.description from mtl_parameters mp, wip_accounting_classes wac where mp.organization_code=:$column$.maintenance_organization and mp.organization_id=wac.organization_id order by wac.class_code 19 TAGGING_REQUIRED LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 20 ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfv.descriptive_flexfield_name='MTL_EAM_ASSET_ACTIVITIES' and fdfv.application_id=401 and fdfv.application_id=fdfcv.application_id and fdfv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 21 ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE1' 22 ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE2' 23 ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE3' 24 ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE4' 25 ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE5' 26 ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE6' 27 ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE7' 28 ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE8' 29 ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE9' 30 ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE10' 31 ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE11' 32 ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE12' 33 ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE13' 34 ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE14' 35 ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 401, p_descriptive_flexfield_name => 'MTL_EAM_ASSET_ACTIVITIES', 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 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=401 and dff.application_table_name='MTL_EAM_ASSET_ACTIVITIES' and dffcu.application_column_name='ATTRIBUTE15' 36 ASSOC_ROW_ID Number number Y Y 37 UPLOAD_ROW Number number Y Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 5 p_assoc_row_id in out Char ASSOC_ROW_ID U 6 p_organization_id in Number Y MAINTENANCE_ORGANIZATION U 7 p_activity_id in Number Y ACTIVITY U 8 p_asset_type in Number Y ASSET_TYPE U 9 p_asset_group_id in Number Y ASSET_GROUP U 10 p_instance_id in Number Y ASSET_NUMBER U 11 p_from_date in Date Y FROM_DATE U 12 p_to_date in Date Y TO_DATE U 13 p_priority in Char Y PRIORITY U 14 p_activity_cause in Char Y ACTIVITY_CAUSE U 15 p_activity_type in Char Y ACTIVITY_TYPE U 16 p_shutdown_type in Char Y SHUTDOWN_TYPE U 17 p_activity_source in Char Y ACTIVITY_SOURCE U 18 p_owning_department_id in Number Y OWNING_DEPARTMENT U 19 p_wip_accounting_class in Char Y WIP_ACCOUNTING_CLASS U 20 p_tagging_required in Char Y TAGGING_REQUIRED U 21 p_attribute_category in Char Y ATTRIBUTE_CATEGORY U 22 p_attribute1 in Char Y ATTRIBUTE1 U 23 p_attribute2 in Char Y ATTRIBUTE2 U 24 p_attribute3 in Char Y ATTRIBUTE3 U 25 p_attribute4 in Char Y ATTRIBUTE4 U 26 p_attribute5 in Char Y ATTRIBUTE5 U 27 p_attribute6 in Char Y ATTRIBUTE6 U 28 p_attribute7 in Char Y ATTRIBUTE7 U 29 p_attribute8 in Char Y ATTRIBUTE8 U 30 p_attribute9 in Char Y ATTRIBUTE9 U 31 p_attribute10 in Char Y ATTRIBUTE10 U 32 p_attribute11 in Char Y ATTRIBUTE11 U 33 p_attribute12 in Char Y ATTRIBUTE12 U 34 p_attribute13 in Char Y ATTRIBUTE13 U 35 p_attribute14 in Char Y ATTRIBUTE14 U 36 p_attribute15 in Char Y ATTRIBUTE15 Error SQL Order By upload_row, maintenance_organization, activity, asset_group, asset_number Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, nvl(mp.organization_code,xu.maintenance_organization) maintenance_organization, nvl(msi_act.concatenated_segments,xu.activity) activity, nvl(xxen_util.meaning(to_char(case when meaa.maintenance_object_type=3 then 1 when meaa.maintenance_object_type=2 then 3 end),'MTL_EAM_ITEM_TYPE',700),xu.asset_type) asset_type, nvl(msi_grp.concatenated_segments,xu.asset_group) asset_group, nvl(cii.instance_number,xu.asset_number) asset_number, nvl(meaa.start_date_active,xu.from_date) from_date, nvl(meaa.end_date_active,xu.to_date) to_date, nvl(xxen_util.meaning(meaa.priority_code,'WIP_EAM_ACTIVITY_PRIORITY',700),xu.priority) priority, nvl(xxen_util.meaning(meaa.activity_cause_code,'MTL_EAM_ACTIVITY_CAUSE',700),xu.activity_cause) activity_cause, nvl(xxen_util.meaning(meaa.activity_type_code,'MTL_EAM_ACTIVITY_TYPE',700),xu.activity_type) activity_type, nvl(xxen_util.meaning(meaa.shutdown_type_code,'BOM_EAM_SHUTDOWN_TYPE',700),xu.shutdown_type) shutdown_type, nvl(xxen_util.meaning(meaa.activity_source_code,'MTL_EAM_ACTIVITY_SOURCE',700),xu.activity_source) activity_source, nvl(bd.department_code,xu.owning_department) owning_department, nvl(meaa.class_code,xu.wip_accounting_class) wip_accounting_class, nvl(decode(meaa.tagging_required_flag,'Y',xxen_util.meaning('Y','YES_NO',0)),xu.tagging_required) tagging_required, nvl(xxen_util.display_flexfield_context(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category),xu.attribute_category) attribute_category, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE1',meaa.rowid,meaa.attribute1),xu.attribute1) attribute1, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE2',meaa.rowid,meaa.attribute2),xu.attribute2) attribute2, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE3',meaa.rowid,meaa.attribute3),xu.attribute3) attribute3, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE4',meaa.rowid,meaa.attribute4),xu.attribute4) attribute4, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE5',meaa.rowid,meaa.attribute5),xu.attribute5) attribute5, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE6',meaa.rowid,meaa.attribute6),xu.attribute6) attribute6, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE7',meaa.rowid,meaa.attribute7),xu.attribute7) attribute7, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE8',meaa.rowid,meaa.attribute8),xu.attribute8) attribute8, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE9',meaa.rowid,meaa.attribute9),xu.attribute9) attribute9, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE10',meaa.rowid,meaa.attribute10),xu.attribute10) attribute10, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE11',meaa.rowid,meaa.attribute11),xu.attribute11) attribute11, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE12',meaa.rowid,meaa.attribute12),xu.attribute12) attribute12, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE13',meaa.rowid,meaa.attribute13),xu.attribute13) attribute13, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE14',meaa.rowid,meaa.attribute14),xu.attribute14) attribute14, nvl(xxen_util.display_flexfield_value(401,'MTL_EAM_ASSET_ACTIVITIES',meaa.attribute_category,'ATTRIBUTE15',meaa.rowid,meaa.attribute15),xu.attribute15) attribute15, meaa.activity_association_id assoc_row_id, xu.upload_row from xxen_eam_asset_activity_1220_u xu, inv.mtl_eam_asset_activities meaa, mtl_parameters mp, mtl_system_items_b_kfv msi_act, mtl_system_items_b_kfv msi_grp, csi_item_instances cii, bom_departments bd where xu.status_code_=xxen_upload.status_success and to_number(xu.assoc_row_id)=meaa.activity_association_id(+) and meaa.organization_id=mp.organization_id(+) and meaa.asset_activity_id=msi_act.inventory_item_id(+) and meaa.organization_id=msi_act.organization_id(+) and meaa.inventory_item_id=msi_grp.inventory_item_id(+) and meaa.organization_id=msi_grp.organization_id(+) and decode(meaa.maintenance_object_type,3,meaa.maintenance_object_id,null)=cii.instance_id(+) and meaa.owning_department_id=bd.department_id(+)