VIEW: APPS.IGS_SV_EDT_USADDR_V

Source

View Text - Preformatted

SELECT usa.batch_id, usa.person_id, usa.address_line1 us_address_line1, usa.address_line2 us_address_line2, usa.city us_city, usa.state us_state, usa.postal_code us_postal_code, usa.postal_routing_code us_postal_routing_code FROM igs_sv_addresses usa, igs_sv_btch_summary usAddrSumm WHERE usa.address_type = 'U' AND usa.batch_id = usAddrSumm.batch_id and usa.person_id = usAddrSumm.person_id and usAddrSumm.TAG_CODE = 'SV_US_ADDR' AND usAddrSumm.ADM_ACTION_CODE = 'SEND' AND usa.ACTIVITY_SITE_CD IS NULL

View Text - HTML Formatted

SELECT USA.BATCH_ID
, USA.PERSON_ID
, USA.ADDRESS_LINE1 US_ADDRESS_LINE1
, USA.ADDRESS_LINE2 US_ADDRESS_LINE2
, USA.CITY US_CITY
, USA.STATE US_STATE
, USA.POSTAL_CODE US_POSTAL_CODE
, USA.POSTAL_ROUTING_CODE US_POSTAL_ROUTING_CODE
FROM IGS_SV_ADDRESSES USA
, IGS_SV_BTCH_SUMMARY USADDRSUMM
WHERE USA.ADDRESS_TYPE = 'U'
AND USA.BATCH_ID = USADDRSUMM.BATCH_ID
AND USA.PERSON_ID = USADDRSUMM.PERSON_ID
AND USADDRSUMM.TAG_CODE = 'SV_US_ADDR'
AND USADDRSUMM.ADM_ACTION_CODE = 'SEND'
AND USA.ACTIVITY_SITE_CD IS NULL