DBA Data[Home] [Help]

VIEW: APPS.CST_STD_COST_ADJ_TMP2_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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