GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle Apps  >  Apps Technical
Go To First  |  Previous Question  |  Next Question 
 Apps Technical  |  Question 64 of 129    Print  
I want to know what is the column link between OM and AR and also the link between AR and GL?

  
Total Answers and Comments: 4 Last Update: September 02, 2006     Asked by: Rajesh 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 04, 2006 08:58:52   #1  
ramarao        

RE: Hi,I want to know what is the column link be...

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.


 
Is this answer useful? Yes | No
July 31, 2006 13:24:48   #2  
Thiru        

RE: Hi,I want to know what is the column link be...

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


 
Is this answer useful? Yes | No
July 31, 2006 13:27:03   #3  
Thiru        

RE: Hi,I want to know what is the column link be...

AR : RA_CUST_TRX_LINE_GL_DIST_ALL

table has the link to GL_CODE_COMBINATIONS table

join key : COMINATION_CODE_ID


 
Is this answer useful? Yes | No
September 02, 2006 14:19:20   #4  
vineet        

RE: Hi,I want to know what is the column link be...

Relation between AR & OP

ra_customer_trx_lines.sales_order oe_order_headers.order_number


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape