17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT PARENT.containername,
customer.customername,
customer.description,
FRESH.customerlotnumber,
PARENT.qty,
PARENT.targetdevice,
con.containername as SubLot,
con.qty as SubQty,
con.customerlotnumber as SubCustLot,
con.datecode as SubDateCode,
tap.qtyperreel,
FRESH.containername as FreshLot,
product.customerspecificinfo2 as COO,
con.customerorder,
con.custmotherwo,
pac.packagetypename,
smd.shipmentdestinationname,
dim.dimensionname,
lea.leadcountname,
pac.packagetypename || '-' || dim.dimensionname || '-' ||
lea.leadcountname as PDL
FROM insitedev.container con,
insitedev.container PARENT,
insitedev.customer customer,
insitedev.container FRESH,
insitedev.product product,
insitedev.tapenreelclass tap,
insitedev.packagetype pac,
insitedev.shipmentdestination smd,
insitedev.dimension dim,
insitedev.leadcount lea
WHERE ((con.parentcontainerid = PARENT.containerid) AND
(PARENT.customerid = customer.customerid) AND
(PARENT.freshlotid = FRESH.containerid) AND
(PARENT.productid = product.productid) AND
(product.tapenreelclassid = tap.tapenreelid) AND
(product.packagetypeid = pac.packagetypeid) and
(product.dimensionid = dim.dimensionid) AND
(product.leadcountid = lea.leadcountid) and
(fresh.shipmentdestinationid = smd.shipmentdestinationid) AND
(PARENT.ContainerName like
'TR7130017'))
ORDER BY con.qty ASC