View: OKS_ENT_BILL_TYPES_V

Product:	OKS - Service Contracts
Description:	Billing Type View For Service Contracts
Implementation/DBA Data:	APPS.OKS_ENT_BILL_TYPES_V

View Text

SELECT BT.ID1 BILLING_TYPE_ID
, BT.NAME NAME
, BT.BILLING_TYPE BILLING_TYPE
, KL.ID CONTRACT_BILLING_TYPE_ID
, KL.CLE_ID TXN_GROUP_ID
, OKSBTL.DISCOUNT_AMOUNT COVERED_AMOUNT
, OKSBTL.DISCOUNT_PERCENT COVERED_PERCENT
FROM OKC_K_LINES_B KL
, OKS_K_LINES_B OKSBTL
, OKC_K_ITEMS IT
, OKX_TXN_BILLING_TYPES_V BT
WHERE KL.LSE_ID IN (5
, 23
, 59)
AND KL.ID = OKSBTL.CLE_ID
AND KL.ID = IT.CLE_ID
AND IT.OBJECT1_ID1 = BT.ID1
AND IT.OBJECT1_ID2 = BT.ID2
AND IT.JTOT_OBJECT1_CODE = 'OKX_BILLTYPE'

Columns