[Home] [Help] [Dependency Information]
Object Name: | CS_BUS_PROCESS_TXNS |
---|---|
Object Type: | TABLE |
Owner: | CS |
FND Design Data: | CS.CS_BUS_PROCESS_TXNS |
Subobject Name: | |
Status: | VALID |
This table stores associations between Transactions Types and Business Processes. Each Business Process can be assigned one or more transaction types. Each assignment can have an effective period, which can differ from the individual effective periods of the Business Processes and Transaction Types.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CS_BUS_PROCESS_TXNS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
BUSINESS_PROCESS_ID
TRANSACTION_TYPE_ID |
CS_BUS_PROCESS_TXNS_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | TRANSACTION_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_PROCESS_ID | NUMBER | (15) | Yes | Unique key to identify a business process transaction |
TRANSACTION_TYPE_ID | NUMBER | (15) | Yes | The Transaction Type associated with the Business Process; foreign key to CS_TRANSACTION_TYPES_B. |
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 |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
START_DATE_ACTIVE | DATE | Effective start date of the transaction associated with the transaction group | ||
END_DATE_ACTIVE | DATE | Effective end date of the transaction associated with the transaction group | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_PROCESS_ID
, TRANSACTION_TYPE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, SECURITY_GROUP_ID
FROM CS.CS_BUS_PROCESS_TXNS;
CS.CS_BUS_PROCESS_TXNS does not reference any database object
CS.CS_BUS_PROCESS_TXNS is referenced by following:
|
|
|