SQLPKG Related to E1 table

Hi,
I am trying to find what SQLPKGs are related to a particular E1 table. I can view the content in package and check but if there is any easy way to find it let me know. This is for E812 TR8.97 on AS400 DB2.

Thanks,
Chan

Hi Chan, I attach to you 2 sql scripts:
1. Permit identify what object have in your project, without use omw,
2. List all contents of the packages from a date, for a pathcode and server, but is easy to change and adapt to you need.

XaviGray,
Bunch of thanks for sharing this. I will dig into it trying to use as much i can.

Thanks,
Chan

No problems.

Xavi,
The info you provided seems to be for the package build. I am looking for the SQL packages which are created for the tables in E1 during execution. normally they start with O,T or J. Any idea on this?. I have a command which displays what contents are in the SQL but there are thousands of them so finding some easy way to browse for a given table.

Chan