[Home] [Help] [Dependency Information]
Object Name: | HXC_APP_COMP_NOTIF_USAGES |
---|---|
Object Type: | TABLE |
Owner: | HXC |
FND Design Data: | HXC.HXC_APP_COMP_NOTIF_USAGES |
Subobject Name: | |
Status: | VALID |
HXC_APP_COMP_NOTIF_USAGES table contains intersection entity between the approval components table and HXC_APP_COMP_NOTIFICATIONS table
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HXC_APP_COMP_NOTIF_USAGES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
APPROVAL_COMP_ID
APPROVAL_COMP_OVN |
HXC_APP_COMP_NOTIF_USAGES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
COMP_NOTIFICATION_ID
COMP_NOTIFICATION_OVN |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPROVAL_COMP_ID | NUMBER | (15) | Yes | Approval Component ID |
APPROVAL_COMP_OVN | NUMBER | (9) | Approval Component Object Version Number | |
COMP_NOTIFICATION_ID | NUMBER | (15) | Yes | Component Notification ID |
COMP_NOTIFICATION_OVN | NUMBER | (9) | Yes | Component Notification Object Version Number |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Enabled Flag |
Cut, paste (and edit) the following text to query this object:
SELECT APPROVAL_COMP_ID
, APPROVAL_COMP_OVN
, COMP_NOTIFICATION_ID
, COMP_NOTIFICATION_OVN
, ENABLED_FLAG
FROM HXC.HXC_APP_COMP_NOTIF_USAGES;
HXC.HXC_APP_COMP_NOTIF_USAGES does not reference any database object
HXC.HXC_APP_COMP_NOTIF_USAGES is referenced by following:
|
|
|