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.JE_ES_MODELO_EXT_PKG dependencies on HZ_PARTIES

Line 174: ,hz_parties HP

170: FROM jg_zz_vat_trx_details JZVTD
171: ,jg_zz_vat_rep_status JZVRS
172: ,ap_invoice_distributions AID
173: ,ap_invoice_distributions PRE
174: ,hz_parties HP
175: ,ap_invoices_all API
176: ,zx_lines_det_factors ZXDF
177:
178: WHERE JZVRS.reporting_status_id = JZVTD.reporting_status_id

Line 1130: ,hz_parties HP

1126: FROM jg_zz_vat_trx_details JZVTD
1127: ,jg_zz_vat_rep_status JZVRS
1128: ,ap_invoice_distributions AID
1129: ,ap_invoice_distributions PRE
1130: ,hz_parties HP
1131: ,ap_invoices_all API
1132: ,zx_lines_det_factors ZXDF
1133: WHERE JZVRS.reporting_status_id = JZVTD.reporting_status_id
1134: AND JZVTD.billing_trading_partner_id = p_vendor_id

Line 1917: lc_contact hz_parties.party_name%TYPE;

1913: lc_address4 hz_locations.address4%TYPE;
1914: lc_city hr_locations.town_or_city%TYPE;
1915: lc_postal_code hr_locations.postal_code%TYPE;
1916: lc_postal_code1 hr_locations.postal_code%TYPE;
1917: lc_contact hz_parties.party_name%TYPE;
1918: lc_phone_number hz_contact_points.phone_number%TYPE;
1919: -- Added for Glob-006 ER
1920: l_province VARCHAR2(120);
1921: l_comm_num VARCHAR2(30);