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

TABLE: CSL.CSL_CONTR_BUSS_PROCESSES_ACC

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


Table stores the business processes 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_PROCESSES_ACC_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ID
ColumnBUSINESS_PROCESS_ID
ColumnINCIDENT_ID
CSL_CONTR_BUS_PROCESSES_ACC_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCESS_ID
CSL_CONTR_BUS_PROCESSES_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
BUSINESS_PROCESS_ID NUMBER
Yes PK - Foreign key to CS_BUSINESS_PROCESSES.BUSINESS_PROCESS_ID
INCIDENT_ID NUMBER
Yes PK- Foreign key to CSL_SR_CONTRACT_HEADERS.INCIDENT_ID
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
,      BUSINESS_PROCESS_ID
,      INCIDENT_ID
,      ACCESS_ID
,      COUNTER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM CSL.CSL_CONTR_BUSS_PROCESSES_ACC;

Dependencies

[top of page]

CSL.CSL_CONTR_BUSS_PROCESSES_ACC does not reference any database object

CSL.CSL_CONTR_BUSS_PROCESSES_ACC is referenced by following:

SchemaAPPS
SynonymCSL_CONTR_BUSS_PROCESSES_ACC