ENGINATICS
SYSTEM_ADMINISTRATOR
SYSADMIN
B52C6BB09E788499E0530100007F4F38
FND Flex Hierarchy
Y
select distinct
ffvnh.parent_flex_value value,
(select ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end from fnd_flex_values_vl ffvv where ffvnh.flex_value_set_id=ffvv.flex_value_set_id and ffvv.parent_flex_value_low is null and ffvnh.parent_flex_value=ffvv.flex_value)||' ('||nvl2(ffvnh.is_child,null,xxen_util.meaning('TOP','TOP_BOTTOM_PERF',283)||' ')||xxen_util.meaning('CCONTAIN','ICX_CONDITIONS',0)||' '||xxen_util.meaning(ffvnh.max_range_attribute,'RANGE_ATTRIBUTE',0)||')' description,
ffvnh.is_child,
ffvnh.max_range_attribute
from
(
select distinct
ffvnh.flex_value_set_id,
ffvnh.parent_flex_value,
(select 'Y' from gl_seg_val_norm_hierarchy gsvnh where ffvnh.parent_flex_value=gsvnh.child_flex_value and ffvnh.flex_value_set_id=gsvnh.flex_value_set_id and rownum=1) is_child,
max(ffvnh.range_attribute) over (partition by ffvnh.parent_flex_value) max_range_attribute
from
fnd_flex_value_norm_hierarchy ffvnh
where
ffvnh.flex_value_set_id in
(
select ffvs.flex_value_set_id from fnd_flex_value_sets ffvs where ffvs.flex_value_set_name=:$flex$.flex_value_set
union all
select
fifsv.flex_value_set_id
from
fnd_id_flex_segments_vl fifsv
where
fifsv.form_left_prompt=:$flex$.hierarchy_segment and
fifsv.application_id=101 and
fifsv.id_flex_code='GL#' and
fifsv.enabled_flag='Y' and
fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101) or xxen_util.contains(:$flex$.ledger,gl.name)='Y')
)
) ffvnh
order by
ffvnh.is_child desc,
ffvnh.max_range_attribute desc,
length(ffvnh.parent_flex_value),
ffvnh.parent_flex_value
US
8E2FF36EDF1979D2E0530100007F1FF2
FND Key Flexfield
Y
select
fif.id_flex_name value,
fav.application_name||': '||fif.application_table_name||' ('||fif.id_flex_code||')' description
from
fnd_application_vl fav,
fnd_id_flexs fif
where
fav.application_id=fif.application_id
order by
fif.id_flex_name
US
A3AB189B606C4736E0530100007FD533
FND Key Flexfield Structure
Y
select
fifsv.id_flex_structure_name value,
fifsv.id_flex_structure_code||': '||fifsv.description description
from
fnd_id_flexs fif,
fnd_id_flex_structures_vl fifsv
where
(fifsv.id_flex_code=:$flex$.fnd_key_flexfield_code or fif.id_flex_name=:$flex$.fnd_key_flexfield) and
fif.application_id=fifsv.application_id and
fif.id_flex_code=fifsv.id_flex_code
order by
fifsv.id_flex_structure_name
US
8E2FF36EDE8479D2E0530100007F1FF2
FND User Name
Y
Y
select
fu.user_name value,
trim(coalesce(
trim(papf.first_name||' '||papf.last_name),
fu.description,
fu.email_address,
papf.email_address
)||fu.inactive) description
from
(select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu,
(select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf,
(
select distinct
furg.user_id,
count(*) over (partition by furg.user_id) resp_count,
max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key
from
fnd_responsibility fr,
fnd_user_resp_groups_direct furg
where
fr.responsibility_id=furg.responsibility_id and
fr.application_id=furg.responsibility_application_id
) furg
where
fu.employee_id=papf.person_id(+) and
fu.user_id=furg.user_id(+) and
not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE')
order by
fu.inactive desc,
fu.user_name
US
FND user names, excluding iRecruitment candidates.
8E2FF36EDEA679D2E0530100007F1FF2
Yes
Y
select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual
US
73DFA150D9911E17E0535754720AA8A9
select
ffvs.flex_value_set_name,
xxen_util.meaning(ffvs.validation_type,'SEG_VAL_TYPES',0) validation_type,
ffvs0.flex_value_set_name parent_flex_value_set,
ffv.parent_flex_value_low independent_value,
ffv.flex_value,
ffvt.flex_value_meaning translated_value,
ffvt.description,
xxen_util.yes(ffv.enabled_flag) enabled,
ffv.start_date_active,
ffv.end_date_active,
xxen_util.yes(ffv.summary_flag) parent,
ffvnh.child_flex_value_low||nvl2(ffvnh.child_flex_value_low,'-',null)||ffvnh.child_flex_value_high child_range,
xxen_util.meaning(ffvnh.range_attribute,'RANGE_ATTRIBUTE',0) range_attribute,
ffhv.hierarchy_name rollup_group,
ffv.hierarchy_level,
(select distinct listagg(ffvnh.parent_flex_value,', ') within group (order by ffvnh.parent_flex_value) over () from fnd_flex_value_norm_hierarchy ffvnh where 2=2 and ffv.summary_flag=decode(ffvnh.range_attribute,'P','Y','N') and ffv.flex_value between ffvnh.child_flex_value_low and ffvnh.child_flex_value_high and ffvs.flex_value_set_id=ffvnh.flex_value_set_id) parent_values,
&value_attributes
ffv.compiled_value_attributes,
&dff_columns
xxen_util.user_name(ffv.created_by) created_by,
xxen_util.client_time(ffv.creation_date) creation_date,
xxen_util.user_name(ffv.last_updated_by) last_updated_by,
xxen_util.client_time(ffv.last_update_date) last_update_date,
ffv.flex_value_set_id
from
fnd_flex_value_sets ffvs,
fnd_flex_value_sets ffvs0,
fnd_flex_values ffv,
fnd_flex_values_tl ffvt,
fnd_flex_hierarchies_vl ffhv,
fnd_flex_value_norm_hierarchy ffvnh
where
1=1 and
ffvs.parent_flex_value_set_id=ffvs0.flex_value_set_id(+) and
ffvs.flex_value_set_id=ffv.flex_value_set_id and
ffv.flex_value_id=ffvt.flex_value_id and
ffvt.language=userenv('lang') and
ffv.structured_hierarchy_level=ffhv.hierarchy_id(+) and
ffv.flex_value_set_id=ffvnh.flex_value_set_id(+) and
ffv.flex_value=ffvnh.parent_flex_value(+)
order by
ffvs.flex_value_set_name,
ffv.parent_flex_value_low,
ffv.flex_value,
ffvnh.child_flex_value_low
Y
AR
FND Flex Values
تقرير لجميع القيم المرنة والتسلسلات الهرمية التي تم تضمينها فيها.
يمكن استخدام العمود "موضع التدرج الهرمي" للتحقق من صحة إعداد التدرج الهرمي لحسابك والتحقق من قيم شريحة الحساب التي لم يتم تضمينها في أي (أو تسلسل هرمي محدد) حتى الآن.
D
FND Flex Values
Bericht für alle Flex-Werte und die Hierarchien, in denen sie enthalten sind.
Die Spalte "Hierarchieposition" kann verwendet werden, um die Einrichtung der Kontenhierarchie zu überprüfen und festzustellen, welche Kontensegmentwerte noch in keiner (oder einer bestimmten) Hierarchie enthalten sind.
E
FND Flex Values
Informe de todos los valores flexibles y las jerarquías en las que están incluidos.
La columna "Posición de la jerarquía" puede utilizarse para validar la configuración de la jerarquía de cuentas y comprobar qué valores de segmentos de cuentas no están incluidos todavía en ninguna jerarquía (o en una específica).
F
FND Flex Values
Faites un rapport pour toutes les valeurs flex et les hiérarchies dans lesquelles elles sont incluses.
La colonne "Position hiérarchique" peut être utilisée pour valider votre configuration de hiérarchie de compte et vérifier quelles valeurs de segment de compte ne sont pas encore incluses dans une hiérarchie (ou une hiérarchie spécifique).
I
FND Flex Values
Report per tutti i valori flex e le gerarchie in cui sono inclusi.
La colonna 'Hierarchy Position' può essere usata per convalidare la configurazione della gerarchia dei conti e controllare quali valori dei segmenti di conto non sono ancora inclusi in nessuna (o in una specifica) gerarchia.
JA
FND Flex Values
すべてのフレックス値とその値が含まれている階層をレポートします。
Hierarchy Position」列は、アカウントの階層設定を検証したり、どのアカウントセグメント値がまだどの階層（または特定の階層）にも含まれていないかをチェックしたりするのに使用できます。
KO
FND Flex Values
모든 플렉스 값과 해당 값이 포함 된 계층에 대해보고합니다.
'계층 위치'열을 사용하여 계정 계층 설정을 확인하고 아직 어떤 (또는 특정) 계층 구조에 포함되지 않은 계정 세그먼트 값을 확인할 수 있습니다.
PTB
FND Flex Values
Relatório para todos os valores flexíveis e as hierarquias em que eles estão incluídos.
A coluna "Posição hierárquica" pode ser usada para validar a configuração da hierarquia de sua conta e verificar quais valores de segmento de conta ainda não estão incluídos em nenhuma (ou em uma hierarquia específica).
RU
FND Flex Values
Сообщите обо всех значениях гибкости и иерархии, в которую они включены.
Колонка "Позиция иерархии" может быть использована для проверки настройки иерархии счетов и проверки того, какие значения сегментов счетов еще не включены в какую-либо (или определенную) иерархию.
S
FND Flex Values
Rapportera för alla flexvärden och de hierarkier de ingår i.
Kolumn 'Hierarkiposition' kan användas för att validera din kontohierarkiinställning och kontrollera vilka kontosegmentvärden som ännu inte ingår i någon (eller en specifik) hierarki.
TR
FND Flex Values
Tüm esnek değerleri ve dahil oldukları hiyerarşiler için rapor.
'Hiyerarşi Konumu' sütunu, hesap hiyerarşi kurulumunuzu doğrulamak ve hangi hesap segmenti değerlerinin henüz herhangi bir (veya belirli) hiyerarşiye dahil edilmediğini kontrol etmek için kullanılabilir.
US
FND Flex Values
Report for all flex values and the hierarchies they are included in.
Column 'Hierarchy Position' can be used to validate your account hierarchy setup and check which account segment values are not included in any (or a specific) hierarchy yet.
In EBS R12.2., there is new flexfield value security in place, which would require the UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE role to maintain flexfield values.
If you do not have this role but apps DB access, you can add it from the backend:
begin
wf_local_synch.propagateuserrole(
p_user_name=>'ANDY.HAACK',
p_role_name=>'UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE'
);
commit;
end;
ZHS
FND Flex Values
报告所有弹性值及其所包含的层次结构。
层次结构位置 "列可以用来验证你的账户层次结构设置，并检查哪些账户段的值还没有包含在任何（或特定）层次结构中。
Enginatics
&dff_columns
&value_attributes
1=1
2=2
1
10
1=1
ffv.flex_value_set_id in
(
select
fifsgv.flex_value_set_id
from
fnd_id_flexs fif,
fnd_id_flex_segments_vl fifsgv
where
fif.id_flex_name=:id_flex_name and
fif.application_id=fifsgv.application_id and
fif.id_flex_code=fifsgv.id_flex_code
)
LOV
FND Key Flexfield
8E2FF36EDF1979D2E0530100007F1FF2
Y
select
fif.id_flex_name value,
fav.application_name||': '||fif.application_table_name||' ('||fif.id_flex_code||')' description
from
fnd_application_vl fav,
fnd_id_flexs fif
where
fav.application_id=fif.application_id
order by
fif.id_flex_name
F
Utilisé par Key Flexfield
US
Used by Key Flexfield
2
20
1=1
ffv.flex_value_set_id in
(
select
fifsgv.flex_value_set_id
from
fnd_id_flex_structures_vl fifsv,
fnd_id_flex_segments_vl fifsgv
where
fifsv.id_flex_structure_name=:id_flex_structure_name and
fifsv.application_id=fifsgv.application_id and
fifsv.id_flex_code=fifsgv.id_flex_code and
fifsv.id_flex_num=fifsgv.id_flex_num
)
LOV
FND Key Flexfield Structure
A3AB189B606C4736E0530100007FD533
Y
select
fifsv.id_flex_structure_name value,
fifsv.id_flex_structure_code||': '||fifsv.description description
from
fnd_id_flexs fif,
fnd_id_flex_structures_vl fifsv
where
(fifsv.id_flex_code=:$flex$.fnd_key_flexfield_code or fif.id_flex_name=:$flex$.fnd_key_flexfield) and
fif.application_id=fifsv.application_id and
fif.id_flex_code=fifsv.id_flex_code
order by
fifsv.id_flex_structure_name
F
Utilisé par Key Flex Structure
US
Used by Key Flex Structure
3
30
1=1
ffvs.flex_value_set_name=:flex_value_set_name
LOV custom
Y
select
ffvs.flex_value_set_name value,
ffvs.description
from
fnd_flex_value_sets ffvs,
fnd_flex_validation_tables ffvt
where
(
:$flex$.fnd_key_flexfield is null or
ffvs.flex_value_set_id in
(
select
fifsgv.flex_value_set_id
from
fnd_id_flexs fif,
fnd_id_flex_segments_vl fifsgv
where
fif.id_flex_name=:$flex$.fnd_key_flexfield and
fif.application_id=fifsgv.application_id and
fif.id_flex_code=fifsgv.id_flex_code
)
) and
(
:$flex$.fnd_key_flexfield_structure is null or
ffvs.flex_value_set_id in
(
select
fifsgv.flex_value_set_id
from
fnd_id_flex_structures_vl fifsv,
fnd_id_flex_segments_vl fifsgv
where
fifsv.id_flex_structure_name=:$flex$.fnd_key_flexfield_structure and
fifsv.application_id=fifsgv.application_id and
fifsv.id_flex_code=fifsgv.id_flex_code and
fifsv.id_flex_num=fifsgv.id_flex_num
)
) and
(ffvs.validation_type in ('D','I','X','Y') or ffvs.validation_type='F' and ffvt.summary_allowed_flag='Y') and
ffvs.flex_value_set_id in (select ffv.flex_value_set_id from fnd_flex_values ffv) and
ffvs.flex_value_set_id=ffvt.flex_value_set_id(+)
order by
ffvs.flex_value_set_name
F
Ensemble de valeurs Flex
US
Flex Value Set
4
&value_attributes
select
'xxen_util.meaning(substr(ffv.compiled_value_attributes,'||
(row_number() over (partition by ffvq.flex_value_set_id order by ffvq.assignment_date,ffvq.value_attribute_type)*2-1)
||',1),'''||fvat.lookup_type||''',0) '||
decode(fvat.value_attribute_type,
'FIN_ITEM_SET_FLAG','financial_category_set',
'LOB_HIER_TOP_NODE','"Line of Business Hier Top Node"',
'DETAIL_BUDGETING_ALLOWED','budgeting_allowed',
'DETAIL_POSTING_ALLOWED','posting_allowed',
'GL_ACCOUNT_TYPE','account_type',
'GL_CONTROL_ACCOUNT','third_party_control',
'RECONCILIATION FLAG','reconcile',
'GL_LEDGER_SET','ledger_set'
)||',' text
from
fnd_flex_value_sets ffvs,
fnd_flex_validation_qualifiers ffvq,
fnd_value_attribute_types fvat
where
ffvs.flex_value_set_name=:flex_value_set_name and
ffvs.flex_value_set_id=ffvq.flex_value_set_id and
ffvq.id_flex_application_id=fvat.application_id and
ffvq.id_flex_code=fvat.id_flex_code and
ffvq.segment_attribute_type=fvat.segment_attribute_type and
ffvq.value_attribute_type=fvat.value_attribute_type
order by
ffvq.flex_value_set_id,
ffvq.assignment_date,
ffvq.value_attribute_type
F
Ensemble de valeurs Flex
US
Flex Value Set
5
40
1=1
ffv.parent_flex_value_low=:independent_value
Char
US
Independent Value
6
50
1=1
lower(ffv.flex_value) like lower(:flex_value_like)
Char
F
Valeur Flex comme
US
Flex Value like
7
60
1=1
ffv.created_by=xxen_util.user_id(:created_by)
LOV
FND User Name
8E2FF36EDE8479D2E0530100007F1FF2
Y
Y
select
fu.user_name value,
trim(coalesce(
trim(papf.first_name||' '||papf.last_name),
fu.description,
fu.email_address,
papf.email_address
)||fu.inactive) description
from
(select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu,
(select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf,
(
select distinct
furg.user_id,
count(*) over (partition by furg.user_id) resp_count,
max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key
from
fnd_responsibility fr,
fnd_user_resp_groups_direct furg
where
fr.responsibility_id=furg.responsibility_id and
fr.application_id=furg.responsibility_application_id
) furg
where
fu.employee_id=papf.person_id(+) and
fu.user_id=furg.user_id(+) and
not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE')
order by
fu.inactive desc,
fu.user_name
F
Créé par
US
Created By
8
70
1=1
ffv.creation_date>=:creation_date_from
Date
F
Date de création du
US
Creation Date From
9
80
1=1
ffv.creation_date<:creation_date_to+1
Date
US
Creation Date To
10
90
1=1
ffv.last_updated_by=xxen_util.user_id(:last_updated_by)
LOV
FND User Name
8E2FF36EDE8479D2E0530100007F1FF2
Y
Y
select
fu.user_name value,
trim(coalesce(
trim(papf.first_name||' '||papf.last_name),
fu.description,
fu.email_address,
papf.email_address
)||fu.inactive) description
from
(select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu,
(select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf,
(
select distinct
furg.user_id,
count(*) over (partition by furg.user_id) resp_count,
max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key
from
fnd_responsibility fr,
fnd_user_resp_groups_direct furg
where
fr.responsibility_id=furg.responsibility_id and
fr.application_id=furg.responsibility_application_id
) furg
where
fu.employee_id=papf.person_id(+) and
fu.user_id=furg.user_id(+) and
not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE')
order by
fu.inactive desc,
fu.user_name
F
Dernière mise à jour par
US
Last Updated By
11
100
1=1
ffv.last_update_date>=:last_update_date_from
Date
F
Date de la dernière mise à jour du
US
Last Update Date From
12
110
1=1
ffv.last_update_date<:last_update_date_to+1
Date
US
Last Update Date To
13
120
1=1
ffv.enabled_flag='Y' and
sysdate between nvl(ffv.start_date_active,sysdate) and nvl(ffv.end_date_active,sysdate)
LOV
Yes
8E2FF36EDEA679D2E0530100007F1FF2
Y
select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual
Y
F
Actif uniquement
US
Active only
14
130
1=1
not exists (select null from fnd_flex_value_hierarchies ffvh where ffvs.flex_value_set_id=ffv.flex_value_set_id and ffvh.parent_flex_value=:parent_flex_value and ffv.flex_value between ffvh.child_flex_value_low and ffvh.child_flex_value_high)
LOV
FND Flex Hierarchy
B52C6BB09E788499E0530100007F4F38
Y
select distinct
ffvnh.parent_flex_value value,
(select ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end from fnd_flex_values_vl ffvv where ffvnh.flex_value_set_id=ffvv.flex_value_set_id and ffvv.parent_flex_value_low is null and ffvnh.parent_flex_value=ffvv.flex_value)||' ('||nvl2(ffvnh.is_child,null,xxen_util.meaning('TOP','TOP_BOTTOM_PERF',283)||' ')||xxen_util.meaning('CCONTAIN','ICX_CONDITIONS',0)||' '||xxen_util.meaning(ffvnh.max_range_attribute,'RANGE_ATTRIBUTE',0)||')' description,
ffvnh.is_child,
ffvnh.max_range_attribute
from
(
select distinct
ffvnh.flex_value_set_id,
ffvnh.parent_flex_value,
(select 'Y' from gl_seg_val_norm_hierarchy gsvnh where ffvnh.parent_flex_value=gsvnh.child_flex_value and ffvnh.flex_value_set_id=gsvnh.flex_value_set_id and rownum=1) is_child,
max(ffvnh.range_attribute) over (partition by ffvnh.parent_flex_value) max_range_attribute
from
fnd_flex_value_norm_hierarchy ffvnh
where
ffvnh.flex_value_set_id in
(
select ffvs.flex_value_set_id from fnd_flex_value_sets ffvs where ffvs.flex_value_set_name=:$flex$.flex_value_set
union all
select
fifsv.flex_value_set_id
from
fnd_id_flex_segments_vl fifsv
where
fifsv.form_left_prompt=:$flex$.hierarchy_segment and
fifsv.application_id=101 and
fifsv.id_flex_code='GL#' and
fifsv.enabled_flag='Y' and
fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl where gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101) or xxen_util.contains(:$flex$.ledger,gl.name)='Y')
)
) ffvnh
order by
ffvnh.is_child desc,
ffvnh.max_range_attribute desc,
length(ffvnh.parent_flex_value),
ffvnh.parent_flex_value
F
Manquant dans la hiérarchie
US
Missing in Hierarchy
15
140
1=1
ffv.summary_flag=decode(xxen_util.lookup_code(:parent_or_child,'DIRECTION_CODE',222),'P','Y','N')
LOV custom
Y
select
flvv.meaning value,
null description
from
fnd_lookup_values_vl flvv
where
flvv.lookup_code in ('P','C') and
flvv.lookup_type(+)='DIRECTION_CODE' and
flvv.view_application_id(+)=222 and
flvv.security_group_id(+)=0
order by
flvv.lookup_code desc
select xxen_util.meaning('C','DIRECTION_CODE',222) from dual where :$flex$.missing_in_hierarchy is not null
F
Parent ou enfant
US
Parent or Child
16
150
2=2
ffvnh.parent_flex_value like :hierarchy_name_like
Char
F
Valeur du parent comme
US
Parent Value like
17
160
1=1
ffv.structured_hierarchy_level=:rollup_group_id
LOV custom
Y
select
ffhv.hierarchy_id id,
ffhv.hierarchy_name value,
ffvs.flex_value_set_name||': '||ffhv.description description
from
fnd_flex_value_sets ffvs,
fnd_flex_hierarchies_vl ffhv
where
(:$flex$.Flex_Value_Set is null or xxen_util.contains(:$flex$.Flex_Value_Set,ffvs.flex_value_set_name)='Y') and
ffvs.flex_value_set_id=ffhv.flex_value_set_id and
ffhv.hierarchy_id in (select ffv.structured_hierarchy_level from fnd_flex_values ffv)
order by
ffhv.hierarchy_name
US
Used in Rollup Group
18
170
&dff_columns
select xxen_util.dff_columns(p_table_name=>'fnd_flex_values') sql_text from dual
LOV
Yes
8E2FF36EDEA679D2E0530100007F1FF2
Y
select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual
Y
US
Show DFF Attributes
:$flex$.Flex_Value_Set
Flex Value Set
Used in Rollup Group
:$flex$.flex_value_set
Flex Value Set
Missing in Hierarchy
:$flex$.fnd_key_flexfield
Used by Key Flexfield
Flex Value Set
:$flex$.fnd_key_flexfield
Used by Key Flexfield
Used by Key Flex Structure
:$flex$.fnd_key_flexfield_structure
Used by Key Flex Structure
Flex Value Set
:$flex$.missing_in_hierarchy
Missing in Hierarchy
Parent or Child