DBA Data[Home] [Help] [Dependency Information]

TABLE: OKS.OKS_CCTAB_TEMP_TABLE

Object Details
Object Name: OKS_CCTAB_TEMP_TABLE
Object Type: TABLE
Owner: OKS
Subobject Name:
Status: VALID

Temporary Table Details

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.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
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)
Query Text

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;

Dependencies

[top of page]

OKS.OKS_CCTAB_TEMP_TABLE does not reference any database object

OKS.OKS_CCTAB_TEMP_TABLE is referenced by following:

SchemaAPPS
SynonymOKS_CCTAB_TEMP_TABLE