View: OKC_CONTACTS_V

Product:	OKC - Contracts Core
Description:	View for table OKC_CONTACTS
Implementation/DBA Data:	APPS.OKC_CONTACTS_V

View Text

SELECT CTCB.ROWID ROW_ID
, CTCB.ID ID
, CTCB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CTCB.CPL_ID CPL_ID
, CTCB.CRO_CODE CRO_CODE
, CTCB.DNZ_CHR_ID DNZ_CHR_ID
, CTCB.CONTACT_SEQUENCE CONTACT_SEQUENCE
, CTCB.OBJECT1_ID1 OBJECT1_ID1
, CTCB.OBJECT1_ID2 OBJECT1_ID2
, CTCB.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, FNDV.MEANING ROLE
, CTCB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CTCB.ATTRIBUTE1 ATTRIBUTE1
, CTCB.ATTRIBUTE2 ATTRIBUTE2
, CTCB.ATTRIBUTE3 ATTRIBUTE3
, CTCB.ATTRIBUTE4 ATTRIBUTE4
, CTCB.ATTRIBUTE5 ATTRIBUTE5
, CTCB.ATTRIBUTE6 ATTRIBUTE6
, CTCB.ATTRIBUTE7 ATTRIBUTE7
, CTCB.ATTRIBUTE8 ATTRIBUTE8
, CTCB.ATTRIBUTE9 ATTRIBUTE9
, CTCB.ATTRIBUTE10 ATTRIBUTE10
, CTCB.ATTRIBUTE11 ATTRIBUTE11
, CTCB.ATTRIBUTE12 ATTRIBUTE12
, CTCB.ATTRIBUTE13 ATTRIBUTE13
, CTCB.ATTRIBUTE14 ATTRIBUTE14
, CTCB.ATTRIBUTE15 ATTRIBUTE15
, CTCB.CREATED_BY CREATED_BY
, CTCB.CREATION_DATE CREATION_DATE
, CTCB.LAST_UPDATED_BY LAST_UPDATED_BY
, CTCB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CTCB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CTCB.START_DATE START_DATE
, CTCB.END_DATE END_DATE
, CTCB.PRIMARY_YN PRIMARY_YN
, CTCB.RESOURCE_CLASS RESOURCE_CLASS
, CTCB.SALES_GROUP_ID SALES_GROUP_ID
FROM OKC_CONTACTS CTCB
, FND_LOOKUPS FNDV
WHERE FNDV.LOOKUP_TYPE = 'OKC_CONTACT_ROLE'
AND CTCB.CRO_CODE = FNDV.LOOKUP_CODE

Columns