View: OKC_K_ITEMS_V

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

View Text

SELECT CIMB.ROWID ROW_ID
, CIMB.ID ID
, CIMB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CIMB.CLE_ID CLE_ID
, CIMB.CHR_ID CHR_ID
, CIMB.CLE_ID_FOR CLE_ID_FOR
, CIMB.DNZ_CHR_ID DNZ_CHR_ID
, CIMB.OBJECT1_ID1 OBJECT1_ID1
, CIMB.OBJECT1_ID2 OBJECT1_ID2
, CIMB.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, CIMB.UOM_CODE UOM_CODE
, CIMB.EXCEPTION_YN EXCEPTION_YN
, CIMB.NUMBER_OF_ITEMS NUMBER_OF_ITEMS
, CIMB.PRICED_ITEM_YN PRICED_ITEM_YN
, CIMB.UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF
, CIMB.UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID
, CIMB.CREATED_BY CREATED_BY
, CIMB.CREATION_DATE CREATION_DATE
, CIMB.LAST_UPDATED_BY LAST_UPDATED_BY
, CIMB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CIMB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CIMB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CIMB.PROGRAM_ID PROGRAM_ID
, CIMB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CIMB.REQUEST_ID REQUEST_ID
FROM OKC_K_ITEMS CIMB

Columns