Oracle Fusion - Inventory Item Receiving Quantity SQL Query

  --SQL Query--

SELECT sum(QUANTITY) RECEIVING_INV_ITEM_QTY

FROM INV_SUPPLY_V 

WHERE

supply_type_code = 'RECEIVING'

AND req_line_id IS NULL

AND item_id IS NOT NULL

AND ITEM_ID=300000010379046 

AND to_organization_id =300000002993023 

Oracle Fusion - Inventory Item Inbound Quantity SQL Query

 --SQL Query--

SELECT sum(QUANTITY) INBOUND_INV_ITEM_QTY

FROM INV_SUPPLY_V 

WHERE

supply_type_code <> 'RECEIVING'

AND req_line_id IS NULL

AND item_id IS NOT NULL

AND ITEM_ID=300000010379046 

AND to_organization_id =300000002993023