1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

EAM - Work Order Information

Discussion in 'Oracle SCM & Manufacturing' started by tomloera, Sep 13, 2011.

  1. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Hi friends;

    I need found the information of the Work Order Number, I need for development some reports, In the diferents tables of EAM and WIP only found the WIP_ENTITY_ID but not found the table with the WORK ORDER NUMBER

    ┬┐Anything help me please?

    Regards
    Tom
     

    Attached Files:

  2. arul2k

    arul2k Active Member

    Messages:
    11
    Likes Received:
    2
    Trophy Points:
    110
    Hi Tom,

    You can get the underlying statement for any view as follows
    select * From all_views where view_name='EAM_WORK_ORDERS_V'

    also,The view uses many tables but the main tables are
    wip_entities
    wip_discrete_jobs

    The view focuses on EMA jobs by looking at only those records in wip_entities where we.entity_type IN (6, 7)

    Regards,
    Arul
     
    tomloera likes this.
  3. tomloera

    tomloera Forum Expert

    Messages:
    167
    Likes Received:
    6
    Trophy Points:
    260
    Location:
    Monterrey Mexico
    Hi Arul;

    Thanks a lot, this query is great I found the information of need by my reports

    Thanks Again
    Regards
    Tom