SELECT c.application_name
"Application
Name",
b.product_code "Short Name",
b.basepath "Application Top",
a.table_name "Table Name",
a.description "Table Description"
FROM fnd_tables a, fnd_application b, fnd_application_tl c
WHERE a.application_id
= b.application_id
AND a.application_id = c.application_id
AND b.application_id = c.application_id
AND c.application_name = NVL (:application_name, c.application_name)
AND b.product_code = NVL (UPPER (:application_short_name), b.product_code)
AND a.table_name = NVL (UPPER (:table_name), a.table_name)
GROUP BY b.product_code,
a.table_name,
c.application_name,
a.description,
b.basepath
ORDER BY a.table_name
