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

VIEW: APPS.IRC_REGISTERED_USERS

Object Details
Object Name: IRC_REGISTERED_USERS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.IRC_REGISTERED_USERS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
FIRST_NAME VARCHAR2 (150)
First Name
LAST_NAME VARCHAR2 (150)
Last Name
NAME_PHONETIC VARCHAR2 (320)
Phonetic full name
LAST_NAME_PHONETIC VARCHAR2 (60)
Phonetic last name
FIRST_NAME_PHONETIC VARCHAR2 (60)
Phonetic First Name
MIDDLE_NAME VARCHAR2 (60)
Middle Name
NAME_SUFFIX VARCHAR2 (30)
Name suffix
PREVIOUS_LAST_NAME VARCHAR2 (150)
Previous last name
KNOWN_AS VARCHAR2 (240)
First name which the person is known as
PERSON_ID NUMBER

internal ID of the person
DATE_OF_BIRTH DATE

Date of birth
PLACE_OF_BIRTH VARCHAR2 (60)
Place of birth
DATE_OF_DEATH DATE

Date of death
MARITAL_STATUS VARCHAR2 (30)
Marital status
PRE_NAME_ADJUNCT VARCHAR2 (30)
Pre name adjunct
Query Text

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


SELECT FIRST_NAME
,      LAST_NAME
,      NAME_PHONETIC
,      LAST_NAME_PHONETIC
,      FIRST_NAME_PHONETIC
,      MIDDLE_NAME
,      NAME_SUFFIX
,      PREVIOUS_LAST_NAME
,      KNOWN_AS
,      PERSON_ID
,      DATE_OF_BIRTH
,      PLACE_OF_BIRTH
,      DATE_OF_DEATH
,      MARITAL_STATUS
,      PRE_NAME_ADJUNCT
FROM APPS.IRC_REGISTERED_USERS;

Dependencies

[top of page]

APPS.IRC_REGISTERED_USERS references the following:

SchemaAPPS
SynonymHZ_PERSON_PROFILES
SynonymIRC_NOTIFICATION_PREFERENCES

APPS.IRC_REGISTERED_USERS is not referenced by any database object