[Home] [Help] [Dependency Information]
Object Name: | CST_PER_CLOSE_SUMMARY_TEMP |
---|---|
Object Type: | TABLE |
Owner: | BOM |
Subobject Name: | |
Status: | VALID |
A temporary table to store intermediate results for period close summarization
BOM.CST_PER_CLOSE_SUMMARY_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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COST_GROUP_ID | NUMBER | (15) | Cost Group identifier | |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Identifies the subinventory | |
INVENTORY_ITEM_ID | NUMBER | (15) | Yes | Inventory item identifier |
ACCOUNTED_VALUE | NUMBER | Yes | Value obtained by summing the accounting distributions | |
ROLLBACK_VALUE | NUMBER | Yes | The inventory value calculated by rolling back transaction quantity and cost | |
ROLLBACK_QTY | NUMBER | Yes | The inventory quantity obtained by rolling back transaction quantity | |
ROLLBACK_ONHAND_VALUE | NUMBER | Onhand portion of the rollback value | ||
ROLLBACK_INTRANSIT_VALUE | NUMBER | Intransit portion of the rollback value |
Cut, paste (and edit) the following text to query this object:
SELECT COST_GROUP_ID
, SUBINVENTORY_CODE
, INVENTORY_ITEM_ID
, ACCOUNTED_VALUE
, ROLLBACK_VALUE
, ROLLBACK_QTY
, ROLLBACK_ONHAND_VALUE
, ROLLBACK_INTRANSIT_VALUE
FROM BOM.CST_PER_CLOSE_SUMMARY_TEMP;
BOM.CST_PER_CLOSE_SUMMARY_TEMP does not reference any database object
BOM.CST_PER_CLOSE_SUMMARY_TEMP is referenced by following:
|
|
|