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 2290: from ra_customer_trx_lines_all cm

2286: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Calculate cm tax amount.');
2287: END IF;
2288: select cm.extended_amount, cm.quantity_credited
2289: into cm_line_amount, cm_line_qty
2290: from ra_customer_trx_lines_all cm
2291: where cm.customer_trx_line_id = tax_info_rec.customer_trx_line_id;
2292:
2293: select line.extended_amount,
2294: tax.extended_amount,

Line 2299: from ra_customer_trx_lines_all line,

2295: line.quantity_invoiced
2296: into orig_line_amount,
2297: orig_tax_amount,
2298: orig_line_qty
2299: from ra_customer_trx_lines_all line,
2300: ra_customer_trx_lines_all tax
2301: where tax.customer_trx_line_id = prev_ctlid
2302: and tax.link_to_cust_trx_line_id = line.customer_trx_line_id;
2303:

Line 2300: ra_customer_trx_lines_all tax

2296: into orig_line_amount,
2297: orig_tax_amount,
2298: orig_line_qty
2299: from ra_customer_trx_lines_all line,
2300: ra_customer_trx_lines_all tax
2301: where tax.customer_trx_line_id = prev_ctlid
2302: and tax.link_to_cust_trx_line_id = line.customer_trx_line_id;
2303:
2304:

Line 2357: from ra_customer_trx_lines_all line,

2353: --BugFix 2499050 Modified the expression in the following DECODE statement.
2354: cursor l_extended_amount_csr is
2355: select decode(nvl(prev_line.extended_amount,0), 0, 0,
2356: (line.extended_amount * nvl(prev_tax.taxable_amount,1))/ prev_line.extended_amount)
2357: from ra_customer_trx_lines_all line,
2358: ra_customer_trx_lines_all prev_line,
2359: ra_customer_trx_lines_all prev_tax
2360: where prev_tax.customer_trx_line_id = prev_ctlid and
2361: nvl(prev_tax.tax_vendor_return_code,tax_no_vendor) =

Line 2358: ra_customer_trx_lines_all prev_line,

2354: cursor l_extended_amount_csr is
2355: select decode(nvl(prev_line.extended_amount,0), 0, 0,
2356: (line.extended_amount * nvl(prev_tax.taxable_amount,1))/ prev_line.extended_amount)
2357: from ra_customer_trx_lines_all line,
2358: ra_customer_trx_lines_all prev_line,
2359: ra_customer_trx_lines_all prev_tax
2360: where prev_tax.customer_trx_line_id = prev_ctlid and
2361: nvl(prev_tax.tax_vendor_return_code,tax_no_vendor) =
2362: tax_no_vendor

Line 2359: ra_customer_trx_lines_all prev_tax

2355: select decode(nvl(prev_line.extended_amount,0), 0, 0,
2356: (line.extended_amount * nvl(prev_tax.taxable_amount,1))/ prev_line.extended_amount)
2357: from ra_customer_trx_lines_all line,
2358: ra_customer_trx_lines_all prev_line,
2359: ra_customer_trx_lines_all prev_tax
2360: where prev_tax.customer_trx_line_id = prev_ctlid and
2361: nvl(prev_tax.tax_vendor_return_code,tax_no_vendor) =
2362: tax_no_vendor
2363: and prev_tax.link_to_cust_trx_line_id = prev_line.customer_trx_line_id

Line 2432: ra_customer_trx_lines_all line

2428: into l_inv_trx_date
2429: from ra_customer_trx_all inv_trx,
2430: ra_cust_trx_types_all trx_type,
2431: ra_customer_trx_all trx,
2432: ra_customer_trx_lines_all line
2433: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
2434: and trx_type.type = 'CM'
2435: and trx_type.org_id = trx.org_id
2436: and trx.previous_customer_trx_id = inv_trx.customer_trx_id

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

2465: END IF;
2466:
2467: tax_rec_tbl.delete;
2468: --
2469: -- Clear the table of record of type ra_customer_trx_lines%rowtype
2470: --
2471: tax_info_rec_tbl.delete;
2472:
2473: --

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

2730: 'Y');
2731: -- End Line Level Rounding
2732:
2733: /********************************************************************************
2734: | For each line calculated, store that line in the ra_customer_trx_lines table |
2735: ********************************************************************************/
2736:
2737: IF (g_level_statement >= g_current_runtime_level) THEN
2738: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','store values into tax_rec_tbl( '||to_char(x)||' ) +');

Line 2957: l_tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE;

2953: | 28-DEC-2004 Nilesh Patel Created. |
2954: | |
2955: *----------------------------------------------------------------------------*/
2956: PROCEDURE arp_tax_calculate IS
2957: l_tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE;
2958: l_use_tax_rate_passed BOOLEAN := FALSE; -- Bugfix 370068, 370265
2959: l_use_tax_vendor BOOLEAN;
2960: l_batch_tax_rate_rule ra_batch_sources.invalid_tax_rate_rule%type;
2961: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;

Line 2961: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;

2957: l_tax_vendor_return_code ra_customer_trx_lines.tax_vendor_return_code%TYPE;
2958: l_use_tax_rate_passed BOOLEAN := FALSE; -- Bugfix 370068, 370265
2959: l_use_tax_vendor BOOLEAN;
2960: l_batch_tax_rate_rule ra_batch_sources.invalid_tax_rate_rule%type;
2961: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
2962: l_precision fnd_currencies.precision%TYPE;
2963: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
2964:
2965: CURSOR get_vat_tax_id(c_sob_id NUMBER,

Line 5997: | ra_customer_Trx_lines into named columns trx_busoness_category, |

5993: | copy_lte_gdfs |
5994: | |
5995: | DESCRIPTION |
5996: | This procedure copies the global attribute columns from |
5997: | ra_customer_Trx_lines into named columns trx_busoness_category, |
5998: | product_category and product_fiscal_class for Latin Tax Engine |
5999: | |
6000: | This procedure should be called by Receivables at the time of |
6001: | populating eBTax Global Temporary tables zx_trx_headers_gt and |

Line 6038: ra_customer_trx_lines_all ratrxlines

6034: FROM
6035: zx_transaction_lines_gt Lines,
6036: --zx_trx_headers_gt Headers,
6037: zx_evnt_cls_mappings event,
6038: ra_customer_trx_lines_all ratrxlines
6039: WHERE
6040: lines.application_id = 222
6041: AND lines.application_id = event.application_id
6042: AND lines.entity_code = event.entity_code

Line 6069: ra_customer_trx_lines_all ratrxlines

6065: FROM
6066: zx_transaction_lines_gt Lines,
6067: --zx_trx_headers_gt Headers,
6068: zx_evnt_cls_mappings event,
6069: ra_customer_trx_lines_all ratrxlines
6070: WHERE
6071: lines.application_id = 222
6072: AND lines.application_id = event.application_id
6073: AND lines.entity_code = event.entity_code