View: CST_PERIOD_VALUE_V

Product:	BOM - Bills of Material
Description:	Used by the View WIP Value form to generate temporary information : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_PERIOD_VALUE_V

View Text

SELECT CPV.SESSION_ID
, CPV.WIP_ENTITY_ID
, CPV.LINE_ID
, CPV.ORGANIZATION_ID
, CCE.COST_ELEMENT
, CPV.TL_VALUE_IN
, CPV.TL_VALUE_OUT
, CPV.PL_VALUE_IN
, CPV.PL_VALUE_OUT
, CPV.VALUE_IN
, CPV.VALUE_OUT
, CPV.VAR
, CPV.NET_ACTIVITY
, CPV.VALUATION_ACCOUNT
FROM CST_PERIOD_VALUE_TEMP CPV
, CST_COST_ELEMENTS CCE
WHERE CPV.COST_ELEMENT_ID = CCE.COST_ELEMENT_ID /*ADDED ORDER BY CLAUSE FOR BUG 6679982 */ ORDER BY CPV.ORGANIZATION_ID
, CPV.WIP_ENTITY_ID
, CCE.COST_ELEMENT_ID

Columns