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

RCV API

  DECLARE   ln_user_id      NUMBER;   ln_po_header_id NUMBER := 3319024; --1713998;   ln_vendor_id    NUMBER;   lv_segment1     VARCHAR2(20)...