Home » Applications » Oracle Fusion Apps & E-Business Suite » Need guidance to acquire tablename associated to each screen
icon5.gif  Need guidance to acquire tablename associated to each screen [message #225905] Wed, 21 March 2007 21:07 Go to next message
swting
Messages: 8
Registered: March 2007
Location: MALAYSIA
Junior Member

Hi,

I need someone to guide me or share with me if there is any way to know the tablename associated to each screen. E.g. How to know if Customer Addresses screen refers to ra_addresses_all?

Any inputs would be much appreciated.

Regards,
SW
Re: Need guidance to acquire tablename associated to each screen [message #225979 is a reply to message #225905] Thu, 22 March 2007 02:46 Go to previous messageGo to next message
vin_odks
Messages: 153
Registered: July 2006
Location: -
Senior Member
1) Open the screen for which u need the table information
2) HELP-->RECORD HISTORY -->Table name
3) If it is the view , open the source for the view


You will get the table link and information of the screen

Regards
Vinod

icon7.gif  Re: Need guidance to acquire tablename associated to each screen [message #226221 is a reply to message #225905] Thu, 22 March 2007 21:54 Go to previous messageGo to next message
swting
Messages: 8
Registered: March 2007
Location: MALAYSIA
Junior Member

Hi Vinod,

Appreciate your reply and guidance. May you provide further guidance on how to open the source for the view?

Thanks,
SW
Re: Need guidance to acquire tablename associated to each screen [message #226277 is a reply to message #225905] Fri, 23 March 2007 02:45 Go to previous messageGo to next message
vin_odks
Messages: 153
Registered: July 2006
Location: -
Senior Member

Quote:

May you provide further guidance on how to open the source for the view?



Have you tried to find the answer..

I would be surprised , if you didn't find the answer your self..

Regards
Vinod
Re: Need guidance to acquire tablename associated to each screen [message #226342 is a reply to message #226277] Fri, 23 March 2007 05:31 Go to previous messageGo to next message
swting
Messages: 8
Registered: March 2007
Location: MALAYSIA
Junior Member

Hi Vinod,

I found the base tables through dependencies. Perhaps you have better way and are willing to share in order to achieve the same result.

Thanks,
SW
Re: Need guidance to acquire tablename associated to each screen [message #226744 is a reply to message #225905] Mon, 26 March 2007 07:07 Go to previous messageGo to next message
vin_odks
Messages: 153
Registered: July 2006
Location: -
Senior Member
I would be eager to share my knowledge..for more exploration!!!

1) In case u have toad installed... just press F4 from the name of the view and the view source is displayed.

2) From SQL..
SQL>select text from all_views where view_name='RA_ADDRESSES'

Regards
Vinod
icon14.gif  Re: Need guidance to acquire tablename associated to each screen [message #226895 is a reply to message #226744] Mon, 26 March 2007 20:06 Go to previous message
swting
Messages: 8
Registered: March 2007
Location: MALAYSIA
Junior Member

Hi Vinod,

Thanks for the further guidance shared. Really appreciate that.

Regards,
SW
Previous Topic: any body help valueset?
Next Topic: INVENTORY responsibility
Goto Forum:
  


Current Time: Mon Dec 05 15:15:35 CST 2016

Total time taken to generate the page: 0.17810 seconds