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

Object Details

Object Name:	PO_WF_NOTIFICATIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.PO_WF_NOTIFICATIONS_V
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	Comments
NOTIFICATION_ID	NUMBER		Notification unique identifier
GROUP_ID	NUMBER		Grouping of notifications
MESSAGE_TYPE	VARCHAR2	(8)	Item type associated with the message
MESSAGE_NAME	VARCHAR2	(30)	The message name
RECIPIENT_ROLE	VARCHAR2	(320)	Role of the recipient of the notification
NOTIFICATION_STATUS	VARCHAR2	(8)	Status of the notification
ACCESS_KEY	VARCHAR2	(80)	Message type notification access key
MAIL_STATUS	VARCHAR2	(8)	mail status of the notification
PRIORITY	NUMBER		Priority assigned to the message (1-100)
CREATION_DATE	DATE		Standard who column - date when this row was created.
END_DATE	DATE		Expiration date of the notification
DUE_DATE	DATE		Date timeout occurs if no response
NOTE	VARCHAR2	(4000)	note passed with the notification to the next approver or reason for control action
CALLBACK	VARCHAR2	(240)	Package and procedure name used by the notification
CONTEXT	VARCHAR2	(2000)	Data used by callback to call the procedure
SUBJECT	VARCHAR2	(4000)	subject of the notification
MESSAGE	VARCHAR2	(4000)	message text of the notification
RECIPIENT_ROLE_NAME	VARCHAR2	(4000)	name of the role of the recipient of the notification
EMPLOYEE_ID	NUMBER		unique identifier of the employee taking the action
FROM_ID	NUMBER		unique ID of the employee sending the notification
EMPLOYEE_NAME	VARCHAR2	(4000)	name of the employee taking the action
FROM_EMPLOYEE_NAME	VARCHAR2	(4000)	name of the employee sending the notification
DOC_TYPE_NAME	VARCHAR2	(80)	type of the document
DOC_TYPE	VARCHAR2	(25)	document type
DOC_CREATION_DATE	DATE		standard who column
OBJECT_ID	NUMBER		document header unique identifier
DOC_NUMBER	VARCHAR2	(61)	document number
AMOUNT	VARCHAR2	(40)	document total amount
CURRENCY	VARCHAR2	(4000)	document base currency
DOC_OWNER	VARCHAR2	(4000)	Document owner
OWNER_ID	NUMBER	(9)	Unique owner identifier
DESCRIPTION	VARCHAR2	(240)	description for the document
DOC_STATUS_DSP	VARCHAR2	(25)	document authorization status
OBJECT_TYPE_CODE	VARCHAR2	(25)	document type
OBJECT_SUB_TYPE_CODE	VARCHAR2	(25)	document subtype
SEQUENCE_NUM	NUMBER		sequence of the approval or control step for a document
OBJECT_REVISION_NUM	NUMBER		document revision number
APPROVAL_PATH_ID	NUMBER		approval hierarchy unique identifier
REQUEST_ID	NUMBER		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_DATE	DATE		standard who column
PROGRAM_ID	NUMBER		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
ITEM_KEY	VARCHAR2	(240)	Workflow Item Key
ITEM_TYPE	VARCHAR2	(8)	Workflow Item Type
ROW_ID	ROWID	(10)	rowid of the underlying table
ORG_ID	NUMBER		Organization identifier
SECURITY_LEVEL_CODE	VARCHAR2	(25)
ACCESS_LEVEL_CODE	VARCHAR2	(25)

Query Text

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


SELECT NOTIFICATION_ID
,      GROUP_ID
,      MESSAGE_TYPE
,      MESSAGE_NAME
,      RECIPIENT_ROLE
,      NOTIFICATION_STATUS
,      ACCESS_KEY
,      MAIL_STATUS
,      PRIORITY
,      CREATION_DATE
,      END_DATE
,      DUE_DATE
,      NOTE
,      CALLBACK
,      CONTEXT
,      SUBJECT
,      MESSAGE
,      RECIPIENT_ROLE_NAME
,      EMPLOYEE_ID
,      FROM_ID
,      EMPLOYEE_NAME
,      FROM_EMPLOYEE_NAME
,      DOC_TYPE_NAME
,      DOC_TYPE
,      DOC_CREATION_DATE
,      OBJECT_ID
,      DOC_NUMBER
,      AMOUNT
,      CURRENCY
,      DOC_OWNER
,      OWNER_ID
,      DESCRIPTION
,      DOC_STATUS_DSP
,      OBJECT_TYPE_CODE
,      OBJECT_SUB_TYPE_CODE
,      SEQUENCE_NUM
,      OBJECT_REVISION_NUM
,      APPROVAL_PATH_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_DATE
,      PROGRAM_ID
,      LAST_UPDATE_DATE
,      ITEM_KEY
,      ITEM_TYPE
,      ROW_ID
,      ORG_ID
,      SECURITY_LEVEL_CODE
,      ACCESS_LEVEL_CODE
FROM APPS.PO_WF_NOTIFICATIONS_V;

Dependencies

[top of page]

APPS.PO_WF_NOTIFICATIONS_V references the following:

APPS: PO_ACTION_HISTORY; PO_CORE_S2 - show dependent code; PO_DOCUMENT_TYPES_ALL_B; PO_DOCUMENT_TYPES_ALL_TL; PO_HEADERS; PO_HEADERS_ALL; PO_NOTIFICATIONS_SV3 - show dependent code; PO_RELEASES; PO_REQUISITION_HEADERS; WF_DIRECTORY - show dependent code; WF_ITEM_ACTIVITY_STATUSES; WF_NOTIFICATION - show dependent code; WF_NOTIFICATIONS; WF_USERS

APPS.PO_WF_NOTIFICATIONS_V is not referenced by any database object