VIEW: APPS.AR_SHIP_TO_ADDRESSES_ACTIVE_V

Source

View Text - Preformatted

SELECT ADDR.ROWID ROW_ID , ADDR.CUST_ACCT_SITE_ID ADDRESS_ID , ADDR.CUST_ACCOUNT_ID CUSTOMER_ID , ADDR.LAST_UPDATE_DATE LAST_UPDATE_DATE , ADDR.LAST_UPDATED_BY LAST_UPDATED_BY , ADDR.CREATION_DATE CREATION_DATE , ADDR.CREATED_BY CREATED_BY , ADDR.STATUS STATUS , ADDR.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE , LOC.COUNTRY COUNTRY , TERR.TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME , TERR.ADDRESS_STYLE ADDRESS_STYLE , LOC.ADDRESS1 ADDRESS1 , LOC.ADDRESS2 ADDRESS2 , LOC.ADDRESS3 ADDRESS3 , LOC.ADDRESS4 ADDRESS4 , LOC.CITY CITY , LOC.COUNTY COUNTY , LOC.STATE STATE , LOC.PROVINCE PROVINCE , LOC.POSTAL_CODE POSTAL_CODE , ARH_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE,LOC.ADDRESS1, LOC.ADDRESS2,LOC.ADDRESS3,LOC.ADDRESS4,LOC.CITY,LOC.COUNTY, LOC.STATE,LOC.PROVINCE,LOC.POSTAL_CODE,TERR.TERRITORY_SHORT_NAME ) CONCATENATED_ADDRESS , SU_SHIP.SITE_USE_ID SITE_USE_ID , SU_SHIP.LOCATION LOCATION , ADDR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , ADDR.TERRITORY_ID TERRITORY_ID , LOC.ADDRESS_KEY ADDRESS_KEY , ADDR.KEY_ACCOUNT_FLAG KEY_ACCOUNT_FLAG , LOC.LANGUAGE LANGUAGE , ADDR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY , ADDR.ATTRIBUTE1 ATTRIBUTE1 , ADDR.ATTRIBUTE2 ATTRIBUTE2 , ADDR.ATTRIBUTE3 ATTRIBUTE3 , ADDR.ATTRIBUTE4 ATTRIBUTE4 , ADDR.ATTRIBUTE5 ATTRIBUTE5 , ADDR.ATTRIBUTE6 ATTRIBUTE6 , ADDR.ATTRIBUTE7 ATTRIBUTE7 , ADDR.ATTRIBUTE8 ATTRIBUTE8 , ADDR.ATTRIBUTE9 ATTRIBUTE9 , ADDR.ATTRIBUTE10 ATTRIBUTE10 , ADDR.ATTRIBUTE11 ATTRIBUTE11 , ADDR.ATTRIBUTE12 ATTRIBUTE12 , ADDR.ATTRIBUTE13 ATTRIBUTE13 , ADDR.ATTRIBUTE14 ATTRIBUTE14 , ADDR.ATTRIBUTE15 ATTRIBUTE15 , LOC.ADDRESS_LINES_PHONETIC ADDRESS_LINES_PHONETIC , ADDR.ECE_TP_LOCATION_CODE EDI_LOCATION FROM FND_TERRITORIES_VL TERR, HZ_CUST_SITE_USES SU_SHIP, HZ_CUST_ACCT_SITES ADDR, HZ_PARTY_SITES PARTY_SITE, HZ_LOCATIONS LOC WHERE ADDR.CUST_ACCT_SITE_ID = SU_SHIP.CUST_ACCT_SITE_ID AND ADDR.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID AND ADDR.STATUS = 'A' AND SU_SHIP.SITE_USE_CODE = 'SHIP_TO' AND SU_SHIP.STATUS = 'A' AND LOC.COUNTRY = TERR.TERRITORY_CODE(+)

View Text - HTML Formatted

SELECT ADDR.ROWID ROW_ID
, ADDR.CUST_ACCT_SITE_ID ADDRESS_ID
, ADDR.CUST_ACCOUNT_ID CUSTOMER_ID
, ADDR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ADDR.LAST_UPDATED_BY LAST_UPDATED_BY
, ADDR.CREATION_DATE CREATION_DATE
, ADDR.CREATED_BY CREATED_BY
, ADDR.STATUS STATUS
, ADDR.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, LOC.COUNTRY COUNTRY
, TERR.TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME
, TERR.ADDRESS_STYLE ADDRESS_STYLE
, LOC.ADDRESS1 ADDRESS1
, LOC.ADDRESS2 ADDRESS2
, LOC.ADDRESS3 ADDRESS3
, LOC.ADDRESS4 ADDRESS4
, LOC.CITY CITY
, LOC.COUNTY COUNTY
, LOC.STATE STATE
, LOC.PROVINCE PROVINCE
, LOC.POSTAL_CODE POSTAL_CODE
, ARH_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.COUNTY
, LOC.STATE
, LOC.PROVINCE
, LOC.POSTAL_CODE
, TERR.TERRITORY_SHORT_NAME ) CONCATENATED_ADDRESS
, SU_SHIP.SITE_USE_ID SITE_USE_ID
, SU_SHIP.LOCATION LOCATION
, ADDR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ADDR.TERRITORY_ID TERRITORY_ID
, LOC.ADDRESS_KEY ADDRESS_KEY
, ADDR.KEY_ACCOUNT_FLAG KEY_ACCOUNT_FLAG
, LOC.LANGUAGE LANGUAGE
, ADDR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ADDR.ATTRIBUTE1 ATTRIBUTE1
, ADDR.ATTRIBUTE2 ATTRIBUTE2
, ADDR.ATTRIBUTE3 ATTRIBUTE3
, ADDR.ATTRIBUTE4 ATTRIBUTE4
, ADDR.ATTRIBUTE5 ATTRIBUTE5
, ADDR.ATTRIBUTE6 ATTRIBUTE6
, ADDR.ATTRIBUTE7 ATTRIBUTE7
, ADDR.ATTRIBUTE8 ATTRIBUTE8
, ADDR.ATTRIBUTE9 ATTRIBUTE9
, ADDR.ATTRIBUTE10 ATTRIBUTE10
, ADDR.ATTRIBUTE11 ATTRIBUTE11
, ADDR.ATTRIBUTE12 ATTRIBUTE12
, ADDR.ATTRIBUTE13 ATTRIBUTE13
, ADDR.ATTRIBUTE14 ATTRIBUTE14
, ADDR.ATTRIBUTE15 ATTRIBUTE15
, LOC.ADDRESS_LINES_PHONETIC ADDRESS_LINES_PHONETIC
, ADDR.ECE_TP_LOCATION_CODE EDI_LOCATION
FROM FND_TERRITORIES_VL TERR
, HZ_CUST_SITE_USES SU_SHIP
, HZ_CUST_ACCT_SITES ADDR
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
WHERE ADDR.CUST_ACCT_SITE_ID = SU_SHIP.CUST_ACCT_SITE_ID
AND ADDR.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND ADDR.STATUS = 'A'
AND SU_SHIP.SITE_USE_CODE = 'SHIP_TO'
AND SU_SHIP.STATUS = 'A'
AND LOC.COUNTRY = TERR.TERRITORY_CODE(+)