[Home] [Help] [Dependency Information]
Object Name: | JTM_WF_NOTIFICATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCESS_ID | NUMBER | |||
NOTIFICATION_ID | NUMBER | Yes | ||
GROUP_ID | NUMBER | Yes | ||
MESSAGE_TYPE | VARCHAR2 | (8) | Yes | |
MESSAGE_NAME | VARCHAR2 | (30) | Yes | |
RECIPIENT_ROLE | VARCHAR2 | (320) | Yes | |
STATUS | VARCHAR2 | (8) | Yes | |
ACCESS_KEY | VARCHAR2 | (80) | Yes | |
MAIL_STATUS | VARCHAR2 | (8) | ||
PRIORITY | NUMBER | |||
BEGIN_DATE | DATE | |||
END_DATE | DATE | |||
DUE_DATE | DATE | |||
ORIGINAL_RECIPIENT | VARCHAR2 | (320) | Yes | |
FROM_USER | VARCHAR2 | (320) | ||
TO_USER | VARCHAR2 | (320) | ||
SUBJECT | VARCHAR2 | (2000) | ||
LANGUAGE | VARCHAR2 | (4) | ||
MORE_INFO_ROLE | VARCHAR2 | (320) |
Cut, paste (and edit) the following text to query this object:
SELECT ACCESS_ID
, NOTIFICATION_ID
, GROUP_ID
, MESSAGE_TYPE
, MESSAGE_NAME
, RECIPIENT_ROLE
, STATUS
, ACCESS_KEY
, MAIL_STATUS
, PRIORITY
, BEGIN_DATE
, END_DATE
, DUE_DATE
, ORIGINAL_RECIPIENT
, FROM_USER
, TO_USER
, SUBJECT
, LANGUAGE
, MORE_INFO_ROLE
FROM APPS.JTM_WF_NOTIFICATIONS_V;
APPS.JTM_WF_NOTIFICATIONS_V is not referenced by any database object
|
|
|