eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_INVOICE_TABLE_HANDLER dependencies on RA_CUSTOMER_TRX_LINES

Line 376: delete from ra_customer_trx_lines where customer_trx_id = p_customer_trx_id;

372:
373: arp_etax_invapi_util.cleanup_tax(p_customer_trx_id);
374:
375: delete from ra_customer_trx where customer_trx_id = p_customer_trx_id;
376: delete from ra_customer_trx_lines where customer_trx_id = p_customer_trx_id;
377: delete from ra_cust_trx_line_gl_dist where customer_trx_id = p_customer_trx_id;
378: delete from ar_payment_schedules where customer_trx_id = p_customer_trx_id;
379: delete from RA_CUST_TRX_LINE_SALESREPS where customer_trx_id = p_customer_trx_id;
380:

Line 410: delete from ra_customer_trx_lines

406: from ar_trx_errors_gt err,
407: ar_trx_header_gt th
408: where err.trx_header_id = th.trx_header_id);
409:
410: delete from ra_customer_trx_lines
411: where customer_trx_id in (
412: select distinct th.customer_trx_id
413: from ar_trx_errors_gt err,
414: ar_trx_header_gt th

Line 464: l_tax_line_rec ra_customer_trx_lines%rowtype;

460: l_gross_unit_selling_price number;
461: l_recalculate_tax_flag boolean;
462: l_status1 varchar2(100);
463: l_status varchar2(100);
464: l_tax_line_rec ra_customer_trx_lines%rowtype;
465: l_freight_line_rec ra_customer_trx_lines%rowtype;
466: l_ct_reference ra_customer_trx.ct_reference%type;
467: l_requery_tax_if_visible boolean;
468: l_batch_id NUMBER;

Line 465: l_freight_line_rec ra_customer_trx_lines%rowtype;

461: l_recalculate_tax_flag boolean;
462: l_status1 varchar2(100);
463: l_status varchar2(100);
464: l_tax_line_rec ra_customer_trx_lines%rowtype;
465: l_freight_line_rec ra_customer_trx_lines%rowtype;
466: l_ct_reference ra_customer_trx.ct_reference%type;
467: l_requery_tax_if_visible boolean;
468: l_batch_id NUMBER;
469: lc_request_id VARCHAR2(40);

Line 871: from ra_customer_trx_lines

867: FOR ar_trx_header_rec IN ar_trx_header_c
868: LOOP
869: l_creation_sign :=ar_trx_header_rec.CREATION_SIGN;
870: select sum(extended_amount) into l_amount
871: from ra_customer_trx_lines
872: where customer_trx_id=ar_trx_header_rec.CUSTOMER_TRX_ID;
873: ar_invoice_utils.debug('l_creation_sign:'||l_creation_sign);
874: ar_invoice_utils.debug('l_amount:'||l_amount);
875: ar_invoice_utils.debug('CUSTOMER_TRX_ID:'||ar_trx_header_rec.CUSTOMER_TRX_ID);