[Home] [Help] [Dependency Information]
Object Name: | IBE_WF_NOTIF_SETUP |
---|---|
Object Type: | TABLE |
Owner: | IBE |
FND Design Data: | IBE.IBE_WF_NOTIF_SETUP |
Subobject Name: | |
Status: | VALID |
This table stores information about supported Work Flow notifications in iStore.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBE_WF_NOTIF_SETUP_U1 | NORMAL | UNIQUE | APPS_TS_SEED | NOTIF_SETUP_ID |
IBE_WF_NOTIF_SETUP_U2 | NORMAL | UNIQUE | APPS_TS_SEED | NOTIFICATION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NOTIF_SETUP_ID | NUMBER | Yes | Unique identifier for notification setup. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object Version Number for Locking |
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
NOTIFICATION_NAME | VARCHAR2 | (30) | Yes | Workflow Notification Name |
ORG_ID_FLAG | VARCHAR2 | (3) | Yes | Flag to indicate that the notification is configurable using Operating Unit. |
MSITE_ID_FLAG | VARCHAR2 | (3) | Yes | Flag to indicate the notification is configurable using Specialty Store. |
USER_TYPE_FLAG | VARCHAR2 | (3) | Yes | Flag to indicate if the notification configurable by user type. |
ENABLED_FLAG | VARCHAR2 | (3) | Yes | Flag to Indicate the Notification is enabled. |
DEFAULT_MESSAGE_NAME | VARCHAR2 | (30) | Yes | Default Message Name for this Notification |
UPDATE_ENABLED_FLAG | VARCHAR2 | (3) | Yes | Flag to Indicate if the notification can be enabled/disabled at will. |
CUSTOMIZED_FLAG | VARCHAR2 | (3) | Flag to indicate that this row is customized by merchant. | |
SECURITY_GROUP_ID | NUMBER | Security Group Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT NOTIF_SETUP_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, NOTIFICATION_NAME
, ORG_ID_FLAG
, MSITE_ID_FLAG
, USER_TYPE_FLAG
, ENABLED_FLAG
, DEFAULT_MESSAGE_NAME
, UPDATE_ENABLED_FLAG
, CUSTOMIZED_FLAG
, SECURITY_GROUP_ID
FROM IBE.IBE_WF_NOTIF_SETUP;
IBE.IBE_WF_NOTIF_SETUP does not reference any database object
IBE.IBE_WF_NOTIF_SETUP is referenced by following:
|
|
|