We have an out of box relationship POLINE_NOHIST between ITEM and POLINE Objects. This relationship is used to display POs in the Purchasing tab of "View Item Availability" section in Inventory application.
By this option, we can view POs that are waiting for receiving the items.
In future, if POs of single Org and different sites have same PONUM. One with status of CLOSED and other with WAPPR. There is a risk of Maximo picking CLOSED POs of other site in the Purchasing tab.
This problem occurred in Maximo 6 environment of my project.
Current where clause in MX 7.5
-------------------------------------------------------------------------------------
itemnum = :itemnum and exists (select 1 from po where po.ponum=poline.ponum and po.revisionnum=poline.revisionnum and po.historyflag = :no) and itemsetid = :itemsetid
-------------------------------------------------------------------------------------
Can be changed to
--------------------------------------------------------------------------------------
itemnum = :itemnum and exists (select 1 from po where po.ponum=poline.ponum and po.revisionnum=poline.revisionnum and po.historyflag = :no and po.orgid = poline.orgid and po.siteid = poline.siteid) and itemsetid = :itemsetid
---------------------------------------------------------------------------------------
By this option, we can view POs that are waiting for receiving the items.
In future, if POs of single Org and different sites have same PONUM. One with status of CLOSED and other with WAPPR. There is a risk of Maximo picking CLOSED POs of other site in the Purchasing tab.
This problem occurred in Maximo 6 environment of my project.
Current where clause in MX 7.5
-------------------------------------------------------------------------------------
itemnum = :itemnum and exists (select 1 from po where po.ponum=poline.ponum and po.revisionnum=poline.revisionnum and po.historyflag = :no) and itemsetid = :itemsetid
-------------------------------------------------------------------------------------
Can be changed to
--------------------------------------------------------------------------------------
itemnum = :itemnum and exists (select 1 from po where po.ponum=poline.ponum and po.revisionnum=poline.revisionnum and po.historyflag = :no and po.orgid = poline.orgid and po.siteid = poline.siteid) and itemsetid = :itemsetid
---------------------------------------------------------------------------------------
No comments:
Post a Comment