SELECT fa.application_id,
fa.application_short_name ,
fat.application_name ,
table_name ,
column_name ,
ft.description table_description ,
fc.description column_description
FROM fnd_tables ft ,
fnd_columns fc ,
fnd_application_tl fat ,
fnd_application fa
WHERE ft.table_id = fc.table_id
AND fat.application_id = ft.application_id
AND fa.application_id = fat.application_id
AND fc.column_name =:column_name;
fa.application_short_name ,
fat.application_name ,
table_name ,
column_name ,
ft.description table_description ,
fc.description column_description
FROM fnd_tables ft ,
fnd_columns fc ,
fnd_application_tl fat ,
fnd_application fa
WHERE ft.table_id = fc.table_id
AND fat.application_id = ft.application_id
AND fa.application_id = fat.application_id
AND fc.column_name =:column_name;
No comments:
Post a Comment