Oracle Apps R12. OPM Query to Find out Quantity of Products and Ingredients of all Batches in particular Month.

Select b.RECIPE_DESCRIPTION,a.RECIPE_VALIDITY_RULE_ID,c.INVENTORY_ITEM_ID,d.description,
decode(c.line_type,-1,'Ingredient','Product') "Type", sum(e.TRANSACTION_QUANTITY) "quantity"
from
GME_BATCH_HEADER a,
gmd_recipes b,
gmd_recipe_validity_rules grr,
gme_material_details c,
mtl_system_items d,
mtl_material_transactions e,
org_organization_definitions f
where a.FORMULA_ID = b.FORMULA_ID
and b.RECIPE_ID = grr.RECIPE_ID
and grr.ITEM_ID = c.ITEM_ID
and c.INVENTORY_ITEM_ID = d.INVENTORY_ITEM_ID
and d.INVENTORY_ITEM_ID = e.INVENTORY_ITEM_ID
and e.ORGANIZATION_ID = f.ORGANIZATION_ID
and f.ORGANIZATION_CODE = 'A01'
group by b.RECIPE_DESCRIPTION,a.RECIPE_VALIDITY_RULE_ID,c.INVENTORY_ITEM_ID,d.description,c.line_type,e.TRANSACTION_QUANTITY;

-------------------------

select ai.BATCH_NO,bi.RECIPE_DESCRIPTION,ci.STD_QTY,di.MATERIAL_DETAIL_ID,ei.DESCRIPTION,fi.TRANSACTION_QUANTITY,gi.ORGANIZATION_CODE,
decode(di.LINE_TYPE, -1,'Ingredient',1,'Product') "Type", sum(fi.TRANSACTION_QUANTITY)"quantity"
from gme_batch_header ai, gmd_recipes bi, gmd_recipe_validity_rules ci, gme_material_details di,mtl_system_items ei,
mtl_material_transactions fi,org_organization_definitions gi
where ai.FORMULA_ID = bi.FORMULA_ID
and bi.RECIPE_ID = ci.RECIPE_ID
and ci.ITEM_ID = di.ITEM_ID
and di.ORGANIZATION_ID = ei.ORGANIZATION_ID
and ei.INVENTORY_ITEM_ID = fi.INVENTORY_ITEM_ID
and fi.ORGANIZATION_ID = gi.ORGANIZATION_ID
and gi.ORGANIZATION_CODE = 'A01'
group by ai.BATCH_NO,bi.RECIPE_DESCRIPTION,ci.STD_QTY,di.MATERIAL_DETAIL_ID,ei.DESCRIPTION,fi.TRANSACTION_QUANTITY,gi.ORGANIZATION_CODE,
di.LINE_TYPE,fi.TRANSACTION_QUANTITY;

--and di.INVENTORY_ITEM_ID = ei.INVENTORY_ITEM_ID
--and ei.ORGANIZATION_ID = fi.ORGANIZATION_ID