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!

Query for all rejected materials from supplier and still on or holding area??

Discussion in 'Oracle Apps Technical' started by splinter2010, Feb 22, 2013.

  1. splinter2010

    splinter2010 Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    Hi all
    I'm getting task with creating report that lists all materials that receive on our manufacture and rejected or didn't take any actions (still in holding area) for example:
    we received 50 unit from material X accept from it 40 and reject 10, this rejected quantity still in our manufacture (not return to vendor), So my report have to list all materials with this kind, the quantity rejected and still not return to vendor or accepted anther time.
    any help ??
    Thanks
     
  2. ac.arijit

    ac.arijit Forum Advisor

    Messages:
    217
    Likes Received:
    22
    Trophy Points:
    280
    Location:
    Kolkata, India
    Check out with TRANSACTION_TYPE in ('RETURN TO VENDOR','RETURN TO RECEIVING') in RCV_TRANSACTIONS.
     
    Dessa likes this.
  3. Dessa

    Dessa Newly Initiated

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    Egypt
    Thanks a lot , I am not the owner of the question but your answer helped me appreciate it