[Home] [Help] [Dependency Information]
Object Name: | BIS_SCHEDULER |
---|---|
Object Type: | TABLE |
Owner: | BIS |
FND Design Data: | BIS.BIS_SCHEDULER |
Subobject Name: | |
Status: | VALID |
BIS Scheduler table
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIS_SCHEDULER_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SCHEDULE_ID |
BIS_SCHEDULER_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
USER_ID
PLUG_ID |
BIS_SCHEDULER_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
USER_ID
FUNCTION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHEDULE_ID | NUMBER | Report Schedule Id | ||
PLUG_ID | NUMBER | SSWA Plug Id | ||
USER_ID | VARCHAR2 | (80) | SSWA Userid | |
FUNCTION_NAME | VARCHAR2 | (480) | Report Function Name | |
RESPONSIBILITY_ID | VARCHAR2 | (80) | SSWA Responsibility Id | |
TITLE | VARCHAR2 | (80) | Schedule Report Title | |
GRAPH_TYPE | NUMBER | (2) | Schedule Report Graph Type | |
FILE_ID | NUMBER | File Id | ||
CONCURRENT_REQUEST_ID | NUMBER | Concurrent Request Id | ||
REPORT_REGION_CODE | VARCHAR2 | (80) | Report's AK Region Code | |
PARAMETER_STRING | VARCHAR2 | (4000) | Parameters string with which the report was run | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (20) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (20) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (20) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CACHED_GRAPH | LONG | (0) | Cached Graph |
Cut, paste (and edit) the following text to query this object:
SELECT SCHEDULE_ID
, PLUG_ID
, USER_ID
, FUNCTION_NAME
, RESPONSIBILITY_ID
, TITLE
, GRAPH_TYPE
, FILE_ID
, CONCURRENT_REQUEST_ID
, REPORT_REGION_CODE
, PARAMETER_STRING
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CACHED_GRAPH
FROM BIS.BIS_SCHEDULER;
BIS.BIS_SCHEDULER does not reference any database object
BIS.BIS_SCHEDULER is referenced by following:
|
|
|