eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: BIV.BIV_DBI_BACKLOG_AGE_DATES

Object Details

Object Name:	BIV_DBI_BACKLOG_AGE_DATES
Object Type:	TABLE
Owner:	BIV
Subobject Name:
Status:	VALID

This table stores the distinct list of dates that are needed to statisfy all Current Backlog Aging and Current Backlog Aging Trend reports. It is refreshed each time the initial or incremental load process is run. The dates are all relative the initial or incremental load date.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Columns

Name	Datatype	Mandatory	Comments
REPORT_DATE	DATE	Yes	The date of the backlog
RECORD_TYPE_ID	NUMBER	Yes	This is a number that represents the use of the report date. A single report can have multiple uses based on period type and current/prior. The column is not used by any process, it exists to enable manual analysis of the row.
CREATION_DATE	DATE	Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	Yes	Standard who column - user who created 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_UPDATED_BY	NUMBER	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REPORT_DATE
,      RECORD_TYPE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM BIV.BIV_DBI_BACKLOG_AGE_DATES;

Dependencies

[top of page]

BIV.BIV_DBI_BACKLOG_AGE_DATES does not reference any database object

BIV.BIV_DBI_BACKLOG_AGE_DATES is referenced by following:

APPS: BIV_DBI_BACKLOG_AGE_DATES