[Home] [Help] [Dependency Information]
Object Name: | IGS_TR_TYP_STEP_NOTE |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_TR_TYP_STEP_NOTE |
Subobject Name: | |
Status: | VALID |
IGS_TR_TYP_STEP_NOTE stores references to notes held against a tracking type step.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_TR_TYP_STEP_NOTE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TRACKING_TYPE
TRACKING_TYPE_STEP_ID REFERENCE_NUMBER |
IGS_TR_TYP_STEP_NOTE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REFERENCE_NUMBER |
IGS_TR_TYP_STEP_NOTE_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRK_NOTE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRACKING_TYPE | VARCHAR2 | (10) | Yes | Describes the user definable tracking types that are used to assist in identifying the items being tracked. These map back onto system defined tracking types that are recognized by system functionality. For example, special consideration application, advanced standing application, review of outcome application. |
TRACKING_TYPE_STEP_ID | NUMBER | (2) | Yes | Uniquely identifies each occurrence of a tracking type step within a tracking type |
REFERENCE_NUMBER | NUMBER | Yes | Uniquely identifies each occurrence of a note | |
TRK_NOTE_TYPE | VARCHAR2 | (10) | Yes | Name of a type of note used within the tracking facility. Note types are institution-defined and are used for the purpose of a categorizing notes. |
ORG_ID | NUMBER | Operating unit identifier | ||
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
, TRACKING_TYPE_STEP_ID
, REFERENCE_NUMBER
, TRK_NOTE_TYPE
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_TR_TYP_STEP_NOTE;
IGS.IGS_TR_TYP_STEP_NOTE does not reference any database object
IGS.IGS_TR_TYP_STEP_NOTE is referenced by following:
|
|
|