CST_PERPAVG_COST2_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
TRANSACTION_ID REC_TRXN_ID DEP_TRXN_ID COST_ELEMENT_ID EXPENSE_POOL_ID EFF_DATE COST_DATE COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID UNIT_COST_ONHAND UNIT_COST_NEW UNIT_COST_ADJUST CURRENCY_CODE

Query

SQL_Statement

SELECT CST.TRANSACTION_ID ,CST.REC_TRXN_ID ,CST.DEP_TRXN_ID ,CST.COST_ELEMENT_ID ,CST.EXPENSE_POOL_ID ,CST.EFF_DATE ,CST.COST_DATE ,CST.COST_ORG_ID ,CST.COST_BOOK_ID ,CST.INVENTORY_ITEM_ID ,CST.VAL_UNIT_ID ,SUM(CST.UNIT_COST_ONHAND) UNIT_COST_ONHAND ,SUM(CST.UNIT_COST_NEW) UNIT_COST_NEW ,SUM(CST.UNIT_COST_ADJUST) UNIT_COST_ADJUST ,CST.CURRENCY_CODE FROM CST_PERPAVG_COST2_GT CST GROUP BY CST.TRANSACTION_ID ,CST.REC_TRXN_ID ,CST.DEP_TRXN_ID ,CST.COST_ELEMENT_ID ,CST.EXPENSE_POOL_ID ,CST.EFF_DATE ,CST.COST_DATE ,CST.COST_ORG_ID ,CST.COST_BOOK_ID ,CST.INVENTORY_ITEM_ID ,CST.VAL_UNIT_ID ,CST.CURRENCY_CODE