SELECT rcta.customer_trx_id, rcta.trx_number, rcta.trx_date, ac.customer_name, rctla.line_number inv_line_number, rctla.unit_selling_price inv_unit_selling_price, ooha.header_id, ooha.order_number, oola.line_number so_line_number, oola.line_id, oola.ordered_item, oola.ordered_quantity * oola.unit_selling_price so_amount FROM apps.ra_customer_trx_all rcta, apps.ra_customer_trx_lines_all rctla, apps.ar_customers ac, apps.oe_order_headers_all ooha, apps.oe_order_lines_all oola WHERE 1 = 1 AND rcta.customer_trx_id = rctla.customer_trx_id AND rcta.bill_to_customer_id = ac.customer_id AND ooha.header_id = oola.header_id AND rctla.interface_line_attribute6 = TO_CHAR(oola.line_id) AND rctla.interface_line_attribute1 = TO_CHAR(ooha.order_number) AND rcta.trx_number = nvl(:p_trx_number,rcta.trx_number) AND ooha.order_number = nvl(:p_order_number,ooha.order_number);
This blog is for Oracle Ebs, Fusion and OIC Techno- Functional People. I am sharing my work experience through this blog.
Wednesday, 17 January 2018
AR and OM link in oracle apps / AR transaction and Sales Order join query
Subscribe to:
Post Comments (Atom)
AP Invoice Notes related Table details in Oracle Fusion
What is the table that stores the AP Invoice notes? AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOI...
-
P2P CYCLE: INVENTORY=> REQUIESTITION=> RFQ=> QUOTATION=> QUOTATION ANALYSIS=> PURCHASE ORDER =>...
-
Order to Cash (O2C) Cycle with in Oracle Apps Enter the Sales Order Book the Sales Order Launch Pick Release Ship Confirm Create In...
-
---------- 1) Below given query can be used TO get concatenated Gl code combinations segment AND its description USING API GL_FLEXFIELDS_PK...
I'm very happy to search out this information processing system. I would like to thank you for this fantastic read!!
ReplyDeleteLearn XML Publisher Reports for Beginners Actual cost of this course is 9,999/- But now Kuncham Software Solutions Pvt ltd is giving you Free access. Limited period offer Hurry-up Enroll Now at Udemy.
Hurry-Up Enroll Now and get Free Access to the Entire Course
Thanks for one marvelous posting! I enjoyed reading it; you are a great author. I will make sure to bookmark your blog and may come back someday. Keep in blogging.AR Customer Helpdesk
ReplyDeletetop ca firms in gurgaon
Vendor Helpdesk
Very helpful post. Thanks for sharing that valuable post.Keep it up. Internal Audit
ReplyDeleteDuplicate Payment Audit
Fraud Prevention
When your website or blog goes live for the first time, it is exciting. That is until you realize no one but you and your.
ReplyDeletepresales
The Article is very informative , Kinldy keepon providing articles
ReplyDeleteDamage Audit
Inventory Verification
Modern Trade Reconciliation