123

SELECT SUBSTR(wh_nr,1,10) AS "Склад",
f2.firm_nr AS "№ Постачальника",
f2.name AS "Назва постачальника",
fi.firm_nr AS "№ Заявителя",
fi.name AS "Заявитель",
COUNT (DISTINCT lu.loadunit_nr) AS "К-ть палет",
lu.status_quality AS "Статус якості",
pc.name AS "Отдел",
ROUND ((sysdate-lu.c_date),0) AS "Днів зберігання",
TRUNC(lu.c_date) AS "Дата создания",
ROUND (SUM (lu.volume),4) AS "Обьем",
SUM (lu.weight) AS "Вес"
FROM load_units_fast lu, qguaradm.storageareas sa, qguaradm.storageplaces sp, sp_classes sc, qguaradm.deliveries de,
sp_zones sz, qguaradm.qcm_warehouses wh, qguaradm.qcm_firms fi, qguaradm.lu_contents_fast lc, qguaradm.qcm_products pr,
qguaradm.qcm_prod_classes pc, qguaradm.qcm_firms f2
WHERE lu.sp_id=sp.sp_id
AND sa.sa_id=sp.sa_id
AND lu.status ^='--'
AND sp.sp_class_id=sc.sp_class_id
AND sa.wh_id = wh.wh_id
AND pr.prod_class_id=pc.prod_class_id
AND lc.status ^='--'
AND owner_id NOT IN (0,1)
AND lu.owner_id=fi.firm_id
AND lu.loadunit_id=lc.loadunit_id
AND lc.product_id=pr.product_id
AND pr.prod_class_id=pc.prod_class_id
AND de.supplier_id=f2.firm_id
AND sp.sp_zone_id=sz.sp_zone_id
AND sa.sa_nr NOT LIKE '%LOST%'
AND lc.delivery_id=de.delivery_id
GROUP BY SUBSTR(wh_nr,1,10), f2.firm_nr, f2.name, fi.firm_nr, fi.name, lu.status_quality, TRUNC(lu.c_date),pc.name, ROUND ((sysdate-lu.c_date),0)