VIEW: APPS.WSH_ORG_CARRIER_SERVICES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)