[Home] [Help] [Dependency Information]
Object Name: | XNP_SV_AUDITS# |
---|---|
Object Type: | VIEW |
Owner: | XNP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SV_AUDIT_ID | NUMBER | Yes | ||
OBJECT_REFERENCE | VARCHAR2 | (80) | Yes | |
SP_ID | NUMBER | Yes | ||
AUDIT_NAME | VARCHAR2 | (40) | Yes | |
AUDIT_TYPE | VARCHAR2 | (10) | Yes | |
STATUS_CODE | VARCHAR2 | (10) | Yes | |
STARTING_NUMBER | VARCHAR2 | (20) | Yes | |
ENDING_NUMBER | VARCHAR2 | (20) | ||
FOR_SP_ID | NUMBER | |||
NUMBER_OF_TN_AUDITED | NUMBER | |||
ACTIVATION_START_DATE | DATE | |||
ACTIVATION_END_DATE | DATE | |||
NOTES | VARCHAR2 | (1996) | ||
ROUTING_NUMBER_FLAG | VARCHAR2 | (1) | ||
CNAM_FLAG | VARCHAR2 | (1) | ||
ISVM_FLAG | VARCHAR2 | (1) | ||
LIDB_FLAG | VARCHAR2 | (1) | ||
CLASS_FLAG | VARCHAR2 | (1) | ||
WSMSC_FLAG | VARCHAR2 | (1) | ||
RN_FLAG | VARCHAR2 | (1) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
SECURITY_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SV_AUDIT_ID
, OBJECT_REFERENCE
, SP_ID
, AUDIT_NAME
, AUDIT_TYPE
, STATUS_CODE
, STARTING_NUMBER
, ENDING_NUMBER
, FOR_SP_ID
, NUMBER_OF_TN_AUDITED
, ACTIVATION_START_DATE
, ACTIVATION_END_DATE
, NOTES
, ROUTING_NUMBER_FLAG
, CNAM_FLAG
, ISVM_FLAG
, LIDB_FLAG
, CLASS_FLAG
, WSMSC_FLAG
, RN_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM XNP.XNP_SV_AUDITS#;
|
|
|