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!

Problem in a query (Wip Return)

Discussion in 'SQL PL/SQL' started by leonardootc, May 10, 2014.

  1. leonardootc

    leonardootc Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Hi everyone; I’m having a hard time with a query. In the batch details when I consult material transactions, SHOWS me all the WIP ISSUE (2) (10) (3) AND A WIP RETURN (2) that belongs to WIP ISSUE. So when I'm recovering the data in the query I do not want the numbers will be showed. ( wip issue 2 and wip return 2)

    I tried to filtering by mmt.transaction_type_id where 43 is wip return but I have the other ‘2’ that is wip issue 35 belongs to (10) (3).

    Thanks in advance. Regards, leonardo.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    One, what is your query? Two, is this Oracle financials or some other Oracle application? We need MORE from you than just this cryptic statement.


    Please post more detail regarding your 'problem'.
     
  3. leonardootc

    leonardootc Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Hi zargon, Thanks for answered my thread. I respond your doubts.

    1.-I couldn´t put my query in this post. (Oops! your Post seems to be a SPAM! If you are posting live links, you need to have made at least 5 Posts as required by the administrator) thats the warning I've received
    2.-Yes, it's EBS12. Inventory modul.

    Thanks, Again.