Dynamický dotaz - Výroba - Dílenské úkony

ID:

PAXBMEOECPM4PICETMCVGVA5TO

Datasety

MAIN

Popis:

Položky dílenského plánu

SQL definice:

SELECT {FIELDS} 
FROM PLMWorkScheduleItems A
{JOIN}
WHERE
  (A.Id <> 'DUMMY00101') 
{ANDWHERE}  
{ORDERBY}

Aliasy:

Alias	CLSID objektu	Prefix	Popis
A	MJXXIRESMQ04NBM2FHVR13EJ3G		Položka dílenského plánu
JO	HTI3OTLGNRPO32EEISEPC0XZ0K	JO	Výrobní příkazy
JODQ	OFTMKVQH3ZD13ACL03KIU0CLP4	JODQ	Výrobní příkazy řada
JON	INOP4D2NWLNOZABVT2GSHH131G	JON	Výrobní příkazy uzly
JOO	MQHKS5K0YQZOLJWWMG50U44U0S	JOO	Výrobní příkazy výstupy
JOP	CAQPAYUOXVCL3ACL03KIU0CLP4	JOP	Výrobní příkazy období
JOR	HRKADG42X2H4BJ2RL5KUAUG3PK	JOR	Technologický postup výrobního příkazu
P	WEC02QYERNCL35CH000ILPWJF4	P	Osoba
Req	IVJSI1K34CJORFG1QBJOMTSVAG	Req	Požadavky na výrobu
ReqDQ	OFTMKVQH3ZD13ACL03KIU0CLP4	ReqDQ	Požadavky řada
ReqN	BAT0KH5TA0Z4F5CFHKEVXBDOVC	ReqN	Požadavky uzly
ReqO	TX3FY4NELOB4JEFT5YOFC1XACO	ReqO	Požadavky výstupy
ReqP	CAQPAYUOXVCL3ACL03KIU0CLP4	ReqP	Požadavky období
ReqR	RMBJ1K5KJKJOVGZZPKYSUS5N3O	ReqR	Technologický postup požadavku
SC	C3V5QDVZ5BDL342M01C0CX3FCC	SC	Skladová karta
W	53FKKCM5GGGOZ3TF2DJ3E40GSK	W	Pracovník
WP	5XGE0QFOGIWOB5ANMTYRIVKJ0O	WP	Pracoviště

Fields:

Jméno	Typ	Velikost	Výraz	CLSID	Popis
CRPBeginTime	dtDateTime	10	(SELECT MIN(CV2.BeginTime$Date) FROM CRPPlanVariants2 CV2 INNER JOIN CRPPLanVariants CV ON CV2.Parent_ID = CV.ID WHERE CV2.WorkScheduleItem_ID = A.ID AND CV.ISMajor = 'A')		Naplánováno od
CRPEndTime	dtDateTime	10	(SELECT MAX(CV2.EndTime$Date) FROM CRPPlanVariants2 CV2 INNER JOIN CRPPLanVariants CV ON CV2.Parent_ID = CV.ID WHERE CV2.WorkScheduleItem_ID = A.ID AND CV.ISMajor = 'A')		Naplánováno do
PlannedTime	dtFloat	15	CASE WHEN (A.JORoutine_ID > '') THEN CAST((JOR.TAC * JOO.Quantity + JOR.TBC) AS NUMERIC(15,4))*CAST(A.PlannedQuantity/JOO.Quantity AS NUMERIC(15,4)) ELSE CAST((ReqR.TAC * ReqO.Quantity + ReqR.TBC) AS NUMERIC(15,4))*CAST(A.PlannedQuantity/ReqO.Quantity AS NUMERIC(15,4)) END		Plánovaný čas
RealizedTime	dtFloat	15	(CAST(JOR.TAC * JOO.Quantity + JOR.TBC AS NUMERIC(15,4)))*CAST((SELECT SUM(OWSI.Quantity) FROM PLMOperationWSIs OWSI WHERE OWSI.WorkScheduleItem_ID = A.ID)/JOO.Quantity AS NUMERIC(15,4))		Realizovaný čas

Podmínky

ID

Šablona:

ID

Dataset:

MAIN

Speciální parametry:

CLASSID=MJXXIRESMQ04NBM2FHVR13EJ3G

Priority

Popiska:

Pořadí

