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.

VIEW: APPS.WSH_ITM_SERVICE_PREFERENCES_V

Source

View Text - Preformatted


SELECT wvs.master_organization_id , hou.name master_organization_name , wvs.application_id , fap.application_name from wsh_itm_service_preferences wvs, hr_organization_units hou, fnd_application_vl fap WHERE wvs.master_organization_id=hou.organization_id and wvs.application_id = fap.application_id group by wvs.master_organization_id, hou.name, wvs.application_id, fap.application_name union all SELECT wvs.master_organization_id , to_char(null) master_organization_name , wvs.application_id , fap.application_name FROM wsh_itm_service_preferences wvs, fnd_application_vl fap WHERE wvs.master_organization_id is null and wvs.application_id = fap.application_id group by wvs.master_organization_id, wvs.application_id, fap.application_name

View Text - HTML Formatted

SELECT WVS.MASTER_ORGANIZATION_ID
, HOU.NAME MASTER_ORGANIZATION_NAME
, WVS.APPLICATION_ID
, FAP.APPLICATION_NAME
FROM WSH_ITM_SERVICE_PREFERENCES WVS
, HR_ORGANIZATION_UNITS HOU
, FND_APPLICATION_VL FAP
WHERE WVS.MASTER_ORGANIZATION_ID=HOU.ORGANIZATION_ID
AND WVS.APPLICATION_ID = FAP.APPLICATION_ID GROUP BY WVS.MASTER_ORGANIZATION_ID
, HOU.NAME
, WVS.APPLICATION_ID
, FAP.APPLICATION_NAME UNION ALL SELECT WVS.MASTER_ORGANIZATION_ID
, TO_CHAR(NULL) MASTER_ORGANIZATION_NAME
, WVS.APPLICATION_ID
, FAP.APPLICATION_NAME
FROM WSH_ITM_SERVICE_PREFERENCES WVS
, FND_APPLICATION_VL FAP
WHERE WVS.MASTER_ORGANIZATION_ID IS NULL
AND WVS.APPLICATION_ID = FAP.APPLICATION_ID GROUP BY WVS.MASTER_ORGANIZATION_ID
, WVS.APPLICATION_ID
, FAP.APPLICATION_NAME