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_CUST_TRX_TYPES

Line 1398: FROM RA_CUST_TRX_TYPES_ALL INV_TYPE

1394: -- to be calculated for each line.
1395: BEGIN
1396: SELECT INV_TYPE.TAX_CALCULATION_FLAG
1397: INTO l_tax_calculation_flag
1398: FROM RA_CUST_TRX_TYPES_ALL INV_TYPE
1399: WHERE INV_TYPE.CUST_TRX_TYPE_ID = zx_global_structures_pkg.trx_line_dist_tbl.receivables_trx_type_id(l_index)
1400: AND ORG_ID = zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(l_index);
1401: EXCEPTION
1402: WHEN OTHERS THEN

Line 1722: FROM RA_CUST_TRX_TYPES_ALL INV_TYPE

1718:
1719: BEGIN
1720: SELECT INV_TYPE.TAX_CALCULATION_FLAG
1721: INTO l_tax_calculation_flag
1722: FROM RA_CUST_TRX_TYPES_ALL INV_TYPE
1723: WHERE INV_TYPE.CUST_TRX_TYPE_ID = zx_global_structures_pkg.trx_line_dist_tbl.receivables_trx_type_id(l_index)
1724: AND ORG_ID = zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(l_index);
1725: EXCEPTION
1726: WHEN OTHERS THEN

Line 2134: from ra_cust_trx_types_all

2130:
2131: /* BugFix 2057800: add this cursor to check the trx type.*/
2132: CURSOR c_chk_trx_type (c_trx_type_id IN NUMBER) IS
2133: select type
2134: from ra_cust_trx_types_all
2135: where cust_trx_type_id = c_trx_type_id
2136: and org_id = sysinfo.sysparam.org_id;
2137:
2138: l_tax_info_rec tax_info_rec_type;

Line 2139: l_trx_type ra_cust_trx_types.type%type;

2135: where cust_trx_type_id = c_trx_type_id
2136: and org_id = sysinfo.sysparam.org_id;
2137:
2138: l_tax_info_rec tax_info_rec_type;
2139: l_trx_type ra_cust_trx_types.type%type;
2140:
2141: BEGIN
2142:
2143: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 2505: l_trx_type ra_cust_trx_types.type%type;

2501: l_numOfRows NUMBER := 0;
2502: l_tax_info_out_rec_tbl_count NUMBER := 0;
2503: l_complete_flag VARCHAR2(1);
2504:
2505: l_trx_type ra_cust_trx_types.type%type;
2506: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
2507: l_tax_calculation_flag varchar2(1);
2508:
2509:

Line 2506: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

2502: l_tax_info_out_rec_tbl_count NUMBER := 0;
2503: l_complete_flag VARCHAR2(1);
2504:
2505: l_trx_type ra_cust_trx_types.type%type;
2506: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
2507: l_tax_calculation_flag varchar2(1);
2508:
2509:
2510: /* BugFix 2057800: add this cursor to check the trx type.*/

Line 2513: from ra_cust_trx_types_all

2509:
2510: /* BugFix 2057800: add this cursor to check the trx type.*/
2511: CURSOR c_chk_trx_type (c_trx_type_id IN NUMBER) IS
2512: select type
2513: from ra_cust_trx_types_all
2514: where cust_trx_type_id = c_trx_type_id
2515: and org_id = sysinfo.sysparam.org_id;
2516:
2517:

Line 2520: from ra_cust_trx_types_all ct

2516:
2517:
2518: cursor calculation_flag_csr(c_cust_trx_type_id in number) is
2519: select tax_calculation_flag
2520: from ra_cust_trx_types_all ct
2521: where ct.cust_trx_type_id = c_cust_trx_type_id
2522: and org_id = sysinfo.sysparam.org_id;
2523:
2524: BEGIN

Line 2736: ra_cust_trx_types_all trx_type,

2732:
2733: select inv_trx.trx_date
2734: into l_inv_trx_date
2735: from ra_customer_trx_all inv_trx,
2736: ra_cust_trx_types_all trx_type,
2737: ra_customer_trx_all trx
2738: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
2739: and trx_type.type = 'CM'
2740: and trx_type.org_id = trx.org_id

Line 2749: ra_cust_trx_types_all trx_type,

2745:
2746: select inv_trx.trx_date
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'

Line 4039: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

4035: PROCEDURE prepare_tax_info_rec(
4036: p_index IN NUMBER
4037: )IS
4038:
4039: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
4040: l_location_structure_id ar_system_parameters.location_structure_id%type;
4041: l_location_segment_num number;
4042: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
4043: l_tax_rounding_allow_override

Line 4053: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;

4049: l_org_class hr_locations_all.global_attribute1%type;
4050: l_taxable_basis ar_vat_tax.taxable_basis%type;
4051: l_tax_calculation_plsql_block
4052: ar_vat_tax.tax_calculation_plsql_block%type;
4053: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
4054: l_tax_type ar_vat_tax.tax_type%type;
4055: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
4056: l_tax_category_id ar_vat_tax.global_attribute1%type;
4057: l_global_attribute5 mtl_system_items.global_attribute1%type;

Line 4199: FROM RA_CUST_TRX_TYPES_ALL INV_TYPE

4195: SELECT INV_TYPE.CUST_TRX_TYPE_ID,
4196: INV_TYPE.TAX_CALCULATION_FLAG
4197: INTO l_cust_trx_type_id,
4198: l_tax_calculation_flag
4199: FROM RA_CUST_TRX_TYPES_ALL INV_TYPE
4200: WHERE INV_TYPE.CUST_TRX_TYPE_ID = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.receivables_trx_type_id(p_index)
4201: AND ORG_ID = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index);
4202:
4203: EXCEPTION