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.

[Home] [Help]

APPS.JG_ZZ_SUMMARY_AP_PKG dependencies on HZ_LOCATIONS

Line 213: l_country hz_locations.country%TYPE;

209: l_legal_entity_id NUMBER;
210: l_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
211: l_company_name xle_registrations.registered_name%TYPE;
212: l_registration_number xle_registrations.registration_number%TYPE;
213: l_country hz_locations.country%TYPE;
214: l_address1 hz_locations.address1%TYPE;
215: l_address2 hz_locations.address2%TYPE;
216: l_address3 hz_locations.address3%TYPE;
217: l_address4 hz_locations.address4%TYPE;

Line 214: l_address1 hz_locations.address1%TYPE;

210: l_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
211: l_company_name xle_registrations.registered_name%TYPE;
212: l_registration_number xle_registrations.registration_number%TYPE;
213: l_country hz_locations.country%TYPE;
214: l_address1 hz_locations.address1%TYPE;
215: l_address2 hz_locations.address2%TYPE;
216: l_address3 hz_locations.address3%TYPE;
217: l_address4 hz_locations.address4%TYPE;
218: l_city hz_locations.city%TYPE;

Line 215: l_address2 hz_locations.address2%TYPE;

211: l_company_name xle_registrations.registered_name%TYPE;
212: l_registration_number xle_registrations.registration_number%TYPE;
213: l_country hz_locations.country%TYPE;
214: l_address1 hz_locations.address1%TYPE;
215: l_address2 hz_locations.address2%TYPE;
216: l_address3 hz_locations.address3%TYPE;
217: l_address4 hz_locations.address4%TYPE;
218: l_city hz_locations.city%TYPE;
219: l_postal_code hz_locations.postal_code%TYPE;

Line 216: l_address3 hz_locations.address3%TYPE;

212: l_registration_number xle_registrations.registration_number%TYPE;
213: l_country hz_locations.country%TYPE;
214: l_address1 hz_locations.address1%TYPE;
215: l_address2 hz_locations.address2%TYPE;
216: l_address3 hz_locations.address3%TYPE;
217: l_address4 hz_locations.address4%TYPE;
218: l_city hz_locations.city%TYPE;
219: l_postal_code hz_locations.postal_code%TYPE;
220: l_contact hz_parties.party_name%TYPE;

Line 217: l_address4 hz_locations.address4%TYPE;

213: l_country hz_locations.country%TYPE;
214: l_address1 hz_locations.address1%TYPE;
215: l_address2 hz_locations.address2%TYPE;
216: l_address3 hz_locations.address3%TYPE;
217: l_address4 hz_locations.address4%TYPE;
218: l_city hz_locations.city%TYPE;
219: l_postal_code hz_locations.postal_code%TYPE;
220: l_contact hz_parties.party_name%TYPE;
221: l_phone_number hz_contact_points.phone_number%TYPE;

Line 218: l_city hz_locations.city%TYPE;

214: l_address1 hz_locations.address1%TYPE;
215: l_address2 hz_locations.address2%TYPE;
216: l_address3 hz_locations.address3%TYPE;
217: l_address4 hz_locations.address4%TYPE;
218: l_city hz_locations.city%TYPE;
219: l_postal_code hz_locations.postal_code%TYPE;
220: l_contact hz_parties.party_name%TYPE;
221: l_phone_number hz_contact_points.phone_number%TYPE;
222: l_tax_registration_num VARCHAR2 (240);

Line 219: l_postal_code hz_locations.postal_code%TYPE;

215: l_address2 hz_locations.address2%TYPE;
216: l_address3 hz_locations.address3%TYPE;
217: l_address4 hz_locations.address4%TYPE;
218: l_city hz_locations.city%TYPE;
219: l_postal_code hz_locations.postal_code%TYPE;
220: l_contact hz_parties.party_name%TYPE;
221: l_phone_number hz_contact_points.phone_number%TYPE;
222: l_tax_registration_num VARCHAR2 (240);
223: l_period_end_date DATE;