CST_RECCOST_TOTAL_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 COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID COST_DATE UNIT_COST CURRENCY_CODE

Query

SQL_Statement
SELECT TRANSACTION_ID ,REC_TRXN_ID ,DEP_TRXN_ID ,COST_ELEMENT_ID ,EXPENSE_POOL_ID ,COST_ORG_ID ,COST_BOOK_ID ,INVENTORY_ITEM_ID ,VAL_UNIT_ID ,COST_DATE ,SUM(UNIT_COST) ,CURRENCY_CODE FROM CST_LAYER_COSTS GROUP BY TRANSACTION_ID ,REC_TRXN_ID ,DEP_TRXN_ID ,COST_ELEMENT_ID ,EXPENSE_POOL_ID ,COST_ORG_ID ,COST_BOOK_ID ,INVENTORY_ITEM_ID ,VAL_UNIT_ID ,COST_DATE ,CURRENCY_CODE