VIEW: APPS.IGS_PE_ALT_PERS_ID_V

Source

View Text - Preformatted

SELECT API.ROWID ROW_ID, API.PE_PERSON_ID, API.API_PERSON_ID, API.API_PERSON_ID_UF, API.PERSON_ID_TYPE, API.START_DT, API.END_DT , API.CREATED_BY, API.CREATION_DATE, API.LAST_UPDATED_BY, API.LAST_UPDATE_DATE, API.LAST_UPDATE_LOGIN , PT.DESCRIPTION PERSON_ID_TYPE_DESC, PT.FORMAT_MASK, API.ATTRIBUTE_CATEGORY, API.ATTRIBUTE1, API.ATTRIBUTE2, API.ATTRIBUTE3, API.ATTRIBUTE4, API.ATTRIBUTE5, API.ATTRIBUTE6, API.ATTRIBUTE7, API.ATTRIBUTE8, API.ATTRIBUTE9, API.ATTRIBUTE10, API.ATTRIBUTE11, API.ATTRIBUTE12, API.ATTRIBUTE13, API.ATTRIBUTE14, API.ATTRIBUTE15, API.ATTRIBUTE16, API.ATTRIBUTE17, API.ATTRIBUTE18, API.ATTRIBUTE19, API.ATTRIBUTE20, api.region_cd, pt.region_ind FROM IGS_PE_ALT_PERS_ID api, IGS_PE_PERSON_ID_TYP PT WHERE PT.PERSON_ID_TYPE = api.person_id_type

View Text - HTML Formatted

SELECT API.ROWID ROW_ID
, API.PE_PERSON_ID
, API.API_PERSON_ID
, API.API_PERSON_ID_UF
, API.PERSON_ID_TYPE
, API.START_DT
, API.END_DT
, API.CREATED_BY
, API.CREATION_DATE
, API.LAST_UPDATED_BY
, API.LAST_UPDATE_DATE
, API.LAST_UPDATE_LOGIN
, PT.DESCRIPTION PERSON_ID_TYPE_DESC
, PT.FORMAT_MASK
, API.ATTRIBUTE_CATEGORY
, API.ATTRIBUTE1
, API.ATTRIBUTE2
, API.ATTRIBUTE3
, API.ATTRIBUTE4
, API.ATTRIBUTE5
, API.ATTRIBUTE6
, API.ATTRIBUTE7
, API.ATTRIBUTE8
, API.ATTRIBUTE9
, API.ATTRIBUTE10
, API.ATTRIBUTE11
, API.ATTRIBUTE12
, API.ATTRIBUTE13
, API.ATTRIBUTE14
, API.ATTRIBUTE15
, API.ATTRIBUTE16
, API.ATTRIBUTE17
, API.ATTRIBUTE18
, API.ATTRIBUTE19
, API.ATTRIBUTE20
, API.REGION_CD
, PT.REGION_IND
FROM IGS_PE_ALT_PERS_ID API
, IGS_PE_PERSON_ID_TYP PT
WHERE PT.PERSON_ID_TYPE = API.PERSON_ID_TYPE