R12 – GL-Receiving India Drill Down Query
Here is the query for Link between General Ledger and Receiving India data’s. SELECT msib.segment1 item, msib.description, rsh.receipt_num, mp.organization_code, gjl.accounted_dr, gjl.accounted_cr, gjh.je_source, gjh.je_category FROM apps.gl_je_headers gjh, apps.gl_je_lines gjl, apps.gl_code_combinations_kfv gcc, apps.gl_import_references gir, apps.rcv_transactions rt, apps.rcv_shipment_headers rsh, apps.rcv_shipment_lines rsl, apps.gl_je_batches gjb, apps.mtl_parameters mp, apps.mtl_system_items_b msib WHERE gjh.je_header_id = gjl.je_header_id AND gjh.je_header_id = gir.je_header_id AND gir.je_header_id […]
Recent Comments