OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Dependent package of per_all_people

Home » Applications » Oracle Fusion Apps & E-Business Suite » Dependent package of per_all_people_f table

Thu, 11 February 2010 04:21

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

Thu, 11 February 2010 06:59

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Mon, 15 February 2010 00:26

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?

Mon, 15 February 2010 03:52

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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: Mon Dec 23 18:14:40 CST 2024