Returns debugging:

select * from RMA where RMA_ID=11502;
select * from RMAITEM where RMAITEM_ID=11502;
select * from RMAIDNYRSN where RMAITEM_ID=11502;
select * from RTNDNYDESC where RTNDNYRSN_ID=-3 and LANGUAGE_ID=-1;
select * from RTNDNYRSN;

Orders that are eligible for Release:

SELECT DISTINCT ORDERS.ORDERS_ID FROM  ORDERITEMS, ORDERS WHERE ORDERS.STOREENT_ID=10151
AND ORDERS.ORDERS_ID = ORDERITEMS.ORDERS_ID  AND ORDERS.STATUS IN ('C', 'M', 'B', 'L')  AND 
( ORDERS.SHIPASCOMPLETE = 'Y' AND NOT EXISTS (SELECT ORDERITEMS_ID FROM ORDERITEMS WHERE ORDERS_ID = ORDERS.ORDERS_ID AND ( INVENTORYSTATUS NOT IN('ALLC','FUL')  )))
AND NOT EXISTS (SELECT ORDERITEMS_ID FROM ORDERITEMS WHERE ORDERS_ID = ORDERS.ORDERS_ID AND (  ORDERITEMS.ADDRESS_ID IS NULL ));