[Home] [Help] [Dependency Information]
Object Name: | ICX_CAT_PRICES_GT |
---|---|
Object Type: | TABLE |
Owner: | ICX |
Subobject Name: | |
Status: | VALID |
ICX.ICX_CAT_PRICES_GT 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 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ICX_CAT_PRICES_GT_N1 | NORMAL | NONUNIQUE | PROCESSED_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_NUMBER | NUMBER | Yes | ||
ROW_TYPE | VARCHAR2 | (20) | Yes | |
PROCESSED_FLAG | VARCHAR2 | (1) | Yes | |
LANGUAGE | VARCHAR2 | (4) | Yes | |
ACTION | VARCHAR2 | (20) | ||
SYSTEM_ACTION | VARCHAR2 | (20) | ||
ERROR_FLAG | VARCHAR2 | (1) | ||
ERROR_MESSAGE | VARCHAR2 | (2000) | ||
SUPPLIER_ID | NUMBER | |||
SUPPLIER | VARCHAR2 | (700) | ||
SUPPLIER_PART_NUM | VARCHAR2 | (700) | ||
SUPPLIER_PART_AUXID | VARCHAR2 | (255) | ||
UNIT_PRICE | VARCHAR2 | (700) | ||
CURRENCY | VARCHAR2 | (15) | ||
UNIT_OF_MEASURE | VARCHAR2 | (3) | ||
PRICE_LIST_NAME | VARCHAR2 | (255) | ||
PRICE_LIST_ID | NUMBER | |||
BUYER_NAME | VARCHAR2 | (255) | ||
ORG_ID | NUMBER | |||
SUPPLIER_SITE_ID | NUMBER | |||
SUPPLIER_SITE_CODE | VARCHAR2 | (100) | ||
CONTRACT_NUM | VARCHAR2 | (700) | ||
CONTRACT_ID | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_NUMBER
, ROW_TYPE
, PROCESSED_FLAG
, LANGUAGE
, ACTION
, SYSTEM_ACTION
, ERROR_FLAG
, ERROR_MESSAGE
, SUPPLIER_ID
, SUPPLIER
, SUPPLIER_PART_NUM
, SUPPLIER_PART_AUXID
, UNIT_PRICE
, CURRENCY
, UNIT_OF_MEASURE
, PRICE_LIST_NAME
, PRICE_LIST_ID
, BUYER_NAME
, ORG_ID
, SUPPLIER_SITE_ID
, SUPPLIER_SITE_CODE
, CONTRACT_NUM
, CONTRACT_ID
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM ICX.ICX_CAT_PRICES_GT;
ICX.ICX_CAT_PRICES_GT does not reference any database object
ICX.ICX_CAT_PRICES_GT is referenced by following:
|
|
|