ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E2A19CB638D65A0BE0530100007F4966Y select null action_, null status_, null message_, null request_id_, null modified_columns_, to_char(null) mode_, fltv.lookup_type, fav1.application_name view_application, fltv.meaning type_meaning, fltv.description type_description, fav2.application_name owning_application, flvv.lookup_code, flvv.meaning, flvv.description, flvv.tag, xxen_util.meaning(flvv.enabled_flag,'YES_NO',0) enabled_flag, flvv.start_date_active, flvv.end_date_active, xxen_util.display_flexfield_context(0,'FND_COMMON_LOOKUPS',flvv.attribute_category) lookup_attribute_category, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE1',flvv.row_id,flvv.attribute1) fnd_lkp_attribute1, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE2',flvv.row_id,flvv.attribute2) fnd_lkp_attribute2, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE3',flvv.row_id,flvv.attribute3) fnd_lkp_attribute3, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE4',flvv.row_id,flvv.attribute4) fnd_lkp_attribute4, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE5',flvv.row_id,flvv.attribute5) fnd_lkp_attribute5, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE6',flvv.row_id,flvv.attribute6) fnd_lkp_attribute6, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE7',flvv.row_id,flvv.attribute7) fnd_lkp_attribute7, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE8',flvv.row_id,flvv.attribute8) fnd_lkp_attribute8, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE9',flvv.row_id,flvv.attribute9) fnd_lkp_attribute9, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE10',flvv.row_id,flvv.attribute10) fnd_lkp_attribute10, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE11',flvv.row_id,flvv.attribute11) fnd_lkp_attribute11, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE12',flvv.row_id,flvv.attribute12) fnd_lkp_attribute12, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE13',flvv.row_id,flvv.attribute13) fnd_lkp_attribute13, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE14',flvv.row_id,flvv.attribute14) fnd_lkp_attribute14, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE15',flvv.row_id,flvv.attribute15) fnd_lkp_attribute15, flvv.territory_code, fav1.application_short_name||':'||fltv.lookup_type old_lookup_type_key, flvv.lookup_code old_lookup_code, null upload_row from fnd_lookup_types_vl fltv, fnd_lookup_values_vl flvv, fnd_application_vl fav1, fnd_application_vl fav2 where :p_mode in (xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update),xxen_upload.action_meaning(xxen_upload.action_update)) and fav1.application_name=:p_view_appl and 1=1 and fltv.view_application_id=fav1.application_id and fltv.application_id=fav2.application_id and fltv.customization_level in ('U','E') and fltv.security_group_id=fnd_global.security_group_id and fltv.lookup_type=flvv.lookup_type and fltv.view_application_id=flvv.view_application_id and fltv.security_group_id=flvv.security_group_id U :Mode = 'Create' or ((:Lookup_Type is not null or :Lookup_Type_Like is not null) and :View_Application is not null and :Mode is not null ) A xxen_fnd_upload.fnd_lookup_type_loader F FND Lookup Upload Cette importation permet à l'utilisateur de - télécharger et mettre à jour les codes de consultation pour les types de consultation existants - d'ajouter de nouveaux codes de consultation aux types de consultation existants. - de créer de nouveaux types de consultation et de télécharger les codes de consultation correspondant à ces nouveaux types de consultation. Le téléchargement des types de consultation et des codes de consultation de la FND s'effectue dans la langue courante de l'utilisateur. Seuls les types de consultation utilisateur et extensible peuvent être gérés par ce téléchargement. Pour les types de consultation extensibles, les codes de consultation semés ne peuvent pas être mis à jour. Pour créer/mettre à jour des codes de consultation uniquement par rapport à un type de consultation existant, utilisez le modèle : Codes de consultation - Création/mise à jour des codes de consultation uniquement Pour créer de nouveaux types de recherche et/ou mettre à jour les informations relatives au niveau du type de recherche, ainsi que les codes de recherche, utilisez le modèle : Types de consultation - Création/mise à jour des types et des codes de consultation Mode and Lookup Type selection criteria must be specified in 'Create and Update and 'Update' Mode US FND Lookup Upload This upload allows the user to - download and update lookup codes against existing Lookup Types. - add new lookup codes to existing Lookup Types. - create new Lookup Types and upload the lookup codes against these new Lookup Types. The upload of FND Lookup Types and Lookup Codes is in the users current language. Only User and Extensible Lookup Types can be maintained by this upload. For Extensible Lookup Types, seeded Lookup Codes canot be updated. For Creating/Updating Lookup Codes only against an existing Lookup Type, use template: Lookup Codes - Create/Update Lookup Codes only For Creating New Lookup Types and/or updating Lookup Type level information, as well as the Lookup Codes, use template: Lookup Types - Create/Update Lookup Types and Codes Mode and Lookup Type selection criteria must be specified in 'Create and Update and 'Update' Mode Enginatics Upload 1=1 :p_mode :p_view_appl 1 10 :p_mode LOV custom Y select x.value, x.description from ( select xxen_upload.action_meaning(xxen_upload.action_create) value, 'Create new Lookup Types and Lookup Codes' description from dual union select xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, 'Download and Update existing Lookup Types and Lookup Codes and/or Create New Lookup Types and Lookup Codes' description from dual union select xxen_upload.action_meaning(xxen_upload.action_update) value, 'Download and Update Lookup Codes against existing Lookup Types only' description from dual ) x order by x.value xxen_upload.action_meaning(xxen_upload.action_update) Y US Mode 2 15 :p_view_appl LOV custom Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav where fav.application_id in (select distinct fltv.view_application_id from fnd_lookup_types_vl fltv where fltv.security_group_id = fnd_global.security_group_id and fltv.customization_level in ('U','E') ) order by value Y US View Application 3 20 1=1 fltv.lookup_type=:p_lookup_type LOV custom Y select fltv.lookup_type value, fav.application_name||': '||nvl(fltv.description,fltv.meaning) description from fnd_application_vl fav, fnd_lookup_types_vl fltv where fav.application_id=fltv.view_application_id and fltv.security_group_id = fnd_global.security_group_id and fltv.customization_level in ('U','E') and fav.application_name = :$flex$.View_Application order by fltv.lookup_type US Lookup Type 4 30 1=1 lower(fltv.lookup_type) like '%' || lower(:p_lookup_type_like) || '%' Char US Lookup Type Like 5 50 1=1 fav2.application_name=:p_owning_appl LOV custom Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav where fav.application_id in (select distinct fltv.application_id from fnd_lookup_types_vl fltv where fltv.security_group_id = fnd_global.security_group_id and fltv.customization_level in ('U','E') and ( (:$flex$.Lookup_type is null and :$flex$.Lookup_Type_Like is null) or (:$flex$.Lookup_type is not null and xxen_util.contains(:$flex$.Lookup_type,fltv.lookup_type) = 'Y') or (:$flex$.Lookup_Type_Like is not null and lower(fltv.lookup_type) like '%' || lower(:$flex$.Lookup_Type_Like) || '%') ) ) order by value US Owning Application ACB54C38069521A1CA717519A25779EE Lookup Codes - Create/Update Lookup Codes only Create/Update Lookup Codes only ENGINATICS -9.001 ATTRIBUTE1 -9.0019 ATTRIBUTE10 -9.002 ATTRIBUTE11 -9.0021 ATTRIBUTE12 -9.0022 ATTRIBUTE13 -9.0023 ATTRIBUTE14 -9.0024 ATTRIBUTE15 -9.0011 ATTRIBUTE2 -9.0012 ATTRIBUTE3 -9.0013 ATTRIBUTE4 -9.0014 ATTRIBUTE5 -9.0015 ATTRIBUTE6 -9.0016 ATTRIBUTE7 -9.0017 ATTRIBUTE8 -9.0018 ATTRIBUTE9 5 DESCRIPTION 7 ENABLED_FLAG 9 END_DATE_ACTIVE 11 FND_LKP_ATTRIBUTE1 20 FND_LKP_ATTRIBUTE10 21 FND_LKP_ATTRIBUTE11 22 FND_LKP_ATTRIBUTE12 23 FND_LKP_ATTRIBUTE13 24 FND_LKP_ATTRIBUTE14 25 FND_LKP_ATTRIBUTE15 12 FND_LKP_ATTRIBUTE2 13 FND_LKP_ATTRIBUTE3 14 FND_LKP_ATTRIBUTE4 15 FND_LKP_ATTRIBUTE5 16 FND_LKP_ATTRIBUTE6 17 FND_LKP_ATTRIBUTE7 18 FND_LKP_ATTRIBUTE8 19 FND_LKP_ATTRIBUTE9 10 LOOKUP_ATTRIBUTE_CATEGORY 3 LOOKUP_CODE 1 LOOKUP_TYPE 4 MEANING 8 START_DATE_ACTIVE 6 TAG 2 VIEW_APPLICATION S Site F3958899AE61659A8E8F7097555B2F74 Lookup Types - Create/Update Lookup Types and Codes Create New Lookup Types ENGINATICS -12.0013 ATTRIBUTE1 -12.0022 ATTRIBUTE10 -12.0023 ATTRIBUTE11 -12.0024 ATTRIBUTE12 -12.0025 ATTRIBUTE13 -12.0026 ATTRIBUTE14 -12.0027 ATTRIBUTE15 -12.0014 ATTRIBUTE2 -12.0015 ATTRIBUTE3 -12.0016 ATTRIBUTE4 -12.0017 ATTRIBUTE5 -12.0018 ATTRIBUTE6 -12.0019 ATTRIBUTE7 -12.002 ATTRIBUTE8 -12.0021 ATTRIBUTE9 8 DESCRIPTION 10 ENABLED_FLAG 12 END_DATE_ACTIVE 14 FND_LKP_ATTRIBUTE1 23 FND_LKP_ATTRIBUTE10 24 FND_LKP_ATTRIBUTE11 25 FND_LKP_ATTRIBUTE12 26 FND_LKP_ATTRIBUTE13 27 FND_LKP_ATTRIBUTE14 28 FND_LKP_ATTRIBUTE15 15 FND_LKP_ATTRIBUTE2 16 FND_LKP_ATTRIBUTE3 17 FND_LKP_ATTRIBUTE4 18 FND_LKP_ATTRIBUTE5 19 FND_LKP_ATTRIBUTE6 20 FND_LKP_ATTRIBUTE7 21 FND_LKP_ATTRIBUTE8 22 FND_LKP_ATTRIBUTE9 13 LOOKUP_ATTRIBUTE_CATEGORY 6 LOOKUP_CODE 1 LOOKUP_TYPE 7 MEANING 5 OWNING_APPLICATION 11 START_DATE_ACTIVE 9 TAG 4 TYPE_DESCRIPTION 3 TYPE_MEANING 2 VIEW_APPLICATION Mode Create, Update S Site SYSADMIN F3958899AE61659A8E8F7097555B2F74 ENGINATICS F3958899AE61659A8E8F7097555B2F74 ACB54C38069521A1CA717519A25779EE 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 MODE_ Char varchar2 nvl(:$flex$.mode,xxen_upload.action_meaning(xxen_upload.action_update)) Y 7 LOOKUP_TYPE LOV custom varchar2 30 select fltv.lookup_type value, fltv.lookup_type description from fnd_application_vl fav, fnd_lookup_types_vl fltv where fav.application_id=fltv.view_application_id and fltv.security_group_id = fnd_global.security_group_id and fltv.customization_level in ('U','E') and fav.application_name = :$flex$.view_application and ( (:$flex$.lookup_type is not null and xxen_util.contains(:$flex$.lookup_type,fltv.lookup_type) = 'Y') or (:$flex$.lookup_type_Like is not null and lower(fltv.lookup_type) like '%' || lower(:$flex$.lookup_type_Like) || '%') ) order by value Y Y 8 VIEW_APPLICATION LOV custom varchar2 240 Y Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav where fav.application_name = :$flex$.view_application order by value :$flex$.view_application Y 9 TYPE_MEANING LOV custom varchar2 80 select fltv.meaning value, fltv.lookup_type description from fnd_application_vl fav, fnd_lookup_types_vl fltv where fav.application_id=fltv.view_application_id and fltv.security_group_id = fnd_global.security_group_id and fltv.customization_level in ('U','E') and fav.application_name = :$flex$.view_application and fltv.lookup_type = :$column$.lookup_type order by value 10 TYPE_DESCRIPTION LOV custom varchar2 240 select fltv.description value, fltv.lookup_type description from fnd_application_vl fav, fnd_lookup_types_vl fltv where fav.application_id=fltv.view_application_id and fltv.security_group_id = fnd_global.security_group_id and fltv.customization_level in ('U','E') and fav.application_name = :$flex$.view_application and fltv.lookup_type = :$column$.lookup_type order by value 11 OWNING_APPLICATION LOV custom varchar2 240 Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav where fav.application_id = ( select fltv.application_id from fnd_application_vl fav, fnd_lookup_types_vl fltv where fav.application_id = fltv.view_application_id and fltv.security_group_id = fnd_global.security_group_id and fltv.customization_level in ('U','E') and fav.application_name = :$flex$.view_application and fltv.lookup_type = :$column$.lookup_type ) or not exists ( select null from fnd_application_vl fav, fnd_lookup_types_vl fltv where fav.application_id = fltv.view_application_id and fltv.security_group_id = fnd_global.security_group_id and fltv.customization_level in ('U','E') and fav.application_name = :$flex$.view_application and fltv.lookup_type = :$column$.lookup_type ) order by value Y 12 LOOKUP_CODE Char varchar2 30 Y Y 13 MEANING Char varchar2 80 Y 14 DESCRIPTION Char varchar2 240 15 TAG Char varchar2 150 16 ENABLED_FLAG LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description xxen_util.meaning('Y','YES_NO',0) 17 START_DATE_ACTIVE Date date trunc(sysdate) 18 END_DATE_ACTIVE Date date 19 LOOKUP_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 fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name select distinct fdfcv.descriptive_flex_context_name from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' and fdfcv.descriptive_flex_context_code = :$column$.lookup_type 20 FND_LKP_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 => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 21 FND_LKP_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 => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 22 FND_LKP_ATTRIBUTE3 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 23 FND_LKP_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 => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 24 FND_LKP_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 => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 25 FND_LKP_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 => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 26 FND_LKP_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 => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 27 FND_LKP_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 => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 28 FND_LKP_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 => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 29 FND_LKP_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 => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 30 FND_LKP_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 => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 31 FND_LKP_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 => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 32 FND_LKP_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 => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 33 FND_LKP_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 => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 34 FND_LKP_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 => 0, p_descriptive_flexfield_name => 'FND_COMMON_LOOKUPS', p_context_name => :$column$.lookup_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.fnd_lkp_attribute1, p_attribute2 => :$column$.fnd_lkp_attribute2, p_attribute3 => :$column$.fnd_lkp_attribute3, p_attribute4 => :$column$.fnd_lkp_attribute4, p_attribute5 => :$column$.fnd_lkp_attribute5, p_attribute6 => :$column$.fnd_lkp_attribute6, p_attribute7 => :$column$.fnd_lkp_attribute7, p_attribute8 => :$column$.fnd_lkp_attribute8, p_attribute9 => :$column$.fnd_lkp_attribute9, p_attribute10 => :$column$.fnd_lkp_attribute10, p_attribute11 => :$column$.fnd_lkp_attribute11, p_attribute12 => :$column$.fnd_lkp_attribute12, p_attribute13 => :$column$.fnd_lkp_attribute13, p_attribute14 => :$column$.fnd_lkp_attribute14, p_attribute15 => :$column$.fnd_lkp_attribute15 ) ) 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 = 0 and fdfv.descriptive_flexfield_name = 'FND_COMMON_LOOKUPS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 35 TERRITORY_CODE Char varchar2 2 Y Y 36 OLD_LOOKUP_TYPE_KEY Char varchar2 81 Y Y 37 OLD_LOOKUP_CODE Char varchar2 30 Y Y 38 UPLOAD_ROW Char varchar2 U 1 action_ in Char ACTION_CODE_ U 2 p_mode in Char Y MODE_ U 3 p_validate_dff in Char Y U 4 p_view_appl in Char VIEW_APPLICATION U 5 p_lookup_type in Char LOOKUP_TYPE U 6 p_type_meaning in Char TYPE_MEANING U 7 p_type_description in Char TYPE_DESCRIPTION U 8 p_type_appl in Char OWNING_APPLICATION U 9 p_lookup_code in Char LOOKUP_CODE U 10 p_meaning in Char MEANING U 11 p_description in Char DESCRIPTION U 12 p_tag in Char TAG U 13 p_enabled_flag in Char ENABLED_FLAG value U 14 p_start_date_active in Date START_DATE_ACTIVE U 15 p_end_date_active in Date Y END_DATE_ACTIVE U 16 p_attribute_category in Char Y LOOKUP_ATTRIBUTE_CATEGORY U 17 p_attribute1 in Char Y FND_LKP_ATTRIBUTE1 U 18 p_attribute2 in Char Y FND_LKP_ATTRIBUTE2 U 19 p_attribute3 in Char Y FND_LKP_ATTRIBUTE3 U 20 p_attribute4 in Char Y FND_LKP_ATTRIBUTE4 U 21 p_attribute5 in Char Y FND_LKP_ATTRIBUTE5 U 22 p_attribute6 in Char Y FND_LKP_ATTRIBUTE6 U 23 p_attribute7 in Char Y FND_LKP_ATTRIBUTE7 U 24 p_attribute8 in Char Y FND_LKP_ATTRIBUTE8 U 25 p_attribute9 in Char Y FND_LKP_ATTRIBUTE9 U 26 p_attribute10 in Char Y FND_LKP_ATTRIBUTE10 U 27 p_attribute11 in Char Y FND_LKP_ATTRIBUTE11 U 28 p_attribute12 in Char Y FND_LKP_ATTRIBUTE12 U 29 p_attribute13 in Char Y FND_LKP_ATTRIBUTE13 U 30 p_attribute14 in Char Y FND_LKP_ATTRIBUTE14 U 31 p_attribute15 in Char Y FND_LKP_ATTRIBUTE15 U 32 p_territory_code in Char Y TERRITORY_CODE U 33 p_old_lookup_type_key in Char Y OLD_LOOKUP_TYPE_KEY U 34 p_old_lookup_code in Char Y OLD_LOOKUP_CODE U 35 request_id_ out Number REQUEST_ID_ U 36 status_ out Char STATUS_CODE_ U 37 message_ out Char MESSAGE_ Error SQL Order By upload_row, lookup_type, lookup_code Success SQL select xu.action_, xu.status_, xu.message_, xu.request_id_, xu.modified_columns_, to_char(null) mode_, fltv.lookup_type, fav1.application_name view_application, fltv.meaning type_meaning, fltv.description type_description, fav2.application_name owning_application, flvv.lookup_code, flvv.meaning, flvv.description, flvv.tag, xxen_util.meaning(flvv.enabled_flag,'YES_NO',0) enabled_flag, flvv.start_date_active, flvv.end_date_active, xxen_util.display_flexfield_context(0,'FND_COMMON_LOOKUPS',flvv.attribute_category) lookup_attribute_category, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE1',flvv.row_id,flvv.attribute1) fnd_lkp_attribute1, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE2',flvv.row_id,flvv.attribute2) fnd_lkp_attribute2, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE3',flvv.row_id,flvv.attribute3) fnd_lkp_attribute3, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE4',flvv.row_id,flvv.attribute4) fnd_lkp_attribute4, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE5',flvv.row_id,flvv.attribute5) fnd_lkp_attribute5, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE6',flvv.row_id,flvv.attribute6) fnd_lkp_attribute6, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE7',flvv.row_id,flvv.attribute7) fnd_lkp_attribute7, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE8',flvv.row_id,flvv.attribute8) fnd_lkp_attribute8, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE9',flvv.row_id,flvv.attribute9) fnd_lkp_attribute9, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE10',flvv.row_id,flvv.attribute10) fnd_lkp_attribute10, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE11',flvv.row_id,flvv.attribute11) fnd_lkp_attribute11, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE12',flvv.row_id,flvv.attribute12) fnd_lkp_attribute12, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE13',flvv.row_id,flvv.attribute13) fnd_lkp_attribute13, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE14',flvv.row_id,flvv.attribute14) fnd_lkp_attribute14, xxen_util.display_flexfield_value(0,'FND_COMMON_LOOKUPS',flvv.attribute_category,'ATTRIBUTE15',flvv.row_id,flvv.attribute15) fnd_lkp_attribute15, flvv.territory_code, fav1.application_short_name||':'||fltv.lookup_type old_lookup_type_key, flvv.lookup_code old_lookup_code, xu.upload_row from xxen_fnd_lookup_upload_0965_u xu, fnd_lookup_values_vl flvv, fnd_lookup_types_vl fltv, fnd_application_vl fav1, fnd_application_vl fav2 where xu.status_code_='S' and upper(xu.lookup_type)=flvv.lookup_type and nvl(xu.view_application,:p_view_appl)=fav1.application_name and upper(xu.lookup_code)=flvv.lookup_code and flvv.security_group_id=fnd_global.security_group_id and flvv.lookup_type=fltv.lookup_type and flvv.view_application_id=fltv.view_application_id and flvv.security_group_id=fltv.security_group_id and flvv.view_application_id=fav1.application_id and fltv.application_id=fav2.application_id