| Journal lines R12(developer) [message #396220] |
Sun, 05 April 2009 02:53  |
alaa_fouad2004
Messages: 31
Registered: January 2009 |
Member |
|
|
Dear all
I want to know the table which have the relation between the invoices in AP and the journals lines in GL.
-i make invoice on AP and create account final post .mean to go to the GL.
- i found the batch which created in GL
- when i do Line drilldawn and press view transaction the application show me the invoice .
so there is table in database have relation between invoices in AP and journals lines I want to know it
Alaa Fouad
|
|
|
| Re: Journal lines R12(developer) [message #396223 is a reply to message #396220] |
Sun, 05 April 2009 04:21  |
 |
vamsi kasina
Messages: 1603
Registered: October 2003
Location: Hyderabad, India |
Senior Member |
|
|
gl_je_lines(je_header_id,je_line_num) -> gl_import_references(je_header_id,je_line_num)
gl_import_references(gl_sl_link_table,gl_sl_link_id) -> xla_ae_lines(gl_sl_link_table,gl_sl_link_id)
xla_ae_lines(applicaiton_id,ae_header_id) -> xla_ae_headers(application_id,ae_header_id)
xla_ae_headers(application_id,event_id) -> xla_events(application_id,event_id)
xla_events(application_id,entity_id) -> xla.xla_transaction_entities(application_id,entity_id)
xla.xla_transaction_entities.source_id_int_1 is equavalent to invoice_id or check_id. it depends on the entity_code.
Hope this helps.
By
Vamsi
|
|
|
|
|
|
|
|
|
|
| Re: Journal lines R12(developer) [message #428652 is a reply to message #428619] |
Thu, 29 October 2009 05:00 |
|
vamsi kasina
Messages: 1603
Registered: October 2003
Location: Hyderabad, India |
Senior Member |
|
|
vamsi kasina wrote on Thu, 29 October 2009 13:35Please read my previous update once again.
Further questions, first read the Forum Guide.
By
Vamsi
Especially the point "Is count(*) giving 0 rows? (Or) Isn't SELECT giving desired output?" in Forum Guide.
If you don't care to read the updates fully, why should I pin point the answer?
By
Vamsi
[Updated on: Thu, 29 October 2009 05:02]
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
