741: AP_INVOICES_UTILITY_PKG.GET_LINE_TOTAL(
742: AI.INVOICE_ID),
743: decode(AB.BATCH_ID,
744: '',null,
745: AP_BATCHES_PKG.GET_ACTUAL_INV_COUNT(
746: AB.BATCH_ID)),
747: decode(AB.BATCH_ID,
748: '',null,
749: AP_BATCHES_PKG.GET_ACTUAL_INV_AMOUNT(
745: AP_BATCHES_PKG.GET_ACTUAL_INV_COUNT(
746: AB.BATCH_ID)),
747: decode(AB.BATCH_ID,
748: '',null,
749: AP_BATCHES_PKG.GET_ACTUAL_INV_AMOUNT(
750: AB.BATCH_ID))
751: from ap_invoices AI,
752: ap_batches_all AB --Bug: 6668692 : Added _all to table name
753: where AI.invoice_id = X_invoice_id