WSH_INV_TXN_PRORATED_COSTS_V

Details

• Schema: FUSION

• Object owner: WSH

• Object type: VIEW

Columns

Name
TRANSACTION_ID CURRENCY_CODE TOTAL_PRORATED_AMOUNT

Query

SQL_Statement
SELECT imt.transaction_id, wpfc.currency_code, SUM(wpfc.prorated_amount) total_prorated_amount FROM inv_material_txns imt, wsh_prorated_freight_costs wpfc WHERE imt.picking_line_id = wpfc.delivery_detail_id AND imt.primary_quantity < 0 GROUP BY imt.transaction_id, wpfc.currency_code