Product: | CSI - Install Base |
---|---|
Description: | Multi Lingual View for Systems. |
Implementation/DBA Data: | APPS.CSI_SYSTEMS_VL |
SELECT CSB.SYSTEM_ID SYSTEM_ID
, CSB.OPERATING_UNIT_ID OPERATING_UNIT_ID
, CSB.CUSTOMER_ID CUSTOMER_ID
, CST.NAME NAME
, CST.DESCRIPTION DESCRIPTION
, CSB.SYSTEM_TYPE_CODE SYSTEM_TYPE_CODE
, CSB.SYSTEM_NUMBER SYSTEM_NUMBER
, CSB.PARENT_SYSTEM_ID PARENT_SYSTEM_ID
, CSB.SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, CSB.BILL_TO_CONTACT_ID BILL_TO_CONTACT_ID
, CSB.TECHNICAL_CONTACT_ID TECHNICAL_CONTACT_ID
, CSB.SERVICE_ADMIN_CONTACT_ID SERVICE_ADMIN_CONTACT_ID
, CSB.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, CSB.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, CSB.INSTALL_SITE_USE_ID INSTALL_SITE_USE_ID
, CSB.COTERMINATE_DAY_MONTH COTERMINATE_DAY_MONTH
, CSB.AUTOCREATED_FROM_SYSTEM_ID AUTOCREATED_FROM_SYSTEM_ID
, CSB.CONFIG_SYSTEM_TYPE CONFIG_SYSTEM_TYPE
, CSB.START_DATE_ACTIVE START_DATE_ACTIVE
, CSB.END_DATE_ACTIVE END_DATE_ACTIVE
, CSB.CONTEXT CONTEXT
, 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.CREATED_BY CREATED_BY
, CSB.CREATION_DATE CREATION_DATE
, CSB.LAST_UPDATED_BY LAST_UPDATED_BY
, CSB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CSB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CSB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM CSI_SYSTEMS_B CSB
, CSI_SYSTEMS_TL CST WHERE CSB.SYSTEM_ID = CST.SYSTEM_ID AND CST.LANGUAGE = USERENV('LANG')