VIEW: APPS.OKS_PARTIES_V

Source

View Text - Preformatted

SELECT PX.party_name, PX.party_number,PX.Party_ID from HZ_PARTIES PX WHERE EXISTS ( Select '*' from okc_k_party_roles_b pr where pr.rle_code = 'CUSTOMER' AND PR.OBJECT1_ID1 = TO_CHAR( PX.PARTY_ID) )

View Text - HTML Formatted

SELECT PX.PARTY_NAME
, PX.PARTY_NUMBER
, PX.PARTY_ID
FROM HZ_PARTIES PX
WHERE EXISTS ( SELECT '*'
FROM OKC_K_PARTY_ROLES_B PR
WHERE PR.RLE_CODE = 'CUSTOMER'
AND PR.OBJECT1_ID1 = TO_CHAR( PX.PARTY_ID) )