eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKS_ENT_BILL_TYPES_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'