View: WSH_ITM_SERVICE_PREFERENCES_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_ITM_SERVICE_PREFERENCES_V

View Text

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

Columns