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_SERVICE_REQUESTS_PKG dependencies on HZ_PARTY_SITE_USES

Line 71: hz_party_sites site, hz_party_site_uses use

67: CURSOR c_bill_to_site_id
68: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
69: ) IS
70: SELECT use.party_site_use_id FROM
71: hz_party_sites site, hz_party_site_uses use
72: WHERE site.party_site_id = use.party_site_id
73: AND site.status= 'A'
74: AND use.site_use_type= 'BILL_TO'
75: AND use.primary_per_type = 'Y'

Line 87: hz_party_sites site, hz_party_site_uses use

83: CURSOR c_ship_to_site_id
84: ( b_customer_id CS_INCIDENTS_ALL_B.CUSTOMER_ID%TYPE
85: ) IS
86: SELECT use.party_site_use_id FROM
87: hz_party_sites site, hz_party_site_uses use
88: WHERE site.party_site_id = use.party_site_id
89: AND site.status= 'A'
90: AND use.site_use_type= 'SHIP_TO'
91: AND use.primary_per_type = 'Y'