[Home] [Help] [Dependency Information]
Object Name: | OKS_CCTAB_TEMP_TABLE |
---|---|
Object Type: | TABLE |
Owner: | OKS |
Subobject Name: | |
Status: | VALID |
OKS.OKS_CCTAB_TEMP_TABLE is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTRACT_NUMBER | VARCHAR2 | (150) | ||
COVERAGE_NAME | VARCHAR2 | (500) | ||
SERVICE_NAME | VARCHAR2 | (500) | ||
COVERAGE_TYPE | VARCHAR2 | (500) | ||
LINE_STATUS | VARCHAR2 | (50) | ||
LINE_START_DATE | DATE | |||
LINE_END_DATE | DATE | |||
DESCRIPTION | VARCHAR2 | (1000) | ||
VERSION | VARCHAR2 | (400) | ||
CATEGORY | VARCHAR2 | (400) | ||
ACCOUNT_NAME | VARCHAR2 | (400) | ||
DURATION | NUMBER | |||
PERIOD | VARCHAR2 | (15) | ||
LINE_REF | VARCHAR2 | (400) | ||
BILL_TO | VARCHAR2 | (400) | ||
SHIP_TO | VARCHAR2 | (400) | ||
COVERAGE_NUMBER | NUMBER | |||
COVERAGE_LINE_ID | NUMBER | |||
SERVICE_ID | NUMBER | |||
CONTRACT_ID | NUMBER | |||
ACCOUNT_NUMBER | VARCHAR2 | (100) | ||
COVERAGE_LINE_TYPE | VARCHAR2 | (400) |
Cut, paste (and edit) the following text to query this object:
SELECT CONTRACT_NUMBER
, COVERAGE_NAME
, SERVICE_NAME
, COVERAGE_TYPE
, LINE_STATUS
, LINE_START_DATE
, LINE_END_DATE
, DESCRIPTION
, VERSION
, CATEGORY
, ACCOUNT_NAME
, DURATION
, PERIOD
, LINE_REF
, BILL_TO
, SHIP_TO
, COVERAGE_NUMBER
, COVERAGE_LINE_ID
, SERVICE_ID
, CONTRACT_ID
, ACCOUNT_NUMBER
, COVERAGE_LINE_TYPE
FROM OKS.OKS_CCTAB_TEMP_TABLE;
OKS.OKS_CCTAB_TEMP_TABLE does not reference any database object
OKS.OKS_CCTAB_TEMP_TABLE is referenced by following:
|
|
|