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

Line 68: ,hz_locations HZL

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

Line 145: ,hz_locations HZ

141: ,NVL(JZVTD.taxable_amt_funcl_curr, taxable_amt) TAXABLE_AMOUNT
142: ,NVL(JZVTD.tax_amt_funcl_curr, tax_amt) TAX_AMOUNT
143: FROM jg_zz_vat_trx_details JZVTD
144: ,jg_zz_vat_rep_status JZVRS
145: ,hz_locations HZ
146: ,hz_party_sites HPS
147: ,ra_customer_trx_all RCTA
148: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
149: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id

Line 172: lc_country hz_locations.country%TYPE;

168: ln_legal_entity_id NUMBER;
169: ln_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
170: lc_company_name xle_registrations.registered_name%TYPE;
171: lc_registration_number xle_registrations.registration_number%TYPE;
172: lc_country hz_locations.country%TYPE;
173: lc_address1 hz_locations.address1%TYPE;
174: lc_address2 hz_locations.address2%TYPE;
175: lc_address3 hz_locations.address3%TYPE;
176: lc_address4 hz_locations.address4%TYPE;

Line 173: lc_address1 hz_locations.address1%TYPE;

169: ln_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
170: lc_company_name xle_registrations.registered_name%TYPE;
171: lc_registration_number xle_registrations.registration_number%TYPE;
172: lc_country hz_locations.country%TYPE;
173: lc_address1 hz_locations.address1%TYPE;
174: lc_address2 hz_locations.address2%TYPE;
175: lc_address3 hz_locations.address3%TYPE;
176: lc_address4 hz_locations.address4%TYPE;
177: lc_city hz_locations.city%TYPE;

Line 174: lc_address2 hz_locations.address2%TYPE;

170: lc_company_name xle_registrations.registered_name%TYPE;
171: lc_registration_number xle_registrations.registration_number%TYPE;
172: lc_country hz_locations.country%TYPE;
173: lc_address1 hz_locations.address1%TYPE;
174: lc_address2 hz_locations.address2%TYPE;
175: lc_address3 hz_locations.address3%TYPE;
176: lc_address4 hz_locations.address4%TYPE;
177: lc_city hz_locations.city%TYPE;
178: lc_postal_code hz_locations.postal_code%TYPE;

Line 175: lc_address3 hz_locations.address3%TYPE;

171: lc_registration_number xle_registrations.registration_number%TYPE;
172: lc_country hz_locations.country%TYPE;
173: lc_address1 hz_locations.address1%TYPE;
174: lc_address2 hz_locations.address2%TYPE;
175: lc_address3 hz_locations.address3%TYPE;
176: lc_address4 hz_locations.address4%TYPE;
177: lc_city hz_locations.city%TYPE;
178: lc_postal_code hz_locations.postal_code%TYPE;
179: lc_contact hz_parties.party_name%TYPE;

Line 176: lc_address4 hz_locations.address4%TYPE;

172: lc_country hz_locations.country%TYPE;
173: lc_address1 hz_locations.address1%TYPE;
174: lc_address2 hz_locations.address2%TYPE;
175: lc_address3 hz_locations.address3%TYPE;
176: lc_address4 hz_locations.address4%TYPE;
177: lc_city hz_locations.city%TYPE;
178: lc_postal_code hz_locations.postal_code%TYPE;
179: lc_contact hz_parties.party_name%TYPE;
180: lc_phone_number hz_contact_points.phone_number%TYPE;

Line 177: lc_city hz_locations.city%TYPE;

173: lc_address1 hz_locations.address1%TYPE;
174: lc_address2 hz_locations.address2%TYPE;
175: lc_address3 hz_locations.address3%TYPE;
176: lc_address4 hz_locations.address4%TYPE;
177: lc_city hz_locations.city%TYPE;
178: lc_postal_code hz_locations.postal_code%TYPE;
179: lc_contact hz_parties.party_name%TYPE;
180: lc_phone_number hz_contact_points.phone_number%TYPE;
181: -- Added for Glob-006 ER

Line 178: lc_postal_code hz_locations.postal_code%TYPE;

174: lc_address2 hz_locations.address2%TYPE;
175: lc_address3 hz_locations.address3%TYPE;
176: lc_address4 hz_locations.address4%TYPE;
177: lc_city hz_locations.city%TYPE;
178: lc_postal_code hz_locations.postal_code%TYPE;
179: lc_contact hz_parties.party_name%TYPE;
180: lc_phone_number hz_contact_points.phone_number%TYPE;
181: -- Added for Glob-006 ER
182: l_province VARCHAR2(120);