VIEW: APPS.SY_ADDR_MST_V

Source

View Text - Preformatted

SELECT CUST.PARTY_SITE_ID, LOC.ADDRESS_LINE_1, LOC.ADDRESS_LINE_2, LOC.ADDRESS_LINE_3, LOC.TOWN_OR_CITY, LOC.REGION_1, LOC.COUNTRY, LOC.POSTAL_CODE FROM HZ_CUST_ACCT_SITES_ALL CUST, HZ_PARTY_SITES PARTY_SITES, HZ_PARTIES PARTIES, HR_LOCATIONS LOC WHERE PARTIES.PARTY_ID = PARTY_SITES.PARTY_ID AND PARTY_SITES.LOCATION_ID = LOC.LOCATION_ID AND PARTY_SITES.PARTY_SITE_ID = CUST.PARTY_SITE_ID AND NVL(FND_PROFILE.VALUE('GML_CUST_SYNC_ELIM'),'N') = 'Y' Union All Select ADDR_ID, ADDR1, ADDR2, ADDR3, ADDR4, STATE_CODE, COUNTRY_CODE, POSTAL_CODE From sy_addr_mst Where NVL(FND_PROFILE.VALUE('GML_CUST_SYNC_ELIM'),'N') = 'N'

View Text - HTML Formatted

SELECT CUST.PARTY_SITE_ID
, LOC.ADDRESS_LINE_1
, LOC.ADDRESS_LINE_2
, LOC.ADDRESS_LINE_3
, LOC.TOWN_OR_CITY
, LOC.REGION_1
, LOC.COUNTRY
, LOC.POSTAL_CODE
FROM HZ_CUST_ACCT_SITES_ALL CUST
, HZ_PARTY_SITES PARTY_SITES
, HZ_PARTIES PARTIES
, HR_LOCATIONS LOC
WHERE PARTIES.PARTY_ID = PARTY_SITES.PARTY_ID
AND PARTY_SITES.LOCATION_ID = LOC.LOCATION_ID
AND PARTY_SITES.PARTY_SITE_ID = CUST.PARTY_SITE_ID
AND NVL(FND_PROFILE.VALUE('GML_CUST_SYNC_ELIM')
, 'N') = 'Y' UNION ALL SELECT ADDR_ID
, ADDR1
, ADDR2
, ADDR3
, ADDR4
, STATE_CODE
, COUNTRY_CODE
, POSTAL_CODE
FROM SY_ADDR_MST
WHERE NVL(FND_PROFILE.VALUE('GML_CUST_SYNC_ELIM')
, 'N') = 'N'