Typ/Subtyp:

ctDateTime/0

ckRange:

(A.PRIORITY >= {:LOW}) and (A.PRIORITY <= {:HIGH})

Dataset:

MAIN

Worker_ID

Popiska:

Pracovník

Typ/Subtyp:

ctSpecial/0

ckSingle:

A.Worker_ID = {:VALUE}

ckList:

A.Worker_ID IN ({:LIST})

Dataset:

MAIN

Speciální parametry:

CLASSID=PLEIB520C1QO11PWPZVI1XOR0W
TextField=PersonalNumber

WorkPlace_ID

Popiska:

Pracoviště

Typ/Subtyp:

ctSpecial/0

ckSingle:

A.WorkPlace_ID = {:VALUE}

ckList:

A.WorkPlace_ID IN ({:LIST})

Dataset:

MAIN

Speciální parametry:

CLASSID=DLUH2Z5HXIN4LGIZR5BHPE4CY4
TextField=DisplayName

JobOrder_DocQueue_ID

Popiska:

Řada dokladů výrobního příkazu

Typ/Subtyp:

ctSpecial/0

ckSingle:

((JO.DocQueue_ID = {:VALUE}) OR (JO.DocQueue_ID IS NULL))

ckList:

((JO.DocQueue_ID IN ({:LIST})) OR (JO.DocQueue_ID IS NULL))

Dataset:

MAIN

Speciální parametry:

CLASSID=W2XNBCJK3ZD13ACL03KIU0CLP4
TextField=Code
FilterDocumentType=JO

JobOrder_ID

Popiska:

Výrobní příkaz

Typ/Subtyp:

ctSpecial/13

ckSingle:

JO.ID =  {:VALUE}

ckList:

JO.ID IN ({:LIST})

Dataset:

MAIN

Speciální parametry:

CLASSID=HTI3OTLGNRPO32EEISEPC0XZ0K
SITECLASSID=Q4EISOIDDKMOLF12IC3WFS0GDS
DisplayField=ID
DisplayLength=15

ProduceRequest_DocQueue_ID

Popiska:

Řada dokladů požadavků na výrobu

Typ/Subtyp:

ctSpecial/0

ckSingle:

((Req.DocQueue_ID = {:VALUE}) OR (Req.DocQueue_ID IS NULL))

ckList:

((Req.DocQueue_ID IN ({:LIST})) OR (Req.DocQueue_ID IS NULL))

Dataset:

MAIN

Speciální parametry:

CLASSID=W2XNBCJK3ZD13ACL03KIU0CLP4
TextField=Code
FilterDocumentType=PQ

ProduceRequest_ID

Popiska:

Požadavek na výrobu

Typ/Subtyp:

ctSpecial/13

ckSingle:

Req.ID =  {:VALUE}

ckList:

Req.ID IN ({:LIST})

Dataset:

MAIN

Speciální parametry:

CLASSID=IVJSI1K34CJORFG1QBJOMTSVAG
SITECLASSID=ONWLBO0DUPX4B400AJEI4YETD4
DisplayField=ID
DisplayLength=15

StoreCard_ID

Popiska:

Vyráběná položka

Typ/Subtyp:

ctSpecial/0

ckSingle:

(
coalesce(JON.StoreCard_ID,'asdf') = {:VALUE}
OR
coalesce(ReqN.StoreCard_ID,'asdf') = {:VALUE}
)

ckList:

(
coalesce(JON.StoreCard_ID,'asdf') IN ({:LIST})
or 
coalesce(ReqN.StoreCard_ID,'asdf') IN ({:LIST})
)

Dataset:

MAIN

Speciální parametry:

CLASSID=S3WZQKDB5FDL342M01C0CX3FCC
TextField=Code
IsProduct=True

JORoutine_ID

Popiska:

Operace VP

Typ/Subtyp:

ctSpecial/4

ckSingle:

A.JORoutine_ID =  {:VALUE}

ckList:

A.JORoutine_ID IN ({:LIST})

Dataset:

MAIN

Speciální parametry:

Hidden=True
CLASSID=HRKADG42X2H4BJ2RL5KUAUG3PK
DisplayField=ID
DisplayLength=15

ReqRoutine_ID

Popiska:

Operace požadavku

Typ/Subtyp:

ctSpecial/4

ckSingle:

