VIEW: APPS.WSH_ORG_CARRIER_SITES_V

Source

View Text - Preformatted

SELECT WOCS.ROWID, WOCS.ORG_CARRIER_SITE_ID, ORG.ORGANIZATION_ID, ORG.ORGANIZATION_CODE, ORG.ORGANIZATION_NAME, WOCS.CARRIER_SITE_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_SITES 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, to_number(NULL), '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'

View Text - HTML Formatted

SELECT WOCS.ROWID
, WOCS.ORG_CARRIER_SITE_ID
, ORG.ORGANIZATION_ID
, ORG.ORGANIZATION_CODE
, ORG.ORGANIZATION_NAME
, WOCS.CARRIER_SITE_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_SITES 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
, TO_NUMBER(NULL)
, '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'