SELECT {FIELDS}
FROM PLMJOInputItems A
JOIN PLMJONodes N ON N.ID = A.Owner_ID
JOIN PLMJONodes NMI ON NMI.ID = N.Master_ID
JOIN PLMJobOrders JO on JO.ID = NMI.Parent_ID
JOIN ProductionTasks PT on PT.ID = JO.Productiontask_ID
JOIN StoreCards JOSC ON JOSC.ID = JO.StoreCard_ID
{JOIN}
WHERE N.Issue = 0 AND JO.Releasedat$date > 0 AND JO.Finishedat$date = 0
{ANDWHERE}
{ORDERBY}
| Alias | CLSID objektu | Prefix | Popis |
|---|---|---|---|
| A | URVJ2ULRJ4B43EK1QLU3A2OXR0 | VP - kusovník | |
| BO | K2WTYL304VD13ACL03KIU0CLP4 | BusOrder | Zakázka |
| BP | QOKMKIQUJF34L3DUICTBWEDQJC | BusProject | Projekt |
| BT | KAWTYL304VD13ACL03KIU0CLP4 | BusTrans | Obchodní případ |
| D | O1X54EUXPZCL35CH000ILPWJF4 | Division | Středisko |
| DQ | OFTMKVQH3ZD13ACL03KIU0CLP4 | DQ | Řada dokladů |
| F | 4K3EXM5PQBCL35CH000ILPWJF4 | Firm | Firma |
| JO | HTI3OTLGNRPO32EEISEPC0XZ0K | JO | Výrobní příkaz |
| JOSC | C3V5QDVZ5BDL342M01C0CX3FCC | JOSC | Skladová karta výrobního příkazu |
| MI | MQHKS5K0YQZOLJWWMG50U44U0S | MI | Vyráběná položka |
| MISC | C3V5QDVZ5BDL342M01C0CX3FCC | MISC | Skladová karta vyráběné položky |
| N | INOP4D2NWLNOZABVT2GSHH131G | N | Uzel výrobního stromu |
| NMI | INOP4D2NWLNOZABVT2GSHH131G | NMI | Uzel výrobního stromu |
| P | CAQPAYUOXVCL3ACL03KIU0CLP4 | Period | Období |
| Ph | CWZXHJPRJFDOFBQI04IH1H4TZK | Phase | Etapa |
| PT | BJTSLF2T32F4HA2RDDJX0QAZLC | PT | Výrobní úloha |
| S | SFMSB5W15BDL3CL100C4RHECN0 | Store | Předpokládaný sklad pro výdej |
| SC | C3V5QDVZ5BDL342M01C0CX3FCC | SC | Skladová karta kusovníku |
##CASEOR {:VALUE} #
##1#(JO.ReleasedAt$DATE = 0)
##2#(JO.ReleasedAt$DATE <> 0 AND JO.FinishedAt$DATE = 0)
##3#(JO.ReleasedAt$DATE <> 0 AND PT.Quantity >= JO.Quantity AND JO.FinishedAt$DATE = 0)
##4#(JO.FinishedAt$DATE <> 0)
##5#(JO.ReleasedAt$DATE <> 0 AND PT.Quantity < JO.Quantity AND JO.FinishedAt$DATE = 0)
##6#(JO.ReleasedAt$DATE <> 0 AND PT.Quantity > 0 AND PT.Quantity < JO.Quantity AND JO.FinishedAt$DATE = 0)
##END#
JO.ID = {:VALUE}
JO.ID IN ({:LIST})
<<JOSC.Code>> LIKE {:VALUE} ESCAPE '~'
JO.StoreCard_ID = {:VALUE}
JO.StoreCard_ID IN ({:LIST})
JO.DocDate$DATE >= {:LOW} and
JO.DocDate$DATE < {:HIGH}
JO.ReleasedAt$DATE >= {:LOW} and
JO.ReleasedAt$DATE < {:HIGH}
JO.ScheduledAt$DATE >= {:LOW} and
JO.ScheduledAt$DATE < {:HIGH}
JO.FinishedAt$DATE >= {:LOW} and
JO.FinishedAt$DATE < {:HIGH}
<<MISC.Code>> LIKE {:VALUE} ESCAPE '~'
MISC.ID = {:VALUE}
MISC.ID IN ({:LIST})
N.PosIndex BETWEEN {:LOW} and {:HIGH}
<<SC.Code>> LIKE {:VALUE} ESCAPE '~'
N.StoreCard_ID = {:VALUE}
N.StoreCard_ID IN ({:LIST})
A.ID in
(select pl.id
from PLMJONodes N
join PLMJOInputItems Pl ON PL.Owner_ID = N.ID
JOIN PLMJONodes NMI ON NMI.ID = N.Master_ID
join PLMJOOutputItems mi on mi.Owner_ID = NMI.ID
left join Plmmiplmaterialdistrib md on md.Parent_id = pl.id
left join Storedocuments2 sd2 on sd2.id = md.Storedocument2_id
left join Plmmiplrmaterialdistrib mrd on mrd.Parent_id = pl.id
left join Storedocuments2 sdr2 on sdr2.id = mrd.Storedocument2_id
group by pl.id, pl.Quantity, mi.Quantity, pl.Wastepercentage
having
##CASEOR {:VALUE} #
##1#
(CAST((coalesce(sum(sd2.Quantity),0) - coalesce(sum(sdr2.Quantity),0)) as Numeric(18,3))= 0)
##2#
(
CAST((coalesce(sum(sd2.Quantity),0) - coalesce(sum(sdr2.Quantity),0)) as Numeric(18,3)) > 0 and
CAST((coalesce(sum(sd2.Quantity),0) - coalesce(sum(sdr2.Quantity),0)) as Numeric(18,3)) < CAST((CAST(pl.Quantity as double precision) * CAST(mi.Quantity as double precision) * (1 + (CAST(PL.WastePercentage as double precision)/100))) as Numeric(18,3))
)
##3#
(CAST((coalesce(sum(sd2.Quantity),0) - coalesce(sum(sdr2.Quantity),0)) as Numeric(18,3)) = CAST((CAST(pl.Quantity as double precision) * CAST(mi.Quantity as double precision) * (1 + (CAST(PL.WastePercentage as double precision)/100))) as Numeric(18,3)))
##4#
(CAST((coalesce(sum(sd2.Quantity),0) - coalesce(sum(sdr2.Quantity),0)) as Numeric(18,3)) > CAST((CAST(pl.Quantity as double precision) * CAST(mi.Quantity as double precision) * (1 + (CAST(PL.WastePercentage as double precision)/100))) as Numeric(18,3)))
##END#
)
A.SupposedStore_ID = {:VALUE}
A.SupposedStore_ID IN ({:LIST})
DQ.Code Collate PXW_CSY {DIR},
P.Code Collate PXW_CSY {DIR},
JO.OrdNumberJOSC.Code Collate PXW_CSY {DIR}, JO.StoreCard_IDJOSC.Name Collate PXW_CSY {DIR}, JO.StoreCard_IDD.Code Collate PXW_CSY {DIR}, JO.Division_IDJO.ScheduledAt$DATE
BO.Code Collate PXW_CSY {DIR}, JO.BusOrder_IDBT.Code Collate PXW_CSY {DIR}, JO.BusTransaction_IDBP.Code Collate PXW_CSY {DIR}, JO.BusProject_IDMISC.Code Collate PXW_CSY {DIR}, MISC.IDMISC.Name Collate PXW_CSY {DIR}, MISC.IDN.PosIndex
SC.Code Collate PXW_CSY {DIR}, SC.IDSC.Name Collate PXW_CSY {DIR}, SC.IDS.Code Collate PXW_CSY {DIR}, A.SupposedStore_IDph.Code Collate PXW_CSY {DIR}, A.Phase_IDGenerated by ABRA Software a.s. 27.10.2021 16:36