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

VIEW: APPS.IGS_SS_INQ_PERSON

Object Details
Object Name: IGS_SS_INQ_PERSON
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_SS_INQ_PERSON
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


Self Service Inquiry Person View


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ORG_ID NUMBER (15)
INQ_PERSON_ID NUMBER (15) Yes
GIVEN_NAME VARCHAR2 (150) Yes
MIDDLE_NAME VARCHAR2 (60)
SURNAME VARCHAR2 (150) Yes
PREFERRED_GIVEN_NAME VARCHAR2 (240)
TITLE VARCHAR2 (60)
SUFFIX VARCHAR2 (30)
PRE_NAME_ADJUNCT VARCHAR2 (30)
BIRTH_DT DATE

SEX VARCHAR2 (30)
ETHNIC_ORIGIN VARCHAR2 (60)
CITIZENSHIP1_ID VARCHAR2 (2)
CITIZENSHIP2_ID VARCHAR2 (2)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

STATUS VARCHAR2 (1) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
IMP_SOURCE_TYPE_ID NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT ROW_ID
,      ORG_ID
,      INQ_PERSON_ID
,      GIVEN_NAME
,      MIDDLE_NAME
,      SURNAME
,      PREFERRED_GIVEN_NAME
,      TITLE
,      SUFFIX
,      PRE_NAME_ADJUNCT
,      BIRTH_DT
,      SEX
,      ETHNIC_ORIGIN
,      CITIZENSHIP1_ID
,      CITIZENSHIP2_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      IMP_SOURCE_TYPE_ID
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_SS_INQ_PERSON;

Dependencies

[top of page]

APPS.IGS_SS_INQ_PERSON references the following:

SchemaAPPS
SynonymIGS_SS_INQ_PERSON_ALL

APPS.IGS_SS_INQ_PERSON is not referenced by any database object