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.JL_ZZ_TAX dependencies on AR_VAT_TAX

Line 281: from ar_vat_tax vt

277: FROM mtl_system_items si
278: WHERE si.inventory_item_id = p_inventory_item_id
279: AND si.organization_id = p_inventory_organization_id
280: AND exists (select 1
281: from ar_vat_tax vt
282: WHERE vt.tax_code = si.tax_code
283: AND vt.tax_type = 'VAT'
284: AND decode(ltrim(vt.global_attribute1, '0123456789'),
285: null, to_number(vt.global_attribute1), null) =

Line 296: ,ar_vat_tax vt

292: SELECT tg.tax_code,
293: NULL,
294: si.inventory_item_id
295: FROM mtl_system_items si
296: ,ar_vat_tax vt
297: ,jl_zz_ar_tx_groups tg
298: ,ar_vat_tax vt1
299: WHERE si.inventory_item_id = p_inventory_item_id
300: AND si.organization_id = p_inventory_organization_id

Line 298: ,ar_vat_tax vt1

294: si.inventory_item_id
295: FROM mtl_system_items si
296: ,ar_vat_tax vt
297: ,jl_zz_ar_tx_groups tg
298: ,ar_vat_tax vt1
299: WHERE si.inventory_item_id = p_inventory_item_id
300: AND si.organization_id = p_inventory_organization_id
301: AND si.tax_code = vt.tax_code
302: AND vt.tax_type = 'TAX_GROUP'

Line 326: from ar_vat_tax vt

322: FROM hz_cust_accounts c
323: WHERE c.cust_account_id = NVL(p_ship_to_customer_id,
324: p_bill_to_customer_id)
325: AND exists (select 1
326: from ar_vat_tax vt
327: WHERE c.tax_code = vt.tax_code
328: AND vt.tax_type = 'VAT'
329: AND decode(ltrim(vt.global_attribute1,
330: '0123456789'),

Line 343: ,ar_vat_tax vt

339: SELECT tg.tax_code,
340: NULL,
341: c.cust_account_id
342: FROM hz_cust_accounts c
343: ,ar_vat_tax vt
344: ,jl_zz_ar_tx_groups tg
345: ,ar_vat_tax vt1
346: WHERE c.cust_account_id = NVL(p_ship_to_customer_id,
347: p_bill_to_customer_id)

Line 345: ,ar_vat_tax vt1

341: c.cust_account_id
342: FROM hz_cust_accounts c
343: ,ar_vat_tax vt
344: ,jl_zz_ar_tx_groups tg
345: ,ar_vat_tax vt1
346: WHERE c.cust_account_id = NVL(p_ship_to_customer_id,
347: p_bill_to_customer_id)
348: AND c.tax_code = vt.tax_code
349: AND vt.tax_type = 'TAX_GROUP'

Line 371: from ar_vat_tax vt

367: su.site_use_id
368: FROM hz_cust_site_uses su
369: WHERE su.site_use_id = p_bill_to_site_use_id
370: AND exists (select 1
371: from ar_vat_tax vt
372: WHERE su.tax_code = vt.tax_code
373: AND vt.tax_type = 'VAT'
374: AND decode(ltrim(vt.global_attribute1,
375: '0123456789'),

Line 387: ,ar_vat_tax vt

383: SELECT tg.tax_code,
384: NULL,
385: su.site_use_id
386: FROM hz_cust_site_uses su
387: ,ar_vat_tax vt
388: ,jl_zz_ar_tx_groups tg
389: ,ar_vat_tax vt1
390: WHERE su.site_use_id = p_bill_to_site_use_id
391: AND su.tax_code = vt.tax_code

Line 389: ,ar_vat_tax vt1

385: su.site_use_id
386: FROM hz_cust_site_uses su
387: ,ar_vat_tax vt
388: ,jl_zz_ar_tx_groups tg
389: ,ar_vat_tax vt1
390: WHERE su.site_use_id = p_bill_to_site_use_id
391: AND su.tax_code = vt.tax_code
392: AND vt.tax_type = 'TAX_GROUP'
393: AND tg.group_tax_id = vt.vat_tax_id

Line 414: from ar_vat_tax vt

410: su.site_use_id
411: FROM hz_cust_site_uses su
412: WHERE su.site_use_id = p_ship_to_site_use_id
413: AND exists (select 1
414: from ar_vat_tax vt
415: WHERE su.tax_code = vt.tax_code
416: AND vt.tax_type = 'VAT'
417: AND decode(ltrim(vt.global_attribute1,
418: '0123456789'),null,

Line 430: ,ar_vat_tax vt

426: SELECT tg.tax_code,
427: NULL,
428: su.site_use_id
429: FROM hz_cust_site_uses su
430: ,ar_vat_tax vt
431: ,jl_zz_ar_tx_groups tg
432: ,ar_vat_tax vt1
433: WHERE su.site_use_id = p_ship_to_site_use_id
434: AND su.tax_code = vt.tax_code

Line 432: ,ar_vat_tax vt1

428: su.site_use_id
429: FROM hz_cust_site_uses su
430: ,ar_vat_tax vt
431: ,jl_zz_ar_tx_groups tg
432: ,ar_vat_tax vt1
433: WHERE su.site_use_id = p_ship_to_site_use_id
434: AND su.tax_code = vt.tax_code
435: AND vt.tax_type = 'TAX_GROUP'
436: AND tg.group_tax_id = vt.vat_tax_id

Line 457: from ar_vat_tax vt

453: p_ship_from_warehouse_id
454: FROM hr_locations_all hrl
455: WHERE hrl.location_id = p_warehouse_location_id
456: AND exists (select 1
457: from ar_vat_tax vt
458: WHERE hrl.global_attribute6 = vt.tax_code
459: AND vt.tax_type = 'VAT'
460: AND decode(ltrim(vt.global_attribute1,'0123456789'),
461: null, to_number(vt.global_attribute1),

Line 479: from ar_vat_tax vt1,

475: AND tg.establishment_type = p_establishment_type
476: AND p_trx_date <= tg.end_date_active
477: AND p_trx_date >= NVL(tg.start_date_active, p_trx_date)
478: AND exists (select 1
479: from ar_vat_tax vt1,
480: ar_vat_tax vt,
481: hr_locations_all hrl
482: WHERE hrl.location_id = p_warehouse_location_id
483: AND hrl.global_attribute6 = vt.tax_code

Line 480: ar_vat_tax vt,

476: AND p_trx_date <= tg.end_date_active
477: AND p_trx_date >= NVL(tg.start_date_active, p_trx_date)
478: AND exists (select 1
479: from ar_vat_tax vt1,
480: ar_vat_tax vt,
481: hr_locations_all hrl
482: WHERE hrl.location_id = p_warehouse_location_id
483: AND hrl.global_attribute6 = vt.tax_code
484: AND vt.tax_type = 'TAX_GROUP'

Line 498: ,ar_vat_tax vt

494: SELECT sp.tax_classification_code,
495: NULL,
496: NULL
497: FROM zx_product_options sp
498: ,ar_vat_tax vt
499: WHERE sp.application_id = 222
500: AND sp.org_id = vt.org_id
501: AND sp.tax_classification_code = vt.tax_code
502: AND vt.tax_type = 'VAT'

Line 521: from ar_vat_tax vt1

517: AND tg.establishment_type = p_establishment_type
518: AND p_trx_date <= tg.end_date_active
519: AND p_trx_date >= NVL(tg.start_date_active, p_trx_date)
520: AND exists (select 1
521: from ar_vat_tax vt1
522: ,ar_vat_tax vt
523: ,zx_product_options sp
524: WHERE sp.tax_classification_code = vt.tax_code
525: AND sp.application_id = 222

Line 522: ,ar_vat_tax vt

518: AND p_trx_date <= tg.end_date_active
519: AND p_trx_date >= NVL(tg.start_date_active, p_trx_date)
520: AND exists (select 1
521: from ar_vat_tax vt1
522: ,ar_vat_tax vt
523: ,zx_product_options sp
524: WHERE sp.tax_classification_code = vt.tax_code
525: AND sp.application_id = 222
526: AND sp.org_id = vt.org_id

Line 543: from ar_vat_tax vt

539: ml.memo_line_id
540: FROM ar_memo_lines ml
541: WHERE ml.memo_line_id = p_memo_line_id
542: AND exists (select 1
543: from ar_vat_tax vt
544: WHERE ml.tax_code = vt.tax_code
545: AND vt.tax_type = 'VAT'
546: AND decode(ltrim(vt.global_attribute1,
547: '0123456789'), null,

Line 559: ,ar_vat_tax vt

555: SELECT tg.tax_code,
556: NULL,
557: ml.memo_line_id
558: FROM ar_memo_lines ml
559: ,ar_vat_tax vt
560: ,jl_zz_ar_tx_groups tg
561: ,ar_vat_tax vt1
562: WHERE memo_line_id = p_memo_line_id
563: AND ml.tax_code = vt.tax_code

Line 561: ,ar_vat_tax vt1

557: ml.memo_line_id
558: FROM ar_memo_lines ml
559: ,ar_vat_tax vt
560: ,jl_zz_ar_tx_groups tg
561: ,ar_vat_tax vt1
562: WHERE memo_line_id = p_memo_line_id
563: AND ml.tax_code = vt.tax_code
564: AND vt.tax_type = 'TAX_GROUP'
565: AND tg.group_tax_id = vt.vat_tax_id

Line 1422: l_tax_code ar_vat_tax.tax_code%type;

1418: tr.rule;
1419:
1420: c_rule_default_rec c_rule_default%ROWTYPE;
1421:
1422: l_tax_code ar_vat_tax.tax_code%type;
1423: l_rule_data_id NUMBER;
1424:
1425:
1426: BEGIN

Line 2226: ,ar_vat_tax v1

2222: ,r1.customer_trx_id header_trx_id
2223: FROM ra_customer_trx r1
2224: ,ra_customer_trx_lines rl1
2225: ,ra_customer_trx_lines rlt1
2226: ,ar_vat_tax v1
2227: ,jl_zz_ar_tx_att_cls tcl1
2228: ,jl_zz_ar_tx_categ tc1
2229: WHERE r1.customer_trx_id = rl1.customer_trx_id
2230: AND r1.customer_trx_id = p_prev_cust_trx_id

Line 2259: ,ar_vat_tax v1

2255: ,r1.customer_trx_id header_trx_id
2256: FROM ra_customer_trx r1
2257: ,ra_customer_trx_lines rl1
2258: ,ra_customer_trx_lines rlt1
2259: ,ar_vat_tax v1
2260: ,jl_zz_ar_tx_att_cls tcl1
2261: ,jl_zz_ar_tx_categ tc1
2262: WHERE r1.customer_trx_id = rl1.customer_trx_id
2263: AND r1.related_customer_trx_id = p_prev_cust_trx_id

Line 2292: ,ar_vat_tax v1

2288: ,r1.customer_trx_id header_trx_id
2289: FROM ra_customer_trx r1
2290: ,ra_customer_trx_lines rl1
2291: ,ra_customer_trx_lines rlt1
2292: ,ar_vat_tax v1
2293: ,jl_zz_ar_tx_att_cls tcl1
2294: ,jl_zz_ar_tx_categ tc1
2295: WHERE r1.customer_trx_id = rl1.customer_trx_id
2296: AND r1.previous_customer_trx_id = p_prev_cust_trx_id

Line 2326: ,ar_vat_tax v1

2322: FROM ra_customer_trx r1
2323: ,ra_customer_trx r2
2324: ,ra_customer_trx_lines rl1
2325: ,ra_customer_trx_lines rlt1
2326: ,ar_vat_tax v1
2327: ,jl_zz_ar_tx_att_cls tcl1
2328: ,jl_zz_ar_tx_categ tc1
2329: WHERE r2.related_customer_trx_id = p_prev_cust_trx_id
2330: AND r2.customer_trx_id = r1.previous_customer_trx_id

Line 2365: ,ar_vat_tax v1

2361: ,r1.customer_trx_id header_trx_id
2362: FROM ra_customer_trx r1
2363: ,ra_customer_trx_lines rl1
2364: ,ra_customer_trx_lines rlt1
2365: ,ar_vat_tax v1
2366: ,jl_zz_ar_tx_att_cls tcl1
2367: ,jl_zz_ar_tx_categ tc1
2368: WHERE r1.customer_trx_id = rl1.customer_trx_id
2369: AND r1.customer_trx_id = p_rel_cust_trx_id

Line 2398: ,ar_vat_tax v1

2394: ,r1.customer_trx_id header_trx_id
2395: FROM ra_customer_trx r1
2396: ,ra_customer_trx_lines rl1
2397: ,ra_customer_trx_lines rlt1
2398: ,ar_vat_tax v1
2399: ,jl_zz_ar_tx_att_cls tcl1
2400: ,jl_zz_ar_tx_categ tc1
2401: WHERE r1.customer_trx_id = rl1.customer_trx_id
2402: AND r1.related_customer_trx_id = p_rel_cust_trx_id

Line 2431: ,ar_vat_tax v1

2427: ,r1.customer_trx_id header_trx_id
2428: FROM ra_customer_trx r1
2429: ,ra_customer_trx_lines rl1
2430: ,ra_customer_trx_lines rlt1
2431: ,ar_vat_tax v1
2432: ,jl_zz_ar_tx_att_cls tcl1
2433: ,jl_zz_ar_tx_categ tc1
2434: WHERE r1.customer_trx_id = rl1.customer_trx_id
2435: AND r1.previous_customer_trx_id = p_rel_cust_trx_id

Line 2465: ,ar_vat_tax v1

2461: FROM ra_customer_trx r1
2462: ,ra_customer_trx r2
2463: ,ra_customer_trx_lines rl1
2464: ,ra_customer_trx_lines rlt1
2465: ,ar_vat_tax v1
2466: ,jl_zz_ar_tx_att_cls tcl1
2467: ,jl_zz_ar_tx_categ tc1
2468: WHERE r2.related_customer_trx_id = p_rel_cust_trx_id
2469: AND r2.customer_trx_id = r1.previous_customer_trx_id

Line 2499: ,ar_vat_tax v1

2495: ,r1.customer_trx_id header_trx_id
2496: FROM ra_customer_trx r1
2497: ,ra_customer_trx_lines rl1
2498: ,ra_customer_trx_lines rlt1
2499: ,ar_vat_tax v1
2500: ,jl_zz_ar_tx_att_cls tcl1
2501: ,jl_zz_ar_tx_categ tc1
2502: WHERE r1.customer_trx_id = rl1.customer_trx_id
2503: AND r1.customer_trx_id = p_curr_cust_trx_id

Line 2524: ,ar_vat_tax v1

2520:
2521: cursor rel_trx_categ is
2522: SELECT tc1.tax_category_id tax_category_id
2523: FROM ra_customer_trx_lines rlt1
2524: ,ar_vat_tax v1
2525: ,jl_zz_ar_tx_categ tc1
2526: WHERE rlt1.customer_trx_id = p_rel_cust_trx_id
2527: AND rlt1.line_type= 'TAX'
2528: AND rlt1.vat_tax_id = v1.vat_tax_id

Line 2536: ,ar_vat_tax v1

2532:
2533: cursor cur_trx_categ is
2534: SELECT tc1.tax_category_id tax_category_id
2535: FROM ra_customer_trx_lines rlt1
2536: ,ar_vat_tax v1
2537: ,jl_zz_ar_tx_categ tc1
2538: WHERE rlt1.customer_trx_id = p_curr_cust_trx_id
2539: AND rlt1.line_type= 'TAX'
2540: AND rlt1.vat_tax_id = v1.vat_tax_id

Line 2779: l_tax_code ar_vat_tax.tax_code%type;

2775:
2776: l_rel_tax_line_amt_ctr BINARY_INTEGER;
2777: l_rel_tax_lines_ctr BINARY_INTEGER;
2778: l_rule_code jl_zz_ar_tx_rules.rule%type;
2779: l_tax_code ar_vat_tax.tax_code%type;
2780: l_grp_attr_name VARCHAR2(30);
2781: l_grp_attr_val VARCHAR2(30);
2782: l_operation_level VARCHAR2(30);
2783: l_func_curr_taxable_base NUMBER;

Line 3059: FROM ar_vat_tax

3055: l_sch_tax_rate := NULL;
3056: BEGIN
3057: SELECT tax_rate
3058: INTO l_sch_tax_rate
3059: FROM ar_vat_tax
3060: WHERE tax_code = tax_schedule_rec.tax_code
3061: AND set_of_books_id = p_set_of_books_id
3062: AND start_date <= p_trx_date
3063: AND NVL(end_date,p_trx_date) >= p_trx_date

Line 3580: FROM ar_vat_tax vt

3576: RAISE ERROR_FROM_FUNCTION;
3577: ELSE
3578: SELECT vt.tax_rate
3579: INTO v_aux_tax_rate
3580: FROM ar_vat_tax vt
3581: WHERE vt.tax_code = v_aux_tax_code
3582: AND vt.set_of_books_id = v_set_of_books_id
3583: AND vt.start_date <= trunc(p_trx_date)
3584: AND nvl(vt.end_date, trunc(p_trx_date)) >= trunc(p_trx_date)

Line 4016: FROM ar_vat_tax vt,

4012: INTO ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.amount_includes_tax_flag,
4013: v_use_legal_message,
4014: v_legal_message_exception,
4015: l_exchange_rate
4016: FROM ar_vat_tax vt,
4017: ar_system_parameters_all sp
4018: WHERE vt.vat_tax_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id
4019: AND nvl(vt.org_id,-99) = nvl(sp.org_id,-99);
4020:

Line 4229: FROM ar_vat_tax

4225: l_vat_tax_id := NULL;
4226: BEGIN
4227: SELECT vat_tax_id
4228: INTO l_vat_tax_id
4229: FROM ar_vat_tax
4230: WHERE tax_code = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.tax_code
4231: AND set_of_books_id = ZX_PRODUCT_INTEGRATION_PKG.sysinfo.sysparam.set_of_books_id
4232: AND tax_type = 'VAT'
4233: AND to_date(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern6,'YYYYMMDD') >= start_date