FND_TABLES Table Name, FND_COLUMNS Column Name

If you are looking for specific column name which comes along with the table name, use the query below in Oracle: -

SELECT t.TABLE_NAME , c.column_name, c.table_id FROM fnd_columns c, fnd_tables t
WHERE c.column_name = 'STOP_ID'
AND c.table_id = t.table_id

To search for the table name, you can use the query as below: -

SELECT object_name,object_type
FROM dba_objects
WHERE LOWER(object_name) LIKE '%countr%'
AND object_type IN ('TABLE','VIEW')

1 Comment

#1 khizar
November 15, 2011 3:26 am
Thanks it was really help full and i need some more information about custom forms
Post Reply

Leave a Comment

Join the over 2,000 people who get free and fresh knowledge as soon as it’s published.

We respect your email privacy.

We promise never to rent, sell or share information we collect because that would be a violation of everything we stand for.

Period.