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.WSH_ITM_UTIL dependencies on WSH_ITM_SERVICE_PREFERENCES

Line 59: FROM WSH_ITM_SERVICE_PREFERENCES us1,

55: s.service_type,
56: s.addl_country_check_req,
57: v.vendor_id,
58: v.supports_combination_flag
59: FROM WSH_ITM_SERVICE_PREFERENCES us1,
60: WSH_ITM_VENDOR_SERVICES s,
61: WSH_ITM_VENDORS v
62: WHERE us1.application_id = p_application_id and
63: us1.master_organization_id = p_master_organization_id and

Line 73: FROM WSH_ITM_SERVICE_PREFERENCES us1,

69: s.service_type,
70: s.addl_country_check_req,
71: v.vendor_id,
72: v.supports_combination_flag
73: FROM WSH_ITM_SERVICE_PREFERENCES us1,
74: WSH_ITM_VENDOR_SERVICES s,
75: WSH_ITM_VENDORS v
76: WHERE us1.application_id = p_application_id and
77: us1.master_organization_id is null and

Line 210: FROM WSH_ITM_SERVICE_PREFERENCES US1,

206: x_service_provider OUT NOCOPY VARCHAR2) IS
207: BEGIN
208: SELECT VENDOR INTO x_service_provider FROM
209: ( SELECT 1 PRIORITY, V.SERVICE_PROVIDER VENDOR
210: FROM WSH_ITM_SERVICE_PREFERENCES US1,
211: WSH_ITM_VENDOR_SERVICES S, WSH_ITM_VENDORS V,
212: WSH_ITM_REQUEST_CONTROL RC
213: WHERE US1.APPLICATION_ID = RC.APPLICATION_ID AND
214: US1.MASTER_ORGANIZATION_ID = RC.MASTER_ORGANIZATION_ID AND

Line 222: FROM WSH_ITM_SERVICE_PREFERENCES US1,

218: S.SERVICE_TYPE = RC.SERVICE_TYPE_CODE AND
219: RC.REQUEST_CONTROL_ID = p_request_control_id
220: UNION
221: SELECT 2 PRIORITY, V.SERVICE_PROVIDER VENDOR
222: FROM WSH_ITM_SERVICE_PREFERENCES US1,
223: WSH_ITM_VENDOR_SERVICES S, WSH_ITM_VENDORS V,
224: WSH_ITM_REQUEST_CONTROL RC
225: WHERE US1.APPLICATION_ID = RC.APPLICATION_ID AND
226: US1.MASTER_ORGANIZATION_ID IS NULL AND