[Home] [Help]
View: CST_STD_COST_ADJ_TMP2_V
View Text
SELECT ROWID ROWIDTODEL
, TRANSACTION_ID
, COST_ELEMENT_ID
, LEVEL_TYPE
, OLD_UNIT_COST
, NEW_UNIT_COST UNIT_COST
, COST_UPDATE_ID
FROM CST_STD_COST_ADJ_VALUES V2
WHERE 0 IN (V2.NEW_UNIT_COST
, V2.OLD_UNIT_COST)
AND V2.TRANSACTION_TYPE = 5
AND ROWNUM > 0
Columns
| Name |
| ROWIDTODEL |
| TRANSACTION_ID |
| COST_ELEMENT_ID |
| LEVEL_TYPE |
| OLD_UNIT_COST |
| UNIT_COST |
| COST_UPDATE_ID |