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

VIEW: APPS.CST_PERIOD_CG_SUMMARY_V

Object Details
Object Name: CST_PERIOD_CG_SUMMARY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_PERIOD_CG_SUMMARY_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Prior to 11.5.10 (Patchset J), period end summarization for PJM or WMS enabled organizations was stored by cost group in MTL_PERIOD_CG_SUMMARY. In 11.5.10, the period end summarization process populates CST_PERIOD_CLOSE_SUMMARY with item level information.
This view combines the old data with a grouping of the new data by cost group to provide uniform backward compatible access of the summary information.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCT_PERIOD_ID NUMBER

Accounting period identifier
ORGANIZATION_ID NUMBER

Organization identifier
COST_GROUP_ID NUMBER

Cost group identifier
COST_GROUP VARCHAR2 (10)
Cost group
DESCRIPTION VARCHAR2 (240)
Cost group description
INVENTORY_VALUE NUMBER

Period end value used as baseline for next period summary.
Query Text

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


SELECT ACCT_PERIOD_ID
,      ORGANIZATION_ID
,      COST_GROUP_ID
,      COST_GROUP
,      DESCRIPTION
,      INVENTORY_VALUE
FROM APPS.CST_PERIOD_CG_SUMMARY_V;

Dependencies

[top of page]

APPS.CST_PERIOD_CG_SUMMARY_V references the following:

SchemaAPPS
SynonymCST_COST_GROUPS
SynonymCST_PERIOD_CLOSE_SUMMARY
SynonymMTL_PERIOD_CG_SUMMARY

APPS.CST_PERIOD_CG_SUMMARY_V is not referenced by any database object