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.CSM_PARTY_DATA_EVENT_PKG dependencies on HZ_PARTY_SITES

Line 161: , hz_party_sites hps

157: , tcpa.party_id
158: , hps.party_site_id
159: , hps.location_id
160: FROM csm_party_assignment tcpa
161: , hz_party_sites hps
162: WHERE tcpa.party_id = hps.party_id
163: AND tcpa.deleted_flag = 'N'
164: AND (tcpa.party_site_id = -1
165: OR tcpa.party_site_id = hps.party_site_id)

Line 197: AND cii.location_type_code = 'HZ_PARTY_SITES'

193: , CSI_II_RELATIONSHIPS CIR
194: WHERE cii.location_id = cpsa.party_site_id
195: AND cpsa.party_id = tcpa.party_id
196: AND cpsa.user_id = tcpa.user_id
197: AND cii.location_type_code = 'HZ_PARTY_SITES'
198: AND (tcpa.party_site_id = -1
199: OR tcpa.party_site_id = cpsa.party_site_id)
200: AND tcpa.deleted_flag = 'N'
201: AND cii.instance_id = civ.instance_id(+)

Line 400: hz_party_sites hps

396: , tcpa.party_id
397: , hps.party_site_id
398: , hps.location_id
399: FROM csm_party_assignment tcpa,
400: hz_party_sites hps
401: WHERE tcpa.party_id = hps.party_id
402: AND tcpa.deleted_flag = 'Y'
403: AND (tcpa.party_site_id = -1
404: OR tcpa.party_site_id = hps.party_site_id)

Line 432: AND cii.location_type_code = 'HZ_PARTY_SITES'

428: , csm_party_assignment tcpa
429: WHERE cii.location_id = cpsa.party_site_id
430: AND cpsa.party_id = tcpa.party_id
431: AND cpsa.user_id = tcpa.user_id
432: AND cii.location_type_code = 'HZ_PARTY_SITES'
433: AND (tcpa.party_site_id = -1
434: OR tcpa.party_site_id = cpsa.party_site_id)
435: AND tcpa.deleted_flag = 'Y'
436: AND EXISTS ( SELECT 1