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

VIEW: APPS.PER_KR_RESIDENT_REG_NUMBER_V

Object Details
Object Name: PER_KR_RESIDENT_REG_NUMBER_V
Object Type: VIEW
Owner: APPS
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
PERSON_ID NUMBER (10)
System generated person primary key from PER_PEOPLE_S.
CONT_PERSON_ID NUMBER (10)
System generated person primary key from PER_PEOPLE_S.
NATIONAL_IDENTIFIER VARCHAR2 (30)
Number by which a person is identified in a given legislation.
FULL_NAME VARCHAR2 (240)
Concatenation of last name, title, first name, middle names and the name the person is known by.
CONT_EFFECTIVE_START_DATE DATE

Effective start date.
CONT_EFFECTIVE_END_DATE DATE

Effective end date.
PERSON_EFFECTIVE_START_DATE DATE

Effective start date.
PERSON_EFFECTIVE_END_DATE DATE

Effective end date.
RELATIONSHIP_START_DATE DATE

RELATIONSHIP_END_DATE DATE

RELATIONSHIP_END_REASON VARCHAR2 (150)
Query Text

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


SELECT PERSON_ID
,      CONT_PERSON_ID
,      NATIONAL_IDENTIFIER
,      FULL_NAME
,      CONT_EFFECTIVE_START_DATE
,      CONT_EFFECTIVE_END_DATE
,      PERSON_EFFECTIVE_START_DATE
,      PERSON_EFFECTIVE_END_DATE
,      RELATIONSHIP_START_DATE
,      RELATIONSHIP_END_DATE
,      RELATIONSHIP_END_REASON
FROM APPS.PER_KR_RESIDENT_REG_NUMBER_V;

Dependencies

[top of page]

APPS.PER_KR_RESIDENT_REG_NUMBER_V references the following:

SchemaAPPS
SynonymPER_ALL_PEOPLE_F
SynonymPER_CONTACT_RELATIONSHIPS
APPS.PER_KR_RESIDENT_REG_NUMBER_V is referenced by following:

SchemaPUBLIC
SynonymPER_KR_RESIDENT_REG_NUMBER_V