[Home] [Help] [Dependency Information]
Object Name: | OKS_USAGE_COUNTERS_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_USAGE_COUNTER_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | USAGE_COUNTER_INTERFACE_ID |
OKS_USAGE_COUNTER_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LINE_INTERFACE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USAGE_COUNTER_INTERFACE_ID | NUMBER | Yes | Primary Key | |
LINE_INTERFACE_ID | NUMBER | Yes | Line Interface Id | |
LINE_NUMBER | NUMBER | Line Number | ||
COUNTER_ID | NUMBER | Counter Id | ||
LINE_REFERENCE | VARCHAR2 | (300) | Line Reference | |
STATUS_CODE | VARCHAR2 | (30) | Status Code | |
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End Date | ||
RENEWAL_TYPE_CODE | VARCHAR2 | (30) | Renewal Type | |
CANCELLATION_DATE | DATE | Cancellation date | ||
CANCELLATION_REASON | VARCHAR2 | (30) | Cancellation Reason Code | |
INVOICE_TEXT | VARCHAR2 | (2000) | Invoice Text | |
PRINT_INVOICE | VARCHAR2 | (1) | Invoice Print Flag (Y or N) | |
SUBTOTAL | NUMBER | Subtotal | ||
TAX_AMOUNT | NUMBER | Tax Amount | ||
FIXED_USG_CNT | NUMBER | Fixed | ||
MINIMUM_USG_CNT | NUMBER | Minimum | ||
DEFAULT_USG_CNT | NUMBER | Default | ||
FILL_YN | VARCHAR2 | (1) | Fill 'Y'/ 'N' | |
ESTIMATION_METHOD | VARCHAR2 | (30) | Estimation method | |
ESTIMATION_START_DATE | DATE | Estimation start date | ||
LEVEL_YN | VARCHAR2 | (1) | Level |
Cut, paste (and edit) the following text to query this object:
SELECT USAGE_COUNTER_INTERFACE_ID
, LINE_INTERFACE_ID
, LINE_NUMBER
, COUNTER_ID
, LINE_REFERENCE
, STATUS_CODE
, START_DATE
, END_DATE
, RENEWAL_TYPE_CODE
, CANCELLATION_DATE
, CANCELLATION_REASON
, INVOICE_TEXT
, PRINT_INVOICE
, SUBTOTAL
, TAX_AMOUNT
, FIXED_USG_CNT
, MINIMUM_USG_CNT
, DEFAULT_USG_CNT
, FILL_YN
, ESTIMATION_METHOD
, ESTIMATION_START_DATE
, LEVEL_YN
FROM OKS.OKS_USAGE_COUNTERS_INTERFACE;
OKS.OKS_USAGE_COUNTERS_INTERFACE does not reference any database object
OKS.OKS_USAGE_COUNTERS_INTERFACE is referenced by following:
|
|
|