Product: | AMS - Marketing |
---|---|
Description: | This view retuns all the parties(both Persons and Organizations) |
Implementation/DBA Data: |
![]() |
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
FROM HZ_PARTIES CUST
WHERE CUST.PARTY_TYPE IN ('PERSON'
, 'ORGANIZATION')