Wednesday, February 20, 2013

Useful query :Relation between AR invoice and Sales Order

Query for to find out AR invoice and Sales Order Details


SELECT oha.order_number, 
               ola.line_number so_line_number,
               ola.ordered_item item_name,
              ola.ordered_quantity * ola.unit_selling_price LINE_AMOUNT,
              rcta.trx_number Transaction_number, rcta.trx_date,
              rctla.line_number TRX_line_number,
               rctla.unit_selling_price unit_selling_price
  FROM oe_order_headers_all oha,
              oe_order_lines_all ola,
               ra_customer_trx_all rcta,
               ra_customer_trx_lines_all rctla
 WHERE oha.header_id = ola.header_id
   AND rcta.customer_trx_id = rctla.customer_trx_id
   AND rctla.interface_line_attribute6 = TO_CHAR (ola.line_id)
   AND rctla.interface_line_attribute1 = TO_CHAR (oha.order_number)
   AND order_number = :p_order_number

Posted by
Labels: , ,

9 comments:

  1. Sridevi KoduruMarch 17, 2014 at 2:36 AM

    This comment has been removed by the author.

    ReplyDelete
  2. Tally TrainingOctober 8, 2015 at 10:43 PM

    One more useful website to learn tally....

    ReplyDelete
  3. James walkerSeptember 24, 2017 at 9:49 AM

    Have one sales activity for every day, since you know you can finish that. Each activity will expand upon the one from the earlier day. sales automation

    ReplyDelete
  4. tamrindsDecember 11, 2017 at 11:46 PM

    Thank you so much for this useful query..! appreciate it..!

    ReplyDelete
  5. john smithJuly 4, 2018 at 4:10 AM

    I make no apology for this requirement. The most common issue I have seen in all my years as a counselor with the numerous people I have seen as clients dealing with relationships, has been inequality between couples. what to talk to a girl about

    ReplyDelete
  6. Mir HaadiJuly 14, 2018 at 5:00 AM

    You should appreciate, doing what makes the other person be aware of the fact they are special is easily done, on condition that we do it https://relationadvisor.com/

    ReplyDelete
  7. Anaya ShaikhJuly 30, 2018 at 12:26 AM

    This comment has been removed by the author.

    ReplyDelete
  8. UnknownMarch 13, 2019 at 7:41 AM

    Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. יחסי ציבור לעסקים

    ReplyDelete
  9. CharlesdayJuly 14, 2019 at 5:58 AM

    I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! The information that you have provided is very helpful. voyance telephone

    ReplyDelete

Subscribe to: Post Comments (Atom)