I am developing a report using EAM_WORK_ORDERS_V, WIP_REQUIREMENT_OPERATIONS_V, CST_DISTRIBUTION_V and EAM_JOB_COMPLETION_TXNS. As 1st 3 are views, it takes so much of time, i don't know the table names of the above views. Kindly help me in providing the table names for above views.
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,