VIEW: APPS.IGI_AR_ADDRESSES_V

Source

View Text - Preformatted

SELECT CUST_SITE.cust_acct_site_id "ADDRESS_ID" , CUST_SITE.LAST_UPDATE_DATE , CUST_SITE.LAST_UPDATED_BY , CUST_SITE.CREATION_DATE , CUST_SITE.CREATED_BY , CUST_SITE.CUST_ACCOUNT_ID "CUSTOMER_ID" , CUST_SITE.STATUS , CUST_SITE.ORIG_SYSTEM_REFERENCE , CUST_SITE.ORG_ID , LOC.COUNTRY , TERR.TERRITORY_SHORT_NAME "COUNTRY_MEANING" , TERR.ADDRESS_STYLE , LOC.ADDRESS1 , LOC.ADDRESS2 , LOC.ADDRESS3 , LOC.ADDRESS4 , LOC.CITY , LOC.POSTAL_CODE , LOC.STATE , LOC.PROVINCE , LOC.COUNTY , CUST_SITE.LAST_UPDATE_LOGIN , CUST_SITE.ECE_TP_LOCATION_CODE , IGI.STP_COMMON_REF , IGI.STP_ALT_ADDR , IGI.STP_SUPPLIER , IGI.STP_SITE_INACTIVE_DATE , LOC.LANGUAGE , LANG.DESCRIPTION "LANGUAGE_DESCRIPTION" , LOC.ADDRESS_LINES_PHONETIC , CUST_SITE.CUSTOMER_CATEGORY_CODE , L_CAT.MEANING "CUSTOMER_CATEGORY_MEANING" , LOC.ADDRESS_KEY , CUST_SITE.ROWID "ROW_ID" FROM HZ_PARTY_SITES PARTY_SITE , HZ_LOCATIONS LOC , HZ_CUST_ACCT_SITES_ALL CUST_SITE , IGI_RA_ADDRESSES IGI , AR_LOOKUPS L_CAT , FND_LANGUAGES_VL LANG , FND_TERRITORIES_VL TERR WHERE CUST_SITE.party_site_id = PARTY_SITE.party_site_id AND LOC.location_id = PARTY_SITE.location_id AND CUST_SITE.cust_acct_site_id = IGI.ADDRESS_ID AND CUST_SITE.CUSTOMER_CATEGORY_CODE = L_CAT.LOOKUP_CODE(+) AND L_CAT.LOOKUP_TYPE(+) = 'ADDRESS_CATEGORY' AND LOC.COUNTRY = TERR.TERRITORY_CODE(+) AND LOC.LANGUAGE = LANG.LANGUAGE_CODE(+)

View Text - HTML Formatted

SELECT CUST_SITE.CUST_ACCT_SITE_ID "ADDRESS_ID"
, CUST_SITE.LAST_UPDATE_DATE
, CUST_SITE.LAST_UPDATED_BY
, CUST_SITE.CREATION_DATE
, CUST_SITE.CREATED_BY
, CUST_SITE.CUST_ACCOUNT_ID "CUSTOMER_ID"
, CUST_SITE.STATUS
, CUST_SITE.ORIG_SYSTEM_REFERENCE
, CUST_SITE.ORG_ID
, LOC.COUNTRY
, TERR.TERRITORY_SHORT_NAME "COUNTRY_MEANING"
, TERR.ADDRESS_STYLE
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.POSTAL_CODE
, LOC.STATE
, LOC.PROVINCE
, LOC.COUNTY
, CUST_SITE.LAST_UPDATE_LOGIN
, CUST_SITE.ECE_TP_LOCATION_CODE
, IGI.STP_COMMON_REF
, IGI.STP_ALT_ADDR
, IGI.STP_SUPPLIER
, IGI.STP_SITE_INACTIVE_DATE
, LOC.LANGUAGE
, LANG.DESCRIPTION "LANGUAGE_DESCRIPTION"
, LOC.ADDRESS_LINES_PHONETIC
, CUST_SITE.CUSTOMER_CATEGORY_CODE
, L_CAT.MEANING "CUSTOMER_CATEGORY_MEANING"
, LOC.ADDRESS_KEY
, CUST_SITE.ROWID "ROW_ID"
FROM HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL CUST_SITE
, IGI_RA_ADDRESSES IGI
, AR_LOOKUPS L_CAT
, FND_LANGUAGES_VL LANG
, FND_TERRITORIES_VL TERR
WHERE CUST_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND CUST_SITE.CUST_ACCT_SITE_ID = IGI.ADDRESS_ID
AND CUST_SITE.CUSTOMER_CATEGORY_CODE = L_CAT.LOOKUP_CODE(+)
AND L_CAT.LOOKUP_TYPE(+) = 'ADDRESS_CATEGORY'
AND LOC.COUNTRY = TERR.TERRITORY_CODE(+)
AND LOC.LANGUAGE = LANG.LANGUAGE_CODE(+)