View: OKS_PARTIES_V

Product:	OKS - Service Contracts
Description:	View for Selecing Parties in reports
Implementation/DBA Data:	APPS.OKS_PARTIES_V

View Text

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) )

Columns