eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BOM.CST_INV_QTY_TEMP

Object Details

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

Temporary Table Details

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.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

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

Query Text

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;

Dependencies

[top of page]

BOM.CST_INV_QTY_TEMP does not reference any database object

BOM.CST_INV_QTY_TEMP is referenced by following:

APPS: CST_INV_QTY_TEMP