機械翻訳について

CST_DEPQTY_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: CST

• オブジェクト・タイプ: VIEW

列

名前
DEP_TRXN_ID COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID COST_DATE QUANTITY_DEPLETED

問合せ

SQL_Statement
SELECT CTL.DEP_TRXN_ID ,CTL.COST_ORG_ID ,CTL.COST_BOOK_ID ,CTL.INVENTORY_ITEM_ID ,CTL.VAL_UNIT_ID ,MAX(CTL.COST_DATE) AS COST_DATE ,SUM (CTL.QUANTITY) AS QUANTITY_DEPLETED FROM CST_TRANSACTION_LAYERS CTL WHERE CTL.DEP_TRXN_ID >0 GROUP BY CTL.DEP_TRXN_ID ,CTL.COST_ORG_ID ,CTL.COST_BOOK_ID ,CTL.INVENTORY_ITEM_ID ,CTL.VAL_UNIT_ID