View: IGS_PE_SS_ADDR_V

Product:	IGS - Student System
Description:	This Entity stores the Address of a Person created from Self Service Application
Implementation/DBA Data:	APPS.IGS_PE_SS_ADDR_V

View Text

SELECT PS.PARTY_ID PERSON_ID
, PS.PARTY_SITE_ID PARTY_SITE_ID
, PS.LOCATION_ID LOCATION_ID
, IGSPS.START_DATE START_DT
, IGSPS.END_DATE END_DT
, L.ADDRESS1 ADDR_LINE_1
, L.ADDRESS2 ADDR_LINE_2
, L.ADDRESS3 ADDR_LINE_3
, L.ADDRESS4 ADDR_LINE_4
, L.CITY CITY
, L.STATE STATE
, L.PROVINCE PROVINCE
, L.COUNTY COUNTY
, L.COUNTRY COUNTRY_CD
, L.ADDRESS_STYLE
, L.ADDRESS_LINES_PHONETIC
, L.DELIVERY_POINT_CODE
, FT.TERRITORY_SHORT_NAME COUNTRY
, L.POSTAL_CODE POSTAL_CODE
, HU.SITE_USE_TYPE SITE_USE_TYPE
, TO_DATE(NULL) DATE_LAST_VERIFIED
, PS.IDENTIFYING_ADDRESS_FLAG CORRESPONDENCE
, NULL OTHER_DETAILS_1
, NULL OTHER_DETAILS_2
, NULL OTHER_DETAILS_3
, PS.CREATED_BY CREATED_BY
, PS.CREATION_DATE CREATION_DATE
, PS.LAST_UPDATED_BY LAST_UPDATED_BY
, L.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PS.REQUEST_ID REQUEST_ID
, PS.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PS.PROGRAM_ID PROGRAM_ID
, PS.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PS.STATUS
, LK.MEANING
, L.OBJECT_VERSION_NUMBER LOCATION_OVN
, PS.OBJECT_VERSION_NUMBER PARTY_SITE_OVN
FROM HZ_PARTY_SITES PS
, HZ_LOCATIONS L
, HZ_PARTY_SITE_USES HU
, FND_TERRITORIES_VL FT
, IGS_PE_HZ_PTY_SITES IGSPS
, FND_LOOKUP_VALUES LK
WHERE PS.LOCATION_ID = L.LOCATION_ID
AND HU.PARTY_SITE_ID = PS.PARTY_SITE_ID
AND FT.TERRITORY_CODE = L.COUNTRY
AND PS.PARTY_SITE_ID = IGSPS.PARTY_SITE_ID(+)
AND PS.STATUS IN ('A'
, 'I')
AND PS.STATUS = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'REGISTRY_STATUS'
AND LK.VIEW_APPLICATION_ID = '222'
AND LK.LANGUAGE = USERENV('LANG')
AND LK.SECURITY_GROUP_ID = 0

Columns