VIEW: APPS.OKC_K_ITEMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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