Product: | AS - Sales Foundation |
---|---|
Description: | Customer, accounts view used in Account form |
Implementation/DBA Data: | Not implemented in this database |
SELECT CUST.CUSTOMER_ID
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, CUST.TAX_REFERENCE
, CUST.STATUS
, CUST.CUSTOMER_KEY
, ADDR.ADDRESS_ID
, NVL(ADDR.STATUS
, CUST.STATUS)
, ADDR.ADDRESS1
, ADDR.ADDRESS2
, ADDR.ADDRESS3
, ADDR.ADDRESS4
, ADDR.CITY
, ADDR.POSTAL_CODE
, ADDR.STATE
, ADDR.ADDRESS_KEY
, ADDR.PROVINCE
, ADDR.COUNTY
, TERR.TERRITORY_SHORT_NAME
, ADDR.COUNTRY
, LOOK2.MEANING
, CUST.CUSTOMER_PROSPECT_CODE
, CUST.COMPETITOR_FLAG
, ADDR.DO_NOT_MAIL_FLAG
, ADDR.REFERENCE_USE_FLAG
, ADDR.KEY_ACCOUNT_FLAG
, ADDR.ATTRIBUTE_CATEGORY
, ADDR.ATTRIBUTE1
, ADDR.ATTRIBUTE2
, ADDR.ATTRIBUTE3
, ADDR.ATTRIBUTE4
, ADDR.ATTRIBUTE5
, ADDR.ATTRIBUTE6
, ADDR.ATTRIBUTE7
, ADDR.ATTRIBUTE8
, ADDR.ATTRIBUTE9
, ADDR.ATTRIBUTE10
, ADDR.ATTRIBUTE11
, ADDR.ATTRIBUTE12
, ADDR.ATTRIBUTE13
, ADDR.ATTRIBUTE14
, ADDR.ATTRIBUTE15
FROM FND_TERRITORIES_TL TERR
, AR_LOOKUPS LOOK2
, RA_ADDRESSES ADDR
, RA_CUSTOMERS CUST
WHERE ADDR.COUNTRY = TERR.TERRITORY_CODE(+)
AND TERR.LANGUAGE(+) = USERENV('LANG')
AND LOOK2.LOOKUP_TYPE(+) = 'CUSTOMER_PROSPECT_CODE'
AND CUST.CUSTOMER_PROSPECT_CODE = LOOK2.LOOKUP_CODE(+)
AND CUST.CUSTOMER_ID = ADDR.CUSTOMER_ID(+)