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

VIEW: AR.ARI_REG_VERIFICATIONS#

Object Details
Object Name: ARI_REG_VERIFICATIONS#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REGISTRATION_ID NUMBER (15) Yes
APPLICATION_CODE VARCHAR2 (10) Yes
USER_EMAIL_ADDR VARCHAR2 (2000) Yes
ACCESS_DOMAIN_SEARCH_TYPE VARCHAR2 (30)
ACCESS_DOMAIN_SEARCH_NUMBER VARCHAR2 (50)
ACCESS_DOMAIN_TYPE VARCHAR2 (30)
ACCESS_DOMAIN_NUMBER VARCHAR2 (50)
ACCESS_DOMAIN_CUST_ID NUMBER

ACCESS_DOMAIN_BILLTO_ID NUMBER

CUST_ACCT_TYPE VARCHAR2 (30)
STATUS VARCHAR2 (30)
MISSED_CUST_QUESTION_COUNT NUMBER

MISSED_BILLTO_QUESTION_COUNT NUMBER

COMPANY_ID NUMBER

PERSON_ID NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER

REGISTRATION_TYPE VARCHAR2 (200)
WF_ITEM_KEY VARCHAR2 (200)
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# references the following:

SchemaAR
TableARI_REG_VERIFICATIONS
AR.ARI_REG_VERIFICATIONS# is referenced by following:

SchemaAPPS
SynonymARI_REG_VERIFICATIONS