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: BIS.BIS_PMF_ALERT_PARAMETERS

Object Details

Object Name:	BIS_PMF_ALERT_PARAMETERS
Object Type:	TABLE
Owner:	BIS
FND Design Data:	BIS.BIS_PMF_ALERT_PARAMETERS
Subobject Name:
Status:	VALID

BIS_PMF_ALERT_PARAMETERS, contains the information about the notifiers for all the combination of performance measure and the dimension levels values, for which the user registered the interest to be notified.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIS_PMF_ALERT_PARAMETERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REGISTRATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REGISTRATION_ID	NUMBER		Yes	Alert Registration ID
PERFORMANCE_MEASURE_ID	NUMBER			Performance Measure ID
TARGET_LEVEL_ID	NUMBER			Target Level ID Column
TIME_DIMENSION_LEVEL_ID	NUMBER			Time Dimension level ID. Time dimension for which the alert is scheduled.
PLAN_ID	NUMBER			Business plan ID
NOTIFIERS_CODE	VARCHAR2	(250)		Notifier Code. This is a workflow role to which the alert is sent.
PARAMETER1_VALUE	VARCHAR2	(80)		Parameter1 Level value
PARAMETER2_VALUE	VARCHAR2	(80)		Parameter2 Level value
PARAMETER3_VALUE	VARCHAR2	(80)		Parameter3 Level value
PARAMETER4_VALUE	VARCHAR2	(80)		Parameter4 Level value
PARAMETER5_VALUE	VARCHAR2	(80)		Parameter5 Level value
PARAMETER6_VALUE	VARCHAR2	(80)		Parameter6 Level value
PARAMETER7_VALUE	VARCHAR2	(80)		Parameter7 Level value
NOTIFY_OWNER_FLAG	VARCHAR2	(1)		Flag to specify whether the Owner of the target should be notified or not
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 REGISTRATION_ID
,      PERFORMANCE_MEASURE_ID
,      TARGET_LEVEL_ID
,      TIME_DIMENSION_LEVEL_ID
,      PLAN_ID
,      NOTIFIERS_CODE
,      PARAMETER1_VALUE
,      PARAMETER2_VALUE
,      PARAMETER3_VALUE
,      PARAMETER4_VALUE
,      PARAMETER5_VALUE
,      PARAMETER6_VALUE
,      PARAMETER7_VALUE
,      NOTIFY_OWNER_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM BIS.BIS_PMF_ALERT_PARAMETERS;

Dependencies

[top of page]

BIS.BIS_PMF_ALERT_PARAMETERS does not reference any database object

BIS.BIS_PMF_ALERT_PARAMETERS is referenced by following:

APPS: BIS_PMF_ALERT_PARAMETERS