1332: null) as EMD_FORFEIT_TRANS_NUM,
1333: decode(petr.status_lookup_code,
1334: 'REFUNDED',
1335: (select aia.invoice_num
1336: from ap_invoices_all aia
1337: where aia.invoice_id = petr.application_ref_id),
1338: null) as EMD_PAY_INV_NUM,
1339: decode(petr.status_lookup_code,
1340: 'REFUNDED',