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)
Oracle Fusion SQL Queries to get Sales Person/Sales Representative information for an Order
1) Get sales person details if the Sales Person ID is known SELECT jrs.SALESREP_NUMBER , jrs.status , jrs.START_...
-
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