261: p_app_gl_date, --this is the application gl_date
262: p_inv_amount_rem,
263: p_inv_currency_code
264: FROM
265: ar_open_trx_v ot
266: WHERE
267: ot.customer_trx_id = p_inv_customer_trx_id and
268: ot.invoice_currency_code = p_cm_currency_code and
269: ot.status=decode(p_show_closed_invoices,'Y',ot.status,'OP') and
300: p_app_gl_date, --this is the defaulted application gl_date
301: p_inv_amount_rem,
302: p_inv_currency_code
303: FROM
304: ar_open_trx_v ot
305: WHERE
306: ot.customer_trx_id = p_inv_customer_trx_id and
307: ot.invoice_currency_code = p_cm_currency_code and
308: ot.status=decode(p_show_closed_invoices,'Y',ot.status,'OP') and