eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IGS_PE_API_ALT_PERS_ID_V

Object Details

Object Name:	IGS_PE_API_ALT_PERS_ID_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_PE_API_ALT_PERS_ID_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes
PERSON_NUMBER	VARCHAR2	(30)	Yes
ORACLE_USERNAME	VARCHAR2	(100)
STAFF_MEMBER_IND	VARCHAR2	(4000)
STUDENT_IND	VARCHAR2	(4000)
ENCUMBERED_IND	VARCHAR2	(4000)
FIRST_ENROLMENT	VARCHAR2	(4000)
LAST_ENROLMENT	VARCHAR2	(4000)
PAL_SEQUENCE_NUMBER	NUMBER
PAL_START_DT	DATE
PAL_END_DT	DATE
FULL_NAME	VARCHAR2	(450)
SURNAME	VARCHAR2	(150)
GIVEN_NAMES	VARCHAR2	(150)
PREFERRED_GIVEN_NAME	VARCHAR2	(240)
SEX	VARCHAR2	(30)
SEX_MEANING	VARCHAR2	(0)
BIRTH_DT	DATE
EMAIL_ADDR	VARCHAR2	(2000)
TITLE	VARCHAR2	(60)
SUFFIX	VARCHAR2	(30)
PREFIX	VARCHAR2	(30)
SALUTATION	VARCHAR2	(60)
DECEASED_IND	VARCHAR2	(1)
PAL_COMMENT	VARCHAR2	(0)
START_DT	DATE			Start Date of the Address used by the person, being selected from IGS extension table
END_DT	DATE			End Date of the Address used by the person, being selected from IGS extension table
API_PERSON_ID	VARCHAR2	(20)
PERSON_ID_TYPE	VARCHAR2	(10)
DESCRIPTION	VARCHAR2	(60)
PREFERRED_IND	VARCHAR2	(1)
DISPLAY_OB_IND	VARCHAR2	(0)
PERSON_ALIAS_DISPLAY	VARCHAR2	(0)
ADDR_TYPE	VARCHAR2	(0)		No longer used
ADDR_LINE_1	VARCHAR2	(240)
ADDR_LINE_2	VARCHAR2	(240)
ADDR_LINE_3	VARCHAR2	(240)
ADDR_LINE_4	VARCHAR2	(240)
CITY	VARCHAR2	(60)
STATE	VARCHAR2	(60)
PROVINCE	VARCHAR2	(60)
COUNTY	VARCHAR2	(60)
COUNTRY	VARCHAR2	(60)
POSTAL_CODE	VARCHAR2	(60)
AD_START_DT	DATE			No longer used
AD_END_DT	DATE			No longer used
OTHER_DETAILS_1	VARCHAR2	(0)		Obsolete
OTHER_DETAILS_2	VARCHAR2	(0)		Obsolete
OTHER_DETAILS_3	VARCHAR2	(0)		Obsolete
PRIMARY_ADDRESS_INDICATOR	VARCHAR2	(0)		No longer used
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
PARTY_SITE_ID	NUMBER			No longer used
LOCATION_ID	NUMBER			No longer used
STATUS	VARCHAR2	(1)	Yes
PS_STATUS	VARCHAR2	(0)		No longer used

Query Text

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


SELECT PERSON_ID
,      PERSON_NUMBER
,      ORACLE_USERNAME
,      STAFF_MEMBER_IND
,      STUDENT_IND
,      ENCUMBERED_IND
,      FIRST_ENROLMENT
,      LAST_ENROLMENT
,      PAL_SEQUENCE_NUMBER
,      PAL_START_DT
,      PAL_END_DT
,      FULL_NAME
,      SURNAME
,      GIVEN_NAMES
,      PREFERRED_GIVEN_NAME
,      SEX
,      SEX_MEANING
,      BIRTH_DT
,      EMAIL_ADDR
,      TITLE
,      SUFFIX
,      PREFIX
,      SALUTATION
,      DECEASED_IND
,      PAL_COMMENT
,      START_DT
,      END_DT
,      API_PERSON_ID
,      PERSON_ID_TYPE
,      DESCRIPTION
,      PREFERRED_IND
,      DISPLAY_OB_IND
,      PERSON_ALIAS_DISPLAY
,      ADDR_TYPE
,      ADDR_LINE_1
,      ADDR_LINE_2
,      ADDR_LINE_3
,      ADDR_LINE_4
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      POSTAL_CODE
,      AD_START_DT
,      AD_END_DT
,      OTHER_DETAILS_1
,      OTHER_DETAILS_2
,      OTHER_DETAILS_3
,      PRIMARY_ADDRESS_INDICATOR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PARTY_SITE_ID
,      LOCATION_ID
,      STATUS
,      PS_STATUS
FROM APPS.IGS_PE_API_ALT_PERS_ID_V;

Dependencies

[top of page]

APPS.IGS_PE_API_ALT_PERS_ID_V references the following:

APPS: HZ_PARTIES; HZ_PERSON_PROFILES; IGS_EN_GEN_003 - show dependent code; IGS_EN_GEN_005 - show dependent code; IGS_EN_GEN_007 - show dependent code; IGS_PE_ALT_PERS_ID; IGS_PE_HZ_PARTIES; IGS_PE_PERSON_ID_TYP

APPS.IGS_PE_API_ALT_PERS_ID_V is not referenced by any database object