CST_PERPAVG_COST_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
REC_TRXN_ID EFF_DATE AVG_COST_TOTAL CURRENCY_CODE

Query

SQL_Statement
SELECT CST.REC_TRXN_ID ,CST.EFF_DATE ,SUM(CST.UNIT_COST_AVERAGE) AS AVG_COST_TOTAL ,CST.CURRENCY_CODE FROM CST_PERPAVG_COST CST GROUP BY CST.REC_TRXN_ID ,CST.EFF_DATE , CST.CURRENCY_CODE