DBA Data[Home] [Help] [Dependency Information]

TABLE: XNP.XNP_AUDIT_SMS_FAILURES

Object Details
Object Name: XNP_AUDIT_SMS_FAILURES
Object Type: TABLE
Owner: XNP
FND Design Data: TableXNP.XNP_AUDIT_SMS_FAILURES
Subobject Name:
Status: VALID


XNP_AUDIT_SMS_FAILURES stores a list of service providers that failed to provide requested audit information. This is an optional list in the audit results. This table will not be used in the current release.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XNP_AUDIT_SMS_FAILURES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSMS_FAILURE_ID
XNP_AUDIT_SMS_FAILURES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUDIT_ID
ColumnSP_ID
ColumnFAILURE_DATE
XNP_AUDIT_SMS_FAILURES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSP_ID
Columns
Name Datatype Length Mandatory Comments
SMS_FAILURE_ID NUMBER
Yes SMS failure identifier
AUDIT_ID NUMBER
Yes Audit Identifier
SP_ID NUMBER
Yes Service Provider identifier that failed to respond
FAILURE_DATE DATE
Yes Date and time of failure
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

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


SELECT SMS_FAILURE_ID
,      AUDIT_ID
,      SP_ID
,      FAILURE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XNP.XNP_AUDIT_SMS_FAILURES;

Dependencies

[top of page]

XNP.XNP_AUDIT_SMS_FAILURES does not reference any database object

XNP.XNP_AUDIT_SMS_FAILURES is referenced by following:

SchemaAPPS
SynonymXNP_AUDIT_SMS_FAILURES