Product: | AS - Sales Foundation |
---|---|
Description: | This view is only a wrapper view of HZ_PARTIES |
Implementation/DBA Data: | APPS.AS_PARTY_CUSTOMERS_V |
SELECT CUST.ROWID
, CUST.PARTY_ID
, CUST.PARTY_ID
, CUST.PARTY_TYPE
, CUST.PARTY_NAME
, CUST.PARTY_NUMBER
, CUST.TAX_REFERENCE
, CUST.STATUS
, CUST.SIC_CODE
, CUST.CUSTOMER_KEY
, CUST.TOTAL_NUM_OF_ORDERS
, CUST.TOTAL_ORDERED_AMOUNT
, CUST.LAST_ORDERED_DATE
, CUST.CATEGORY_CODE
, CUST.EMPLOYEES_TOTAL
, 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
, CUST.ORGANIZATION_NAME_PHONETIC
, CUST.PERSON_FIRST_NAME_PHONETIC
, CUST.PERSON_LAST_NAME_PHONETIC
, CUST.VALIDATED_FLAG
, CUST.PERSON_FIRST_NAME
, CUST.PERSON_LAST_NAME
, CUST.DUNS_NUMBER_C
FROM HZ_PARTIES CUST
WHERE CUST.PARTY_TYPE IN ('PERSON'
, 'ORGANIZATION')
AND CUST.STATUS='A'