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 153: hz_party_site_uses hpsu1,

149: select hps1.party_site_id billto_site_id,
150: hps2.party_site_id shipto_site_id
151: From hz_party_sites hps1,
152: hz_party_sites hps2,
153: hz_party_site_uses hpsu1,
154: hz_party_site_uses hpsu2
155: Where hps1.party_id = p_party_id
156: and hpsu1.party_site_id = hps1.party_site_id
157: and hpsu1.site_use_type = 'BILL_TO'

Line 154: hz_party_site_uses hpsu2

150: hps2.party_site_id shipto_site_id
151: From hz_party_sites hps1,
152: hz_party_sites hps2,
153: hz_party_site_uses hpsu1,
154: hz_party_site_uses hpsu2
155: Where hps1.party_id = p_party_id
156: and hpsu1.party_site_id = hps1.party_site_id
157: and hpsu1.site_use_type = 'BILL_TO'
158: and hpsu1.status = 'A'