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

VIEW: APPS.CST_PER_CLOSE_DTLS_V

Object Details
Object Name: CST_PER_CLOSE_DTLS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_PER_CLOSE_DTLS_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 actual costing organizations were stored by item in MTL_PER_CLOSE_DTLS. In 11.5.10, the period end summarization process populates CST_PERIOD_CLOSE_SUMMARY with item level information.
This view combines the old and new data 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
SECONDARY_INVENTORY VARCHAR2 (10)
Subinventory identifier
INVENTORY_ITEM_ID NUMBER

Item identifier
PERIOD_END_QUANTITY NUMBER

Quantity at period end
PERIOD_END_UNIT_COST NUMBER

Unit cost at period end
Query Text

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


SELECT ACCT_PERIOD_ID
,      ORGANIZATION_ID
,      COST_GROUP_ID
,      SECONDARY_INVENTORY
,      INVENTORY_ITEM_ID
,      PERIOD_END_QUANTITY
,      PERIOD_END_UNIT_COST
FROM APPS.CST_PER_CLOSE_DTLS_V;

Dependencies

[top of page]

APPS.CST_PER_CLOSE_DTLS_V references the following:

SchemaAPPS
SynonymCST_PERIOD_CLOSE_SUMMARY
SynonymMTL_PER_CLOSE_DTLS
APPS.CST_PER_CLOSE_DTLS_V is referenced by following:

SchemaAPPS
Package BodyINV_TURNS - show dependent code