[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FND_REGISTRATIONS# |
|---|---|
| Object Type: | VIEW |
| Owner: | APPLSYS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REGISTRATION_ID | NUMBER | (15) | Yes | |
| REGISTRATION_KEY | VARCHAR2 | (100) | Yes | |
| APPLICATION_ID | NUMBER | (15) | Yes | |
| PARTY_ID | NUMBER | (15) | ||
| REGISTRATION_TYPE | VARCHAR2 | (255) | Yes | |
| REQUESTED_USER_NAME | VARCHAR2 | (100) | ||
| ASSIGNED_USER_NAME | VARCHAR2 | (100) | ||
| REGISTRATION_STATUS | VARCHAR2 | (30) | Yes | |
| EXISTS_IN_FND_USER_FLAG | VARCHAR2 | (30) | Yes | |
| USER_TITLE | VARCHAR2 | (100) | ||
| FIRST_NAME | VARCHAR2 | (100) | ||
| MIDDLE_NAME | VARCHAR2 | (100) | ||
| LAST_NAME | VARCHAR2 | (100) | ||
| USER_SUFFIX | VARCHAR2 | (30) | ||
| EMAIL_CONTACT_POINT_ID | NUMBER | (15) | ||
| VARCHAR2 | (100) | |||
| PHONE_CONTACT_POINT_ID | NUMBER | (15) | ||
| PHONE_COUNTRY_CODE | VARCHAR2 | (100) | ||
| PHONE_AREA_CODE | VARCHAR2 | (10) | ||
| PHONE | VARCHAR2 | (100) | ||
| PHONE_EXTENSION | VARCHAR2 | (100) | ||
| FAX_CONTACT_POINT_ID | NUMBER | (15) | ||
| FAX_COUNTRY_CODE | VARCHAR2 | (100) | ||
| FAX_AREA_CODE | VARCHAR2 | (10) | ||
| FAX | VARCHAR2 | (100) | ||
| FAX_EXTENSION | VARCHAR2 | (100) | ||
| LANGUAGE_CODE | VARCHAR2 | (4) | ||
| TIME_ZONE | VARCHAR2 | (100) | ||
| TERRITORY_CODE | VARCHAR2 | (2) | ||
| LOCATION_ID | NUMBER | (15) | ||
| ADDRESS1 | VARCHAR2 | (240) | ||
| ADDRESS2 | VARCHAR2 | (240) | ||
| CITY | VARCHAR2 | (100) | ||
| STATE | VARCHAR2 | (60) | ||
| PROVINCE | VARCHAR2 | (100) | ||
| ZIP | VARCHAR2 | (10) | ||
| POSTAL_CODE | VARCHAR2 | (40) | ||
| COUNTRY | VARCHAR2 | (100) | ||
| DATE_REQUESTED | DATE | |||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT REGISTRATION_ID
, REGISTRATION_KEY
, APPLICATION_ID
, PARTY_ID
, REGISTRATION_TYPE
, REQUESTED_USER_NAME
, ASSIGNED_USER_NAME
, REGISTRATION_STATUS
, EXISTS_IN_FND_USER_FLAG
, USER_TITLE
, FIRST_NAME
, MIDDLE_NAME
, LAST_NAME
, USER_SUFFIX
, EMAIL_CONTACT_POINT_ID
, EMAIL
, PHONE_CONTACT_POINT_ID
, PHONE_COUNTRY_CODE
, PHONE_AREA_CODE
, PHONE
, PHONE_EXTENSION
, FAX_CONTACT_POINT_ID
, FAX_COUNTRY_CODE
, FAX_AREA_CODE
, FAX
, FAX_EXTENSION
, LANGUAGE_CODE
, TIME_ZONE
, TERRITORY_CODE
, LOCATION_ID
, ADDRESS1
, ADDRESS2
, CITY
, STATE
, PROVINCE
, ZIP
, POSTAL_CODE
, COUNTRY
, DATE_REQUESTED
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
FROM APPLSYS.FND_REGISTRATIONS#;
APPLSYS
FND_REGISTRATIONS
APPS
FND_REGISTRATIONS
|
|
|
|