[Home] [Help] [Dependency Information]
Object Name: | IGS_TR_TSTP_GRP_LMT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_TR_TSTP_GRP_LMT |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This table will store the Step Group Limit for the Step Group ID of Tracking Step Types
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_TR_TSTP_GRP_LMT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TRACKING_TYPE
STEP_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRACKING_TYPE | VARCHAR2 | (10) | Yes | Stores the Tracking Type for which the group id are present |
STEP_GROUP_ID | NUMBER | (10) | Yes | Step group Id for the Tracking Step Types |
STEP_GROUP_LIMIT | NUMBER | (10) | Yes | Step group limit for teh Step group ID for the Tracking Step Types |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT TRACKING_TYPE
, STEP_GROUP_ID
, STEP_GROUP_LIMIT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_TR_TSTP_GRP_LMT;
IGS.IGS_TR_TSTP_GRP_LMT does not reference any database object
IGS.IGS_TR_TSTP_GRP_LMT is referenced by following:
|
|
|