View: WSH_ORG_CARRIER_SERVICES_V

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

View Text

SELECT WOCS.ROWID
, WOCS.ORG_CARRIER_SERVICE_ID
, ORG.ORGANIZATION_ID
, ORG.ORGANIZATION_CODE
, ORG.ORGANIZATION_NAME
, WOCS.CARRIER_SERVICE_ID
, NVL(WOCS.ENABLED_FLAG
, 'N')
, WOCS.ATTRIBUTE_CATEGORY
, WOCS.ATTRIBUTE1
, WOCS.ATTRIBUTE2
, WOCS.ATTRIBUTE3
, WOCS.ATTRIBUTE4
, WOCS.ATTRIBUTE5
, WOCS.ATTRIBUTE6
, WOCS.ATTRIBUTE7
, WOCS.ATTRIBUTE8
, WOCS.ATTRIBUTE9
, WOCS.ATTRIBUTE10
, WOCS.ATTRIBUTE11
, WOCS.ATTRIBUTE12
, WOCS.ATTRIBUTE13
, WOCS.ATTRIBUTE14
, WOCS.ATTRIBUTE15
, WOCS.CREATION_DATE
, WOCS.CREATED_BY
, WOCS.LAST_UPDATE_DATE
, WOCS.LAST_UPDATED_BY
, WOCS.LAST_UPDATE_LOGIN
, WOCS.PROGRAM_APPLICATION_ID
, WOCS.PROGRAM_ID
, WOCS.PROGRAM_UPDATE_DATE
, WOCS.REQUEST_ID
FROM ORG_ORGANIZATION_DEFINITIONS ORG
, WSH_ORG_CARRIER_SERVICES WOCS
WHERE WOCS.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND ORG.INVENTORY_ENABLED_FLAG = 'Y' UNION SELECT CHARTOROWID(TO_CHAR(NULL))
, TO_NUMBER(NULL)
, ORG.ORGANIZATION_ID
, ORG.ORGANIZATION_CODE
, ORG.ORGANIZATION_NAME
, WSH_CARRIER_SERVICES_PKG.GET_CARRIER_SERVICE_ID
, 'N'
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
FROM ORG_ORGANIZATION_DEFINITIONS ORG
WHERE ORG.INVENTORY_ENABLED_FLAG = 'Y'
AND NOT EXISTS (SELECT 'X'
FROM WSH_ORG_CARRIER_SERVICES
WHERE CARRIER_SERVICE_ID = WSH_CARRIER_SERVICES_PKG.GET_CARRIER_SERVICE_ID
AND ORGANIZATION_ID = ORG.ORGANIZATION_ID)

Columns