Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
select IN_.HAZMAT_ID, OR_.SO_BR_ID||OR_.SO_ID, OR_.CUST_NAME, OR_.STATUS, OR_.CARRIER_ROUTE,OR_1.PART_ID, OR_1.QTY_ORDERED, OR_.PICK_BATCH_ID from CSI.IN_INFORMATION IN_, CSI.OR_HEADER OR_, CSI.OR_LINE OR_1 where OR_1.PART_ID = IN_.PART_ID and OR_.SO_BR_ID = OR_1.SO_BR_ID and OR_.SO_ID = OR_1.SO_ID and (IN_.HAZMAT_ID IN ('LIA311', 'LIA511')) and (OR_.STATUS = 'R') and (OR_.CARRIER_ROUTE in ('F1', 'F2', 'FO', 'FS', 'UO', 'UB', 'US', 'U3', 'CL', 'PG'))
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.