This content has been marked as final. Show 3 replies
You can get the underlying statement for any view as follows1 person found this helpful
select * From all_views where view_name='EAM_WORK_ORDERS_V'
Hope this helps,
Thanks Sandeep, but I am not getting the table name of the view from this query.
The view uses many tables but the main tables are
The view focuses on EMA jobs by looking at only those records in wip_entities where we.entity_type IN (6, 7)
Hope this answers your question,