[Home] [Help] [Dependency Information]
Object Name: | OKS_COVERED_LEVELS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | OKS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKS_COVERED_LEVEL_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | COVERED_LEVEL_INTERFACE_ID |
OKS_COVERED_LEVEL_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LINE_INTERFACE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COVERED_LEVEL_INTERFACE_ID | NUMBER | Yes | Primary Key | |
LINE_INTERFACE_ID | NUMBER | Yes | Line Interface ID | |
LINE_NUMBER | NUMBER | Line Number | ||
COVERED_SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number | |
COVERED_INSTANCE_NUMBER | VARCHAR2 | (30) | Instance Number | |
COVERED_INSTANCE_ID | NUMBER | Instance Id | ||
COVERED_ITEM_NAME | VARCHAR2 | (800) | Item Name | |
COVERED_ITEM_ID | NUMBER | Item Id | ||
COVERED_ITEM_ORG_ID | NUMBER | Item Organization | ||
COVERED_SYSTEM_ID | NUMBER | System Id | ||
COVERED_ACCOUNT_NUMBER | VARCHAR2 | (30) | Account Number | |
COVERED_ACCOUNT_ID | NUMBER | Account Id | ||
COVERED_SITE_NUMBER | VARCHAR2 | (30) | Site Number | |
COVERED_SITE_ID | NUMBER | Site Id | ||
COVERED_PARTY_NAME | VARCHAR2 | (360) | Party Name | |
COVERED_PARTY_NUMBER | VARCHAR2 | (30) | Party Number | |
COVERED_PARTY_ID | NUMBER | Party Id | ||
LINE_REFERENCE | VARCHAR2 | (300) | Line Reference | |
STATUS_CODE | VARCHAR2 | (30) | Yes | Status |
START_DATE | DATE | Line Start Date | ||
END_DATE | DATE | Line End Date | ||
RENEWAL_TYPE_CODE | VARCHAR2 | (30) | Renewal Type | |
CANCELLATION_DATE | DATE | Cancellation Date | ||
CANCELLATION_REASON | VARCHAR2 | (30) | Cancellation reason | |
INVOICE_TEXT | VARCHAR2 | (2000) | Invoice text | |
PRINT_INVOICE | VARCHAR2 | (1) | Invoice Print flag | |
QUANTITY_COVERED | NUMBER | Covered quantity | ||
QUANTITY_UOM | VARCHAR2 | (3) | Covered quantity unit of measure code | |
PRICE_UOM | VARCHAR2 | (3) | Price unit of measure code | |
SUBTOTAL | NUMBER | Subtotal | ||
TAX_AMOUNT | NUMBER | Tax amount | ||
FIRST_BILL_AMOUNT | NUMBER | First bill amount | ||
LAST_BILL_AMOUNT | NUMBER | Last bill amount |
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;
OKS.OKS_COVERED_LEVELS_INTERFACE does not reference any database object
OKS.OKS_COVERED_LEVELS_INTERFACE is referenced by following:
|
|
|