VIEW: APPS.PA_ORG_PARTIES_LOV_V

Source

View Text - Preformatted

SELECT 112, hzo.party_id, hzo.party_name, hzo.party_number FROM hz_parties hzo WHERE hzo.party_type='ORGANIZATION' and hzo.status = 'A'

View Text - HTML Formatted

SELECT 112
, HZO.PARTY_ID
, HZO.PARTY_NAME
, HZO.PARTY_NUMBER
FROM HZ_PARTIES HZO
WHERE HZO.PARTY_TYPE='ORGANIZATION'
AND HZO.STATUS = 'A'