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 369: FROM hz_cust_site_uses su

365: CURSOR c_bill_to IS
366: SELECT su.tax_code,
367: NULL,
368: su.site_use_id
369: FROM hz_cust_site_uses su
370: WHERE su.site_use_id = p_bill_to_site_use_id
371: AND exists (select 1
372: from ar_vat_tax vt
373: WHERE su.tax_code = vt.tax_code

Line 388: FROM hz_cust_site_uses su

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

Line 413: FROM hz_cust_site_uses su

409: CURSOR c_ship_to IS
410: SELECT su.tax_code,
411: NULL,
412: su.site_use_id
413: FROM hz_cust_site_uses su
414: WHERE su.site_use_id = p_ship_to_site_use_id
415: AND exists (select 1
416: from ar_vat_tax vt
417: WHERE su.tax_code = vt.tax_code

Line 432: FROM hz_cust_site_uses su

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

Line 630: from hz_cust_site_uses su

626: AND cp_trx_date <= loc.end_date_active
627: AND cp_trx_date >= NVL(loc.start_date_active, cp_trx_date)
628: AND exists
629: (select /*+ FIRST_ROWS(1) leading (su) */ 1
630: from hz_cust_site_uses su
631: ,hz_cust_acct_sites ad
632: ,hz_party_sites p
633: ,hz_locations lc
634: ,hz_geographies lv

Line 661: ,hz_cust_site_uses su

657: AND p_trx_date >= NVL(exc.start_date_active, p_trx_date)
658: AND exists (select 1
659: from hz_geographies lv
660: ,hz_cust_acct_sites ad
661: ,hz_cust_site_uses su
662: ,hz_party_sites p
663: ,hz_locations loc
664: ,ar_system_parameters sp
665: ,hr_locations_all hrl

Line 692: ,hz_cust_site_uses su

688: AND p_trx_date >= NVL(exi.start_date_active, p_trx_date)
689: AND exists (select 1
690: from hz_geographies lv
691: ,hz_cust_acct_sites ad
692: ,hz_cust_site_uses su
693: ,hz_party_sites p
694: ,hz_locations loc
695: ,ar_system_parameters sp
696: ,hr_locations_all hrl

Line 756: hz_cust_site_uses su

752: SELECT tec.tax_code,
753: tec.base_rate,
754: tec.exc_cus_id
755: FROM jl_zz_ar_tx_exc_cus tec,
756: hz_cust_site_uses su
757: WHERE tec.tax_category_id = p_tax_category_id
758: AND p_trx_date <= tec.end_date_active
759: AND p_trx_date >= NVL(tec.start_date_active,p_trx_date)
760: AND su.site_use_id = NVL(p_ship_to_site_use_id,p_bill_to_site_use_id)

Line 1764: hz_cust_site_uses rsu,

1760: cta.tax_attribute_value
1761: into l_establishment_type,
1762: l_contributor_type
1763: FROM jl_zz_ar_tx_cus_cls cta,
1764: hz_cust_site_uses rsu,
1765: jl_zz_ar_tx_att_cls ota,
1766: jl_zz_ar_tx_categ tc
1767: WHERE tc.tax_category_id = p_tax_category_id
1768: AND tc.threshold_check_grp_by = 'DOCUMENT'

Line 3577: hz_cust_site_uses su,

3573: IF NVL(ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.userf4,'N') = 'Y' THEN
3574: select ac.tax_attribute_value
3575: into v_aux_contributor_type
3576: from jl_zz_ar_tx_cus_cls ac,
3577: hz_cust_site_uses su,
3578: jl_zz_ar_tx_categ cat
3579: where ac.tax_attr_class_code = p_contributor_class
3580: and ac.tax_category_id = v_tax_category_to_reduce_id
3581: and ac.enabled_flag = 'Y'