Product: | CSC - Customer Care |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CSC_ACCT_SITE_USES_V |
SELECT CUST.ROWID
, CUST.SITE_USE_ID
, CUST.CUST_ACCT_SITE_ID
, CUST.BILL_TO_SITE_USE_ID
, CUST.SITE_USE_CODE
, LOOKUP.MEANING
, CUST.PRIMARY_FLAG
, CUST.STATUS
, CUST.LOCATION
, CUST.LAST_UPDATE_DATE
, CUST.LAST_UPDATED_BY
, CUST.CREATION_DATE
, CUST.CREATED_BY
, CUST.LAST_UPDATE_LOGIN
, 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 HZ_CUST_SITE_USES_ALL CUST
, AR_LOOKUPS LOOKUP
WHERE CUST.SITE_USE_CODE = LOOKUP.LOOKUP_CODE
AND LOOKUP.LOOKUP_TYPE = 'SITE_USE_CODE'