Product: | CSI - Install Base |
---|---|
Description: | Backward Compatible : System Multilingual View. |
Implementation/DBA Data: | APPS.CSI_BC_SYSTEMS_VL |
SELECT B.ROWID ROW_ID
, B.SYSTEM_ID SYSTEM_ID
, B.CUSTOMER_ID CUSTOMER_ID
, B.SYSTEM_TYPE_CODE SYSTEM_TYPE_CODE
, B.SYSTEM_NUMBER SERIAL_NUMBER
, B.PARENT_SYSTEM_ID PARENT_SYSTEM_ID
, B.BILL_TO_CONTACT_ID BILL_TO_CONTACT_ID
, B.SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, B.SERVICE_ADMIN_CONTACT_ID SERVICE_ADMIN_CONTACT_ID
, B.TECHNICAL_CONTACT_ID TECHNICAL_CONTACT_ID
, B.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, B.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, B.INSTALL_SITE_USE_ID INSTALL_SITE_USE_ID
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.COTERMINATE_DAY_MONTH COTERMINATE_DAY_MONTH
, B.START_DATE_ACTIVE START_DATE_ACTIVE
, B.END_DATE_ACTIVE END_DATE_ACTIVE
, B.AUTOCREATED_FROM_SYSTEM_ID AUTOCREATED_FROM_SYSTEM_ID
, B.ATTRIBUTE1 ATTRIBUTE1
, B.ATTRIBUTE2 ATTRIBUTE2
, B.ATTRIBUTE3 ATTRIBUTE3
, B.ATTRIBUTE4 ATTRIBUTE4
, B.ATTRIBUTE5 ATTRIBUTE5
, B.ATTRIBUTE6 ATTRIBUTE6
, B.ATTRIBUTE7 ATTRIBUTE7
, B.ATTRIBUTE8 ATTRIBUTE8
, B.ATTRIBUTE9 ATTRIBUTE9
, B.ATTRIBUTE10 ATTRIBUTE10
, B.ATTRIBUTE11 ATTRIBUTE11
, B.ATTRIBUTE12 ATTRIBUTE12
, B.ATTRIBUTE13 ATTRIBUTE13
, B.ATTRIBUTE14 ATTRIBUTE14
, B.ATTRIBUTE15 ATTRIBUTE15
, B.CONTEXT CONTEXT
, B.CONFIG_SYSTEM_TYPE CONFIG_SYSTEM_TYPE
, T.NAME NAME
, T.DESCRIPTION DESCRIPTION
, NULL ORG_ID
FROM CSI_SYSTEMS_TL T
, CSI_SYSTEMS_B B
WHERE B.SYSTEM_ID = T.SYSTEM_ID AND T.LANGUAGE = USERENV('LANG')