Hi Shanthi,
Okay please try the following query.
1. Run the following script against the company database:
Select PICKNUMBER from MOP1210 where MANUFACTUREORDER_I = 'XXXX'
and MANUFACTUREORDER_I in (select MANUFACTUREORDER_I from MOP1400
where MANUFACTUREORDER_I in (select MANUFACTUREORDER_I where PENDING_REV_ISS_QTY_I > 0 or PENDING_ISSUE_QTY_I > 0 or PENDING_SCRAP_QTY_I > 0 or PENDING_REV_SCRAP_QTY_I > 0))
and TRX_TYPE in (1,2,5,6) and PICKNUMBER in (select PICKNUMBER from MOP1200 where POSTED = 0)
Note In this script, you must replace the XXXX placeholder with the manufacturing order number.
Results that the script in step 2 returns indicate that an un-posted picking document exists. To post the picking document or remove the items from the picking document, follow these steps:
a. On the Transactions menu, point to Manufacturing, point to Manufacturing Orders, and then click Component Trx Entry.
b. In the Manufacture Pick Number list, click the pick document number from step 2.
c. Follow one of these steps:
 If you want to post the items, click Mark All, and then click Post.
 If you do not want to post the items, click to select the check box next to each item number, click Edit, and then click Delete Row.
Note If all items are removed from the pick document, you do not have to post the pick document.
Try this first and let me know.