< N I   1 > 
 
 < P P   2 1 0   2 9 7   2   1 0   2   1 0 > 
 
 
 
 < P I   " e Q C " > 
 
 < D M   " Y Y Y Y - M M - D D " > 
 
 < H M   " H H : M M : S S " > 
 
 < D S   " . " > 
 
 < T S   " " > 
 
 
 
 < B R   2 > 
 
 
 
 < F N   " T a h o m a " > 
 
 < F S   1 6 > 
 
 < F C   0 0 0 0 0 0 0 0 0 > 
 
 < B D   1 > 
 
 < U N   0 > 
 
 < I T   0 > 
 
 < S T   0 > 
 
 < C T   C   0   2   2 0 6 > R A P O R T   N I E Z G O D N O ZC I < / C T > 
 
 < B R   7 > 
 
 < B R   6 > 
 
 < C T   L   1 0   - 1   2 5 > A v o n I D : < / C T > 
 
 < C A   0   0   N   L   3 8   - 1   5 6   - 1 > 
 
 < C T   L   1 4 7   - 1   3 0 > K o n t r o l e r : < / C T > 
 
 < C A   0   1   N   L   1 8 0   - 1   2 0   - 1 > 
 
 < B R   7 > 
 
 < B R   3 > 
 
 
 
 < F C   0 0 0 0 0 0 0 0 0 > 
 
 < L N   5   - 1   2 0 0   0   0 > 
 
 < B R   1 > 
 
 < B R   1 0 > 
 
 
 
 < F S   1 4 > 
 
 < F C   0 0 0 0 0 0 0 0 0 > 
 
 < C T   L   1 0   - 1   1 8 > F S C < / C T > 
 
 < C T   L   3 5   - 1   3 2 > P r o d u k t < / C T > 
 
 < C T   R   1 1 8   - 1   2 1 > P r z y n i e [< / C T > 
 
 < C T   R   1 4 5   - 1   1 8 > O d n i e [< / C T > 
 
 < C T   R   1 6 7   - 1   1 6 > S t a c j a < / C T > 
 
 < C T   R   1 8 5   - 1   1 3 > B I N < / C T > 
 
 < B R   6 > 
 
 < B R   5 > 
 
 < S Q   1   7 > " s e l e c t   a v o n i d ,   f s c ,   o p i s ,   s t a c j a ,   b i n ,   
 
 c a s e   w h e n   i l o s c - i l o s c f a k t y c z n a > 0   t h e n   i l o s c - i l o s c f a k t y c z n a   e l s e   N U L L   e n d   a s   p r z y n i e s ,   
 
 c a s e   w h e n   i l o s c f a k t y c z n a - i l o s c > 0   t h e n   i l o s c f a k t y c z n a - i l o s c   e l s e   N U L L   e n d   a s   w y n i e s 
 
 f r o m   z a m o w i e n i a 
 
 w h e r e   z a m o w i e n i a . t o t e   =   ' "  1 0 1 +  1 0 1 V A R ( 1 )  1 0 1 +  1 0 1 " '   A N D   z a m o w i e n i a . a v o n i d   =   ' "  1 0 1 +  1 0 1 V A R ( 0 )  1 0 1 +  1 0 1 " '   A N D   i l o s c < > i l o s c f a k t y c z n a   A N D   s t a t u s k o n t r o l i = ' K Z '   A N D   ( s t a t u s s h o r t a = ' O K '   o r   s t a t u s s h o r t a   I S   N U L L )   o r d e r   b y   s t a c j a ,   b i n " < / S Q > 
 
 
 
 < L P   1   0 > 
 
 	 < B R   4 > 
 
 
 
 	 < F N   " T a h o m a " > 
 
 	 < F S   1 0 > 
 
 	 < F C   0 0 0 0 0 0 0 0 0 > 
 
 	 < B D   0 > 
 
 	 < U N   0 > 
 
 	 < I T   0 > 
 
 	 < S T   0 > 
 
 	 < C A   1   1   N   L   1 0   - 1   1 9   - 1 > 
 
 	 < C A   1   2   N   L   3 5   - 1   8 0   - 1 > 
 
 	 < C A   1   5   N   R   1 1 8   - 1   2 1   - 1 > 
 
 	 < C A   1   6   N   R   1 4 5   - 1   1 8   - 1 > 
 
 	 < C A   1   3   N   R   1 6 7   - 1   1 6   - 1 > 
 
 	 < C A   1   4   N   R   1 8 5   - 1   1 3   - 1 > 
 
 	 < B R   4 > 
 
 < / L P > 
 
 
 
 < B R   1 4 > 
 
 
 
 < F N   " T a h o m a " > 
 
 < F S   1 4 > 
 
 < F C   2 3 7 0 0 5 0 2 9 > 
 
 < B D   1 > 
 
 < U N   0 > 
 
 < I T   0 > 
 
 < S T   0 > 
 
 < C T   L   1 0   - 1   1 1 3 > B AD N E   P R O D U K T Y : < / C T > 
 
 < B R   6 > 
 
 < B R   5 > 
 
 < S Q   2   7 > " s e l e c t   a v o n i d ,   b . f s c ,   o p i s ,   c a s e   w h e n   s t a c j a = ' - - - - '   t h e n   ( s e l e c t   t o p   1   s t a c j a   f r o m   p r o d u k t y   w h e r e   f s c = b . f s c   o r d e r   b y   k a m p a n i a   d e s c ,   s t a c j a ,   b i n )   e l s e   s t a c j a   e n d   a s   s t a c j a ,   c a s e   w h e n   b i n = ' - - - - '   t h e n   ( s e l e c t   t o p   1   b i n   f r o m   p r o d u k t y   w h e r e   f s c = b . f s c   o r d e r   b y   k a m p a n i a   d e s c ,   s t a c j a ,   b i n )   e l s e   b i n   e n d   a s   b i n ,   N U L L ,   i l o s c   f r o m   b l e d y   a s   b   w h e r e   t o t e   =   ' "  1 0 1 +  1 0 1 V A R ( 1 )  1 0 1 +  1 0 1 " '   A N D   a v o n i d   =   ' "  1 0 1 +  1 0 1 V A R ( 0 )  1 0 1 +  1 0 1 " '   A N D   b l a d = 5   o r d e r   b y   s t a c j a ,   b i n " < / S Q > 
 
 
 
 < L P   2   0 > 
 
 	 < B R   4 > 
 
 
 
 	 < F N   " T a h o m a " > 
 
 	 < F S   1 0 > 
 
 	 < F C   0 0 0 0 0 0 0 0 0 > 
 
 	 < B D   0 > 
 
 	 < U N   0 > 
 
 	 < I T   0 > 
 
 	 < S T   0 > 
 
 	 < C A   2   1   N   L   1 0   - 1   1 9   - 1 > 
 
 	 < C A   2   2   N   L   3 5   - 1   8 0   - 1 > 
 
 	 < C A   2   5   N   R   1 1 8   - 1   2 3   - 1 > 
 
 	 < C A   2   6   N   R   1 4 3   - 1   2 0   - 1 > 
 
 	 < C A   2   3   N   R   1 6 7   - 1   1 6   - 1 > 
 
 	 < C A   2   4   N   R   1 8 5   - 1   1 3   - 1 > 
 
 	 < B R   4 > 
 
 < / L P > 
 
 
 
 < B R   1 9 > 
 
 
 
 < F N   " T a h o m a " > 
 
 < F S   1 4 > 
 
 < F C   0 0 0 0 0 0 0 0 0 > 
 
 < B D   1 > 
 
 < U N   0 > 
 
 < I T   0 > 
 
 < S T   0 > 
 
 < C T   L   1 0   - 1   1 1 3 > B AD Y   O P E R A T O R  W : < / C T > 
 
 < B R   6 > 
 
 < B R   5 > 
 
 < C T   L   1 0   - 1   2 5 > O p e r a t o r < / C T > 
 
 < C T   L   4 0   - 1   3 0 > L i n i a s t a c j a < / C T > 
 
 < C T   L   7 5   - 1   1 5 > B i n < / C T > 
 
 < C T   R   9 5   - 1   1 5 > I l o [< / C T > 
 
 < C T   R   1 1 6   - 1   1 5 > B Bd < / C T > 
 
 < C T   L   1 5 0   - 1   5 0 > G d z i e   j e s t   o p e r a t o r < / C T > 
 
 < B R   6 > 
 
 < B R   5 > 
 
 < S Q   3   7 > " S E L E C T   b l e d y . k t o ,   b l e d y . l i n i a s t a c j a ,   b l e d y . b i n ,   b l e d y . i l o s c ,   b l e d y . b l a d ,   ( s e l e c t   c a s e   w h e n   ( s e l e c t   t o p   1   d a t a c z a s z e j s c i a   f r o m   h i s t o r i a o p e r a t o r a   w h e r e   o p e r a t o r = b l e d y . k t o   A N D   t o t e   =   ' "  1 0 1 +  1 0 1 V A R ( 1 )  1 0 1 +  1 0 1 " '   A N D   a v o n i d   =   ' "  1 0 1 +  1 0 1 V A R ( 0 )  1 0 1 +  1 0 1 " '   o r d e r   b y   d a t a c z a s w e j s c i a   d e s c )   I S   N O T   N U L L   t h e n   ' W y l o g o w a n y '   e l s e   h i s t o r i a o p e r a t o r a . l i n i a s t a c j a   e n d )   a s   G d z i e J e s t T e r a z   F R O M   b l e d y   i n n e r   j o i n   h i s t o r i a o p e r a t o r a   o n   b l e d y . k t o = h i s t o r i a o p e r a t o r a . o p e r a t o r   w h e r e   t o t e   =   ' "  1 0 1 +  1 0 1 V A R ( 1 )  1 0 1 +  1 0 1 " '   A N D   a v o n i d   =   ' "  1 0 1 +  1 0 1 V A R ( 0 )  1 0 1 +  1 0 1 " '   
 
 A N D   b l e d y . s t a t u s   i s   N U L L   a n d   h i s t o r i a o p e r a t o r a . d a t a c z a s w e j s c i a = ( s e l e c t   t o p   1   h i s t o r i a o p e r a t o r a . d a t a c z a s w e j s c i a   f r o m   h i s t o r i a o p e r a t o r a   w h e r e   o p e r a t o r = b l e d y . k t o   A N D   t o t e   =   ' "  1 0 1 +  1 0 1 V A R ( 1 )  1 0 1 +  1 0 1 " '   A N D   a v o n i d   =   ' "  1 0 1 +  1 0 1 V A R ( 0 )  1 0 1 +  1 0 1 " '   o r d e r   b y   d a t a c z a s w e j s c i a   d e s c )   o r d e r   b y   b l e d y . k t o ,   b l e d y . l i n i a s t a c j a ,   b l e d y . b i n " < / S Q > 
 
 
 
 < L P   3   0 > 
 
 	 < B R   4 > 
 
 
 
 	 < F N   " T a h o m a " > 
 
 	 < F S   1 0 > 
 
 	 < F C   0 0 0 0 0 0 0 0 0 > 
 
 	 < B D   0 > 
 
 	 < U N   0 > 
 
 	 < I T   0 > 
 
 	 < S T   0 > 
 
 	 < C A   3   0   N   L   1 1   - 1   2 5   - 1 > 
 
 	 < C A   3   1   N   L   4 0   - 1   3 0   - 1 > 
 
 	 < C A   3   2   N   L   7 5   - 1   1 5   - 1 > 
 
 	 < C A   3   3   N   R   9 5   - 1   1 5   - 1 > 
 
 	 < C A   3   4   N   R   1 1 6   - 1   1 5   - 1 > 
 
 	 < C A   3   5   N   L   1 5 0   - 1   5 0   - 1 > 
 
 	 < B R   4 > 
 
 	 < / L P > 
 
 
 
 < E F > 
 
 
 
 