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: OKS.OKS_USAGE_COUNTERS_INTERFACE#

Source

View Text - Preformatted


select USAGE_COUNTER_INTERFACE_ID USAGE_COUNTER_INTERFACE_ID, LINE_INTERFACE_ID LINE_INTERFACE_ID, LINE_NUMBER LINE_NUMBER, COUNTER_ID COUNTER_ID, LINE_REFERENCE LINE_REFERENCE, STATUS_CODE STATUS_CODE, START_DATE START_DATE, END_DATE END_DATE, RENEWAL_TYPE_CODE RENEWAL_TYPE_CODE, CANCELLATION_DATE CANCELLATION_DATE, CANCELLATION_REASON CANCELLATION_REASON, INVOICE_TEXT INVOICE_TEXT, PRINT_INVOICE PRINT_INVOICE, SUBTOTAL SUBTOTAL, TAX_AMOUNT TAX_AMOUNT, FIXED_USG_CNT FIXED_USG_CNT, MINIMUM_USG_CNT MINIMUM_USG_CNT, DEFAULT_USG_CNT DEFAULT_USG_CNT, FILL_YN FILL_YN, ESTIMATION_METHOD ESTIMATION_METHOD, ESTIMATION_START_DATE ESTIMATION_START_DATE, LEVEL_YN LEVEL_YN from "OKS"."OKS_USAGE_COUNTERS_INTERFACE"

View Text - HTML Formatted

SELECT USAGE_COUNTER_INTERFACE_ID USAGE_COUNTER_INTERFACE_ID
, LINE_INTERFACE_ID LINE_INTERFACE_ID
, LINE_NUMBER LINE_NUMBER
, COUNTER_ID COUNTER_ID
, LINE_REFERENCE LINE_REFERENCE
, STATUS_CODE STATUS_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, RENEWAL_TYPE_CODE RENEWAL_TYPE_CODE
, CANCELLATION_DATE CANCELLATION_DATE
, CANCELLATION_REASON CANCELLATION_REASON
, INVOICE_TEXT INVOICE_TEXT
, PRINT_INVOICE PRINT_INVOICE
, SUBTOTAL SUBTOTAL
, TAX_AMOUNT TAX_AMOUNT
, FIXED_USG_CNT FIXED_USG_CNT
, MINIMUM_USG_CNT MINIMUM_USG_CNT
, DEFAULT_USG_CNT DEFAULT_USG_CNT
, FILL_YN FILL_YN
, ESTIMATION_METHOD ESTIMATION_METHOD
, ESTIMATION_START_DATE ESTIMATION_START_DATE
, LEVEL_YN LEVEL_YN
FROM "OKS"."OKS_USAGE_COUNTERS_INTERFACE"