Objektová akce

Popis:

Vrátí přidružené položky dílenského plánu

Kód:

41

Tělo:

select ws.id, ws.objversion, JON.STORECARD_ID, SC.NAME 
from PLMWorkScheduleItems ws
    INNER JOIN PLMJobOrdersRoutines JOR ON (JOR.id = ws.JORoutine_id)
    INNER JOIN PLMJOOutputItems JOO ON (JOR.parent_id = JOO.ID)
    INNER JOIN PLMJONodes JON ON (JOO.owner_id = JON.ID)
    INNER JOIN PLMJobOrders JO ON (JON.parent_id = JO.ID)
    INNER JOIN PLMJOSetParsQueues JOQ ON (JO.docqueue_id = JOQ.docqueue_id)
    INNER JOIN PLMWorkPlaces WP ON (ws.Workplace_id = WP.ID)
    INNER JOIN STORECARDS SC ON (JON.STORECARD_ID = SC.ID)
where JO.ID = :OBJID
  and ws.status in (0,1,2)
  and (ws.PlannedQuantity > (SELECT COALESCE(sum(Quantity),0) from PLMOperationWSIs WHERE WorkScheduleItem_id = ws.ID))
  and WP.CRPpLAN > 0
  and JOR.Planned = 'A'
  and JOQ.InPlan = 'A'
  and ((JOR.TAC > 0 and JOO.Quantity > 0) OR JOR.TBC > 0)

Generated by ABRA Software a.s. 27.10.2021 16:34:49