select * from oe_order_headers_all where order_number='1399679' select line_id,flow_status_code,open_flag from oe_order_lines_all where HEADER_ID='1917514' select RELEASED_STATUS from WSH_DELIVERY_DETAILS where SOURCE_LINE_ID='7068610' select * from wsh_new_deliveries where DELIVERY_ID=1726467 select * from wsh_delivery_assignments where DELIVERY_DETAIL_ID in(select DELIVERY_DETAIL_ID from WSH_DELIVERY_DETAILS where SOURCE_LINE_ID='7068610') select * from MTL_MATERIAL_TRANSACTIONS where TRX_SOURCE_LINE_ID='7068610' --Workflow Background Process inserts the records select *from ra_interface_lines_all where interface_line_attribute1='1399679' select *from ra_customer_trx_all where interface_header_attribute1='1399679' select *from ra_customer_trx_lines_all where customer_trx_id=1485353 select * from regal.regal_om_edi850_header_tab where tprt_number='6111350004' --where PURCHASE_ORDER_NUM= SELECT trx_number, trx_date FROM ra_customer_trx_all WHERE interface_header_attribute1 ='1399673' AND interface_header_attribute3 ='1726464' select * from ar_customers where CUSTOMER_NUMBER like 'SRC%' select a.order_number ORDER#, c.requested_quantity "Requested QTY", e.concatenated_segments "Ordered Item", c.net_weight, d.delivery_id Delivery#, f.CONTAINER_NAME "LPN Name" from oe_order_headers_all a, oe_order_lines_all b, wsh_delivery_details c, wsh_delivery_assignments d, mtl_system_items_kfv e, wsh_delivery_details f where 1 = 1 AND a.header_id = b.header_id AND b.line_id = c.source_line_id AND c.delivery_detail_id = d.delivery_detail_id AND b.inventory_item_id = e.inventory_item_id AND c.inventory_item_id = e.inventory_item_id AND d.parent_delivery_detail_id =f.DELIVERY_DETAIL_ID AND e.organization_id = 81 AND c.source_header_number = '1399679' --AND f.CONTAINER_NAME IN('00006782980157314993') order by f.CONTAINER_NAME desc