Query to get the order and invoice details,Joins between OM and AR



Joins between OM and AR
Modules Involved : AR, OM
Description      : get the invoices and order details


SELECT ooha.order_number        Order_Number,
       rct.trx_number           Invoice_number,
       rctl.line_type           Invoice_Line_Type,
       msi.segment1             Item_Number,
       rctl.quantity_ordered    Quantity_ordered,
       rctl.quantity_invoiced   Quantity_invoiced,
       rctl.unit_standard_price Unit_standard_price,
       rctl.unit_selling_price  Unit_selling_price,
       RCTL.EXTENDED_AMOUNT     EXTENDED_AMOUNT
       --,rctl.*
  FROM apps.oe_order_headers_all      ooha,
       apps.ra_customer_trx_all       rct,
       APPS.RA_CUSTOMER_TRX_LINES_ALL RCTL,
       apps.mtl_system_items_b          msi
 WHERE 1=1
   AND to_char(ooha.order_number)      = rct.interface_header_attribute1
   AND rct.customer_trx_id             = rctl.customer_trx_id
   and RCTL.INVENTORY_ITEM_ID          = MSI.INVENTORY_ITEM_ID
   AND msi.organization_id             = 65 -- Master
   and RCT.TRX_NUMBER                  = '284968'
   --and RCTL.INTERFACE_LINE_ATTRIBUTE2  = 'Test_Order_Type'
   ;

7 Comments

After a long time, I read a very beautiful and very important article that I enjoyed reading. I have found that this article has many important points, I sincerely thank the admin of this website for sharing it. Best simple invoicing service provider.

Reply

You are providing essential knowledge. It is helpful and important information of Small Parcel Contract Negotiation for us and everyone to increase knowledge. Continue sharing your data. Thanks once again for sharing it.

Reply

Absolutely knowledgeable content. Thanks for sharing this kind of content. It is very helpful and very informative and I really learned a lot from it. Invoice Finance

Reply

It’s great to come across a blog every once in a while that isn’t the same out of date rehashed material. Fantastic read. best simple invoicing service provider.

Reply

I read this article, it is really informative one. Your way of writing and making things clear is very impressive. Thanking you for such an informative article.Receipt Generator

Reply

I found your blog on Google and read a few of your other posts. I just added you to my Google News Reader. You can also visit Create Receipt Online for more Receipt Builder related information and knowledge, Keep up the great work Look forward to reading more from you in the future.

Reply

To be honest your post is informative and very helpful. After I saw your Post, it helped me a lot. Thanks for share your kind information about Receipt Generator

Reply

Post a Comment