[Home] [Help]
View: IGS_SV_EDT_FADDR_V
Product: | IGS - Student System (Obsolete) |
Description: | View for fetching US Address information |
Implementation/DBA Data: |
Not implemented in this database
|
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
Name |
BATCH_ID |
PERSON_ID |
FN_ADDRESS_LINE1 |
FN_ADDRESS_LINE2 |
FN_CITY |
FN_PROVINCE |
FN_POSTAL_CODE |
FN_CNTRY_CODE |