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 158: to ZX lines to confirm that there is (or isnt) a

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

Line 229: FROM ZX_LINES zxt,

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

Line 231: ZX_LINES inv_zxt,

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

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

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

Line 322: ZX_LINES zx

318: DELETE FROM RA_CUST_TRX_LINE_GL_DIST gld
319: WHERE customer_trx_line_id in (
320: SELECT tl.customer_trx_line_id
321: FROM RA_CUSTOMER_TRX_LINES tl,
322: ZX_LINES zx
323: WHERE tl.customer_trx_id = p_customer_trx_id
324: AND tl.line_type = 'TAX'
325: AND tl.tax_line_id IS NOT NULL
326: AND tl.tax_line_id = zx.tax_line_id)

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

332: l_rows := SQL%ROWCOUNT;
333: debug(' Deleted tax dists = ' || l_rows);
334: END IF;
335:
336: /* NOTE: zx_lines_u2 uses only tax_line_id as key */
337:
338: DELETE FROM RA_CUSTOMER_TRX_LINES
339: WHERE customer_trx_id = p_customer_trx_id
340: AND line_type = 'TAX'

Line 343: FROM ZX_LINES);

339: WHERE customer_trx_id = p_customer_trx_id
340: AND line_type = 'TAX'
341: AND tax_line_id IN
342: (SELECT tax_line_id
343: FROM ZX_LINES);
344:
345: IF PG_DEBUG in ('Y', 'C') THEN
346: l_rows := SQL%ROWCOUNT;
347: debug(' Deleted tax lines = ' || l_rows);

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

Line 1206: zx_lines_det_factors zx

1202: tl.customer_trx_line_id,
1203: nvl(tl.tax_classification_code, zx.output_tax_classification_code)
1204: from ra_customer_trx t,
1205: ra_customer_trx_lines tl,
1206: zx_lines_det_factors zx
1207: where t.request_id = p_request_id
1208: and t.customer_trx_id = tl.customer_trx_id
1209: and tl.line_type = 'LINE'
1210: and tl.request_id = p_request_id

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

1466: associated with adjustments or discounts */
1467:
1468: /* Dev Note: I debated adding the line_id to this call - but
1469: I dont think it is necessary. These routines only process the
1470: lines that are present in zx_lines for the given adjustment. There
1471: is no expectation that the same adj would be processed more than once.
1472: */
1473:
1474: /* 4607809 - The call to arp_det_dist_pkg requires that the RA row

Line 1610: zx_lines zx,

1606: DECODE(l_mode, 'ADJUST', zx.tax_amt, NULL),
1607: DECODE(l_mode, 'EDISC', zx.tax_amt, NULL),
1608: DECODE(l_mode, 'UNEDISC',zx.tax_amt, NULL)
1609: FROM
1610: zx_lines zx,
1611: ra_customer_trx_lines tl
1612: WHERE
1613: zx.application_id = p_transaction_rec.application_id
1614: AND zx.entity_code = p_transaction_rec.entity_code

Line 1661: zx_lines zx,

1657: sum(zx.tax_amt), NULL),
1658: DECODE(l_mode, 'UNEDISC',max(zx.line_amt) -
1659: sum(zx.tax_amt), NULL)
1660: FROM
1661: zx_lines zx,
1662: ra_customer_trx_lines il
1663: WHERE
1664: zx.application_id = p_transaction_rec.application_id
1665: AND zx.entity_code = p_transaction_rec.entity_code

Line 2231: FROM zx_lines

2227: CURSOR tax_lines(p_entity VARCHAR2, p_event_class VARCHAR2,
2228: p_trx_id NUMBER, p_trx_line_id NUMBER,
2229: p_mode VARCHAR2) IS
2230: SELECT adjusted_doc_line_id, SUM(tax_amt) tax_amt, MAX(line_amt) line_amt
2231: FROM zx_lines
2232: WHERE application_id = 222
2233: AND entity_code = p_entity
2234: AND event_class_code = p_event_class
2235: AND trx_id = p_trx_id