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_ALL

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 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 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