[Home] [Help] [Dependency Information]
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 |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
OKS.OKS_USG_QP_CALL_TBL does not reference any database object
OKS.OKS_USG_QP_CALL_TBL is referenced by following:
|
|
|