205: ROMAV.SOLDTOCONTACTPHONE ,
206: ROMAV.SOLDTOCONTACTEMAIL
207: FROM RCV_OPSM_LINE_V ROLV,
208: RCV_OPSM_MANUFACT_ADDRESS_V ROMAV,
209: RCV_OPSM_CUSTOMERADDRESS_V ROCAV,
210: MTL_PARAMETERS MP
211: WHERE ROLV.SHIPMENT_HEADER_ID=p_shipmentheaderid
212: AND ROLV.GROUP_ID=p_groupid
213: AND ROLV.SHIPMENT_HEADER_ID=ROMAV.SHIPMENT_HEADER_ID