A.ReqRoutine_ID =  {:VALUE}

ckList:

A.ReqRoutine_ID IN ({:LIST})

Dataset:

MAIN

Speciální parametry:

Hidden=True
CLASSID=RMBJ1K5KJKJOVGZZPKYSUS5N3O
DisplayField=ID
DisplayLength=15

Status

Popiska:

Stav

Typ/Subtyp:

ctSpecial/14

ckSingle:

##CASEOR {:VALUE} #
##0#A.Status=0
##1#A.Status=1
##2#A.Status=2
##3#A.Status=3
##4#A.Status=4
##5#A.Status=5
##END#

Dataset:

MAIN

Speciální parametry:

FirstValue=0
Names=Plánovaný;Potvrzený;V procesu;Odložený;Dokončený;Stornovaný
Values=0;1;2;3;4;5

DateFrom

Popiska:

Datum

Typ/Subtyp:

ctDateTime/0

ckRange:

A.DateFrom$DATE >= {:LOW} and A.DateFrom$DATE < {:HIGH}

Dataset:

MAIN

Speciální parametry:

IncludeTime=True

Progress

Popiska:

Rozpracovanost

Typ/Subtyp:

ctSpecial/14

ckSingle:

##CASEOR {:VALUE} #
##1#not exists (Select ID From PLMOperationWSIs O Where O.WorkScheduleItem_ID = A.ID)
##2#(Select Sum(Quantity) From PLMOperationWSIs O Where O.WorkScheduleItem_ID = A.ID) < PlannedQuantity
##3#(Select Sum(Quantity) From PLMOperationWSIs O Where O.WorkScheduleItem_ID = A.ID) = PlannedQuantity
##4#(Select Sum(Quantity) From PLMOperationWSIs O Where O.WorkScheduleItem_ID = A.ID) > PlannedQuantity
##END#

Dataset:

MAIN

Speciální parametry:

Names=Nerozpracováno;Rozpracováno;Zpracováno;Přepracováno
Values=1;2;3;4

ConfirmedBy_ID

Popiska:

Potvrdil

Typ/Subtyp:

ctSpecial/0

ckSingle:

A.ConfirmedBy_ID = {:VALUE}

ckList:

A.ConfirmedBy_ID IN ({:LIST})

Dataset:

MAIN

Speciální parametry:

CLASSID=G1W2A2CBNNDL3DZ403KIU0CLP4
TextField=LoginName

DocumentType

Popiska:

Typ dokladu

Typ/Subtyp:

ctSpecial/14

ckSingle:

##CASEOR {:VALUE} #
##1#(A.JORoutine_ID IS NULL) AND Req.DocQueue_ID IS NOT NULL
##2#(A.JORoutine_ID IS NOT NULL) AND JO.DocQueue_ID IS NOT NULL
##END#

Dataset:

MAIN

Speciální parametry:

Names=Požadavek na výrobu;Výrobní příkaz
Values=1;2

PlanedStartAt

Popiska:

Plánovaný termín spuštění

Typ/Subtyp:

ctDateTime/0

ckRange:

((A.JORoutine_ID IS NULL) AND Req.PlanedStartAt$Date >= {:LOW} and Req.PlanedStartAt$Date < {:HIGH}) 
OR 
((A.JORoutine_ID IS NOT NULL) AND JO.PlanedStartAt$Date >= {:LOW} and JO.PlanedStartAt$Date < {:HIGH})

Dataset:

MAIN

ScheduledAt$Date

Popiska:

Plánovaný termín ukončení

Typ/Subtyp:

ctDateTime/0

ckRange:

((A.JORoutine_ID IS NULL) AND Req.Schedule$Date >= {:LOW} and Req.Schedule$Date < {:HIGH})
OR
((A.JORoutine_ID IS NOT NULL) AND JO.ScheduledAt$Date >= {:LOW} and JO.ScheduledAt$Date < {:HIGH})

Dataset:

MAIN

PriorityDoc

Popiska:

Priorita dokladu

Typ/Subtyp:

ctSpecial/14

ckSingle:

