VIEW: APPS.QA_GROUP_V

Source

View Text - Preformatted

SELECT party_id, party_name, party_number, last_update_date from hz_parties where party_type = 'GROUP' and group_type = 'QA'

View Text - HTML Formatted

SELECT PARTY_ID
, PARTY_NAME
, PARTY_NUMBER
, LAST_UPDATE_DATE
FROM HZ_PARTIES
WHERE PARTY_TYPE = 'GROUP'
AND GROUP_TYPE = 'QA'