View: SY_ADDR_MST_V

Product:	GMA - Process Manufacturing Systems
Description:	View of sy_addr_mst for OPM OF customers
Implementation/DBA Data:	APPS.SY_ADDR_MST_V

View Text

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'

Columns