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 HZ_CUST_SITE_USES

Line 368: FROM hz_cust_site_uses su

364: CURSOR c_bill_to IS
365: SELECT su.tax_code,
366: NULL,
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

Line 386: FROM hz_cust_site_uses su

382: UNION
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

Line 411: FROM hz_cust_site_uses su

407: CURSOR c_ship_to IS
408: SELECT su.tax_code,
409: NULL,
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

Line 429: FROM hz_cust_site_uses su

425: UNION
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

Line 615: ,hz_cust_site_uses su

611: AND p_trx_date >= NVL(loc.start_date_active, p_trx_date)
612: AND exists (select 1
613: from hz_geographies lv
614: ,hz_cust_acct_sites ad
615: ,hz_cust_site_uses su
616: ,hz_party_sites p
617: ,hz_locations lc
618: ,ar_system_parameters sp
619: ,hr_locations_all hrl

Line 646: ,hz_cust_site_uses su

642: AND p_trx_date >= NVL(exc.start_date_active, p_trx_date)
643: AND exists (select 1
644: from hz_geographies lv
645: ,hz_cust_acct_sites ad
646: ,hz_cust_site_uses su
647: ,hz_party_sites p
648: ,hz_locations loc
649: ,ar_system_parameters sp
650: ,hr_locations_all hrl

Line 677: ,hz_cust_site_uses su

673: AND p_trx_date >= NVL(exi.start_date_active, p_trx_date)
674: AND exists (select 1
675: from hz_geographies lv
676: ,hz_cust_acct_sites ad
677: ,hz_cust_site_uses su
678: ,hz_party_sites p
679: ,hz_locations loc
680: ,ar_system_parameters sp
681: ,hr_locations_all hrl

Line 740: hz_cust_site_uses su

736: SELECT tec.tax_code,
737: tec.base_rate,
738: tec.exc_cus_id
739: FROM jl_zz_ar_tx_exc_cus tec,
740: hz_cust_site_uses su
741: WHERE tec.tax_category_id = p_tax_category_id
742: AND p_trx_date <= tec.end_date_active
743: AND p_trx_date >= NVL(tec.start_date_active,p_trx_date)
744: AND su.site_use_id = NVL(p_ship_to_site_use_id,p_bill_to_site_use_id)

Line 1744: hz_cust_site_uses rsu,

1740: cta.tax_attribute_value
1741: into l_establishment_type,
1742: l_contributor_type
1743: FROM jl_zz_ar_tx_cus_cls cta,
1744: hz_cust_site_uses rsu,
1745: jl_zz_ar_tx_att_cls ota,
1746: jl_zz_ar_tx_categ tc
1747: WHERE tc.tax_category_id = p_tax_category_id
1748: AND tc.threshold_check_grp_by = 'DOCUMENT'

Line 3499: hz_cust_site_uses su,

3495: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN
3496: select ac.tax_attribute_value
3497: into v_aux_contributor_type
3498: from jl_zz_ar_tx_cus_cls ac,
3499: hz_cust_site_uses su,
3500: jl_zz_ar_tx_categ cat
3501: where ac.tax_attr_class_code = p_contributor_class
3502: and ac.tax_category_id = v_tax_category_to_reduce_id
3503: and ac.enabled_flag = 'Y'