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

TABLE: BIV.BIV_TREND_RPT

Object Details
Object Name: BIV_TREND_RPT
Object Type: TABLE
Owner: BIV
Subobject Name:
Status: VALID


This table stores a fixed set of rows that are used to calculate the relative dates for all Service Intelligence Trend reports using rolling time periods.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CURRENT_IND NUMBER
Yes This column indicates the row's use, 1 = Current Period, 2 = Prior Period and 4 = Immediate Prior Period when comparison is Prior Year
OFFSET NUMBER
Yes This is the relative offset to the current period. This is used to determine the number of rows to display based on the period type.
MAX_DATE DATE

This column is not used
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

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

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 CURRENT_IND
,      OFFSET
,      MAX_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM BIV.BIV_TREND_RPT;

Dependencies

[top of page]

BIV.BIV_TREND_RPT does not reference any database object

BIV.BIV_TREND_RPT is referenced by following:

SchemaAPPS
SynonymBIV_TREND_RPT