View: CSI_CP_SYSTEMS_ALL_B_V

Product:	CSI - Install Base
Description:	Backward Compatible : Systems (View for the Base table CS_SYSTEMS_ALL_B).
Implementation/DBA Data:	APPS.CSI_CP_SYSTEMS_ALL_B_V

View Text

SELECT CSB.SYSTEM_ID SYSTEM_ID
, CSB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CSB.LAST_UPDATED_BY LAST_UPDATED_BY
, CSB.CREATION_DATE CREATION_DATE
, CSB.CREATED_BY CREATED_BY
, CSB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CSB.CUSTOMER_ID CUSTOMER_ID
, CSB.SYSTEM_TYPE_CODE SYSTEM_TYPE_CODE
, CSB.SYSTEM_NUMBER SERIAL_NUMBER
, CSB.PARENT_SYSTEM_ID PARENT_SYSTEM_ID
, CSB.TECHNICAL_CONTACT_ID TECHINICAL_CONTACT_ID
, CSB.SERVICE_ADMIN_CONTACT_ID SERVICE_ADMIN_CONTACT_ID
, CSB.INSTALL_SITE_USE_ID INSTALL_SITE_USE_ID
, CSB.BILL_TO_CONTACT_ID BILL_TO_CONTACT_ID
, CSB.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, CSB.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, CSB.SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, CSB.COTERMINATE_DAY_MONTH COTERMINATE_DAY_MONTH
, CSB.START_DATE_ACTIVE START_DATE_ACTIVE
, CSB.END_DATE_ACTIVE END_DATE_ACTIVE
, CSB.AUTOCREATED_FROM_SYSTEM_ID AUTOCREATED_FROM_SYSTEM_ID
, CSB.ATTRIBUTE1 ATTRIBUTE1
, CSB.ATTRIBUTE2 ATTRIBUTE2
, CSB.ATTRIBUTE3 ATTRIBUTE3
, CSB.ATTRIBUTE4 ATTRIBUTE4
, CSB.ATTRIBUTE5 ATTRIBUTE5
, CSB.ATTRIBUTE6 ATTRIBUTE6
, CSB.ATTRIBUTE7 ATTRIBUTE7
, CSB.ATTRIBUTE8 ATTRIBUTE8
, CSB.ATTRIBUTE9 ATTRIBUTE9
, CSB.ATTRIBUTE10 ATTRIBUTE10
, CSB.ATTRIBUTE11 ATTRIBUTE11
, CSB.ATTRIBUTE12 ATTRIBUTE12
, CSB.ATTRIBUTE13 ATTRIBUTE13
, CSB.ATTRIBUTE14 ATTRIBUTE14
, CSB.ATTRIBUTE15 ATTRIBUTE15
, CSB.CONTEXT CONTEXT
, CSB.CONFIG_SYSTEM_TYPE CONFIG_SYSTEM_TYPE
, CSB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, NULL ORG_ID
FROM CSI_SYSTEMS_B CSB

Columns