[Home] [Help]
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
Name |
BILLING_TYPE_ID |
NAME |
BILLING_TYPE |
CONTRACT_BILLING_TYPE_ID |
TXN_GROUP_ID |
COVERED_AMOUNT |
COVERED_PERCENT |