This discussion is archived
2 Replies Latest reply: Jul 16, 2012 11:28 PM by PS RSS

stuck po receipts in interface tables in R12

user627525 Newbie
Currently Being Moderated
Hi,

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points