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.CN_NOTIFY_LOG_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
NOTIFY_LOG_ID	NUMBER	(15)	Yes	notify log id
NOTIFY_LOG_DATE	DATE			notify log date
DELETE_DATE	DATE			delete date
EVENT_LOG_ID	NUMBER	(15)		event log id
NOTIFY_NAME	VARCHAR2	(30)		notify name
NOTIFY_ACTION	VARCHAR2	(30)		notify action
OBJECT_OWNER_ID	NUMBER	(15)		object owner id
OBJECT_ID	NUMBER	(15)		object id
OBJECT_TYPE	VARCHAR2	(30)		object type
OBJECT_NAME	VARCHAR2	(80)		object name
STATUS	VARCHAR2	(30)		status
PRIORITY	NUMBER	(3)		priority
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ORG_ID	NUMBER	(15)		Organization identifier
SALESREP_ID	NUMBER	(15)		salesrep id
PERIOD_ID	NUMBER	(15)		period id
REVERT_STATE	VARCHAR2	(30)		revert to state
START_DATE	DATE			start date
END_DATE	DATE			end date
QUOTA_ID	NUMBER	(15)		plan element id
COMP_GROUP_ID	NUMBER	(15)		compensation group id
ACTION	VARCHAR2	(30)		action
ACTION_LINK_ID	NUMBER	(15)		action link id
BASE_SALESREP_ID	NUMBER	(15)		base salesrep id
BASE_COMP_GROUP_ID	NUMBER	(15)		base compensation group id
PHYSICAL_BATCH_ID	NUMBER	(15)		physical batch id
SALESREP_NAME	VARCHAR2	(360)		salesrep name
PERIOD_NAME	VARCHAR2	(30)	Yes	period name
STATUS_NAME	VARCHAR2	(80)	Yes	status name
REVERT_STATE_NAME	VARCHAR2	(80)	Yes	revert state name
COMP_GROUP_NAME	VARCHAR2	(60)		compensation group name
BASE_COMP_GROUP_NAME	VARCHAR2	(60)		base compensation group name
BASE_SALESREP_NAME	VARCHAR2	(360)		base salesrep name

Query Text

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


SELECT NOTIFY_LOG_ID
,      NOTIFY_LOG_DATE
,      DELETE_DATE
,      EVENT_LOG_ID
,      NOTIFY_NAME
,      NOTIFY_ACTION
,      OBJECT_OWNER_ID
,      OBJECT_ID
,      OBJECT_TYPE
,      OBJECT_NAME
,      STATUS
,      PRIORITY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ORG_ID
,      SALESREP_ID
,      PERIOD_ID
,      REVERT_STATE
,      START_DATE
,      END_DATE
,      QUOTA_ID
,      COMP_GROUP_ID
,      ACTION
,      ACTION_LINK_ID
,      BASE_SALESREP_ID
,      BASE_COMP_GROUP_ID
,      PHYSICAL_BATCH_ID
,      SALESREP_NAME
,      PERIOD_NAME
,      STATUS_NAME
,      REVERT_STATE_NAME
,      COMP_GROUP_NAME
,      BASE_COMP_GROUP_NAME
,      BASE_SALESREP_NAME
FROM APPS.CN_NOTIFY_LOG_V;

Dependencies

[top of page]

APPS.CN_NOTIFY_LOG_V references the following:

APPS: CN_ACC_PERIOD_STATUSES_V; CN_COMP_GROUPS; CN_LOOKUPS; CN_NOTIFY_LOG; CN_SALESREPS

APPS.CN_NOTIFY_LOG_V is not referenced by any database object