eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CSI.CSI_T_TXN_SYSTEMS

Object Details

Object Name:	CSI_T_TXN_SYSTEMS
Object Type:	TABLE
Owner:	CSI
FND Design Data:	CSI.CSI_T_TXN_SYSTEMS
Subobject Name:
Status:	VALID

Transaction Details : System Details.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSI_T_TXN_SYSTEMS_U01	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_SYSTEM_ID
CSI_T_TXN_SYSTEMS_N01	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SYSTEM_NAME
CSI_T_TXN_SYSTEMS_N02	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_LINE_ID
CSI_T_TXN_SYSTEMS_N03	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID
CSI_T_TXN_SYSTEMS_N04	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BILL_TO_CONTACT_ID
CSI_T_TXN_SYSTEMS_N05	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SERVICE_ADMIN_CONTACT_ID
CSI_T_TXN_SYSTEMS_N06	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIP_TO_CONTACT_ID
CSI_T_TXN_SYSTEMS_N07	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TECHNICAL_CONTACT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_SYSTEM_ID	NUMBER		Yes	Primary Key
SYSTEM_NAME	VARCHAR2	(50)	Yes	Name of the system that needs to be created in IB
DESCRIPTION	VARCHAR2	(240)		Description of the system
SYSTEM_TYPE_CODE	VARCHAR2	(30)	Yes	System Type Code
SYSTEM_NUMBER	VARCHAR2	(30)		System Serial Number , if any.
BILL_TO_CONTACT_ID	NUMBER		Yes	Contact Party ID
SHIP_TO_CONTACT_ID	NUMBER		Yes	Contact Party ID
TECHNICAL_CONTACT_ID	NUMBER		Yes	Contact Party ID
SERVICE_ADMIN_CONTACT_ID	NUMBER		Yes	Contact Party ID
SHIP_TO_SITE_USE_ID	NUMBER		Yes	Ship to Site
BILL_TO_SITE_USE_ID	NUMBER		Yes	Bill / Invoice to Site
COTERMINATE_DAY_MONTH	VARCHAR2	(6)		Coterminate day month
CONFIG_SYSTEM_TYPE	VARCHAR2	(30)		Config System Type Code
CONTEXT	VARCHAR2	(30)		Standard DFF Columns
ATTRIBUTE1	VARCHAR2	(150)		Standard DFF Columns
ATTRIBUTE2	VARCHAR2	(150)		Standard DFF Columns
ATTRIBUTE3	VARCHAR2	(150)		Standard DFF Columns
ATTRIBUTE4	VARCHAR2	(150)		Standard DFF Columns
ATTRIBUTE5	VARCHAR2	(150)		Standard DFF Columns
ATTRIBUTE6	VARCHAR2	(150)		Standard DFF Columns
ATTRIBUTE7	VARCHAR2	(150)		Standard DFF Columns
ATTRIBUTE8	VARCHAR2	(150)		Standard DFF Columns
ATTRIBUTE9	VARCHAR2	(150)		Standard DFF Columns
ATTRIBUTE10	VARCHAR2	(150)		Standard DFF Columns
ATTRIBUTE11	VARCHAR2	(150)		Standard DFF Columns
ATTRIBUTE12	VARCHAR2	(150)		Standard DFF Columns
ATTRIBUTE13	VARCHAR2	(150)		Standard DFF Columns
ATTRIBUTE14	VARCHAR2	(150)		Standard DFF Columns
ATTRIBUTE15	VARCHAR2	(150)		Standard DFF Columns
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Columns
CREATION_DATE	DATE		Yes	Standard WHO Columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Columns
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Columns
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number.
SECURITY_GROUP_ID	NUMBER			Security Group Identifier.
INSTALL_SITE_USE_ID	NUMBER		Yes	Install Site
TRANSACTION_LINE_ID	NUMBER		Yes	FK to the CSI_T_TRANSACTION_LINES Table
CUSTOMER_ID	NUMBER		Yes	Cust Account / Customer on the System
START_DATE_ACTIVE	DATE			Activation Start Date.
END_DATE_ACTIVE	DATE			Activation End Date.
REQUEST_ID	NUMBER			Column for the Account Merge.
PROGRAM_APPLICATION_ID	NUMBER			Column for the Account Merge.
PROGRAM_ID	NUMBER			Column for the Account Merge.
PROGRAM_UPDATE_DATE	DATE			Column for the Account Merge.
MIGRATED_FLAG	VARCHAR2	(1)		Flag indicating if the record is created as a part of migration.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_SYSTEM_ID
,      SYSTEM_NAME
,      DESCRIPTION
,      SYSTEM_TYPE_CODE
,      SYSTEM_NUMBER
,      BILL_TO_CONTACT_ID
,      SHIP_TO_CONTACT_ID
,      TECHNICAL_CONTACT_ID
,      SERVICE_ADMIN_CONTACT_ID
,      SHIP_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      COTERMINATE_DAY_MONTH
,      CONFIG_SYSTEM_TYPE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      INSTALL_SITE_USE_ID
,      TRANSACTION_LINE_ID
,      CUSTOMER_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      MIGRATED_FLAG
FROM CSI.CSI_T_TXN_SYSTEMS;

Dependencies

[top of page]

CSI.CSI_T_TXN_SYSTEMS does not reference any database object

CSI.CSI_T_TXN_SYSTEMS is referenced by following:

APPS: CSI_T_TXN_SYSTEMS