I want to know what is the column link between OM and AR and also the link between AR and GL?

Showing Answers 1 - 19 of 19 Answers

ramarao

  • Jul 4th, 2006
 

Column link between OM and AR, You have customer_id in AR table and

sales_to_org_id in OM.using these mentioned columns we can link.

  Was this answer useful?  Yes

Thiru

  • Jul 31st, 2006
 

Hi ,

OM : main tables

       1) oe_order_headers_all

       2) oe_order_lines_all

AR : Main tables

1) RA_CUSTOMER_TRX_ALL 2) RA_CUSTOMER_TRX_LINES_ALL

when order is booked/shipped from OM then it generates auto invoice to AR

LINK is :


oe_order_lines_all.header_id = RA_CUSTOMER_TRX_LINES_ALL.interface_line_attribut6

  Was this answer useful?  Yes

Thiru

  • Jul 31st, 2006
 

AR : RA_CUST_TRX_LINE_GL_DIST_ALL

  table has the link to GL_CODE_COMBINATIONS table

join key : COMINATION_CODE_ID

  Was this answer useful?  Yes

vineet

  • Sep 2nd, 2006
 

Relation between AR & OP

ra_customer_trx_lines.sales_order = oe_order_headers.order_number

  Was this answer useful?  Yes

sravan

  • Mar 22nd, 2016
 

I did not see any sale_order in ra_customer_trx_lines

  Was this answer useful?  Yes

Sajal Maheshwari

  • Mar 29th, 2016
 

--Link between OM and AR is
SELECT *
FROM oe_order_headers_all ooha, ra_customer_trx_all rcta
WHERE TO_CHAR (ooha.order_number) = rcta.interface_header_attribute1
and and ooha.SHIP_FROM_ORG_ID=INTERFACE_HEADER_ATTRIBUTE10
/*-------------------------------------------------*/
interface_header_attribute2 is Order Type
interface_header_attribute3 is Delivery id of JAI_OM_WSH_LINES_all

--Link between Gl and AR is
/* Formatted on 2016/03/29 18:00 (Formatter Plus v4.8.8) */
/* Formatted on 2016/03/29 18:03 (Formatter Plus v4.8.8) */
SELECT *
FROM xla.xla_transaction_entities xte,
ra_customer_trx_all rcta,
xla_events xe,
xla_ae_headers xah,
xla_ae_lines xal,
gl_import_references gim,
gl_je_headers gjh
WHERE xte.source_id_int_1 = rcta.customer_trx_id
AND xte.entity_code = TRANSACTIONS
AND trx_number = 136AE002013
AND xte.entity_id = xe.entity_id
AND xe.event_id = xah.event_id
AND xah.ae_header_id = xal.ae_header_id
AND xal.gl_sl_link_id = gim.gl_sl_link_id
AND gim.je_header_id = gjh.je_header_id

Code
  1. SELECT *

  2.   FROM oe_order_headers_all ooha, ra_customer_trx_all rcta

  3.  WHERE TO_CHAR (ooha.order_number) = rcta.interface_header_attribute1

  4. AND AND ooha.SHIP_FROM_ORG_ID=INTERFACE_HEADER_ATTRIBUTE10

  5.  

  6.  

  7. SELECT *

  8.   FROM xla.xla_transaction_entities xte,

  9.        ra_customer_trx_all rcta,

  10.        xla_events xe,

  11.        xla_ae_headers xah,

  12.        xla_ae_lines xal,

  13.        gl_import_references gim,

  14.        gl_je_headers gjh

  15.  WHERE xte.source_id_int_1 = rcta.customer_trx_id

  16.    AND xte.entity_code = TRANSACTIONS

  17.    AND trx_number = 136AE002013

  18.    AND xte.entity_id = xe.entity_id

  19.    AND xe.event_id = xah.event_id

  20.    AND xah.ae_header_id = xal.ae_header_id

  21.    AND xal.gl_sl_link_id = gim.gl_sl_link_id

  22.    AND gim.je_header_id = gjh.je_header_id

  Was this answer useful?  Yes

Nidhi Soni

  • Oct 12th, 2016
 

Link between OM and AR tables

Code
  1. SELECT ooha.order_number

  2.      , oola.line_number so_line_number

  3.      , oola.ordered_item

  4.      , oola.ordered_quantity * oola.unit_selling_price so_extended_price

  5.      , rcta.trx_number invoice_number

  6.      , rcta.trx_date

  7.      , rctla.line_number inv_line_number

  8.      , rctla.unit_selling_price inv_unit_selling_price

  9. FROM   oe_order_headers_all ooha

  10.      , oe_order_lines_all oola

  11.      , ra_customer_trx_all rcta

  12.      , ra_customer_trx_lines_all rctla

  13. WHERE  ooha.header_id = oola.header_id

  14. AND    rcta.customer_trx_id = rctla.customer_trx_id

  15. AND    rctla.interface_line_attribute6 = TO_CHAR (oola.line_id)

  16. AND    rctla.interface_line_attribute1 = TO_CHAR (ooha.order_number)

  17. AND    order_number = :p_order_number

  Was this answer useful?  Yes

leela

  • Aug 11th, 2017
 

xla_ae_lines(gl_sl_link_table,gl_sl_link_id)=gl_import_references(gl_sl_link_table,gl_sl_link_id)
gl_je_lines(gl_je_header_id)=gl_import_references(gl_je_header_id)

  Was this answer useful?  Yes

Kiran praveen kumar Thota

  • Nov 1st, 2018
 

Not sale_order ,its sales_order

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions