DBA Data[Home] [Help]

APPS.AR_CM_VAL_PVT dependencies on AR_OPEN_TRX_V

Line 265: ar_open_trx_v ot

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

Line 304: ar_open_trx_v ot

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