2 Replies Latest reply on Jul 17, 2012 6:28 AM by PranitSaha

    stuck po receipts in interface tables in R12


      I have to prepare a query, this query will used for an Oracle Alert. requirement is as below.
      when ever stuck po receipts in interface table, we need to send an alert tp Buyers. please let me know how to achieve this.
      what are all the join conditions between RCV_TRANSACTIONS_INTERFACE,RCV_HEADERS_INTERFACE, PO_Headers_all andPO_Lines_all tables.
      Thought of using above tables to build the query. if i am missing any other tables please provide those to complete this task.

      Many Thanks.