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.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on HZ_PARTY_SITE_USES

Line 163: hz_party_site_uses hpsu1,

159: select hps1.party_site_id billto_site_id,
160: hps2.party_site_id shipto_site_id
161: From hz_party_sites hps1,
162: hz_party_sites hps2,
163: hz_party_site_uses hpsu1,
164: hz_party_site_uses hpsu2
165: Where hps1.party_id = p_party_id
166: and hpsu1.party_site_id = hps1.party_site_id
167: and hpsu1.site_use_type = 'BILL_TO'

Line 164: hz_party_site_uses hpsu2

160: hps2.party_site_id shipto_site_id
161: From hz_party_sites hps1,
162: hz_party_sites hps2,
163: hz_party_site_uses hpsu1,
164: hz_party_site_uses hpsu2
165: Where hps1.party_id = p_party_id
166: and hpsu1.party_site_id = hps1.party_site_id
167: and hpsu1.site_use_type = 'BILL_TO'
168: and hpsu1.status = 'A'