[Home] [Help] [Dependency Information]
Object Name: | OKS_COVERED_LEVELS_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | OKS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COVERED_LEVEL_INTERFACE_ID | NUMBER | Yes | ||
LINE_INTERFACE_ID | NUMBER | Yes | ||
LINE_NUMBER | NUMBER | |||
COVERED_SERIAL_NUMBER | VARCHAR2 | (30) | ||
COVERED_INSTANCE_NUMBER | VARCHAR2 | (30) | ||
COVERED_INSTANCE_ID | NUMBER | |||
COVERED_ITEM_NAME | VARCHAR2 | (800) | ||
COVERED_ITEM_ID | NUMBER | |||
COVERED_ITEM_ORG_ID | NUMBER | |||
COVERED_SYSTEM_ID | NUMBER | |||
COVERED_ACCOUNT_NUMBER | VARCHAR2 | (30) | ||
COVERED_ACCOUNT_ID | NUMBER | |||
COVERED_SITE_NUMBER | VARCHAR2 | (30) | ||
COVERED_SITE_ID | NUMBER | |||
COVERED_PARTY_NAME | VARCHAR2 | (360) | ||
COVERED_PARTY_NUMBER | VARCHAR2 | (30) | ||
COVERED_PARTY_ID | NUMBER | |||
LINE_REFERENCE | VARCHAR2 | (300) | ||
STATUS_CODE | VARCHAR2 | (30) | Yes | |
START_DATE | DATE | |||
END_DATE | DATE | |||
RENEWAL_TYPE_CODE | VARCHAR2 | (30) | ||
CANCELLATION_DATE | DATE | |||
CANCELLATION_REASON | VARCHAR2 | (30) | ||
INVOICE_TEXT | VARCHAR2 | (2000) | ||
PRINT_INVOICE | VARCHAR2 | (1) | ||
QUANTITY_COVERED | NUMBER | |||
QUANTITY_UOM | VARCHAR2 | (3) | ||
PRICE_UOM | VARCHAR2 | (3) | ||
SUBTOTAL | NUMBER | |||
TAX_AMOUNT | NUMBER | |||
FIRST_BILL_AMOUNT | NUMBER | |||
LAST_BILL_AMOUNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT COVERED_LEVEL_INTERFACE_ID
, LINE_INTERFACE_ID
, LINE_NUMBER
, COVERED_SERIAL_NUMBER
, COVERED_INSTANCE_NUMBER
, COVERED_INSTANCE_ID
, COVERED_ITEM_NAME
, COVERED_ITEM_ID
, COVERED_ITEM_ORG_ID
, COVERED_SYSTEM_ID
, COVERED_ACCOUNT_NUMBER
, COVERED_ACCOUNT_ID
, COVERED_SITE_NUMBER
, COVERED_SITE_ID
, COVERED_PARTY_NAME
, COVERED_PARTY_NUMBER
, COVERED_PARTY_ID
, LINE_REFERENCE
, STATUS_CODE
, START_DATE
, END_DATE
, RENEWAL_TYPE_CODE
, CANCELLATION_DATE
, CANCELLATION_REASON
, INVOICE_TEXT
, PRINT_INVOICE
, QUANTITY_COVERED
, QUANTITY_UOM
, PRICE_UOM
, SUBTOTAL
, TAX_AMOUNT
, FIRST_BILL_AMOUNT
, LAST_BILL_AMOUNT
FROM OKS.OKS_COVERED_LEVELS_INTERFACE#;
|
|
|