View: OKS_CONTACT_V

Product:	OKS - Service Contracts
Description:	Contacts View for Contract details Form
Implementation/DBA Data:	APPS.OKS_CONTACT_V

View Text

SELECT D.ID
, D.COD_ID COD_ID
, D.OBJECT1_ID1 OBJECT1_ID1
, D.OBJECT1_ID2
, D.JTOT_OBJECT_CODE
, A.CRO_CODE
, B.MEANING
, C.NAME
FROM OKC_CONTACT_SOURCES_V A
, FND_LOOKUPS B
, OKX_PARTY_CONTACTS_V C
, OKS_K_ORDER_CONTACTS_V D
WHERE A.CRO_CODE = B.LOOKUP_CODE
AND A.BUY_OR_SELL = 'S'
AND D.CRO_CODE = A.CRO_CODE
AND A.JTOT_OBJECT_CODE = D.JTOT_OBJECT_CODE
AND A.RLE_CODE = 'CUSTOMER'
AND B.LOOKUP_TYPE = 'OKC_CONTACT_ROLE'
AND TO_NUMBER(D.OBJECT1_ID1) = C.ID1
AND D.OBJECT1_ID2 = C.ID2

Columns