##CASEOR {:VALUE} #
##1#((A.JORoutine_ID IS NULL) AND (Req.Priority = 0)) OR ((A.JORoutine_ID IS NOT NULL) AND (JO.Priority = 0)) 
##2#((A.JORoutine_ID IS NULL) AND (Req.Priority = 1)) OR ((A.JORoutine_ID IS NOT NULL) AND (JO.Priority = 1)) 
##3#((A.JORoutine_ID IS NULL) AND (Req.Priority = 2)) OR ((A.JORoutine_ID IS NOT NULL) AND (JO.Priority = 2)) 
##4#((A.JORoutine_ID IS NULL) AND (Req.Priority = 3)) OR ((A.JORoutine_ID IS NOT NULL) AND (JO.Priority = 3)) 
##END#

Dataset:

MAIN

Speciální parametry:

Names=Nízká;Běžná;Vysoká;Neodkladná;
Values=1;2;3;4

PLMOperationsExists

Popiska:

Existují pracovní lístky

Typ/Subtyp:

ctBoolean/0

ckSingle:

(
(({:VALUE} = 'N') AND (0 = (SELECT COUNT(*) FROM PLMOperationWSIs WHERE WorkScheduleItem_ID = A.ID)))  
OR
(({:VALUE} = 'A') AND (0 <> (SELECT COUNT(*) FROM PLMOperationWSIs WHERE WorkScheduleItem_ID = A.ID)))  
)

Dataset:

MAIN

Title

Popiska:

Název operace

Typ/Subtyp:

ctString/0

ckSingle:

((A.JORoutine_ID IS NULL) AND <<ReqR.Title>> LIKE {:VALUE} ESCAPE '~') 
OR 
((A.JORoutine_ID IS NOT NULL) AND <<JOR.Title>> LIKE {:VALUE} ESCAPE '~')

Dataset:

MAIN

Speciální parametry:

ConvertWildChars=True
IgnoreCase=True

Finished

Popiska:

Dokončující operace

Typ/Subtyp:

ctBoolean/0

ckSingle:

((A.JORoutine_ID IS NULL) AND ReqR.Finished = {:VALUE}) 
OR 
((A.JORoutine_ID IS NOT NULL) AND JOR.Finished = {:VALUE})

Dataset:

MAIN

DocumentFirm_ID

Popiska:

Firma

Typ/Subtyp:

ctSpecial/0

ckSingle:

((A.JORoutine_ID IS NULL) AND Req.Firm_ID = {:VALUE}) 
OR 
((A.JORoutine_ID IS NOT NULL) AND JO.Firm_ID = {:VALUE})

ckList:

((A.JORoutine_ID IS NULL) AND Req.Firm_ID IN ({:LIST})) 
OR 
((A.JORoutine_ID IS NOT NULL) AND JO.Firm_ID IN ({:LIST}))

Dataset:

MAIN

Speciální parametry:

CLASSID=O3OWQQYWYJCL3J0B01K0LEIOE0
TextField=Code

DocumentDivision_ID

Popiska:

Středisko

Typ/Subtyp:

ctSpecial/8

ckSingle:

