SELECT 
PH_NO,
PH_DT,
PH_SUPP_CODE,
SUPP_NAME,
PI_ITEM_CODE,
ITEM_NAME,
PI_QTY_BU/1000 PO_QTY,
PI_GI_QTY_BU/1000 GRN_QTY,
PI_QTY_BU/1000 - PI_GI_QTY_BU/1000 PNDG_QTY, 
PID_DEL_DT,
PID_DEL_QTY,
PID_EXP_AVAIL_DT
FROM OT_PO_HEAD, OT_PO_ITEM,OT_PO_ITEM_DEL,OM_SUPPLIER,OM_ITEM
WHERE PI_PH_SYS_ID = PH_SYS_ID 
AND PID_PI_SYS_ID = PI_SYS_ID
AND SUPP_CODE = PH_SUPP_CODE
AND ITEM_CODE = PI_ITEM_CODE
AND PI_ITEM_CODE LIKE ?
AND PH_SUPP_CODE LIKE ?
AND PI_QTY_BU/1000 > PI_GI_QTY_BU/1000
AND NVL(PH_CLO_STATUS,0) = 0
AND PI_SHORT_CLO_STATUS = 2
ORDER BY PH_DT