OPM GL Reconciliation in R12 for Specific Segment
Hi,
I need your help. We are doing OPM GL Reconciliation. I need a query for reconciliation of specific segment (Receiving Inventory Control A/C) in detailed. I also want to validate it with GL.We presently use following query
------------------------------
SELECT gcc.segment5 account,
gjh.name journal_name,
gjh.je_category,
gjh.je_source,
gjl.effective_date,
gjh.period_name,
-- gjl.accounted_dr,
-- gjl.accounted_cr,
xal.accounted_dr,
xal.accounted_cr,
gjl.je_header_id,
gjl.je_line_num,
gcc.concatenated_segments,
gjl.code_combination_id,
'RECEIPT_NUM' doc_type,
gir.reference_5,
(SELECT cad.source_document_no