(
  (A.JORoutine_ID IS NULL) 
  AND 
  (
  (Req.Division_ID = (select Bx.ID from Divisions Bx where Bx.ID = {:VALUE} and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (Req.Division_ID in
      (select Bx.ID from Divisions Bx where
        Bx.ID in (select B2x.ID from SYS$Divisions2 B2x where B2x.Superior_ID = {:VALUE}) and
        Bx.Hidden = 'N')))
  )
)
OR 
(
  (A.JORoutine_ID IS NOT NULL) 
  AND
  (
  (JO.Division_ID = (select Bx.ID from Divisions Bx where Bx.ID = {:VALUE} and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (JO.Division_ID in
      (select Bx.ID from Divisions Bx where
        Bx.ID in (select B2x.ID from SYS$Divisions2 B2x where B2x.Superior_ID = {:VALUE}) and
        Bx.Hidden = 'N')))
  )
)

				

ckList:

(
  (A.JORoutine_ID IS NULL) 
  AND 
  (
  (Req.Division_ID in (select Bx.ID from Divisions Bx where Bx.ID in ({:LIST}) and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (Req.Division_ID in
      (select Bx.ID from Divisions Bx where
        Bx.ID in (select B2x.ID from SYS$Divisions2 B2x where B2x.Superior_ID in ({:LIST})) and
        Bx.Hidden = 'N')))
  )
)
OR 
(
  (A.JORoutine_ID IS NOT NULL) 
  AND
  (
  (JO.Division_ID in (select Bx.ID from Divisions Bx where Bx.ID in ({:LIST}) and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (JO.Division_ID in
      (select Bx.ID from Divisions Bx where
        Bx.ID in (select B2x.ID from SYS$Divisions2 B2x where B2x.Superior_ID in ({:LIST})) and
        Bx.Hidden = 'N')))
  )
)

				

Dataset:

MAIN

Speciální parametry:

CLASSID=OA5JMX4J2FD135CH000ILPWJF4
TextField=Code

DocumentBusOrder_ID

Popiska:

Zakázka

Typ/Subtyp:

ctSpecial/8

ckSingle:

(
  (A.JORoutine_ID IS NULL) 
  AND 
  (
  (Req.BusOrder_ID = (select Bx.ID from BusOrders Bx where Bx.ID = {:VALUE} and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (Req.BusOrder_ID in
      (select Bx.ID from BusOrders Bx where
        Bx.ID in (select B2x.ID from SYS$BusOrders2 B2x where B2x.Superior_ID = {:VALUE}) and
        Bx.Hidden = 'N')))
  )
)
OR 
(
  (A.JORoutine_ID IS NOT NULL) 
  AND
  (
  (JO.BusOrder_ID = (select Bx.ID from BusOrders Bx where Bx.ID = {:VALUE} and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (JO.BusOrder_ID in
      (select Bx.ID from BusOrders Bx where
        Bx.ID in (select B2x.ID from SYS$BusOrders2 B2x where B2x.Superior_ID = {:VALUE}) and
        Bx.Hidden = 'N')))
  )
)

				

ckList:

(
  (A.JORoutine_ID IS NULL) 
  AND 
  (
  (Req.BusOrder_ID in (select Bx.ID from BusOrders Bx where Bx.ID in ({:LIST}) and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (Req.BusOrder_ID in
      (select Bx.ID from BusOrders Bx where
        Bx.ID in (select B2x.ID from SYS$BusOrders2 B2x where B2x.Superior_ID in ({:LIST})) and
        Bx.Hidden = 'N')))
  )
)
OR 
(
  (A.JORoutine_ID IS NOT NULL) 
  AND
  (
  (JO.BusOrder_ID in (select Bx.ID from BusOrders Bx where Bx.ID in ({:LIST}) and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (JO.BusOrder_ID in
      (select Bx.ID from BusOrders Bx where
        Bx.ID in (select B2x.ID from SYS$BusOrders2 B2x where B2x.Superior_ID in ({:LIST})) and
        Bx.Hidden = 'N')))
  )
)

				

Dataset:

MAIN

Speciální parametry:

CLASSID=03OXHKRF4VD13ACL03KIU0CLP4
TextField=Code

DocumentBusTransaction_ID

Popiska:

Obchodní případ

Typ/Subtyp:

ctSpecial/8

ckSingle:

(
  (A.JORoutine_ID IS NULL) 
  AND 
  (
  (Req.BusTransaction_ID = (select Bx.ID from BusTransactions Bx where Bx.ID = {:VALUE} and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (Req.BusTransaction_ID in
      (select Bx.ID from BusTransactions Bx where
        Bx.ID in (select B2x.ID from SYS$BusTransactions2 B2x where B2x.Superior_ID = {:VALUE}) and
        Bx.Hidden = 'N')))
  )
)
OR 
(
  (A.JORoutine_ID IS NOT NULL) 
  AND
  (
  (JO.BusTransaction_ID = (select Bx.ID from BusTransactions Bx where Bx.ID = {:VALUE} and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (JO.BusTransaction_ID in
      (select Bx.ID from BusTransactions Bx where
        Bx.ID in (select B2x.ID from SYS$BusTransactions2 B2x where B2x.Superior_ID = {:VALUE}) and
        Bx.Hidden = 'N')))
  )
)

ckList:

(
  (A.JORoutine_ID IS NULL) 
  AND 
  (
  (Req.BusTransaction_ID in (select Bx.ID from BusTransactions Bx where Bx.ID in ({:LIST}) and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (Req.BusTransaction_ID in
      (select Bx.ID from BusTransactions Bx where
        Bx.ID in (select B2x.ID from SYS$BusTransactions2 B2x where B2x.Superior_ID in ({:LIST})) and
        Bx.Hidden = 'N')))
  )
)
OR 
(
  (A.JORoutine_ID IS NOT NULL) 
  AND
  (
  (JO.BusTransaction_ID in (select Bx.ID from BusTransactions Bx where Bx.ID in ({:LIST}) and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (JO.BusTransaction_ID in
      (select Bx.ID from BusTransactions Bx where
        Bx.ID in (select B2x.ID from SYS$BusTransactions2 B2x where B2x.Superior_ID in ({:LIST})) and
        Bx.Hidden = 'N')))
  )
)

Dataset:

MAIN

Speciální parametry:

CLASSID=0BOXHKRF4VD13ACL03KIU0CLP4
TextField=Code

DocumentBusProject_ID

Popiska:

Projekt

Typ/Subtyp:

ctSpecial/8

ckSingle:

(
  (A.JORoutine_ID IS NULL) 
  AND 
  (
  (Req.BusProject_ID = (select Bx.ID from BusProjects Bx where Bx.ID = {:VALUE} and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (Req.BusProject_ID in
      (select Bx.ID from BusProjects Bx where
        Bx.ID in (select B2x.ID from SYS$BusProjects2 B2x where B2x.Superior_ID = {:VALUE}) and
        Bx.Hidden = 'N')))
  )
)
OR 
(
  (A.JORoutine_ID IS NOT NULL) 
  AND
  (
  (JO.BusProject_ID = (select Bx.ID from BusProjects Bx where Bx.ID = {:VALUE} and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (JO.BusProject_ID in
      (select Bx.ID from BusProjects Bx where
        Bx.ID in (select B2x.ID from SYS$BusProjects2 B2x where B2x.Superior_ID = {:VALUE}) and
        Bx.Hidden = 'N')))
  )
)

ckList:

(
  (A.JORoutine_ID IS NULL) 
  AND 
  (
  (Req.BusProject_ID in (select Bx.ID from BusProjects Bx where Bx.ID in ({:LIST}) and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (Req.BusProject_ID in
      (select Bx.ID from BusProjects Bx where
        Bx.ID in (select B2x.ID from SYS$BusProjects2 B2x where B2x.Superior_ID in ({:LIST})) and
        Bx.Hidden = 'N')))
  )
)
OR 
(
  (A.JORoutine_ID IS NOT NULL) 
  AND
  (
  (JO.BusProject_ID in (select Bx.ID from BusProjects Bx where Bx.ID in ({:LIST}) and Bx.Hidden = 'N'))
  or
  ({WithChildren} = 1 AND
    (JO.BusProject_ID in
      (select Bx.ID from BusProjects Bx where
        Bx.ID in (select B2x.ID from SYS$BusProjects2 B2x where B2x.Superior_ID in ({:LIST})) and
        Bx.Hidden = 'N')))
  )
)

Dataset:

MAIN

Speciální parametry:

CLASSID=ZX20VMNR1NV4N30K2MRDAXLRN4
TextField=Code

FixedDateTo

Popiska:

Konec fixace do

Typ/Subtyp:

ctDateTime/0

ckRange:

A.ID IN (
  SELECT 
    Parent_ID 
  FROM 
    PLMWorkScheduleItemFixes 
  GROUP BY 
    Parent_ID 
  HAVING   
    (MAX(EndTime) >= {:LOW}) and (MAX(EndTime) < {:HIGH}) 
)

Dataset:

MAIN

Speciální parametry:

IncludeTime=True
Hidden=True

InCRP

Popiska:

V kapacitním plánu

Typ/Subtyp:

ctBoolean/0

ckSingle:

(
(({:VALUE} = 'N') AND 
  NOT(A.ID IN (SELECT CV2.WorkScheduleItem_ID
     FROM CRPPlanVariants2 CV2
     INNER JOIN CRPPLanVariants CV ON CV2.Parent_ID = CV.ID
   WHERE CV.ISMajor = 'A')
  )
  )  
OR
(({:VALUE} = 'A') AND 
   (A.ID IN (SELECT CV2.WorkScheduleItem_ID
     FROM CRPPlanVariants2 CV2
     INNER JOIN CRPPLanVariants CV ON CV2.Parent_ID = CV.ID
   WHERE CV.ISMajor = 'A')
  )
   )  
)

Dataset:

MAIN

inCRPAt

Popiska:

Naplánováno v období

Typ/Subtyp:

ctDateTime/0

ckRange:

  (A.ID IN (SELECT CV2.WorkScheduleItem_ID
     FROM CRPPlanVariants2 CV2
     INNER JOIN CRPPLanVariants CV ON CV2.Parent_ID = CV.ID
   WHERE CV.ISMajor = 'A' 
     AND CV2.EndTime$Date > {:LOW} 
     AND CV2.BeginTime$Date <= {:HIGH} 
   )
  )

Dataset:

MAIN

Speciální parametry:

MultiSetupOnly=True
IncludeTime=True

ExcludePhantom

Popiska:

Schovat úkony na duplicitní práci

Typ/Subtyp:

ctBoolean/0

ckSingle:

(
(({:VALUE} = 'A') AND 
NOT (
  A.ReqRoutine_ID > ''
  AND
  (A.JORoutine_ID IS NULL)
  AND
  EXISTS
    (SELECT ID
       FROM PLMWorkScheduleItems
       WHERE (RequestWSI_ID = A.ID) AND
         (ID <> RequestWSI_ID) AND
         (JORoutine_id > '') AND
         (ReqRoutine_ID IS NULL))
)
  )  
OR
({:VALUE} = 'N')
)

Dataset:

MAIN

Speciální parametry:

AlwaysUsed=True

Klíče

Priority

Popiska:

Pořadí

SQL:

A.Priority

Dataset:

MAIN

DateFrom

Popiska:

Datum

SQL:

A.DateFrom$Date

Dataset:

MAIN

DocumentDisplayName

Popiska:

Název/dokl.

SQL:

JODQ.Code Collate PXW_CSY {DIR}, 

JOP.Code Collate PXW_CSY {DIR},

JO.OrdNumber {DIR},

ReqDQ.Code Collate PXW_CSY {DIR}, 

ReqP.Code Collate PXW_CSY {DIR},

Req.OrdNumber {DIR},

A.Priority

Dataset:

MAIN

PlannedQuantity

Popiska:

Plánované množství

SQL:

A.PlannedQuantity {DIR}, A.Priority

Dataset:

MAIN

StoreCard_ID.Name

Popiska:

Skaldová karta

SQL:

SC.Name {DIR}, A.Priority

Dataset:

MAIN

RoutinePosition

Popiska:

Pořadí operace

SQL:

JOR.PosIndex {DIR}, ReqR.PosIndex {DIR}, A.Priority

Dataset:

MAIN

RoutineTitle

Popiska:

Název operace

SQL:

JOR.Title {DIR}, ReqR.Title {DIR}, A.Priority

Dataset:

MAIN

Status

Popiska:

Status

SQL:

A.Status

Dataset:

MAIN

DocumentPlannedAt

Popiska:

Plánované spuštění

SQL:

JO.PlanedstartAt$Date {DIR}, Req.PlanedStartAt$Date {DIR}, A.Priority

Dataset:

MAIN

DocumentScheduledAt

Popiska:

Plánované dokončení

SQL:

JO.ScheduledAt$Date {DIR}, Req.Schedule$Date {DIR}, A.Priority

Dataset:

MAIN

WorkPlace_ID.DisplayName

Popiska:

Pracoviště

SQL:

WP.Code Collate PXW_CSY {DIR}, WP.Name Collate PXW_CSY {DIR}, A.WorkPlace_ID

Dataset:

MAIN

Worker_ID.DisplayName

Popiska:

Pracovník

SQL:

TRIM(LEADING FROM P.LastName) Collate PXW_CSY {DIR}, 

P.FirstName Collate PXW_CSY {DIR}, P.Title Collate PXW_CSY {DIR}, W.ID

Dataset:

MAIN

DocumentPriorityText

Popiska:

Priorita/dokl.

SQL:

CASE WHEN A.JORoutine_ID > ' ' THEN JO.Priority ELSE Req.Priority END

Dataset:

MAIN

CRPBeginTime

Popiska:

Naplánováno od

SQL:

%CRPBeginTime%

Dataset:

MAIN

CRPEndTime

Popiska:

Naplánováno do

SQL:

%CRPEndTime%

Dataset:

MAIN

Generated by ABRA Software a.s. 27.10.2021 16:36