[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IBY_ACTIVITY |
|---|---|
| Object Type: | TABLE |
| Owner: | IBY |
| FND Design Data: |  IBY.IBY_ACTIVITY
|
| Subobject Name: | |
| Status: | VALID |
IBY_ACTIVITY stores scheduler related activities.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IBY_ACT_JTF_ACT_ACT_LOGS_ID_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 JTF_ACT_ACTIVITY_LOGS_ID
|
| IBY_ACT_ACTIVITY_NAME_ID_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ACTIVITY_NAME_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| JTF_ACT_ACTIVITY_LOGS_ID | NUMBER | Yes | JTF Activity Log Identifier | |
| APPLICATION_ID | NUMBER | Yes | Application Identifier | |
| ACTIVITY_NAME_ID | NUMBER | Yes | Activity Name Identifier which logs this activity | |
| JTF_ACT_ACTIVITY_LOGS_USER_ID | NUMBER | JTF Activity Log User Identifier | ||
| COMPONENT | VARCHAR2 | (255) | Subcomponent of the Loging activity | |
| COLUMN1 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN2 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN3 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN4 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN5 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN6 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN7 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN8 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN9 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN10 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN11 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN12 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN13 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN14 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN15 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN16 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN17 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN18 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN19 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN20 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN21 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN22 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN23 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN24 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN25 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN26 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN27 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN28 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN29 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN30 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN31 | VARCHAR2 | (255) | vthe columns which stores the values of activities. | |
| COLUMN32 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN33 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN34 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN35 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN36 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN37 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN38 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN39 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| COLUMN40 | VARCHAR2 | (255) | the columns which stores the values of activities. | |
| CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| OBJECT_VERSION_NUMBER | NUMBER | This column is used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. The situation occurs when the HTML application is an 'stateless' application. | ||
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT JTF_ACT_ACTIVITY_LOGS_ID
, APPLICATION_ID
, ACTIVITY_NAME_ID
, JTF_ACT_ACTIVITY_LOGS_USER_ID
, COMPONENT
, COLUMN1
, COLUMN2
, COLUMN3
, COLUMN4
, COLUMN5
, COLUMN6
, COLUMN7
, COLUMN8
, COLUMN9
, COLUMN10
, COLUMN11
, COLUMN12
, COLUMN13
, COLUMN14
, COLUMN15
, COLUMN16
, COLUMN17
, COLUMN18
, COLUMN19
, COLUMN20
, COLUMN21
, COLUMN22
, COLUMN23
, COLUMN24
, COLUMN25
, COLUMN26
, COLUMN27
, COLUMN28
, COLUMN29
, COLUMN30
, COLUMN31
, COLUMN32
, COLUMN33
, COLUMN34
, COLUMN35
, COLUMN36
, COLUMN37
, COLUMN38
, COLUMN39
, COLUMN40
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
FROM IBY.IBY_ACTIVITY;
IBY.IBY_ACTIVITY does not reference any database object
IBY.IBY_ACTIVITY is referenced by following:
IBY
IBY_ACTIVITY#
|
|
|
|