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

Line 2609: from ra_customer_trx_lines_all cm

2605: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Calculate cm tax amount.');
2606: END IF;
2607: select cm.extended_amount, cm.quantity_credited
2608: into cm_line_amount, cm_line_qty
2609: from ra_customer_trx_lines_all cm
2610: where cm.customer_trx_line_id = tax_info_rec.customer_trx_line_id;
2611:
2612: select line.extended_amount,
2613: tax.extended_amount,

Line 2618: from ra_customer_trx_lines_all line,

2614: line.quantity_invoiced
2615: into orig_line_amount,
2616: orig_tax_amount,
2617: orig_line_qty
2618: from ra_customer_trx_lines_all line,
2619: ra_customer_trx_lines_all tax
2620: where tax.customer_trx_line_id = prev_ctlid
2621: and tax.link_to_cust_trx_line_id = line.customer_trx_line_id;
2622:

Line 2619: ra_customer_trx_lines_all tax

2615: into orig_line_amount,
2616: orig_tax_amount,
2617: orig_line_qty
2618: from ra_customer_trx_lines_all line,
2619: ra_customer_trx_lines_all tax
2620: where tax.customer_trx_line_id = prev_ctlid
2621: and tax.link_to_cust_trx_line_id = line.customer_trx_line_id;
2622:
2623:

Line 2676: from ra_customer_trx_lines_all line,

2672: --BugFix 2499050 Modified the expression in the following DECODE statement.
2673: cursor l_extended_amount_csr is
2674: select decode(nvl(prev_line.extended_amount,0), 0, 0,
2675: (line.extended_amount * nvl(prev_tax.taxable_amount,1))/ prev_line.extended_amount)
2676: from ra_customer_trx_lines_all line,
2677: ra_customer_trx_lines_all prev_line,
2678: ra_customer_trx_lines_all prev_tax
2679: where prev_tax.customer_trx_line_id = prev_ctlid and
2680: nvl(prev_tax.tax_vendor_return_code,tax_no_vendor) =

Line 2677: ra_customer_trx_lines_all prev_line,

2673: cursor l_extended_amount_csr is
2674: select decode(nvl(prev_line.extended_amount,0), 0, 0,
2675: (line.extended_amount * nvl(prev_tax.taxable_amount,1))/ prev_line.extended_amount)
2676: from ra_customer_trx_lines_all line,
2677: ra_customer_trx_lines_all prev_line,
2678: ra_customer_trx_lines_all prev_tax
2679: where prev_tax.customer_trx_line_id = prev_ctlid and
2680: nvl(prev_tax.tax_vendor_return_code,tax_no_vendor) =
2681: tax_no_vendor

Line 2678: ra_customer_trx_lines_all prev_tax

2674: select decode(nvl(prev_line.extended_amount,0), 0, 0,
2675: (line.extended_amount * nvl(prev_tax.taxable_amount,1))/ prev_line.extended_amount)
2676: from ra_customer_trx_lines_all line,
2677: ra_customer_trx_lines_all prev_line,
2678: ra_customer_trx_lines_all prev_tax
2679: where prev_tax.customer_trx_line_id = prev_ctlid and
2680: nvl(prev_tax.tax_vendor_return_code,tax_no_vendor) =
2681: tax_no_vendor
2682: and prev_tax.link_to_cust_trx_line_id = prev_line.customer_trx_line_id

Line 2751: ra_customer_trx_lines_all line

2747: into l_inv_trx_date
2748: from ra_customer_trx_all inv_trx,
2749: ra_cust_trx_types_all trx_type,
2750: ra_customer_trx_all trx,
2751: ra_customer_trx_lines_all line
2752: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
2753: and trx_type.type = 'CM'
2754: and trx_type.org_id = trx.org_id
2755: and trx.previous_customer_trx_id = inv_trx.customer_trx_id

Line 2788: -- Clear the table of record of type ra_customer_trx_lines%rowtype

2784: END IF;
2785:
2786: tax_rec_tbl.delete;
2787: --
2788: -- Clear the table of record of type ra_customer_trx_lines%rowtype
2789: --
2790: tax_info_rec_tbl.delete;
2791:
2792: --

Line 3052: | For each line calculated, store that line in the ra_customer_trx_lines table |

3048: 'Y');
3049: -- End Line Level Rounding
3050:
3051: /********************************************************************************
3052: | For each line calculated, store that line in the ra_customer_trx_lines table |
3053: ********************************************************************************/
3054:
3055: IF (g_level_statement >= g_current_runtime_level) THEN
3056: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','store values into tax_rec_tbl( '||to_char(x)||' ) +');

Line 3275: l_tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE;

3271: | 28-DEC-2004 Nilesh Patel Created. |
3272: | |
3273: *----------------------------------------------------------------------------*/
3274: PROCEDURE arp_tax_calculate IS
3275: l_tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE;
3276: l_use_tax_rate_passed BOOLEAN := FALSE; -- Bugfix 370068, 370265
3277: l_use_tax_vendor BOOLEAN;
3278: l_batch_tax_rate_rule ra_batch_sources.invalid_tax_rate_rule%type;
3279: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;

Line 3279: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;

3275: l_tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE;
3276: l_use_tax_rate_passed BOOLEAN := FALSE; -- Bugfix 370068, 370265
3277: l_use_tax_vendor BOOLEAN;
3278: l_batch_tax_rate_rule ra_batch_sources.invalid_tax_rate_rule%type;
3279: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3280: l_precision fnd_currencies.precision%TYPE;
3281: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
3282:
3283: CURSOR get_vat_tax_id(c_sob_id NUMBER,

Line 6403: | ra_customer_Trx_lines into named columns trx_busoness_category, |

6399: | copy_lte_gdfs |
6400: | |
6401: | DESCRIPTION |
6402: | This procedure copies the global attribute columns from |
6403: | ra_customer_Trx_lines into named columns trx_busoness_category, |
6404: | product_category and product_fiscal_class for Latin Tax Engine |
6405: | |
6406: | This procedure should be called by Receivables at the time of |
6407: | populating eBTax Global Temporary tables zx_trx_headers_gt and |

Line 6446: ra_customer_trx_lines_all ratrxlines

6442: FROM
6443: zx_transaction_lines_gt Lines,
6444: --zx_trx_headers_gt Headers,
6445: zx_evnt_cls_mappings event,
6446: ra_customer_trx_lines_all ratrxlines
6447: WHERE
6448: lines.application_id = 222
6449: AND lines.application_id = event.application_id
6450: AND lines.entity_code = event.entity_code

Line 6482: ra_customer_trx_lines_all ratrxlines

6478: FROM
6479: zx_transaction_lines_gt Lines,
6480: --zx_trx_headers_gt Headers,
6481: zx_evnt_cls_mappings event,
6482: ra_customer_trx_lines_all ratrxlines
6483: WHERE
6484: lines.application_id = 222
6485: AND lines.application_id = event.application_id
6486: AND lines.entity_code = event.entity_code