View: WSH_ITM_USER_SETUPS_V

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

View Text

SELECT WCU.ROWID ROW_ID
, WCU.ITM_USER_SEQUENCE_ID
, WCU.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WCU.ORGANIZATION_ID
, HOU2.NAME ORGANIZATION_NAME
, WCU.APPLICATION_ID
, FAP.APPLICATION_NAME
, WCU.APPLICATION_USER_ID
, FU.USER_NAME
, WCU.VENDOR_ID
, WIV.SERVICE_PROVIDER
, WCU.USER_ID
, WCU.ENCRYPTED_USER_PASSWORD
, WCU.CREATION_DATE
, WCU.CREATED_BY
, WCU.LAST_UPDATE_DATE
, WCU.LAST_UPDATED_BY
, WCU.LAST_UPDATE_LOGIN
FROM WSH_ITM_USER_SETUPS WCU
, HR_ORGANIZATION_UNITS HOU1
, HR_ORGANIZATION_UNITS HOU2
, FND_USER FU
, FND_APPLICATION_VL FAP
, WSH_ITM_VENDORS WIV
WHERE WCU.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WCU.ORGANIZATION_ID=HOU2.ORGANIZATION_ID
AND WCU.APPLICATION_USER_ID=FU.USER_ID
AND WCU.APPLICATION_ID = FAP.APPLICATION_ID
AND WIV.VENDOR_ID = WCU.VENDOR_ID UNION ALL SELECT WCU.ROWID ROW_ID
, WCU.ITM_USER_SEQUENCE_ID
, WCU.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WCU.ORGANIZATION_ID
, HOU2.NAME ORGANIZATION_NAME
, WCU.APPLICATION_ID
, FAP.APPLICATION_NAME
, WCU.APPLICATION_USER_ID
, TO_CHAR(NULL) USER_NAME
, WCU.VENDOR_ID
, WIV.SERVICE_PROVIDER
, WCU.USER_ID
, WCU.ENCRYPTED_USER_PASSWORD
, WCU.CREATION_DATE
, WCU.CREATED_BY
, WCU.LAST_UPDATE_DATE
, WCU.LAST_UPDATED_BY
, WCU.LAST_UPDATE_LOGIN
FROM WSH_ITM_USER_SETUPS WCU
, HR_ORGANIZATION_UNITS HOU1
, HR_ORGANIZATION_UNITS HOU2
, FND_APPLICATION_VL FAP
, WSH_ITM_VENDORS WIV
WHERE WCU.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WCU.ORGANIZATION_ID=HOU2.ORGANIZATION_ID
AND WCU.APPLICATION_USER_ID IS NULL
AND WCU.APPLICATION_ID = FAP.APPLICATION_ID
AND WIV.VENDOR_ID = WCU.VENDOR_ID UNION ALL SELECT WCU.ROWID ROW_ID
, WCU.ITM_USER_SEQUENCE_ID
, WCU.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WCU.ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_NAME
, WCU.APPLICATION_ID
, FAP.APPLICATION_NAME
, WCU.APPLICATION_USER_ID
, FU.USER_NAME
, WCU.VENDOR_ID
, WIV.SERVICE_PROVIDER
, WCU.USER_ID
, WCU.ENCRYPTED_USER_PASSWORD
, WCU.CREATION_DATE
, WCU.CREATED_BY
, WCU.LAST_UPDATE_DATE
, WCU.LAST_UPDATED_BY
, WCU.LAST_UPDATE_LOGIN
FROM WSH_ITM_USER_SETUPS WCU
, HR_ORGANIZATION_UNITS HOU1
, FND_USER FU
, FND_APPLICATION_VL FAP
, WSH_ITM_VENDORS WIV
WHERE WCU.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WCU.APPLICATION_USER_ID=FU.USER_ID
AND WCU.ORGANIZATION_ID IS NULL
AND WCU.APPLICATION_ID = FAP.APPLICATION_ID
AND WIV.VENDOR_ID = WCU.VENDOR_ID UNION ALL SELECT WCU.ROWID ROW_ID
, WCU.ITM_USER_SEQUENCE_ID
, WCU.MASTER_ORGANIZATION_ID
, HOU1.NAME MASTER_ORGANIZATION_NAME
, WCU.ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_NAME
, WCU.APPLICATION_ID
, FAP.APPLICATION_NAME
, WCU.APPLICATION_USER_ID
, TO_CHAR(NULL) USER_NAME
, WCU.VENDOR_ID
, WIV.SERVICE_PROVIDER
, WCU.USER_ID
, WCU.ENCRYPTED_USER_PASSWORD
, WCU.CREATION_DATE
, WCU.CREATED_BY
, WCU.LAST_UPDATE_DATE
, WCU.LAST_UPDATED_BY
, WCU.LAST_UPDATE_LOGIN
FROM WSH_ITM_USER_SETUPS WCU
, HR_ORGANIZATION_UNITS HOU1
, FND_APPLICATION_VL FAP
, WSH_ITM_VENDORS WIV
WHERE WCU.MASTER_ORGANIZATION_ID=HOU1.ORGANIZATION_ID
AND WCU.APPLICATION_USER_ID IS NULL
AND WCU.ORGANIZATION_ID IS NULL
AND WCU.APPLICATION_ID = FAP.APPLICATION_ID
AND WCU.VENDOR_ID = WIV.VENDOR_ID UNION ALL SELECT WCU.ROWID ROW_ID
, WCU.ITM_USER_SEQUENCE_ID
, WCU.MASTER_ORGANIZATION_ID
, TO_CHAR(NULL)
, WCU.ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_NAME
, WCU.APPLICATION_ID
, FAP.APPLICATION_NAME
, WCU.APPLICATION_USER_ID
, TO_CHAR(NULL) USER_NAME
, WCU.VENDOR_ID
, WIV.SERVICE_PROVIDER
, WCU.USER_ID
, WCU.ENCRYPTED_USER_PASSWORD
, WCU.CREATION_DATE
, WCU.CREATED_BY
, WCU.LAST_UPDATE_DATE
, WCU.LAST_UPDATED_BY
, WCU.LAST_UPDATE_LOGIN
FROM WSH_ITM_USER_SETUPS WCU
, FND_APPLICATION_VL FAP
, WSH_ITM_VENDORS WIV
WHERE WCU.MASTER_ORGANIZATION_ID IS NULL
AND WCU.APPLICATION_USER_ID IS NULL
AND WCU.ORGANIZATION_ID IS NULL
AND WCU.APPLICATION_ID = FAP.APPLICATION_ID
AND WCU.VENDOR_ID = WIV.VENDOR_ID

Columns