tag:blogger.com,1999:blog-3748123311723907043.post5640083187346080942..comments2024-03-19T17:26:45.499+05:30Comments on Oracle Applications: General Ledger(GL) to Account Payables(AP)Unknownnoreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3748123311723907043.post-62108519225396314732016-04-13T01:03:58.599+05:302016-04-13T01:03:58.599+05:30Collecting the data from GL
Below query collects t...Collecting the data from GL<br />Below query collects the data from GL.<br />In the below query, you the see the linking columns in the first five places and others were other important ones.<br /><br />SELECT glimp.reference_5 ENTITY_ID<br /> ,glimp.reference_6 EVENT_ID<br /> ,glimp.reference_7 AE_HEADER_ID<br /> ,glimp.gl_sl_link_id<br /> ,glimp.gl_sl_link_table<br /> ,glb.je_batch_id<br /> ,glb.name<br /> ,glb.status<br /> ,glb.description<br /> ,glh.je_header_id<br /> ,glh.je_category<br /> ,glh.je_source<br /> ,glh.name<br /> ,glh.description<br /> ,glh.running_total_accounted_cr<br /> ,glh.running_total_accounted_dr<br /> ,gll.je_line_num<br /> ,gll.code_combination_id<br />FROM gl_import_references glimp<br /> ,gl_je_batches glb<br /> ,gl_je_headers glh<br /> ,gl_je_lines gll<br />WHERE glimp.je_header_id = glh.je_header_id<br />AND glimp.je_line_num = gll.je_line_num<br />AND glimp.je_batch_id = glb.je_batch_id<br />AND glh.je_header_id = gll.je_header_id<br />AND glh.je_batch_id = glb.je_batch_id<br />AND glimp.gl_sl_link_id = 508000 <br />AND glimp.gl_sl_link_table = 'XLAJEL';Anonymousnoreply@blogger.com