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 1200: FROM RA_CUST_TRX_TYPES_ALL INV_TYPE

1196: -- to be calculated for each line.
1197: BEGIN
1198: SELECT INV_TYPE.TAX_CALCULATION_FLAG
1199: INTO l_tax_calculation_flag
1200: FROM RA_CUST_TRX_TYPES_ALL INV_TYPE
1201: WHERE INV_TYPE.CUST_TRX_TYPE_ID = zx_global_structures_pkg.trx_line_dist_tbl.receivables_trx_type_id(l_index)
1202: AND ORG_ID = zx_global_structures_pkg.trx_line_dist_tbl.internal_organization_id(l_index);
1203: EXCEPTION
1204: WHEN OTHERS THEN

Line 1817: from ra_cust_trx_types_all

1813:
1814: /* BugFix 2057800: add this cursor to check the trx type.*/
1815: CURSOR c_chk_trx_type (c_trx_type_id IN NUMBER) IS
1816: select type
1817: from ra_cust_trx_types_all
1818: where cust_trx_type_id = c_trx_type_id
1819: and org_id = sysinfo.sysparam.org_id;
1820:
1821: l_tax_info_rec tax_info_rec_type;

Line 1822: l_trx_type ra_cust_trx_types.type%type;

1818: where cust_trx_type_id = c_trx_type_id
1819: and org_id = sysinfo.sysparam.org_id;
1820:
1821: l_tax_info_rec tax_info_rec_type;
1822: l_trx_type ra_cust_trx_types.type%type;
1823:
1824: BEGIN
1825:
1826: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 2186: l_trx_type ra_cust_trx_types.type%type;

2182: l_numOfRows NUMBER := 0;
2183: l_tax_info_out_rec_tbl_count NUMBER := 0;
2184: l_complete_flag VARCHAR2(1);
2185:
2186: l_trx_type ra_cust_trx_types.type%type;
2187: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
2188: l_tax_calculation_flag varchar2(1);
2189:
2190:

Line 2187: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

2183: l_tax_info_out_rec_tbl_count NUMBER := 0;
2184: l_complete_flag VARCHAR2(1);
2185:
2186: l_trx_type ra_cust_trx_types.type%type;
2187: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
2188: l_tax_calculation_flag varchar2(1);
2189:
2190:
2191: /* BugFix 2057800: add this cursor to check the trx type.*/

Line 2194: from ra_cust_trx_types_all

2190:
2191: /* BugFix 2057800: add this cursor to check the trx type.*/
2192: CURSOR c_chk_trx_type (c_trx_type_id IN NUMBER) IS
2193: select type
2194: from ra_cust_trx_types_all
2195: where cust_trx_type_id = c_trx_type_id
2196: and org_id = sysinfo.sysparam.org_id;
2197:
2198:

Line 2201: from ra_cust_trx_types_all ct

2197:
2198:
2199: cursor calculation_flag_csr(c_cust_trx_type_id in number) is
2200: select tax_calculation_flag
2201: from ra_cust_trx_types_all ct
2202: where ct.cust_trx_type_id = c_cust_trx_type_id
2203: and org_id = sysinfo.sysparam.org_id;
2204:
2205: BEGIN

Line 2417: ra_cust_trx_types_all trx_type,

2413:
2414: select inv_trx.trx_date
2415: into l_inv_trx_date
2416: from ra_customer_trx_all inv_trx,
2417: ra_cust_trx_types_all trx_type,
2418: ra_customer_trx_all trx
2419: where trx.cust_trx_type_id = trx_type.cust_trx_type_id
2420: and trx_type.type = 'CM'
2421: and trx_type.org_id = trx.org_id

Line 2430: ra_cust_trx_types_all trx_type,

2426:
2427: select inv_trx.trx_date
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'

Line 3717: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

3713: PROCEDURE prepare_tax_info_rec(
3714: p_index IN NUMBER
3715: )IS
3716:
3717: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
3718: l_location_structure_id ar_system_parameters.location_structure_id%type;
3719: l_location_segment_num number;
3720: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
3721: l_tax_rounding_allow_override

Line 3731: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;

3727: l_org_class hr_locations_all.global_attribute1%type;
3728: l_taxable_basis ar_vat_tax.taxable_basis%type;
3729: l_tax_calculation_plsql_block
3730: ar_vat_tax.tax_calculation_plsql_block%type;
3731: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
3732: l_tax_type ar_vat_tax.tax_type%type;
3733: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
3734: l_tax_category_id ar_vat_tax.global_attribute1%type;
3735: l_global_attribute5 mtl_system_items.global_attribute1%type;

Line 3868: FROM RA_CUST_TRX_TYPES_ALL INV_TYPE

3864: SELECT INV_TYPE.CUST_TRX_TYPE_ID,
3865: INV_TYPE.TAX_CALCULATION_FLAG
3866: INTO l_cust_trx_type_id,
3867: l_tax_calculation_flag
3868: FROM RA_CUST_TRX_TYPES_ALL INV_TYPE
3869: WHERE INV_TYPE.CUST_TRX_TYPE_ID = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.receivables_trx_type_id(p_index)
3870: AND ORG_ID = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.internal_organization_id(p_index);
3871:
3872: EXCEPTION