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

TABLE: AR.ARI_REG_VERIFICATIONS

Object Details
Object Name: ARI_REG_VERIFICATIONS
Object Type: TABLE
Owner: AR
Subobject Name:
Status: VALID


Table contains details of self service registration treid by an user


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
REGISTRATION_ID NUMBER (15) Yes Uniquely Identifies a registration
APPLICATION_CODE VARCHAR2 (10) Yes Identifies the Application
USER_EMAIL_ADDR VARCHAR2 (2000) Yes Identifies the username tried for a registration
ACCESS_DOMAIN_SEARCH_TYPE VARCHAR2 (30)
Search type
ACCESS_DOMAIN_SEARCH_NUMBER VARCHAR2 (50)
Search Number
ACCESS_DOMAIN_TYPE VARCHAR2 (30)
Domain type
ACCESS_DOMAIN_NUMBER VARCHAR2 (50)
Domain number for which user tried for registration
ACCESS_DOMAIN_CUST_ID NUMBER

Customer id for which user tried for registration
ACCESS_DOMAIN_BILLTO_ID NUMBER

Customer billto site id
CUST_ACCT_TYPE VARCHAR2 (30)
Customer acccount type
STATUS VARCHAR2 (30)
Status to show registration is on hold or not
MISSED_CUST_QUESTION_COUNT NUMBER

Number of times user entered wrong answer at customer level
MISSED_BILLTO_QUESTION_COUNT NUMBER

Number of times user entered wrong answer at billto site level
COMPANY_ID NUMBER

Company id
PERSON_ID NUMBER

Person id
CREATION_DATE DATE
Yes Registration access Creation Date
CREATED_BY NUMBER (15) Yes Created By
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATED_BY NUMBER (15) Yes Last Updated By
LAST_UPDATE_LOGIN NUMBER

Last Update Login
REGISTRATION_TYPE VARCHAR2 (200)
Indicates the type of Registration
WF_ITEM_KEY VARCHAR2 (200)
Unique Item Key of the workflow process
Query Text

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


SELECT REGISTRATION_ID
,      APPLICATION_CODE
,      USER_EMAIL_ADDR
,      ACCESS_DOMAIN_SEARCH_TYPE
,      ACCESS_DOMAIN_SEARCH_NUMBER
,      ACCESS_DOMAIN_TYPE
,      ACCESS_DOMAIN_NUMBER
,      ACCESS_DOMAIN_CUST_ID
,      ACCESS_DOMAIN_BILLTO_ID
,      CUST_ACCT_TYPE
,      STATUS
,      MISSED_CUST_QUESTION_COUNT
,      MISSED_BILLTO_QUESTION_COUNT
,      COMPANY_ID
,      PERSON_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REGISTRATION_TYPE
,      WF_ITEM_KEY
FROM AR.ARI_REG_VERIFICATIONS;

Dependencies

[top of page]

AR.ARI_REG_VERIFICATIONS does not reference any database object

AR.ARI_REG_VERIFICATIONS is referenced by following:

SchemaAR
ViewARI_REG_VERIFICATIONS#