[Home] [Help] [Dependency Information]
Object Name: | CST_INV_QTY_TEMP |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.CST_INV_QTY_TEMP |
Subobject Name: | |
Status: | VALID |
A temporary table to store intermediate results for period close summarization, standard cost update and inventory valuation reports
BOM.CST_INV_QTY_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 |
---|---|---|---|---|
QTY_SOURCE | NUMBER | (3) | Yes | Identifies the code module that has created the row |
ORGANIZATION_ID | NUMBER | (15) | Yes | Organization identifier |
INVENTORY_ITEM_ID | NUMBER | (15) | Item identifier | |
COST_GROUP_ID | NUMBER | (15) | Cost group identifier | |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Identifies the subinventory | |
ACCOUNTED_VALUE | NUMBER | Value obtained from summing the accounting distributions | ||
ROLLBACK_VALUE | NUMBER | Value obtained from the quantity and cost of transactions that are being rolled back | ||
ROLLBACK_QTY | NUMBER | Quantity contributing to the inventory value | ||
REVISION | VARCHAR2 | (3) | Item revision | |
TXN_SOURCE_TYPE_ID | NUMBER | (15) | Identifies the source type of the transaction that we are rolling back | |
CATEGORY_ID | NUMBER | (15) | Category identifier | |
COST_TYPE_ID | NUMBER | (15) | The cost type against which the asset status of the item is checked | |
FROM_ORGANIZATION_ID | NUMBER | (15) | Identifies the organization that the intransit quantity originated from | |
TO_ORGANIZATION_ID | NUMBER | (15) | Identifies the organization that the intransit quantity is going to | |
RCV_TRANSACTION_ID | NUMBER | (15) | Receiving Transaction Identifier | |
SHIPMENT_LINE_ID | NUMBER | (15) | Shipment Line Identifier | |
INTRANSIT_INV_ACCOUNT | NUMBER | (15) | The account that holds the intransit value |
Cut, paste (and edit) the following text to query this object:
SELECT QTY_SOURCE
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, COST_GROUP_ID
, SUBINVENTORY_CODE
, ACCOUNTED_VALUE
, ROLLBACK_VALUE
, ROLLBACK_QTY
, REVISION
, TXN_SOURCE_TYPE_ID
, CATEGORY_ID
, COST_TYPE_ID
, FROM_ORGANIZATION_ID
, TO_ORGANIZATION_ID
, RCV_TRANSACTION_ID
, SHIPMENT_LINE_ID
, INTRANSIT_INV_ACCOUNT
FROM BOM.CST_INV_QTY_TEMP;
BOM.CST_INV_QTY_TEMP does not reference any database object
BOM.CST_INV_QTY_TEMP is referenced by following:
|
|
|