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

TABLE: BOM.CSTGILEV_TEMP

Object Details
Object Name: CSTGILEV_TEMP
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.CSTGILEV_TEMP
Subobject Name:
Status: VALID

Temporary Table Details

BOM.CSTGILEV_TEMP 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
ITEM_ID NUMBER

ITEM_DESC VARCHAR2 (240)
PERIOD_ID NUMBER

PERIOD_NAME VARCHAR2 (240)
WAC NUMBER

LIFO_COST NUMBER

MARKET_VALUE NUMBER

JUSTIFICATION VARCHAR2 (240)
LAYER_QUANTITY NUMBER

TOTAL_LAYER_QUANTITY NUMBER

INVENTORY_VALUE NUMBER

TOTAL_INVENTORY_VALUE NUMBER

ITEM_CODE VARCHAR2 (30)
UOM_CODE VARCHAR2 (30)
Query Text

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


SELECT ITEM_ID
,      ITEM_DESC
,      PERIOD_ID
,      PERIOD_NAME
,      WAC
,      LIFO_COST
,      MARKET_VALUE
,      JUSTIFICATION
,      LAYER_QUANTITY
,      TOTAL_LAYER_QUANTITY
,      INVENTORY_VALUE
,      TOTAL_INVENTORY_VALUE
,      ITEM_CODE
,      UOM_CODE
FROM BOM.CSTGILEV_TEMP;

Dependencies

[top of page]

BOM.CSTGILEV_TEMP does not reference any database object

BOM.CSTGILEV_TEMP is referenced by following:

SchemaAPPS
SynonymCSTGILEV_TEMP