VIEW: APPS.ASO_PVT_PARTIES_V

Source

View Text - Preformatted

SELECT PARTY_ID, PARTY_NAME, PARTY_TYPE, PERSON_FIRST_NAME, PERSON_LAST_NAME, ADDRESS1, CITY FROM HZ_PARTIES WHERE STATUS = 'A'

View Text - HTML Formatted

SELECT PARTY_ID
, PARTY_NAME
, PARTY_TYPE
, PERSON_FIRST_NAME
, PERSON_LAST_NAME
, ADDRESS1
, CITY
FROM HZ_PARTIES
WHERE STATUS = 'A'