Product: | IGI - Public Sector Financials International |
---|---|
Description: | This view displays single third party customer site information |
Implementation/DBA Data: | APPS.IGI_AR_ADDRESSES_V |
SELECT ADDR.ADDRESS_ID
, ADDR.LAST_UPDATE_DATE
, ADDR.LAST_UPDATED_BY
, ADDR.CREATION_DATE
, ADDR.CREATED_BY
, ADDR.CUSTOMER_ID
, ADDR.STATUS
, ADDR.ORIG_SYSTEM_REFERENCE
, ADDR.ORG_ID
, ADDR.COUNTRY
, TERR.TERRITORY_SHORT_NAME COUNTRY_MEANING
, TERR.ADDRESS_STYLE
, ADDR.ADDRESS1
, ADDR.ADDRESS2
, ADDR.ADDRESS3
, ADDR.ADDRESS4
, ADDR.CITY
, ADDR.POSTAL_CODE
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.COUNTY
, ADDR.LAST_UPDATE_LOGIN
, ADDR.ECE_TP_LOCATION_CODE
, IGI.STP_COMMON_REF
, IGI.STP_ALT_ADDR
, IGI.STP_SUPPLIER
, IGI.STP_SITE_INACTIVE_DATE
, ADDR.LANGUAGE
, LANG.DESCRIPTION LANGUAGE_DESCRIPTION
, ADDR.ADDRESS_LINES_PHONETIC
, ADDR.CUSTOMER_CATEGORY_CODE
, L_CAT.MEANING CUSTOMER_CATEGORY_MEANING
, ADDR.ADDRESS_KEY
, ADDR.ROW_ID ROW_ID
FROM RA_ADDRESSES ADDR
, IGI_RA_ADDRESSES IGI
, AR_LOOKUPS L_CAT
, FND_LANGUAGES_VL LANG
, FND_TERRITORIES_VL TERR
WHERE ADDR.ADDRESS_ID = IGI.ADDRESS_ID
AND ADDR.CUSTOMER_CATEGORY_CODE = L_CAT.LOOKUP_CODE(+)
AND L_CAT.LOOKUP_TYPE(+) = 'ADDRESS_CATEGORY'
AND ADDR.COUNTRY = TERR.TERRITORY_CODE(+)
AND ADDR.LANGUAGE = LANG.LANGUAGE_CODE(+)