VIEW: APPLSYS.FND_REGISTRATIONS#

Source

View Text - Preformatted

select REGISTRATION_ID REGISTRATION_ID, REGISTRATION_KEY REGISTRATION_KEY, APPLICATION_ID APPLICATION_ID, PARTY_ID PARTY_ID, REGISTRATION_TYPE REGISTRATION_TYPE, REQUESTED_USER_NAME REQUESTED_USER_NAME, ASSIGNED_USER_NAME ASSIGNED_USER_NAME, REGISTRATION_STATUS REGISTRATION_STATUS, EXISTS_IN_FND_USER_FLAG EXISTS_IN_FND_USER_FLAG, USER_TITLE USER_TITLE, FIRST_NAME FIRST_NAME, MIDDLE_NAME MIDDLE_NAME, LAST_NAME LAST_NAME, USER_SUFFIX USER_SUFFIX, EMAIL_CONTACT_POINT_ID EMAIL_CONTACT_POINT_ID, EMAIL EMAIL, PHONE_CONTACT_POINT_ID PHONE_CONTACT_POINT_ID, PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE, PHONE_AREA_CODE PHONE_AREA_CODE, PHONE PHONE, PHONE_EXTENSION PHONE_EXTENSION, FAX_CONTACT_POINT_ID FAX_CONTACT_POINT_ID, FAX_COUNTRY_CODE FAX_COUNTRY_CODE, FAX_AREA_CODE FAX_AREA_CODE, FAX FAX, FAX_EXTENSION FAX_EXTENSION, LANGUAGE_CODE LANGUAGE_CODE, TIME_ZONE TIME_ZONE, TERRITORY_CODE TERRITORY_CODE, LOCATION_ID LOCATION_ID, ADDRESS1 ADDRESS1, ADDRESS2 ADDRESS2, CITY CITY, STATE STATE, PROVINCE PROVINCE, ZIP ZIP, POSTAL_CODE POSTAL_CODE, COUNTRY COUNTRY, DATE_REQUESTED DATE_REQUESTED, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "APPLSYS"."FND_REGISTRATIONS"

View Text - HTML Formatted

SELECT REGISTRATION_ID REGISTRATION_ID
, REGISTRATION_KEY REGISTRATION_KEY
, APPLICATION_ID APPLICATION_ID
, PARTY_ID PARTY_ID
, REGISTRATION_TYPE REGISTRATION_TYPE
, REQUESTED_USER_NAME REQUESTED_USER_NAME
, ASSIGNED_USER_NAME ASSIGNED_USER_NAME
, REGISTRATION_STATUS REGISTRATION_STATUS
, EXISTS_IN_FND_USER_FLAG EXISTS_IN_FND_USER_FLAG
, USER_TITLE USER_TITLE
, FIRST_NAME FIRST_NAME
, MIDDLE_NAME MIDDLE_NAME
, LAST_NAME LAST_NAME
, USER_SUFFIX USER_SUFFIX
, EMAIL_CONTACT_POINT_ID EMAIL_CONTACT_POINT_ID
, EMAIL EMAIL
, PHONE_CONTACT_POINT_ID PHONE_CONTACT_POINT_ID
, PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE
, PHONE_AREA_CODE PHONE_AREA_CODE
, PHONE PHONE
, PHONE_EXTENSION PHONE_EXTENSION
, FAX_CONTACT_POINT_ID FAX_CONTACT_POINT_ID
, FAX_COUNTRY_CODE FAX_COUNTRY_CODE
, FAX_AREA_CODE FAX_AREA_CODE
, FAX FAX
, FAX_EXTENSION FAX_EXTENSION
, LANGUAGE_CODE LANGUAGE_CODE
, TIME_ZONE TIME_ZONE
, TERRITORY_CODE TERRITORY_CODE
, LOCATION_ID LOCATION_ID
, ADDRESS1 ADDRESS1
, ADDRESS2 ADDRESS2
, CITY CITY
, STATE STATE
, PROVINCE PROVINCE
, ZIP ZIP
, POSTAL_CODE POSTAL_CODE
, COUNTRY COUNTRY
, DATE_REQUESTED DATE_REQUESTED
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "APPLSYS"."FND_REGISTRATIONS"