[Home] [Help] [Dependency Information]
Object Name: | ISC_FS_TASK_BAC_DATES_F |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
This table stores a row for all of the dates necessary to render all of the task backlog aging and backlog aging trend reports. It also stores previously collected rows for XTD period end dates. These rows are retained as there is a high probablity that they will be reused for another date in the same of future period. Rows that do not represent XTD period end dates are deleted if they are not required for the current date to ensure the size of the materialized views based on this table do not explode.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_FS_TASK_BAC_DATES_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | REPORT_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPORT_DATE | DATE | Yes | Report Date | |
AGING_DATE | DATE | Yes | Aging Date (and time) | |
XTD_END_DATE_FLAG | VARCHAR2 | (1) | Yes | Indicates if aging date is for at least one XTD period end date |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
PROGRAM_ID | NUMBER | Standard who column | ||
PROGRAM_LOGIN_ID | NUMBER | Standard who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard who column | ||
REQUEST_ID | NUMBER | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT REPORT_DATE
, AGING_DATE
, XTD_END_DATE_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM ISC.ISC_FS_TASK_BAC_DATES_F;
ISC.ISC_FS_TASK_BAC_DATES_F does not reference any database object
ISC.ISC_FS_TASK_BAC_DATES_F is referenced by following:
|
|
|