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.

[Home] [Help]

VIEW: OKS.OKS_COVERED_LEVELS_INTERFACE#

Source

View Text - Preformatted


select COVERED_LEVEL_INTERFACE_ID COVERED_LEVEL_INTERFACE_ID, LINE_INTERFACE_ID LINE_INTERFACE_ID, LINE_NUMBER LINE_NUMBER, COVERED_SERIAL_NUMBER COVERED_SERIAL_NUMBER, COVERED_INSTANCE_NUMBER COVERED_INSTANCE_NUMBER, COVERED_INSTANCE_ID COVERED_INSTANCE_ID, COVERED_ITEM_NAME COVERED_ITEM_NAME, COVERED_ITEM_ID COVERED_ITEM_ID, COVERED_ITEM_ORG_ID COVERED_ITEM_ORG_ID, COVERED_SYSTEM_ID COVERED_SYSTEM_ID, COVERED_ACCOUNT_NUMBER COVERED_ACCOUNT_NUMBER, COVERED_ACCOUNT_ID COVERED_ACCOUNT_ID, COVERED_SITE_NUMBER COVERED_SITE_NUMBER, COVERED_SITE_ID COVERED_SITE_ID, COVERED_PARTY_NAME COVERED_PARTY_NAME, COVERED_PARTY_NUMBER COVERED_PARTY_NUMBER, COVERED_PARTY_ID COVERED_PARTY_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, QUANTITY_COVERED QUANTITY_COVERED, QUANTITY_UOM QUANTITY_UOM, PRICE_UOM PRICE_UOM, SUBTOTAL SUBTOTAL, TAX_AMOUNT TAX_AMOUNT, FIRST_BILL_AMOUNT FIRST_BILL_AMOUNT, LAST_BILL_AMOUNT LAST_BILL_AMOUNT from "OKS"."OKS_COVERED_LEVELS_INTERFACE"

View Text - HTML Formatted

SELECT COVERED_LEVEL_INTERFACE_ID COVERED_LEVEL_INTERFACE_ID
, LINE_INTERFACE_ID LINE_INTERFACE_ID
, LINE_NUMBER LINE_NUMBER
, COVERED_SERIAL_NUMBER COVERED_SERIAL_NUMBER
, COVERED_INSTANCE_NUMBER COVERED_INSTANCE_NUMBER
, COVERED_INSTANCE_ID COVERED_INSTANCE_ID
, COVERED_ITEM_NAME COVERED_ITEM_NAME
, COVERED_ITEM_ID COVERED_ITEM_ID
, COVERED_ITEM_ORG_ID COVERED_ITEM_ORG_ID
, COVERED_SYSTEM_ID COVERED_SYSTEM_ID
, COVERED_ACCOUNT_NUMBER COVERED_ACCOUNT_NUMBER
, COVERED_ACCOUNT_ID COVERED_ACCOUNT_ID
, COVERED_SITE_NUMBER COVERED_SITE_NUMBER
, COVERED_SITE_ID COVERED_SITE_ID
, COVERED_PARTY_NAME COVERED_PARTY_NAME
, COVERED_PARTY_NUMBER COVERED_PARTY_NUMBER
, COVERED_PARTY_ID COVERED_PARTY_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
, QUANTITY_COVERED QUANTITY_COVERED
, QUANTITY_UOM QUANTITY_UOM
, PRICE_UOM PRICE_UOM
, SUBTOTAL SUBTOTAL
, TAX_AMOUNT TAX_AMOUNT
, FIRST_BILL_AMOUNT FIRST_BILL_AMOUNT
, LAST_BILL_AMOUNT LAST_BILL_AMOUNT
FROM "OKS"."OKS_COVERED_LEVELS_INTERFACE"