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.WSH_TPA_SELECTOR_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 195: FROM hz_cust_acct_sites_all acct_site ,

191:
192: CURSOR Get_Ece_Loc_Code (v_site_use_id NUMBER) IS-- TCA View Removal starts
193: SELECT Acct_site.Ece_tp_location_code,
194: Acct_site.Tp_header_id /* TP_HEADER_ID */
195: FROM hz_cust_acct_sites_all acct_site ,
196: hz_cust_site_uses_all site_uses
197: WHERE site_uses.site_use_id = v_site_use_id AND
198: acct_site.cust_acct_site_id/*address-id*/ = site_uses.cust_acct_site_id; -- TCA View Removal ends
199:

Line 206: hz_cust_acct_sites_all acct_site

202: CURSOR Get_Tp_Code (v_tp_hdr_id NUMBER) IS -- TCA View Removal starts
203: SELECT etg.tp_group_code
204: FROM ece_tp_group etg,
205: ece_tp_headers eth,
206: hz_cust_acct_sites_all acct_site
207: WHERE acct_site.tp_header_id = v_tp_hdr_id
208: AND acct_site.tp_header_id = eth.tp_header_id
209: AND eth.tp_group_id = etg.tp_group_id; -- -- TCA View Removal ends
210: