FND Tables and Columns

Description
Categories: Enginatics
Repository: Github Columns: Application Short Name, Application Name, Table Name, Column Name, Column Description, Column Type, Null Allowed, Primary Key Name, Primary Key Sequence, Flexfield Name ...
Registered FND tables, columns, primary keys and their flexfields
select
fav.application_short_name,
fav.application_name,
ft.table_name,
fc.column_name,
fc.description column_description,
xxen_util.meaning(fc.column_type,'COLUMN_TYPE',0)||case when fc.column_type in ('C','U','V') then ' ('||fc.width||')' end column_type,
xxen_util.meaning(fc.null_allowed_flag,'YES_NO',0) null_allowed,
fpk.primary_key_name,
fpkc.primary_key_sequence,
fc.flexfield_name,
fdfv.title flexfield_title,
fc.column_type column_type_code,
xxen_util.user_name(fc.created_by) created_by,
xxen_util.client_time(fc.creation_date) creation_date,
xxen_util.user_name(fc.last_updated_by) last_updated_by,
xxen_util.client_time(fc.last_update_date) last_update_date
from
fnd_application_vl fav,
fnd_tables ft,
fnd_columns fc,
fnd_primary_key_columns fpkc,
fnd_primary_keys fpk,
fnd_descriptive_flexs_vl fdfv
where
1=1 and
fav.application_id=ft.application_id and
ft.application_id=fc.application_id and
ft.table_id=fc.table_id and
fc.application_id=fpkc.application_id(+) and
fc.table_id=fpkc.table_id(+) and
fc.column_id=fpkc.column_id(+) and
fc.flexfield_application_id=fdfv.application_id(+) and
fc.flexfield_name=fdfv.descriptive_flexfield_name(+) and
fpkc.application_id=fpk.application_id(+) and
fpkc.table_id=fpk.table_id(+) and
fpkc.primary_key_id=fpk.primary_key_id(+)
order by
ft.table_name,
fc.column_sequence,
fpkc.primary_key_sequence
Parameter Name SQL text Validation
Key Columns only
fpkc.primary_key_sequence is not null
LOV
Table Name
ft.table_name=:table_name
LOV
Column Name like
lower(fc.column_name) like :colum_name