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.OKS_TAX_UTIL_PVT dependencies on ZX_ID_TCC_MAPPING

Line 238: FROM ZX_ID_TCC_MAPPING

234: --end npalepu
235:
236: CURSOR tax_code_csr(cp_tax_code VARCHAR2) IS
237: SELECT TAX_CLASSIFICATION_CODE
238: FROM ZX_ID_TCC_MAPPING
239: WHERE TAX_RATE_CODE_ID = cp_tax_code
240: AND source = 'AR';
241: l_tax_code ZX_ID_TCC_MAPPING.TAX_CLASSIFICATION_CODE%TYPE;
242:

Line 241: l_tax_code ZX_ID_TCC_MAPPING.TAX_CLASSIFICATION_CODE%TYPE;

237: SELECT TAX_CLASSIFICATION_CODE
238: FROM ZX_ID_TCC_MAPPING
239: WHERE TAX_RATE_CODE_ID = cp_tax_code
240: AND source = 'AR';
241: l_tax_code ZX_ID_TCC_MAPPING.TAX_CLASSIFICATION_CODE%TYPE;
242:
243:
244: CURSOR cust_acct_csr(cp_site_use_id NUMBER) IS
245: SELECT ACCT_SITE_SHIP.CUST_ACCOUNT_ID

Line 388: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.classification_code_old','classification code from ZX_ID_TCC_MAPPING, l_tax_code='|| l_tax_code);

384:
385: px_rail_rec.TAX_CLASSIFICATION_CODE := l_tax_code;
386:
387: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
388: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.classification_code_old','classification code from ZX_ID_TCC_MAPPING, l_tax_code='|| l_tax_code);
389: END IF;
390:
391: END IF; --of IF tax_code_csr%FOUND THEN
392: CLOSE tax_code_csr;

Line 639: FROM ZX_ID_TCC_MAPPING

635: --end npalepu
636:
637: CURSOR tax_code_csr(cp_tax_code VARCHAR2) IS
638: SELECT TAX_CLASSIFICATION_CODE
639: FROM ZX_ID_TCC_MAPPING
640: WHERE TAX_RATE_CODE_ID = cp_tax_code
641: AND source = 'AR';
642: l_tax_code ZX_ID_TCC_MAPPING.TAX_CLASSIFICATION_CODE%TYPE;
643:

Line 642: l_tax_code ZX_ID_TCC_MAPPING.TAX_CLASSIFICATION_CODE%TYPE;

638: SELECT TAX_CLASSIFICATION_CODE
639: FROM ZX_ID_TCC_MAPPING
640: WHERE TAX_RATE_CODE_ID = cp_tax_code
641: AND source = 'AR';
642: l_tax_code ZX_ID_TCC_MAPPING.TAX_CLASSIFICATION_CODE%TYPE;
643:
644: CURSOR cur_address(cp_site_use_id IN VARCHAR2, cp_code VARCHAR2) IS
645: SELECT CS.SITE_USE_ID, CS.ORG_ID, CA.CUST_ACCOUNT_ID, CA.CUST_ACCT_SITE_ID
646: FROM HZ_CUST_SITE_USES_ALL CS, HZ_CUST_ACCT_SITES_ALL CA

Line 2475: FROM ZX_ID_TCC_MAPPING_ALL zx /* npalepu replaced ZX_ID_TCC_MAPPING with ZX_ID_TCC_MAPPING_ALL on 29-jun-2006 for bug # 4908543 */

2471: set TAX_CLASSIFICATION_CODE = (CASE WHEN oks1.TAX_CODE IS NOT NULL
2472: AND oks1.TAX_CLASSIFICATION_CODE IS NULL
2473: THEN
2474: (SELECT zx.TAX_CLASSIFICATION_CODE
2475: FROM ZX_ID_TCC_MAPPING_ALL zx /* npalepu replaced ZX_ID_TCC_MAPPING with ZX_ID_TCC_MAPPING_ALL on 29-jun-2006 for bug # 4908543 */
2476: WHERE zx.TAX_RATE_CODE_ID = oks1.TAX_CODE
2477: AND zx.SOURCE = 'AR')
2478: --npalepu added on 29-jun-2006 for bug # 4908543
2479: WHEN (oks1.TAX_EXEMPTION_ID IS NOT NULL)

Line 2615: FROM ZX_ID_TCC_MAPPING_ALL zx /* npalepu replaced ZX_ID_TCC_MAPPING with ZX_ID_TCC_MAPPING_ALL on 29-jun-2006 for bug # 4908543 */

2611: set TAX_CLASSIFICATION_CODE = (CASE WHEN oks1.TAX_CODE IS NOT NULL
2612: AND oks1.TAX_CLASSIFICATION_CODE IS NULL
2613: THEN
2614: (SELECT zx.TAX_CLASSIFICATION_CODE
2615: FROM ZX_ID_TCC_MAPPING_ALL zx /* npalepu replaced ZX_ID_TCC_MAPPING with ZX_ID_TCC_MAPPING_ALL on 29-jun-2006 for bug # 4908543 */
2616: WHERE zx.TAX_RATE_CODE_ID = oks1.TAX_CODE
2617: AND zx.SOURCE = 'AR')
2618: --npalepu added on 29-jun-2006 for bug # 4908543
2619: WHEN (oks1.TAX_EXEMPTION_ID IS NOT NULL)