[Home] [Help]
View: WSH_CC_SERVICE_HEADER_SETUPS_V
View Text
SELECT DISTINCT WSS.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WSS.ORGANIZATION_ID
, HOU2.NAME ORGANIZATION_NAME
, WSS.APPLICATION_ID
, FAP.APPLICATION_NAME
, WSS.APPLICATION_USER_ID
, FU.USER_NAME
FROM WSH_CC_SERVICE_SETUPS WSS
, HR_ORGANIZATION_UNITS HOU1
, HR_ORGANIZATION_UNITS HOU2
, FND_USER FU
, FND_APPLICATION_TL FAP
WHERE WSS.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WSS.ORGANIZATION_ID=HOU2.ORGANIZATION_ID
AND WSS.APPLICATION_USER_ID=FU.USER_ID
AND WSS.APPLICATION_ID = FAP.APPLICATION_ID UNION SELECT DISTINCT WSS.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WSS.ORGANIZATION_ID
, HOU2.NAME ORGANIZATION_NAME
, WSS.APPLICATION_ID
, FAP.APPLICATION_NAME
, WSS.APPLICATION_USER_ID
, TO_CHAR(NULL) USER_NAME
FROM WSH_CC_SERVICE_SETUPS WSS
, HR_ORGANIZATION_UNITS HOU1
, HR_ORGANIZATION_UNITS HOU2
, FND_APPLICATION_TL FAP
WHERE WSS.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WSS.ORGANIZATION_ID=HOU2.ORGANIZATION_ID
AND WSS.APPLICATION_USER_ID IS NULL
AND WSS.APPLICATION_ID = FAP.APPLICATION_ID UNION SELECT DISTINCT WSS.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WSS.ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_NAME
, WSS.APPLICATION_ID
, FAP.APPLICATION_NAME
, WSS.APPLICATION_USER_ID
, FU.USER_NAME
FROM WSH_CC_SERVICE_SETUPS WSS
, HR_ORGANIZATION_UNITS HOU1
, FND_USER FU
, FND_APPLICATION_TL FAP
WHERE WSS.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WSS.ORGANIZATION_ID IS NULL
AND WSS.APPLICATION_USER_ID = FU.USER_ID
AND WSS.APPLICATION_ID = FAP.APPLICATION_ID UNION SELECT DISTINCT WSS.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WSS.ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_NAME
, WSS.APPLICATION_ID
, FAP.APPLICATION_NAME
, WSS.APPLICATION_USER_ID
, TO_CHAR(NULL) USER_NAME
FROM WSH_CC_SERVICE_SETUPS WSS
, HR_ORGANIZATION_UNITS HOU1
, FND_APPLICATION_TL FAP
WHERE WSS.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WSS.ORGANIZATION_ID IS NULL
AND WSS.APPLICATION_USER_ID IS NULL
AND WSS.APPLICATION_ID = FAP.APPLICATION_ID
Columns
Name |
MASTER_ORGANIZATION_ID |
MASTER_ORGANIZATION_NAME |
ORGANIZATION_ID |
ORGANIZATION_NAME |
APPLICATION_ID |
APPLICATION_NAME |
APPLICATION_USER_ID |
USER_NAME |