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_PERIOD_CLOSE_SUMMARY

Object Details

Object Name:	CST_PERIOD_CLOSE_SUMMARY
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.CST_PERIOD_CLOSE_SUMMARY
Subobject Name:
Status:	VALID

This table stores the result of the period close summarization process enhancement introduced in 11.5.10 (Patchset J). Previously, periods were summarized into MTL_PERIOD_SUMMARY or MTL_PERIOD_CG_SUMMARY. The old and new tables are consolidated under the views MTL_PERIOD_SUMMARY_V and MTL_PERIOD_CG_SUMMARY_V.
In this table, summarization results are stored at the item, cost group and subinventory level for each accounting period and organization combination. The two main results of the summarization are:
1) ACCOUNTED_VALUE - The sum of accounting distributions for the relevant period
2) ROLLBACK_VALUE - The product of the rolled back onhand quantity and cost.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	60
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_PERIOD_CLOSE_SUMMARY_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ACCT_PERIOD_ID COST_GROUP_ID INVENTORY_ITEM_ID
CST_PERIOD_CLOSE_SUMMARY_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ACCT_PERIOD_ID SUBINVENTORY_CODE INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACCT_PERIOD_ID	NUMBER	(15)	Yes	Accounting period identifier
ORGANIZATION_ID	NUMBER	(15)	Yes	Organization identifier
COST_GROUP_ID	NUMBER	(15)		Cost group identifier
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory identifier
INVENTORY_ITEM_ID	NUMBER	(15)	Yes	Item identifier
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
CREATION_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
REQUEST_ID	NUMBER	(15)		Concurrent WHO column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent WHO column
PROGRAM_ID	NUMBER	(15)		Concurrent WHO column
PROGRAM_UPDATE_DATE	DATE			Concurrent WHO column
ACCOUNTED_VALUE	NUMBER		Yes	The period close value calculated from accounting distributions
ROLLBACK_VALUE	NUMBER		Yes	The period close value calculated by rolling back transaction quantity and cost
ROLLBACK_QUANTITY	NUMBER		Yes	The period close 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
ACCOUNTED_ONHAND_VALUE	NUMBER			Onhand portion of the accounted value
ACCOUNTED_INTRANSIT_VALUE	NUMBER			Intransit portion of the accounted value
ONHAND_VALUE_DISCREPANCY	NUMBER			Difference between the rollback onhand value and the accounted onhand value
INTRANSIT_VALUE_DISCREPANCY	NUMBER			Difference between the rollback intransit value and the accounted intransit value
CUMULATIVE_ONHAND_MTA	NUMBER			Onhand portion of the cumulative accounting distributions
CUMULATIVE_INTRANSIT_MTA	NUMBER			Intransit portion of the cumulative accounting distributions

Query Text

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


SELECT ACCT_PERIOD_ID
,      ORGANIZATION_ID
,      COST_GROUP_ID
,      SUBINVENTORY_CODE
,      INVENTORY_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATION_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ACCOUNTED_VALUE
,      ROLLBACK_VALUE
,      ROLLBACK_QUANTITY
,      ROLLBACK_ONHAND_VALUE
,      ROLLBACK_INTRANSIT_VALUE
,      ACCOUNTED_ONHAND_VALUE
,      ACCOUNTED_INTRANSIT_VALUE
,      ONHAND_VALUE_DISCREPANCY
,      INTRANSIT_VALUE_DISCREPANCY
,      CUMULATIVE_ONHAND_MTA
,      CUMULATIVE_INTRANSIT_MTA
FROM BOM.CST_PERIOD_CLOSE_SUMMARY;

Dependencies

[top of page]

BOM.CST_PERIOD_CLOSE_SUMMARY does not reference any database object

BOM.CST_PERIOD_CLOSE_SUMMARY is referenced by following:

APPS: CST_PERIOD_CLOSE_SUMMARY