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!

Get Back From PO to PR

Discussion in 'Oracle SCM & Manufacturing' started by RIAZ, May 1, 2009.

  1. RIAZ

    RIAZ Forum Advisor

    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    130
    hi,

    Would you please tell me how can i come back from PO to PR ?

    I have PO Number and i can view all the details in
    PO_HEADERS_ALL and PO_LINES_ALL

    but i am unable to find any link to go back to PO_REQUISITION_HEADER_ALL

    Waiting for experts opinion ...
     
  2. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    Hi RIAZ

    PO_DISTRIBUTIONS_ALL has the REQ_DISTRIBUTION_ID and PO_REQ_DISTRIBUTIONS_ALL has the DISTRIBUTION_ID, REQUISITION_LINE_ID. You have to make a join on PO_DISTRIBUTIONS_ALL (REQ_DISTRIBUTION_ID) and PO_REQ_DISTRIBUTIONS_ALL (DISTRIBUTION_ID) to see if there is a PO for a requistion.
     
  3. RIAZ

    RIAZ Forum Advisor

    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    130
    Thank you so much. It works.
     
  4. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    You are welcome :)