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

VIEW: APPS.IGS_PE_PERSON_ADDR_GOVT_PERM_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


IGS_PE_PERSON_ADDR_GOVT_PERM_V describes the permanent address


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Yes Unique identifier of the person in the system
START_DT DATE

Statrt date of the address after that the address is effective
END_DT DATE

End date after that the address is not effective
ADDR_PART_1 VARCHAR2 (240) Yes Part 1 of the address
ADDR_PART_2 VARCHAR2 (240)
Part 2 of the address
ADDR_PART_3 VARCHAR2 (240)
Part 3 of the address
POSTCODE VARCHAR2 (60)
Postal code of the address
OS_ADDR_IND CHAR (1)
Flag indicates if the address is an overseas address or not
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT PERSON_ID
,      START_DT
,      END_DT
,      ADDR_PART_1
,      ADDR_PART_2
,      ADDR_PART_3
,      POSTCODE
,      OS_ADDR_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_PE_PERSON_ADDR_GOVT_PERM_V;

Dependencies

[top of page]

APPS.IGS_PE_PERSON_ADDR_GOVT_PERM_V references the following:

SchemaAPPS
ViewIGS_PE_PERSON_ADDR

APPS.IGS_PE_PERSON_ADDR_GOVT_PERM_V is not referenced by any database object