View: IGS_SV_EDT_FADDR_V

Product:	IGS - Student System
Description:	View for fetching US Address information
Implementation/DBA Data:	APPS.IGS_SV_EDT_FADDR_V

View Text

SELECT FGN.BATCH_ID
, FGN.PERSON_ID
, FGN.ADDRESS_LINE1 FN_ADDRESS_LINE1
, FGN.ADDRESS_LINE2 FN_ADDRESS_LINE2
, FGN.CITY FN_CITY
, FGN.PROVINCE FN_PROVINCE
, FGN.POSTAL_CODE FN_POSTAL_CODE
, FGN.COUNTRY_CODE FN_CNTRY_CODE
FROM IGS_SV_ADDRESSES FGN
, IGS_SV_BTCH_SUMMARY FADDRSUMM
WHERE FGN.ADDRESS_TYPE = 'F'
AND FGN.BATCH_ID = FADDRSUMM.BATCH_ID
AND FGN.PERSON_ID = FADDRSUMM.PERSON_ID
AND FADDRSUMM.TAG_CODE = 'SV_F_ADDR'
AND FADDRSUMM.ADM_ACTION_CODE = 'SEND'
AND FGN.ACTIVITY_SITE_CD IS NULL

Columns