CST_RECCOST_TOTAL_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CST
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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 |
問合せ
| 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 |