Product: | AS - Sales Foundation |
---|---|
Description: | All customers view |
Implementation/DBA Data: | Not implemented in this database |
SELECT CUST.CUSTOMER_ID
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, CUST.TAX_REFERENCE
, CUST.STATUS
, CUST.SIC_CODE
, LOOK1.MEANING
, CUST.CUSTOMER_PROSPECT_CODE
, CUST.COMPETITOR_FLAG
, CUST.CUSTOMER_KEY
, CUST.ATTRIBUTE_CATEGORY
, CUST.ATTRIBUTE1
, CUST.ATTRIBUTE2
, CUST.ATTRIBUTE3
, CUST.ATTRIBUTE4
, CUST.ATTRIBUTE5
, CUST.ATTRIBUTE6
, CUST.ATTRIBUTE7
, CUST.ATTRIBUTE8
, CUST.ATTRIBUTE9
, CUST.ATTRIBUTE10
, CUST.ATTRIBUTE11
, CUST.ATTRIBUTE12
, CUST.ATTRIBUTE13
, CUST.ATTRIBUTE14
, CUST.ATTRIBUTE15
FROM RA_CUSTOMERS CUST
, AR_LOOKUPS LOOK1
WHERE CUST.CUSTOMER_PROSPECT_CODE = LOOK1.LOOKUP_CODE(+)
AND LOOK1.LOOKUP_TYPE(+) = 'CUSTOMER_PROSPECT_CODE'