[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 60 |
PCT Used: |
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 |
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 |
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;
BOM.CST_PERIOD_CLOSE_SUMMARY does not reference any database object
BOM.CST_PERIOD_CLOSE_SUMMARY is referenced by following:
|
|
|