VIEW: APPS.PA_CUSTOMER_NAME_V

Source

View Text - Preformatted

SELECT DISTINCT CUSTOMER_NAME FROM PA_CUSTOMERS_V WHERE STATUS= 'A' and PARTY_TYPE= 'ORGANIZATION'

View Text - HTML Formatted

SELECT DISTINCT CUSTOMER_NAME
FROM PA_CUSTOMERS_V
WHERE STATUS= 'A'
AND PARTY_TYPE= 'ORGANIZATION'