[Home] [Help] [Dependency Information]
Object Name: | ARI_REG_VERIFICATIONS# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
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) |
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#;
|
|
|