View: OKS_RESOURCES_HV

Product:	OKS - Service Contracts
Description:	History View for Coverage Resources
Implementation/DBA Data:	APPS.OKS_RESOURCES_HV

View Text

SELECT CONTS.ROWID ROW_ID
, CONTS.ID ID
, CONTS.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, KPROL.MAJOR_VERSION MAJOR_VERSION
, 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
FROM OKC_K_PARTY_ROLES_HV KPROL
, OKC_CONTACTS_H CONTS
WHERE CONTS.CPL_ID = KPROL.ID
AND CONTS.MAJOR_VERSION = KPROL.MAJOR_VERSION
AND KPROL.RLE_CODE = 'VENDOR'

Columns