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.JG_ZZ_SUMMARY_AR_PKG dependencies on HZ_LOCATIONS

Line 1108: l_country hz_locations.country%TYPE;

1104: l_new_unapp_vat NUMBER;
1105: l_zero NUMBER;
1106: l_company_name xle_registrations.registered_name%TYPE;
1107: l_registration_number xle_registrations.registration_number%TYPE;
1108: l_country hz_locations.country%TYPE;
1109: l_address1 hz_locations.address1%TYPE;
1110: l_address2 hz_locations.address2%TYPE;
1111: l_address3 hz_locations.address3%TYPE;
1112: l_address4 hz_locations.address4%TYPE;

Line 1109: l_address1 hz_locations.address1%TYPE;

1105: l_zero NUMBER;
1106: l_company_name xle_registrations.registered_name%TYPE;
1107: l_registration_number xle_registrations.registration_number%TYPE;
1108: l_country hz_locations.country%TYPE;
1109: l_address1 hz_locations.address1%TYPE;
1110: l_address2 hz_locations.address2%TYPE;
1111: l_address3 hz_locations.address3%TYPE;
1112: l_address4 hz_locations.address4%TYPE;
1113: l_city hz_locations.city%TYPE;

Line 1110: l_address2 hz_locations.address2%TYPE;

1106: l_company_name xle_registrations.registered_name%TYPE;
1107: l_registration_number xle_registrations.registration_number%TYPE;
1108: l_country hz_locations.country%TYPE;
1109: l_address1 hz_locations.address1%TYPE;
1110: l_address2 hz_locations.address2%TYPE;
1111: l_address3 hz_locations.address3%TYPE;
1112: l_address4 hz_locations.address4%TYPE;
1113: l_city hz_locations.city%TYPE;
1114: l_postal_code hz_locations.postal_code%TYPE;

Line 1111: l_address3 hz_locations.address3%TYPE;

1107: l_registration_number xle_registrations.registration_number%TYPE;
1108: l_country hz_locations.country%TYPE;
1109: l_address1 hz_locations.address1%TYPE;
1110: l_address2 hz_locations.address2%TYPE;
1111: l_address3 hz_locations.address3%TYPE;
1112: l_address4 hz_locations.address4%TYPE;
1113: l_city hz_locations.city%TYPE;
1114: l_postal_code hz_locations.postal_code%TYPE;
1115: l_contact hz_parties.party_name%TYPE;

Line 1112: l_address4 hz_locations.address4%TYPE;

1108: l_country hz_locations.country%TYPE;
1109: l_address1 hz_locations.address1%TYPE;
1110: l_address2 hz_locations.address2%TYPE;
1111: l_address3 hz_locations.address3%TYPE;
1112: l_address4 hz_locations.address4%TYPE;
1113: l_city hz_locations.city%TYPE;
1114: l_postal_code hz_locations.postal_code%TYPE;
1115: l_contact hz_parties.party_name%TYPE;
1116: l_phone_number hz_contact_points.phone_number%TYPE;

Line 1113: l_city hz_locations.city%TYPE;

1109: l_address1 hz_locations.address1%TYPE;
1110: l_address2 hz_locations.address2%TYPE;
1111: l_address3 hz_locations.address3%TYPE;
1112: l_address4 hz_locations.address4%TYPE;
1113: l_city hz_locations.city%TYPE;
1114: l_postal_code hz_locations.postal_code%TYPE;
1115: l_contact hz_parties.party_name%TYPE;
1116: l_phone_number hz_contact_points.phone_number%TYPE;
1117: -- Added for Glob-006 ER

Line 1114: l_postal_code hz_locations.postal_code%TYPE;

1110: l_address2 hz_locations.address2%TYPE;
1111: l_address3 hz_locations.address3%TYPE;
1112: l_address4 hz_locations.address4%TYPE;
1113: l_city hz_locations.city%TYPE;
1114: l_postal_code hz_locations.postal_code%TYPE;
1115: l_contact hz_parties.party_name%TYPE;
1116: l_phone_number hz_contact_points.phone_number%TYPE;
1117: -- Added for Glob-006 ER
1118: l_province VARCHAR2(120);