Oracle EBs Apps Blog of Mahfuz, OPM and OBIEE Consultant

Sunday, 20 November 2016

Errors: OPM

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

No comments:

Post a Comment

Isolated  Item delete form system: -SET DEFINE OFF; Insert into BOM_DELETE_ENTITIES    (DELETE_ENTITY_SEQUENCE_ID, DELETE_GROUP_SEQUENCE_ID,...