FND Design Data [Home] [Help]

View: OKC_K_SALES_CREDITS_HV

Product: OKC - Contracts Core
Description: view for service sales credits history
Implementation/DBA Data: ViewAPPS.OKC_K_SALES_CREDITS_HV
View Text

SELECT KSCHV.ROWID ROW_ID
, KSCHV.ID ID
, KSCHV.DNZ_CHR_ID DNZ_CHR_ID
, KSCHV.MAJOR_VERSION MAJOR_VERSION
, KSCHV.PERCENT PERCENT
, KSCHV.CHR_ID CHR_ID
, KSCHV.CLE_ID CLE_ID
, KSCHV.SALESREP_ID1 SALESREP_ID1
, KSCHV.SALESREP_ID2 SALESREP_ID2
, KSCHV.SALES_CREDIT_TYPE_ID1 SALES_CREDIT_TYPE_ID1
, KSCHV.SALES_CREDIT_TYPE_ID2 SALES_CREDIT_TYPE_ID2
, KSCHV.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, KSCHV.CREATED_BY CREATED_BY
, KSCHV.CREATION_DATE CREATION_DATE
, KSCHV.LAST_UPDATED_BY LAST_UPDATED_BY
, KSCHV.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM OKC_K_SALES_CREDITS_H KSCHV

Columns

Name
ROW_ID
ID
DNZ_CHR_ID
MAJOR_VERSION
PERCENT
CHR_ID
CLE_ID
SALESREP_ID1
SALESREP_ID2
SALES_CREDIT_TYPE_ID1
SALES_CREDIT_TYPE_ID2
OBJECT_VERSION_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE