Objektová akce

Kód:

3

Tělo:

SELECT  v.ProduceDocument_ID,
        v.ProduceDocumentBasedJO,
        v.ProduceDocumentDisplayName,
        v.pdplannedstartat$date,
        v.pdscheduledstartat$date,
        v.pdreleasedstartat$date,
        v.pdpriority,
        v.pdstorecard_id,
        v.pdstorecarddisplayname,
        v.pdquantity,
        v.pdqunit,
        v.PDBusOrder_ID,
        v.Req_ID,
        v.WorkScheduleItem_ID,
        v.wsiversion,
        v.WorkScheduleItemDisplayName,
        v.WorkPlace_ID,
        v.wsiroutinetitle,
        v.wsistorecard_id,
        v.wsistorecarddisplayname,
        v.wsipriority,
        v.wsistatus,
        v.WSIPlannedQuantity,
        v.WSIOngoing,
        v.WSIAdvanceQuantity,
        v.WSIQuantum,
        v.WSIRealizedQuantity,
        v.RoutineQuantity,
        v.Routine_ID ,
        v.WSIRequestWSI_ID,
        v.WSISuspend,
        v.calcdate$date,
        v.CalcMethod_ID,
        v.BeginTime$date,
        v.EndTime$date,
        v.Machine_ID,
        v.PowerRate,
        v.Quantity,
        v.Capacity,     
        v.ItemID,
        v.ItemType
FROM CRPPlanVariants2 v
WHERE (v.Parent_ID = :OBJID)
ORDER BY v.WorkPlace_ID, v.Machine_ID, v.ItemID 

Generated by ABRA Software a.s. 27.10.2021 16:35:42