How to check tables of each screen?

[admin]

No you are doing excellent job by sharing your experience just meant that there is any example/sample output for better understanding for others. thanks

[lukman]

Hello,

how to find the owner of a view or materialized view? Can we use script:

SELECT owner
FROM dba_tables
WHERE table_name = 'table_name'

I tried to use it but failed. Thanks.

[ahmadbilal]

SELECT owner, object_name, object_type, created, status, last_ddl_time
FROM all_objects
WHERE UPPER (object_name) = UPPER ('Object Name')

[lukman]

Thanks for the script, it really helps.

[lukman]

hi,

using the script I got here I tried to find the owner of mtl_parameters. I found that the owner is apps but when I looked in schema browser with TOAD there's no mtl_parameters (though there are some views started with mtl_parameters). When I saw the script in mtl_parameters_view it referred to mtl_parameters too (but in that view's script there are 2 mtl_parameters with different alias, what's the reason for that?). So where's that mtl_parameters anyway? Thanks