[Home] [Help]
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
Name |
SESSION_ID |
WIP_ENTITY_ID |
LINE_ID |
ORGANIZATION_ID |
COST_ELEMENT |
TL_VALUE_IN |
TL_VALUE_OUT |
PL_VALUE_IN |
PL_VALUE_OUT |
VALUE_IN |
VALUE_OUT |
VAR |
NET_ACTIVITY |
ACCOUNT_ID |