CST_PERPAVG_QTY_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
TRANSACTION_ID REC_TRXN_ID DEP_TRXN_ID COST_ELEMENT_ID BASE_TXN_TYPE_ID COST_TRANSACTION_TYPE ADDITIONAL_PROCESSING_CODE EFF_DATE COST_ORG_ID COST_BOOK_ID INVENTORY_ITEM_ID VAL_UNIT_ID COST_DATE QUANTITY_ONHAND QUANTITY_NEW QUANTITY_ADJUST UOM_CODE

Query

SQL_Statement

SELECT QTY.TRANSACTION_ID ,QTY.REC_TRXN_ID ,QTY.DEP_TRXN_ID ,SUM(QTY.COST_ELEMENT_ID) AS COST_ELEMENT_ID ,QTY.BASE_TXN_TYPE_ID ,QTY.COST_TRANSACTION_TYPE ,QTY.ADDITIONAL_PROCESSING_CODE ,QTY.EFF_DATE ,QTY.COST_ORG_ID ,QTY.COST_BOOK_ID ,QTY.INVENTORY_ITEM_ID ,QTY.VAL_UNIT_ID ,QTY.COST_DATE ,QTY.QUANTITY_ONHAND ,QTY.QUANTITY_NEW ,QTY.QUANTITY_ADJUST ,QTY.UOM_CODE FROM CST_PERPAVG_COST_GT QTY WHERE QTY.POSTED_FLAG = 'N' GROUP BY QTY.TRANSACTION_ID ,QTY.REC_TRXN_ID ,QTY.DEP_TRXN_ID ,QTY.BASE_TXN_TYPE_ID ,QTY.COST_TRANSACTION_TYPE ,QTY.ADDITIONAL_PROCESSING_CODE ,QTY.EFF_DATE ,QTY.COST_ORG_ID ,QTY.COST_BOOK_ID ,QTY.INVENTORY_ITEM_ID ,QTY.VAL_UNIT_ID ,QTY.COST_DATE ,QTY.QUANTITY_ONHAND ,QTY.QUANTITY_NEW ,QTY.QUANTITY_ADJUST ,QTY.UOM_CODE