機械翻訳について

CST_DEPQTY_REMAIN_V

詳細

• スキーマ: FUSION

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

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

列

名前
DEP_TRXN_ID COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID COST_DATE ORIG_QUANTITY QUANTITY_DEPLETED QUANTITY_REMAIN

問合せ

SQL_Statement

SELECT CT.TRANSACTION_ID AS DEP_TRXN_ID ,CT.COST_ORG_ID ,CT.COST_BOOK_ID ,CT.INVENTORY_ITEM_ID ,CT.VAL_UNIT_ID ,CT.COST_DATE ,CT.QUANTITY AS ORIG_QUANTITY , NVL(DEP.QUANTITY_DEPLETED,0) AS QUANTITY_DEPLETED , CT.QUANTITY - NVL(DEP.QUANTITY_DEPLETED,0) AS QUANTITY_REMAIN FROM CST_TRANSACTIONS CT LEFT OUTER JOIN CST_DEPQTY_V DEP ON CT.TRANSACTION_ID = DEP.DEP_TRXN_ID WHERE CT.POSTED_FLAG = 'N' AND CT.COST_TRANSACTION_TYPE = 'ISSUE'