View: OKS_RESOURCES_V

Product:	OKS - Service Contracts
Description:	View for Preferred Resources for Service Contracts Coverages
Implementation/DBA Data:	APPS.OKS_RESOURCES_V

View Text

SELECT CONTS.ROWID ROW_ID
, CONTS.ID ID
, CONTS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, KPROL.CLE_ID BUS_PROCESS_CLE_ID
, CONTS.DNZ_CHR_ID DNZ_CHR_ID
, CONTS.OBJECT1_ID1 RESOURCE_ID1
, CONTS.OBJECT1_ID2 RESOURCE_ID2
, CONTS.CRO_CODE RESOURCE_TYPE
, CONTS.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, CONTS.PRIMARY_YN PRIMARY_YN
, CONTS.RESOURCE_CLASS RESOURCE_CLASS
FROM OKC_K_PARTY_ROLES_B KPROL
, OKC_CONTACTS CONTS
WHERE CONTS.CPL_ID = KPROL.ID

Columns