VIEW: APPS.IGS_PE_PERSON_ADDR_GOVT_PERM_V

Source

View Text - Preformatted

SELECT pa.person_id, pa.start_dt, pa.end_dt, pa.addr_line_1 ADDR_PART_1, pa.addr_line_2 ADDR_PART_2, pa.addr_line_3 ADDR_PART_3, POSTAL_CODE POSTCODE, 'Y' OS_ADDR_IND, pa.CREATED_BY, pa.CREATION_DATE, pa.LAST_UPDATED_BY, pa.LAST_UPDATE_DATE, pa.LAST_UPDATE_LOGIN FROM IGS_PE_PERSON_ADDR pa WHERE pa.ADDR_TYPE = 'HOME'

View Text - HTML Formatted

SELECT PA.PERSON_ID
, PA.START_DT
, PA.END_DT
, PA.ADDR_LINE_1 ADDR_PART_1
, PA.ADDR_LINE_2 ADDR_PART_2
, PA.ADDR_LINE_3 ADDR_PART_3
, POSTAL_CODE POSTCODE
, 'Y' OS_ADDR_IND
, PA.CREATED_BY
, PA.CREATION_DATE
, PA.LAST_UPDATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATE_LOGIN
FROM IGS_PE_PERSON_ADDR PA
WHERE PA.ADDR_TYPE = 'HOME'