VIEW: APPS.AMS_PARTY_CUSTOMERS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')