Shipping
select* from oe_lot_serial_numbers ----select * from ic_lots_mst
select * from mtl_serial_numbers---------
select * from rcv_transactions ---------
select * from gml_recv_trans_map
select * from ic_tran_pnd
select * from ic_loct_inv
select reason_code,reason_desc1 from sy_reas_cds order by 1
select * from MTL_MATERIAL_TRANSACTIONS--