mtl_material_transactions

mtl_material_transactions

select ood.ORGANIZATION_NAME,msb.DESCRIPTION,
rc.CUSTOMER_NAME,mmt.SHIPMENT_NUMBER,mmt.TRANSACTION_QUANTITY,mmt.TRANSACTION_ID,
mmt.ACTUAL_COST,
oel.ordered_item,oel.UNIT_COST,oel.INVENTORY_ITEM_ID,
oel.line_id
 from wsh_delivery_details wdd,
 oe_order_headers_all oeh,
 oe_order_lines_all oel,
 mtl_system_items_b msb,
 org_organization_definitions ood,
 ra_customers rc,
 mtl_material_transactions mmt
 where oeh.ORDER_number=wdd.SOURCE_HEADER_number
 and oeh.HEADER_ID=oel.HEADER_ID
 and ood.ORGANIZATION_ID=msb.ORGANIZATION_ID
 and msb.INVENTORY_ITEM_ID=oel.INVENTORY_ITEM_ID
 and rc.CUSTOMER_ID=oeh.SOLD_TO_ORG_ID
 and wdd.SOURCE_LINE_ID=oel.LINE_ID
 and oel.ORG_ID=msb.ORGANIZATION_ID
 --and oel.LINE_ID=wdd.SOURCE_LINE_ID
 and wdd.transaction_id=mmt.TRANSACTION_ID
 --and msb.ORGANIZATION_ID=mmt.ORGANIZATION_ID
   --and wdd.transaction_id='11147296'
  and ood.ORGANIZATION_ID=204
  and rc.CUSTOMER_NAME='A. C. Networks'
-- and mmt.SHIPMENT_NUMBER is not null
   --and oel.line_id=222353