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 1079: l_country hz_locations.country%TYPE;

1075: l_new_unapp_vat NUMBER;
1076: l_zero NUMBER;
1077: l_company_name xle_registrations.registered_name%TYPE;
1078: l_registration_number xle_registrations.registration_number%TYPE;
1079: l_country hz_locations.country%TYPE;
1080: l_address1 hz_locations.address1%TYPE;
1081: l_address2 hz_locations.address2%TYPE;
1082: l_address3 hz_locations.address3%TYPE;
1083: l_address4 hz_locations.address4%TYPE;

Line 1080: l_address1 hz_locations.address1%TYPE;

1076: l_zero NUMBER;
1077: l_company_name xle_registrations.registered_name%TYPE;
1078: l_registration_number xle_registrations.registration_number%TYPE;
1079: l_country hz_locations.country%TYPE;
1080: l_address1 hz_locations.address1%TYPE;
1081: l_address2 hz_locations.address2%TYPE;
1082: l_address3 hz_locations.address3%TYPE;
1083: l_address4 hz_locations.address4%TYPE;
1084: l_city hz_locations.city%TYPE;

Line 1081: l_address2 hz_locations.address2%TYPE;

1077: l_company_name xle_registrations.registered_name%TYPE;
1078: l_registration_number xle_registrations.registration_number%TYPE;
1079: l_country hz_locations.country%TYPE;
1080: l_address1 hz_locations.address1%TYPE;
1081: l_address2 hz_locations.address2%TYPE;
1082: l_address3 hz_locations.address3%TYPE;
1083: l_address4 hz_locations.address4%TYPE;
1084: l_city hz_locations.city%TYPE;
1085: l_postal_code hz_locations.postal_code%TYPE;

Line 1082: l_address3 hz_locations.address3%TYPE;

1078: l_registration_number xle_registrations.registration_number%TYPE;
1079: l_country hz_locations.country%TYPE;
1080: l_address1 hz_locations.address1%TYPE;
1081: l_address2 hz_locations.address2%TYPE;
1082: l_address3 hz_locations.address3%TYPE;
1083: l_address4 hz_locations.address4%TYPE;
1084: l_city hz_locations.city%TYPE;
1085: l_postal_code hz_locations.postal_code%TYPE;
1086: l_contact hz_parties.party_name%TYPE;

Line 1083: l_address4 hz_locations.address4%TYPE;

1079: l_country hz_locations.country%TYPE;
1080: l_address1 hz_locations.address1%TYPE;
1081: l_address2 hz_locations.address2%TYPE;
1082: l_address3 hz_locations.address3%TYPE;
1083: l_address4 hz_locations.address4%TYPE;
1084: l_city hz_locations.city%TYPE;
1085: l_postal_code hz_locations.postal_code%TYPE;
1086: l_contact hz_parties.party_name%TYPE;
1087: l_phone_number hz_contact_points.phone_number%TYPE;

Line 1084: l_city hz_locations.city%TYPE;

1080: l_address1 hz_locations.address1%TYPE;
1081: l_address2 hz_locations.address2%TYPE;
1082: l_address3 hz_locations.address3%TYPE;
1083: l_address4 hz_locations.address4%TYPE;
1084: l_city hz_locations.city%TYPE;
1085: l_postal_code hz_locations.postal_code%TYPE;
1086: l_contact hz_parties.party_name%TYPE;
1087: l_phone_number hz_contact_points.phone_number%TYPE;
1088: -- Added for Glob-006 ER

Line 1085: l_postal_code hz_locations.postal_code%TYPE;

1081: l_address2 hz_locations.address2%TYPE;
1082: l_address3 hz_locations.address3%TYPE;
1083: l_address4 hz_locations.address4%TYPE;
1084: l_city hz_locations.city%TYPE;
1085: l_postal_code hz_locations.postal_code%TYPE;
1086: l_contact hz_parties.party_name%TYPE;
1087: l_phone_number hz_contact_points.phone_number%TYPE;
1088: -- Added for Glob-006 ER
1089: l_province VARCHAR2(120);