select * from wh_purchases_orders where purchases_order_code='1500118000802PO'
select * from wh_delivery_orders where purchases_order_id='802'
select * from companies where delivery_order_id=640
select * from wh_stock_warehouses where company_id='13'
select w.movement_origin_code,w.product_code,w.quantity,w.created_at,wh.name,t.name from wh_stock_movements w
left join wh_stock_warehouses wh on w.source_warehouse_id=wh.wh_stock_warehouse_id
left join wh_stock_movement_types t on t.wh_stock_movement_type_id = w.stock_movement_type_id where
w.srv_spare_part_id='24083' and w.created_at::date >= '2018-10-24' and w.stock_movement_type_id=2 and w.source_warehouse_id='50' and w.movement_origin_code='1500118000656SPK'
select * from srv_invoices where bill_of_service_id in (
select * from srv_work_order_letters where reference_number='1500118000656SPK')
select * from srv_wol_part_maps where work_order_letter_id='4801'
Query Umum
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.