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 HR_LOCATIONS_ALL

Line 454: FROM hr_locations_all hrl

450: CURSOR c_organization IS
451: SELECT hrl.global_attribute6 tax_code,
452: NULL,
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

Line 481: hr_locations_all hrl

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'
485: AND tg.group_tax_id = vt.vat_tax_id

Line 619: ,hr_locations_all hrl

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
620: WHERE hrl.location_id = p_warehouse_location_id
621: AND loc.ship_from_code = hrl.REGION_2
622: AND loc.ship_to_segment_id = lv.geography_id
623: AND lv.geography_type = sp.global_attribute9

Line 650: ,hr_locations_all hrl

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
651: WHERE hrl.location_id = p_warehouse_location_id
652: AND exc.ship_from_code = hrl.REGION_2
653: AND exc.ship_to_segment_id = lv.geography_id
654: AND lv.geography_type = sp.global_attribute9

Line 681: ,hr_locations_all hrl

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
682: WHERE hrl.location_id = p_warehouse_location_id
683: AND exi.ship_from_code = hrl.REGION_2
684: AND exi.ship_to_segment_id = lv.geography_id
685: AND lv.geography_type = sp.global_attribute9

Line 4044: FROM hr_locations_all

4040: END IF;
4041:
4042: SELECT NVL(global_attribute1,'DEFAULT')
4043: INTO l_organization_class
4044: FROM hr_locations_all
4045: where location_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.usern4;
4046:
4047: IF (g_level_statement >= g_current_runtime_level) THEN
4048: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','-- Organization Class: '||l_organization_class);