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

TABLE: CSL.CSL_CONTR_BUSS_TXN_TYPES_ACC

Object Details
Object Name: CSL_CONTR_BUSS_TXN_TYPES_ACC
Object Type: TABLE
Owner: CSL
Subobject Name:
Status: VALID


Table stores the transaction types for contracts per resource which needs to be replicated


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSL_CONTR_BUS_TXN_TYPES_ACC_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ID
ColumnTXN_BILLING_TYPE_ID
ColumnBUSINESS_PROCESS_ID
ColumnINCIDENT_ID
CSL_CONTR_BUS_TXN_TYPES_ACC_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCESS_ID
CSL_CONTR_BUS_TXN_TYPES_ACC_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOUNTER
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Yes Mobile resource ID, references to JTF_RS_RESOURCE_EXTNS.RESOURCE_ID
TXN_BILLING_TYPE_ID NUMBER
Yes The transaction billing type identifier.
BUSINESS_PROCESS_ID NUMBER
Yes Key to identify a transaction group
INCIDENT_ID NUMBER
Yes Indentifier to CS_INCIDENTS_ALL_B
ACCESS_ID NUMBER

PK - Indentifier for replication
COUNTER NUMBER

Counter, indicates the amount of reasons for the record to be replicated
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
Query Text

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


SELECT RESOURCE_ID
,      TXN_BILLING_TYPE_ID
,      BUSINESS_PROCESS_ID
,      INCIDENT_ID
,      ACCESS_ID
,      COUNTER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM CSL.CSL_CONTR_BUSS_TXN_TYPES_ACC;

Dependencies

[top of page]

CSL.CSL_CONTR_BUSS_TXN_TYPES_ACC does not reference any database object

CSL.CSL_CONTR_BUSS_TXN_TYPES_ACC is referenced by following:

SchemaCSL
ViewCSL_CONTR_BUSS_TXN_TYPES_ACC#