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.ARP_PROCESS_APPLICATION dependencies on RA_CUSTOMER_TRX_LINES

Line 9084: from ra_customer_trx_lines

9080: arp_debug.debug('Updating CM ard to stamp ref_prev_cust_trx_line_id');
9081:
9082: update ar_distributions ard
9083: set ref_prev_cust_trx_line_id = (select previous_customer_trx_line_id
9084: from ra_customer_trx_lines
9085: where customer_trx_line_id = ard.ref_customer_trx_line_id)
9086: where source_id = rec.source_id
9087: and source_table = 'RA'
9088: and ref_customer_trx_line_id in (select customer_trx_line_id

Line 9089: from ra_customer_trx_lines ctl_cm,

9085: where customer_trx_line_id = ard.ref_customer_trx_line_id)
9086: where source_id = rec.source_id
9087: and source_table = 'RA'
9088: and ref_customer_trx_line_id in (select customer_trx_line_id
9089: from ra_customer_trx_lines ctl_cm,
9090: ar_receivable_applications ra
9091: where ra.receivable_application_id = rec.source_id
9092: and ra.customer_trx_id = ctl_cm.customer_trx_id
9093: and ctl_cm.previous_customer_trx_line_id is not null);

Line 9110: from ra_customer_trx_lines ctl_inv,

9106: and ref_prev_cust_trx_line_id = ard.ref_customer_trx_line_id
9107: and rownum = 1)
9108: where source_id = rec.source_id
9109: and ref_customer_trx_line_id in (select customer_trx_line_id
9110: from ra_customer_trx_lines ctl_inv,
9111: ar_receivable_applications ra
9112: where ra.receivable_application_id = rec.source_id
9113: and ra.applied_customer_trx_id = ctl_inv.customer_trx_id);
9114: l_cnt := sql%rowcount;

Line 9129: update ra_customer_Trx_lines

9125: set previous_customer_Trx_id = NULL
9126: where customer_Trx_id = p_cust_trx_id
9127: and previous_customer_Trx_id = p_app_cust_trx_id;
9128:
9129: update ra_customer_Trx_lines
9130: set previous_customer_Trx_line_id = NULL,
9131: previous_customer_Trx_id = NULL -- Fix for Bug 6726394 (customer_trx_id
9132: where customer_Trx_id = p_cust_trx_id -- value has to be set to null in ra_customer_Trx_lines)
9133: and previous_customer_Trx_id = p_app_cust_trx_id;

Line 9132: where customer_Trx_id = p_cust_trx_id -- value has to be set to null in ra_customer_Trx_lines)

9128:
9129: update ra_customer_Trx_lines
9130: set previous_customer_Trx_line_id = NULL,
9131: previous_customer_Trx_id = NULL -- Fix for Bug 6726394 (customer_trx_id
9132: where customer_Trx_id = p_cust_trx_id -- value has to be set to null in ra_customer_Trx_lines)
9133: and previous_customer_Trx_id = p_app_cust_trx_id;
9134:
9135: /* Bug 9928392 - Remove association to invoice tax in etax tables */
9136: BEGIN