Home » Applications » Oracle Fusion Apps & E-Business Suite » Dependent package of per_all_people_f table
Dependent package of per_all_people_f table [message #442906] Thu, 11 February 2010 04:21 Go to next message
katripon
Messages: 6
Registered: February 2010
Location: Bangladesh
Junior Member
Hi,
How can I know which packages are using per_all_people_f table in ERP?
Can anybody help by providing me query/script?

Thanks
Re: Dependent package of per_all_people_f table [message #442927 is a reply to message #442906] Thu, 11 February 2010 06:59 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Check referenced_name in user_dependencies.
(Or) If you have any GUI tool like Toad, check the Usages of the table.

By
Vamsi
Re: Dependent package of per_all_people_f table [message #443295 is a reply to message #442927] Mon, 15 February 2010 00:26 Go to previous messageGo to next message
katripon
Messages: 6
Registered: February 2010
Location: Bangladesh
Junior Member
Hi,

Thanks for reply.
Can you tell, how I can get usage of a table information from TOAD?
Re: Dependent package of per_all_people_f table [message #443343 is a reply to message #443295] Mon, 15 February 2010 03:52 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Search the table in the schema browser and click on "User By" tab.

By
Vamsi
Previous Topic: GL enquiries
Next Topic: From where Indexes are analyzed
Goto Forum:
  


Current Time: Sun Dec 11 02:19:22 CST 2016

Total time taken to generate the page: 0.13205 seconds