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]

VIEW: APPS.IRCBV_NOTIFICATION_PREFER_V

Object Details

Object Name:	IRCBV_NOTIFICATION_PREFER_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

Notification preference (from IRC_NOTIFICATION_PREFERENCES table).

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
MATCHING_JOBS_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
MATCHING_JOB_FREQ_M	VARCHAR2	(4000)		Matching job frequency.
RECEIVE_INFO_MAIL_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
ALLOW_ACCESS_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
MATCHING_JOB_FREQ	VARCHAR2	(30)	Yes	Matching job frequency.
MATCHING_JOBS	VARCHAR2	(30)	Yes	(Lookup code based on lookup type YES_NO).
RECEIVE_INFO_MAIL	VARCHAR2	(30)	Yes	(Lookup code based on lookup type YES_NO).
ALLOW_ACCESS	VARCHAR2	(30)	Yes	(Lookup code based on lookup type YES_NO).
_DF:INP	CHAR	(40)
ADDRESS_ID	NUMBER	(15)		Foreign key to PER_ADDRESSES.
PARTY_ID	NUMBER	(15)		Foreign key to HZ_PARTIES.
NOTIFICATION_PREFERENCE_ID	NUMBER	(15)	Yes	Foreign key to IRC_NOTIFICATION_PREFERENCES.
PERSON_ID	NUMBER	(15)	Yes	Foreign key to PER_ALL_PEOPLE_F.
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT MATCHING_JOBS_M
,      MATCHING_JOB_FREQ_M
,      RECEIVE_INFO_MAIL_M
,      ALLOW_ACCESS_M
,      MATCHING_JOB_FREQ
,      MATCHING_JOBS
,      RECEIVE_INFO_MAIL
,      ALLOW_ACCESS
,      _DF:INP
,      ADDRESS_ID
,      PARTY_ID
,      NOTIFICATION_PREFERENCE_ID
,      PERSON_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.IRCBV_NOTIFICATION_PREFER_V;

Dependencies

[top of page]

APPS.IRCBV_NOTIFICATION_PREFER_V references the following:

APPS: HR_BIS - show dependent code; IRC_NOTIFICATION_PREFERENCES

APPS.IRCBV_NOTIFICATION_PREFER_V is not referenced by any database object