[Home] [Help]
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
Name |
ADDR_ID |
ADDR1 |
ADDR2 |
ADDR3 |
ADDR4 |
STATE_CODE |
COUNTRY_CODE |
POSTAL_CODE |