[Home] [Help] [Dependency Information]
Object Name: | CS_SR_STATUS_GROUPS_B |
---|---|
Object Type: | TABLE |
Owner: | CS |
FND Design Data: | CS.CS_SR_STATUS_GROUPS_B |
Subobject Name: | |
Status: | VALID |
Stores non-translated Information about the status rules.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CS_SR_STATUS_GROUP_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED | STATUS_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATUS_GROUP_ID | NUMBER | Yes | Primary Key. Status group identifier. | |
DEFAULT_INCIDENT_STATUS_ID | NUMBER | (15) | This is a FK to CS_INCIDENT_STATUSES_B.INCIDENT_STATUS_ID. This will be one of the allowed statuses for this status group with the initial flag set to 'Y'.This status will be defaulted to the Service request created using this status group, if a status is not passed. | |
TRANSITION_IND | VARCHAR2 | (3) | Transition Indicator. This will indicate if there are any transitions attached to this status group. | |
START_DATE | DATE | Date from which the status group was / will be active. | ||
END_DATE | DATE | Date from which the status group was / will be inactive. | ||
CREATION_DATE | DATE | Yes | Who column. Date on which the record was created. | |
CREATED_BY | NUMBER | Yes | Who column. User id of the user who created the record. | |
LAST_UPDATE_DATE | DATE | Yes | Who column. Date the record was last updated. | |
LAST_UPDATED_BY | NUMBER | Yes | Who column. ID of the user who last updated the record. | |
LAST_UPDATE_LOGIN | NUMBER | Who column. Login ID of the OS user who last updated the record. | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Specifies how many updates the link record has gone through. This value is used in obtainint a lock before updates are performed. | |
SECURITY_GROUP_ID | NUMBER | (15) | Data striping attribute used by the Hosting product. | |
ORIG_SYSTEM_REFERENCE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT STATUS_GROUP_ID
, DEFAULT_INCIDENT_STATUS_ID
, TRANSITION_IND
, START_DATE
, END_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, ORIG_SYSTEM_REFERENCE_ID
FROM CS.CS_SR_STATUS_GROUPS_B;
CS.CS_SR_STATUS_GROUPS_B does not reference any database object
CS.CS_SR_STATUS_GROUPS_B is referenced by following:
|
|
|