[Home] [Help]
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
Name |
PARTY_NAME |
PARTY_NUMBER |
PARTY_ID |