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

Line 244: hz_cust_acct_sites_all hcas

240: hp.party_name||'_'||nvl(hps.party_site_name,hps.party_site_number) Site,
241: hps.creation_date Cdate,
242: 'CUSTOMER' Company_Type
243: FROM wsh_locations wl, hz_party_sites hps, hz_parties hp,
244: hz_cust_acct_sites_all hcas
245: WHERE wl.source_location_id = p_location_id
246: AND wl.location_source_code = 'HZ'
247: AND wl.source_location_id = hps.location_id
248: AND hps.party_id=hp.party_id

Line 385: hz_cust_acct_sites_all hcas, fte_location_parameters flp,

381: hp.party_name||'_'||nvl(hps.party_site_name,hps.party_site_number) Site,
382: hps.creation_date Cdate,
383: 'CUSTOMER' Company_Type
384: FROM wsh_locations wl, hz_party_sites hps, hz_parties hp,
385: hz_cust_acct_sites_all hcas, fte_location_parameters flp,
386: wsh_location_owners wlo
387: WHERE wl.wsh_location_id = flp.location_id(+)
388: AND wl.wsh_location_id = wlo.wsh_location_id
389: AND wlo.owner_type = 2

Line 948: hz_cust_acct_sites_all hcas,

944: DELETE FROM FTE_LOCATION_PARAMETERS
945: WHERE location_id IN (
946: SELECT wl.wsh_location_id WSH_LOCATION_ID
947: FROM hz_party_sites hps,
948: hz_cust_acct_sites_all hcas,
949: hz_cust_site_uses_all hcsu, po_location_associations_all pla,
950: wsh_locations wl
951: WHERE pla.customer_id = hcas.cust_account_id
952: AND pla.site_use_id = hcsu.site_use_id