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.JE_ES_MODELO_EXT_PKG dependencies on HR_LOCATIONS

Line 539: , hr_locations HL

535: -- 4 Property located outside Spain
536: 4) property_location_code
537: FROM
538: jg_zz_vat_trx_details JZVTD
539: , hr_locations HL
540: , ra_customer_trx TRX
541: , zx_lines_det_factors ZXDF
542: where JZVTD.trx_id = p_trx_id
543: AND JZVTD.trx_id = TRX.customer_trx_id

Line 647: , hr_locations HL

643: FROM jg_zz_vat_rep_status JZVRS
644: , jg_zz_vat_trx_details JZVTD
645: , hz_cust_acct_sites_all HCAS
646: , hz_party_sites HPS
647: , hr_locations HL
648: -- , fnd_territories FT -- Bug 8485057: not necessary
649: , hz_cust_site_uses_all HCSU
650: , zx_lines_det_factors ZXDF
651: , ra_customer_trx TRX

Line 1909: lc_country hr_locations.country%TYPE;

1905: --
1906: lc_taxpayer_id jg_zz_vat_trx_details.billing_tp_taxpayer_id%TYPE;
1907: lc_company_name xle_registrations.registered_name%TYPE;
1908: lc_registration_number xle_registrations.registration_number%TYPE;
1909: lc_country hr_locations.country%TYPE;
1910: lc_address1 hr_locations.address_line_1%TYPE;
1911: lc_address2 hr_locations.address_line_2%TYPE;
1912: lc_address3 hr_locations.address_line_3%TYPE;
1913: lc_address4 hz_locations.address4%TYPE;

Line 1910: lc_address1 hr_locations.address_line_1%TYPE;

1906: lc_taxpayer_id jg_zz_vat_trx_details.billing_tp_taxpayer_id%TYPE;
1907: lc_company_name xle_registrations.registered_name%TYPE;
1908: lc_registration_number xle_registrations.registration_number%TYPE;
1909: lc_country hr_locations.country%TYPE;
1910: lc_address1 hr_locations.address_line_1%TYPE;
1911: lc_address2 hr_locations.address_line_2%TYPE;
1912: lc_address3 hr_locations.address_line_3%TYPE;
1913: lc_address4 hz_locations.address4%TYPE;
1914: lc_city hr_locations.town_or_city%TYPE;

Line 1911: lc_address2 hr_locations.address_line_2%TYPE;

1907: lc_company_name xle_registrations.registered_name%TYPE;
1908: lc_registration_number xle_registrations.registration_number%TYPE;
1909: lc_country hr_locations.country%TYPE;
1910: lc_address1 hr_locations.address_line_1%TYPE;
1911: lc_address2 hr_locations.address_line_2%TYPE;
1912: lc_address3 hr_locations.address_line_3%TYPE;
1913: lc_address4 hz_locations.address4%TYPE;
1914: lc_city hr_locations.town_or_city%TYPE;
1915: lc_postal_code hr_locations.postal_code%TYPE;

Line 1912: lc_address3 hr_locations.address_line_3%TYPE;

1908: lc_registration_number xle_registrations.registration_number%TYPE;
1909: lc_country hr_locations.country%TYPE;
1910: lc_address1 hr_locations.address_line_1%TYPE;
1911: lc_address2 hr_locations.address_line_2%TYPE;
1912: lc_address3 hr_locations.address_line_3%TYPE;
1913: lc_address4 hz_locations.address4%TYPE;
1914: lc_city hr_locations.town_or_city%TYPE;
1915: lc_postal_code hr_locations.postal_code%TYPE;
1916: lc_postal_code1 hr_locations.postal_code%TYPE;

Line 1914: lc_city hr_locations.town_or_city%TYPE;

1910: lc_address1 hr_locations.address_line_1%TYPE;
1911: lc_address2 hr_locations.address_line_2%TYPE;
1912: lc_address3 hr_locations.address_line_3%TYPE;
1913: lc_address4 hz_locations.address4%TYPE;
1914: lc_city hr_locations.town_or_city%TYPE;
1915: lc_postal_code hr_locations.postal_code%TYPE;
1916: lc_postal_code1 hr_locations.postal_code%TYPE;
1917: lc_contact hz_parties.party_name%TYPE;
1918: lc_phone_number hz_contact_points.phone_number%TYPE;

Line 1915: lc_postal_code hr_locations.postal_code%TYPE;

1911: lc_address2 hr_locations.address_line_2%TYPE;
1912: lc_address3 hr_locations.address_line_3%TYPE;
1913: lc_address4 hz_locations.address4%TYPE;
1914: lc_city hr_locations.town_or_city%TYPE;
1915: lc_postal_code hr_locations.postal_code%TYPE;
1916: lc_postal_code1 hr_locations.postal_code%TYPE;
1917: lc_contact hz_parties.party_name%TYPE;
1918: lc_phone_number hz_contact_points.phone_number%TYPE;
1919: -- Added for Glob-006 ER

Line 1916: lc_postal_code1 hr_locations.postal_code%TYPE;

1912: lc_address3 hr_locations.address_line_3%TYPE;
1913: lc_address4 hz_locations.address4%TYPE;
1914: lc_city hr_locations.town_or_city%TYPE;
1915: lc_postal_code hr_locations.postal_code%TYPE;
1916: lc_postal_code1 hr_locations.postal_code%TYPE;
1917: lc_contact hz_parties.party_name%TYPE;
1918: lc_phone_number hz_contact_points.phone_number%TYPE;
1919: -- Added for Glob-006 ER
1920: l_province VARCHAR2(120);