--QUERY1 

SELECT DISTINCT ITEM_CODE,ITEM_NAME,
       ((LCS_STK_QTY_BU + LCS_RCVD_QTY_BU - LCS_ISSD_QTY_BU- LCS_REJECT_QTY_BU)/IU_MAX_LOOSE_1)STORES,      
       SUM((PI_QTY_BU  - NVL(PI_GI_QTY_BU,0))/IU_MAX_LOOSE_1)PENPOQTY,                        
       DECODE(ITEM_MIN_STK_LS,NULL,ITEM_MIN_STK,(ITEM_MIN_STK||'.'||ITEM_MIN_STK_LS))MINSTK,
       DECODE(ITEM_MAX_STK_LS,NULL,ITEM_MAX_STK,(ITEM_MAX_STK||'.'||ITEM_MAX_STK_LS))MAXSTK,
       DECODE(ITEM_RORD_LVL_LS,NULL,ITEM_RORD_LVL,(ITEM_RORD_LVL||'.'||ITEM_RORD_LVL_LS))RORDRLVL,
       DECODE(ITEM_RORD_QTY_LS,NULL,ITEM_RORD_QTY,(ITEM_RORD_QTY||'.'||ITEM_RORD_QTY_LS))RORDQTY 
FROM   OM_ITEM,OM_ITEM_UOM,OS_LOCN_CURR_STK,OT_PO_ITEM,OT_PO_HEAD
WHERE  ITEM_IG_CODE IN('PM','RM')
AND    ITEM_CODE = IU_ITEM_CODE 
AND    ITEM_CODE = LCS_ITEM_CODE(+)
AND    ITEM_CODE = PI_ITEM_CODE(+)  
AND    PI_PH_SYS_ID = PH_SYS_ID(+)
AND    PH_CLO_STATUS IS NULL
AND    LCS_LOCN_CODE IN ('RM','PM')
AND   LCS_COMP_CODE = 'RB'
GROUP BY PI_ITEM_CODE,ITEM_CODE,ITEM_NAME,LCS_STK_QTY_BU,LCS_RCVD_QTY_BU,LCS_ISSD_QTY_BU,IU_MAX_LOOSE_1,ITEM_MIN_STK_LS,ITEM_MIN_STK,ITEM_MAX_STK,
                    ITEM_MAX_STK_LS,ITEM_RORD_LVL_LS,ITEM_RORD_LVL,ITEM_RORD_QTY_LS,ITEM_RORD_QTY,LCS_LOCN_CODE,LCS_REJECT_QTY_BU,LCS_ITEM_CODE
ORDER BY ITEM_CODE


--QUERY2

SELECT DISTINCT PWI_ITEM_CODE,SUM((PWI_QTY_BU - NVL(PWI_PR_QTY_BU,0))/IU_MAX_LOOSE_1)PWOQTY
FROM     OM_ITEM,OM_ITEM_UOM,OT_PWO_ITEM,OT_PWO_STAGE_DETAIL,OT_PWO_HEAD
WHERE  PWI_ITEM_CODE      =   ITEM_CODE 
AND        PWI_ITEM_CODE     =   IU_ITEM_CODE
AND        PWI_PSD_SYS_ID    =   PSD_SYS_ID
AND        PSD_PWH_SYS_ID  =   PWH_SYS_ID
AND        PWH_CLO_STATUS IS NULL
GROUP BY PWI_ITEM_CODE