Table Usage Details

[Former Member]

Can anyone provide me a sql/plsql statement to find the jobs in which a table is being used.

Please note that I don't want to use AL_USAGE table in the process.

Thanks in advance

[former_member216148]

Hi..Please check out these links..

https://scn.sap.com/thread/3261180

Oracle stored procedure as source in BODS | SCN

Regards

Saad

[Former Member]

Thanks for the info Syed but I am not looking for this.

Let me try to explain the question in other way.

Suppose I have 10 jobs in my local repository. A table 'TABLE_1' is used in 5 of these jobs. I need a sql which can give me all the 5 job names in which 'TABLE_1' is used.

It can be done easily if we use AL_USAGE table but due to some constraints I am not able to use that.