eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OKS.OKS_USG_QP_CALL_TBL

Object Details

Object Name:	OKS_USG_QP_CALL_TBL
Object Type:	TABLE
Owner:	OKS
FND Design Data:	OKS.OKS_USG_QP_CALL_TBL
Subobject Name:
Status:	VALID

Temporary Table Details

OKS.OKS_USG_QP_CALL_TBL 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:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
PRICE_LIST	NUMBER
PRICE_LIST_LINE_ID	NUMBER
CHR_ID	NUMBER
LINE_ID	NUMBER
SUBLINE_ID	NUMBER
INTENT	VARCHAR2	(200)
CURRENCY	VARCHAR2	(200)
BCL_ID	NUMBER
BSL_ID	NUMBER
USAGE_QTY	NUMBER
USAGE_UOM_CODE	VARCHAR2	(200)
BREAK_UOM_CODE	VARCHAR2	(200)
PRORATION_YN	VARCHAR2	(200)
BILL_FROM_DATE	DATE
BILL_TO_DATE	DATE
ASKING_UNIT_PRICE	NUMBER
DNZ_CHR_ID	NUMBER
CURRENCY_CODE	VARCHAR2	(20)
PRORATE	VARCHAR2	(10)
PRV	NUMBER
BILL_SIGN	NUMBER
USG_BCL_ID	NUMBER
LEVEL_ELEMENT_ID	NUMBER
LEVEL_COVERAGE_ID	NUMBER
LINE_INDEX	NUMBER
LINE_PRORATE	VARCHAR2	(10)
AMOUNT	NUMBER
STATUS_CODE	VARCHAR2	(50)
STATUS_TEXT	VARCHAR2	(200)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PRICE_LIST
,      PRICE_LIST_LINE_ID
,      CHR_ID
,      LINE_ID
,      SUBLINE_ID
,      INTENT
,      CURRENCY
,      BCL_ID
,      BSL_ID
,      USAGE_QTY
,      USAGE_UOM_CODE
,      BREAK_UOM_CODE
,      PRORATION_YN
,      BILL_FROM_DATE
,      BILL_TO_DATE
,      ASKING_UNIT_PRICE
,      DNZ_CHR_ID
,      CURRENCY_CODE
,      PRORATE
,      PRV
,      BILL_SIGN
,      USG_BCL_ID
,      LEVEL_ELEMENT_ID
,      LEVEL_COVERAGE_ID
,      LINE_INDEX
,      LINE_PRORATE
,      AMOUNT
,      STATUS_CODE
,      STATUS_TEXT
FROM OKS.OKS_USG_QP_CALL_TBL;

Dependencies

[top of page]

OKS.OKS_USG_QP_CALL_TBL does not reference any database object

OKS.OKS_USG_QP_CALL_TBL is referenced by following:

APPS: OKS_USG_QP_CALL_TBL