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!

Search by description in purchase order summary

Discussion in 'Oracle Financials' started by hbrjsa, Mar 12, 2012.

  1. hbrjsa

    hbrjsa Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Battletown, Kentucky
    I am brand new to Oracle and my company enters invoice numbers into the purchase orders in the description line. Is there a way to search by description line? I know how to search by purchase order number, but can not find how to search by description. Thanks for your help.
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi,

    Are you trying to search through front-end (Application level) or back-end (database level) using queries.
     
  3. hbrjsa

    hbrjsa Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Battletown, Kentucky
    Back end I assume. I am going through invoices that have been entered and then checking for payment or checking for duplicate invoices.
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi,

    Use comments field in PO_HEADERS_ALL table to get details of that purchase order using description.

    sample query: -

    Code (Text):
    select * from po_headers_all where COMMENTS='Standard PO1';
    You can get your Purchase order record by using your invoice number (Description) at comments field as above.