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_ETAX_UTIL dependencies on ZX_LINES

Line 157: to ZX lines to confirm that there is (or isnt) a

153: tax lines. Used Navigator to tweak for improved perf.
154:
155: 7) Added logic to preserve IL localization tax lines.
156: spoke with Ling (etax) and she said I need to join
157: to ZX lines to confirm that there is (or isnt) a
158: tax line over there. Just a value in tax_line_id is not
159: sufficient to guarantee that it is a migrated or native R12
160: tax line.
161:

Line 228: FROM ZX_LINES zxt,

224: zxt.tax_line_id,
225: inv_lin.customer_trx_line_id, -- invoice tax line id
226: inv_lin.customer_trx_id, -- inv trx_id, 5125882
227: plin.org_id
228: FROM ZX_LINES zxt,
229: RA_CUSTOMER_TRX_LINES plin,
230: ZX_LINES inv_zxt,
231: RA_CUSTOMER_TRX_LINES inv_lin
232: WHERE

Line 230: ZX_LINES inv_zxt,

226: inv_lin.customer_trx_id, -- inv trx_id, 5125882
227: plin.org_id
228: FROM ZX_LINES zxt,
229: RA_CUSTOMER_TRX_LINES plin,
230: ZX_LINES inv_zxt,
231: RA_CUSTOMER_TRX_LINES inv_lin
232: WHERE
233: zxt.application_id = 222
234: AND zxt.entity_code = 'TRANSACTIONS'

Line 270: that we can use the presence of lines in ZX_LINES as a basis

266: /* Procedure for removing tax lines from AR prior to calculate
267: and build_ar_tax_lines calls. This code was separated out so
268: we could delete from AR based on existing tax lines just before
269: calling calculate_tax (which recreates them in ZX). This means
270: that we can use the presence of lines in ZX_LINES as a basis
271: for our delete. So the intended flow is now like this:
272:
273: 1) call delete_tax_lines_from_ar
274: 2) call eTax calculate_tax

Line 297: ZX_LINES zx

293: DELETE FROM RA_CUST_TRX_LINE_GL_DIST gld
294: WHERE customer_trx_line_id in (
295: SELECT tl.customer_trx_line_id
296: FROM RA_CUSTOMER_TRX_LINES tl,
297: ZX_LINES zx
298: WHERE tl.customer_trx_id = p_customer_trx_id
299: AND tl.line_type = 'TAX'
300: AND tl.tax_line_id IS NOT NULL
301: AND tl.tax_line_id = zx.tax_line_id)

Line 311: /* NOTE: zx_lines_u2 uses only tax_line_id as key */

307: l_rows := SQL%ROWCOUNT;
308: arp_standard.debug(' Deleted tax dists = ' || l_rows);
309: END IF;
310:
311: /* NOTE: zx_lines_u2 uses only tax_line_id as key */
312:
313: DELETE FROM RA_CUSTOMER_TRX_LINES
314: WHERE customer_trx_id = p_customer_trx_id
315: AND line_type = 'TAX'

Line 318: FROM ZX_LINES);

314: WHERE customer_trx_id = p_customer_trx_id
315: AND line_type = 'TAX'
316: AND tax_line_id IN
317: (SELECT tax_line_id
318: FROM ZX_LINES);
319:
320: IF PG_DEBUG in ('Y', 'C') THEN
321: l_rows := SQL%ROWCOUNT;
322: arp_standard.debug(' Deleted tax lines = ' || l_rows);

Line 1133: | zx_lines to the corresponding LINE row in ra_customer_trx_lines.

Line 1166: zx_lines_det_factors zx

1162: nvl(tl.tax_classification_code, zx.output_tax_classification_code)
1163: from ra_customer_trx t,
1164: ra_customer_trx_lines tl,
1165: ra_cust_trx_types tt,
1166: zx_lines_det_factors zx
1167: where t.request_id = p_request_id
1168: and t.cust_trx_type_id = tt.cust_trx_type_id
1169: and t.org_id = tt.org_id
1170: and tt.type = p_phase

Line 1406: lines that are present in zx_lines for the given adjustment. There

1402: associated with adjustments or discounts */
1403:
1404: /* Dev Note: I debated adding the line_id to this call - but
1405: I dont think it is necessary. These routines only process the
1406: lines that are present in zx_lines for the given adjustment. There
1407: is no expectation that the same adj would be processed more than once.
1408: */
1409:
1410: /* 4607809 - The call to arp_det_dist_pkg requires that the RA row

Line 1546: zx_lines zx,

1542: DECODE(l_mode, 'ADJUST', zx.tax_amt, NULL),
1543: DECODE(l_mode, 'EDISC', zx.tax_amt, NULL),
1544: DECODE(l_mode, 'UNEDISC',zx.tax_amt, NULL)
1545: FROM
1546: zx_lines zx,
1547: ra_customer_trx_lines tl
1548: WHERE
1549: zx.application_id = p_transaction_rec.application_id
1550: AND zx.entity_code = p_transaction_rec.entity_code

Line 1597: zx_lines zx,

1593: sum(zx.tax_amt), NULL),
1594: DECODE(l_mode, 'UNEDISC',max(zx.line_amt) -
1595: sum(zx.tax_amt), NULL)
1596: FROM
1597: zx_lines zx,
1598: ra_customer_trx_lines il
1599: WHERE
1600: zx.application_id = p_transaction_rec.application_id
1601: AND zx.entity_code = p_transaction_rec.entity_code

Line 2161: FROM zx_lines

2157: CURSOR tax_lines(p_entity VARCHAR2, p_event_class VARCHAR2,
2158: p_trx_id NUMBER, p_trx_line_id NUMBER,
2159: p_mode VARCHAR2) IS
2160: SELECT adjusted_doc_line_id, SUM(tax_amt) tax_amt, MAX(line_amt) line_amt
2161: FROM zx_lines
2162: WHERE application_id = 222
2163: AND entity_code = p_entity
2164: AND event_class_code = p_event_class
2165: AND trx_id = p_trx_id