Item Reserved till now and on-hand quantity allocated but no record found from Batch
select *
FROM apps.mtl_reservations a, apps.gme_batch_header b, apps.mtl_parameters c, apps.gme_material_details d
WHERE --demand_source_type_id=5 AND supply_source_type_id=13
a.demand_source_header_id=b.batch_id
AND a.organization_id=c.organization_id
AND a.organization_id=b.organization_id
AND b.batch_id=d.batch_id
AND a.demand_source_line_id=d.material_detail_id
--and b.ORGANIZATION_ID=204
and a.INVENTORY_ITEM_ID=69106
select *
FROM apps.mtl_reservations a, apps.gme_batch_header b, apps.mtl_parameters c, apps.gme_material_details d
WHERE --demand_source_type_id=5 AND supply_source_type_id=13
a.demand_source_header_id=b.batch_id
AND a.organization_id=c.organization_id
AND a.organization_id=b.organization_id
AND b.batch_id=d.batch_id
AND a.demand_source_line_id=d.material_detail_id
--and b.ORGANIZATION_ID=204
and a.INVENTORY_ITEM_ID=69106
No comments:
Post a Comment