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_AUDIT_AR_PKG dependencies on HZ_LOCATIONS

Line 66: ,hz_locations HZL

62: FROM jg_zz_vat_trx_details JZVTD
63: ,jg_zz_vat_rep_status JZVRS
64: ,hz_cust_acct_sites_all HZCAS
65: ,hz_party_sites HPS
66: ,hz_locations HZL
67: ,ra_customer_trx_all RCTA
68: ,ra_cust_trx_types RTT
69: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
70: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id

Line 140: ,hz_locations HZ

136: ,NVL(JZVTD.taxable_amt_funcl_curr, taxable_amt) TAXABLE_AMOUNT
137: ,NVL(JZVTD.tax_amt_funcl_curr, tax_amt) TAX_AMOUNT
138: FROM jg_zz_vat_trx_details JZVTD
139: ,jg_zz_vat_rep_status JZVRS
140: ,hz_locations HZ
141: ,hz_party_sites HPS
142: ,ra_customer_trx_all RCTA
143: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
144: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id

Line 167: lc_country hz_locations.country%TYPE;

163: ln_legal_entity_id NUMBER;
164: ln_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
165: lc_company_name xle_registrations.registered_name%TYPE;
166: lc_registration_number xle_registrations.registration_number%TYPE;
167: lc_country hz_locations.country%TYPE;
168: lc_address1 hz_locations.address1%TYPE;
169: lc_address2 hz_locations.address2%TYPE;
170: lc_address3 hz_locations.address3%TYPE;
171: lc_address4 hz_locations.address4%TYPE;

Line 168: lc_address1 hz_locations.address1%TYPE;

164: ln_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
165: lc_company_name xle_registrations.registered_name%TYPE;
166: lc_registration_number xle_registrations.registration_number%TYPE;
167: lc_country hz_locations.country%TYPE;
168: lc_address1 hz_locations.address1%TYPE;
169: lc_address2 hz_locations.address2%TYPE;
170: lc_address3 hz_locations.address3%TYPE;
171: lc_address4 hz_locations.address4%TYPE;
172: lc_city hz_locations.city%TYPE;

Line 169: lc_address2 hz_locations.address2%TYPE;

165: lc_company_name xle_registrations.registered_name%TYPE;
166: lc_registration_number xle_registrations.registration_number%TYPE;
167: lc_country hz_locations.country%TYPE;
168: lc_address1 hz_locations.address1%TYPE;
169: lc_address2 hz_locations.address2%TYPE;
170: lc_address3 hz_locations.address3%TYPE;
171: lc_address4 hz_locations.address4%TYPE;
172: lc_city hz_locations.city%TYPE;
173: lc_postal_code hz_locations.postal_code%TYPE;

Line 170: lc_address3 hz_locations.address3%TYPE;

166: lc_registration_number xle_registrations.registration_number%TYPE;
167: lc_country hz_locations.country%TYPE;
168: lc_address1 hz_locations.address1%TYPE;
169: lc_address2 hz_locations.address2%TYPE;
170: lc_address3 hz_locations.address3%TYPE;
171: lc_address4 hz_locations.address4%TYPE;
172: lc_city hz_locations.city%TYPE;
173: lc_postal_code hz_locations.postal_code%TYPE;
174: lc_contact hz_parties.party_name%TYPE;

Line 171: lc_address4 hz_locations.address4%TYPE;

167: lc_country hz_locations.country%TYPE;
168: lc_address1 hz_locations.address1%TYPE;
169: lc_address2 hz_locations.address2%TYPE;
170: lc_address3 hz_locations.address3%TYPE;
171: lc_address4 hz_locations.address4%TYPE;
172: lc_city hz_locations.city%TYPE;
173: lc_postal_code hz_locations.postal_code%TYPE;
174: lc_contact hz_parties.party_name%TYPE;
175: lc_phone_number hz_contact_points.phone_number%TYPE;

Line 172: lc_city hz_locations.city%TYPE;

168: lc_address1 hz_locations.address1%TYPE;
169: lc_address2 hz_locations.address2%TYPE;
170: lc_address3 hz_locations.address3%TYPE;
171: lc_address4 hz_locations.address4%TYPE;
172: lc_city hz_locations.city%TYPE;
173: lc_postal_code hz_locations.postal_code%TYPE;
174: lc_contact hz_parties.party_name%TYPE;
175: lc_phone_number hz_contact_points.phone_number%TYPE;
176: -- Added for Glob-006 ER

Line 173: lc_postal_code hz_locations.postal_code%TYPE;

169: lc_address2 hz_locations.address2%TYPE;
170: lc_address3 hz_locations.address3%TYPE;
171: lc_address4 hz_locations.address4%TYPE;
172: lc_city hz_locations.city%TYPE;
173: lc_postal_code hz_locations.postal_code%TYPE;
174: lc_contact hz_parties.party_name%TYPE;
175: lc_phone_number hz_contact_points.phone_number%TYPE;
176: -- Added for Glob-006 ER
177: l_province VARCHAR2(120);