How to Get Oracle E-Bussiness Suite Tables list

You can use the following select statement to get the Oracle E-Bussiness Suite Tables List for each application:

SELECT A.APPLICATION_ID,
       A.APPLICATION_NAME,
       A.APPLICATION_SHORT_NAME,
       A.DESCRIPTION APPLICATION_DESCRIPTION,
       A.BASEPATH,
       A.PRODUCT_CODE,
       P.TABLE_NAME,
       P.USER_TABLE_NAME,
       P.DESCRIPTION
  FROM FND_TABLES P,
       FND_APPLICATION_VL A
 WHERE A.APPLICATION_ID = P.APPLICATION_ID
Advertisements

One response to “How to Get Oracle E-Bussiness Suite Tables list

  1. Pingback: How to Get Oracle E-Bussiness Suite Tables list « OraPedia

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s