FND Design Data [Home] [Help]

View: CST_STD_COST_ADJ_TMP1_V

Product: BOM - Bills of Material
Description:
Implementation/DBA Data: ViewAPPS.CST_STD_COST_ADJ_TMP1_V
View Text

SELECT ROWID ROWIDTODEL
, TRANSACTION_ID
, COST_ELEMENT_ID
, LEVEL_TYPE
, OLD_UNIT_COST UNIT_COST
, NEW_UNIT_COST
, COST_UPDATE_ID
FROM CST_STD_COST_ADJ_VALUES V1
WHERE 0 IN (V1.NEW_UNIT_COST
, V1.OLD_UNIT_COST)
AND V1.TRANSACTION_TYPE = 5
AND ROWNUM > 0

Columns

Name
ROWIDTODEL
TRANSACTION_ID
COST_ELEMENT_ID
LEVEL_TYPE
UNIT_COST
NEW_UNIT_COST
COST_UPDATE_ID