119: decode(nvl(ael.accounted_Cr,0),0,decode(nvl(ael.entered_Cr,0),0,decode(nvl(ael.accounted_Dr,0),0,ael.entered_Dr,ael.accounted_Dr),ael.entered_Cr),ael.accounted_Cr) ival,
120: ab.batch_name bat,
121: ab.batch_id batid,
122: ai.org_id
123: From ap_ae_headers aeh,
124: ap_ae_lines ael,
125: ap_invoices ai,
126: gl_periods gp,
127: gl_sets_of_books gs,
161: decode(nvl(accounted_Cr,0),0,decode(nvl(entered_Cr,0),0,decode(nvl(accounted_Dr,0),0,entered_Dr,accounted_Dr),entered_Cr),accounted_Cr) ival,
162: ac.checkrun_name bat,
163: 0 batid,
164: ai.org_id
165: From ap_ae_headers aeh,
166: ap_ae_lines ael,
167: ap_invoice_payments aip,
168: ap_invoices ai,
169: ap_checks ac,