IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> meet my clipboard
TiL
post Apr 4 2006, 05:15 PM
Post #1


100% BMW corupt
*****

Group: Administrators
Posts: 8,476
Joined: 17-October 05
From: Bucuresti
Member No.: 7
Car: E28 525i
Engine: M30 2.5 147cp



[quote][/qoute]
la naiba, nu era nimic biggrin.gif


--------------------
Inline 6 in a 5-er 4 ever
E28 528i, E39 525i touring, E39 520i touring, E53 X5 4.4i, E70 X5 3.0si, E46 318i

ex E39 520i exclusive, E39 525tds, E46 318d touring, E28 525i, E34 525i, E28 524td, E30 318i, E28 525i
Go to the top of the page
 
+Quote Post
florin83
post Apr 4 2006, 05:44 PM
Post #2


100% BMW corupt
*****

Group: Root Admin
Posts: 8,263
Joined: 18-October 05
From: Bucuresti
Member No.: 13
Car: E36 325i
Engine: M50 192CP



QUOTE


cand dam paste aici? e vreo regula?
Go to the top of the page
 
+Quote Post
florin83
post Apr 4 2006, 06:45 PM
Post #3


100% BMW corupt
*****

Group: Root Admin
Posts: 8,263
Joined: 18-October 05
From: Bucuresti
Member No.: 13
Car: E36 325i
Engine: M50 192CP





QUOTE


interesant..
Go to the top of the page
 
+Quote Post
Viper05
post Apr 4 2006, 07:10 PM
Post #4


a
***

Group: Members
Posts: 545
Joined: 1-November 05
From: a
Member No.: 83
Car: a
Engine: a



care e faza? :retard:
Go to the top of the page
 
+Quote Post
sixx
post Apr 4 2006, 09:13 PM
Post #5


xX
***

Group: Root Admin
Posts: 545
Joined: 25-October 05
From: London, UK
Member No.: 63
Car: K13R - soon
Engine: 1.3 4L



BA-CAB-GPS

LE: Nici eu nu mai stiu ce e aia smile.gif


--------------------
xi // GSR
Go to the top of the page
 
+Quote Post
io's®
post Apr 4 2006, 11:25 PM
Post #6


.
*****

Group: Super Moderators
Posts: 5,955
Joined: 31-October 05
From: Bucureşti
Member No.: 72
Car: .
Engine: .





:retard:


--------------------
"PUTEREA BATE CUPLU PT CA TOT TIMPUL VEI GASI O TREAPTA INFERIOARA UNDE SA O PUI"
"BMW E PENTRU DRUMURI LUNGI PE CARE SA LE FACI MAI REPEDE DECIT ORICINE PE SOSEA, SA MERGI TARE SI PE AUTOSTRADA SI PE SERPENTINE SI SA -I DAI 200 SI LA DEAL SI LA VALE"
Go to the top of the page
 
+Quote Post
florin83
post Apr 4 2006, 11:32 PM
Post #7


100% BMW corupt
*****

Group: Root Admin
Posts: 8,263
Joined: 18-October 05
From: Bucuresti
Member No.: 13
Car: E36 325i
Engine: M50 192CP



da-i paste aici..
Go to the top of the page
 
+Quote Post
Gabi_323i
post Apr 5 2006, 10:44 AM
Post #8


82% BMW corupt
****

Group: Members
Posts: 821
Joined: 18-October 05
From: Bucuresti
Member No.: 18
Car: E21
Engine: M20 2.3 143CP



http://www.bmwe34.net/ASP/DUClassified/adD...id=16&ad_id=498


--------------------
BMW E21 323i 2.3l K-Jetronic, 17" Alpina
Go to the top of the page
 
+Quote Post
Darren
post Apr 5 2006, 11:09 AM
Post #9


100% BMW corupt
*****

Group: Insiders
Posts: 1,502
Joined: 17-October 05
From: Bucuresti
Member No.: 4
Car: E36 318i/1995
Engine: M43 1.8 115CP



truncate table syn_mf602_dh;

/********************************/

insert into syn_mf602_DH (cod_div_wiz, cod_fil_wiz, itemkey, Demand_Counter, First_Invoice, Sort, Demand_History)
(SELECT st.cod_divizie, st.cod_filiala, stm.itemkey,
0 DemandCounter, min(nvl(st.valuedate,next_day(sysdate,'Sunday')-7)) finv,
TO_CHAR (st.valuedate, 'YYYYIW') AS sort,
SUM (nvl(stm.supplyquantity,0)) sales
FROM wiz_company100.stock@cons.world st,
wiz_company100.stockmoves@cons.world stm
WHERE st.ID = stm.stockid
AND st.status =1
AND st.documentid IN (1, 2, 9)
AND (st.valuedate >= (NEXT_DAY (SYSDATE, 'Sunday') - (105 * 7)))
GROUP BY st.cod_divizie, st.cod_filiala,
stm.itemkey,
TO_CHAR (st.valuedate, 'YYYYIW')
union all
SELECT st.cod_divizie, st.cod_filiala, stm.itemkey,
0 DemandCounter, min(nvl(st.valuedate,next_day(sysdate,'Sunday')-7)) finv,
TO_CHAR (st.valuedate, 'YYYYIW') AS sort,
SUM (nvl(stm.supplyquantity,0)) sales
FROM wiz_company250.stock@cons.world st,
wiz_company250.stockmoves@cons.world stm
WHERE st.ID = stm.stockid
AND st.status =1
AND st.documentid IN (1, 2, 9)
AND (st.valuedate >= (NEXT_DAY (SYSDATE, 'Sunday') - (105 * 7)))
GROUP BY st.cod_divizie, st.cod_filiala,
stm.itemkey,
TO_CHAR (st.valuedate, 'YYYYIW')
union all
SELECT st.cod_divizie, st.cod_filiala, stm.itemkey,
0 DemandCounter, min(nvl(st.valuedate,next_day(sysdate,'Sunday')-7)) finv,
TO_CHAR (st.valuedate, 'YYYYIW') AS sort,
SUM (nvl(stm.supplyquantity,0)) sales
FROM wiz_company500.stock@cons.world st,
wiz_company500.stockmoves@cons.world stm
WHERE st.ID = stm.stockid
AND st.status =1
AND st.documentid IN (1, 2, 9)
AND (st.valuedate >= (NEXT_DAY (SYSDATE, 'Sunday') - (105 * 7)))
GROUP BY st.cod_divizie, st.cod_filiala,
stm.itemkey,
TO_CHAR (st.valuedate, 'YYYYIW')
union all
SELECT st.cod_divizie, st.cod_filiala, stm.itemkey,
0 DemandCounter, min(nvl(st.valuedate,next_day(sysdate,'Sunday')-7)) finv,
TO_CHAR (st.valuedate, 'YYYYIW') AS sort,
SUM (nvl(stm.supplyquantity,0)) sales
FROM wiz_company800.stock@cons.world st,
wiz_company800.stockmoves@cons.world stm
WHERE st.ID = stm.stockid
AND st.status =1
AND st.documentid IN (1, 2, 9)
AND (st.valuedate >= (NEXT_DAY (SYSDATE, 'Sunday') - (105 * 7)))
GROUP BY st.cod_divizie, st.cod_filiala,
stm.itemkey,
TO_CHAR (st.valuedate, 'YYYYIW')
);
commit;


/************************************/

update SYN_MF602_DH set
demand_counter=((to_number(TO_CHAR (sysdate, 'YYYY'))-to_number(to_char(first_invoice,'YYYY')))*52+(to_number(to_char(sysdate,'IW'))-to_number(to_char(first_invoice,'IW'))))
;

commit;




/***********************************/

truncate table syn_mf602_dh_cons;
insert into syn_mf602_DH_cons (prod_code, Demand_History, Demand_Counter, Sort, First_Invoice)
(select fd.Item_prefix || ia.sync_group, sum(nvl(dh.DEMAND_HISTORY,0)), max(dh.DEMAND_COUNTER), dh.SORT, min(dh.first_invoice)
from items_all ia, syn_mf602_DH dh, (select fdes.*, i.itemkey from forecast_desagg fdes, items_all i where i.cod_divizie=fdes.cod_divizie and fdes.man_id<>0 and (i.sortgroup between fdes.FROM_SGRP and fdes.TO_SGRP) and fdes.interface_id=1) fd
where fd.cod_div_wiz=dh.cod_div_wiz and ia.cod_divizie=fd.cod_divizie and
fd.itemkey=dh.itemkey and ia.itemkey=fd.itemkey and
dh.cod_fil_wiz=fd.cod_fil_wiz
group by fd.Item_prefix || ia.sync_group, fd.Item_prefix, ia.sync_group, dh.sort);
commit;

/***********************************/


truncate table syn_mf732_dh_cons;
insert into syn_mf732_dh_cons (prod_code, sort, demand_history)
(select prod_code, sort, demand_history from syn_mf602_dh_cons);
commit;


/***********************************/

truncate table syn_mf602;
insert into SYN_MF602 (PROD_CODE, ITEM_PREFIX, SYNC_GROUP, DESCRIPTION, UNIT_COST, LEAD_TIME, MIN_OQ, MAX_OQ, MOQ,
SEASONAL_KEY, PARAM_REF_KEY, DEMAND_HISTORY, BACK_ORDERS, CURRENT_STOCK, OUTSTANDING_ORDERS, DEMAND_TO_DATE, DEMAND_COUNTER, TOTAL_BACK_ORDERS,FREE_TEXT1, FREE_TEXT2, FREE_TEXT3, Multi_VAU, Manual_Buffer_Stock, Manual_Buffer_Override, SUPERSEDED_KEY)
(select fd.Item_prefix || ia.sync_group as prod_code,fd.Item_prefix, ia.sync_group, min(ia.description) description, max(ia.pret_ach*ia.status) pret_ach, max(ia.lead_time) lead_time,
0 as MIN_OQ, 9999999 as MAX_OQ, max(ia.MOQ_MULTIPLIER) MOQ,
'ZZZZZZZZZZZZZZZ' as SEASONAL_KEY,
'ZZ' as PARAM_REF_KEY,
0 as DEMAND_HISTORY,
0 as BACK_ORDERS,
sum (nvl(DA.STOC_AGENTI_REAL,0)+nvl(DA.STOC_DEPOZIT_REAL,0)) Current_Stock,
0 as Total_Outstand_Ord,
0 as DemandToDate,
0 as DemandCounter,
sum(nvl(DA.Comenzi_viitor,0)) TotalBackOrders,
min(ia.filter) as free_text1,
substr(min(ia.category),1,25) as free_text2,
'' as free_text3,
max(nvl(ia.MULTI_VAU,0)) as multi_vau,
0 as manual_buffer_stock,
'' as manual_buffer_override,
max(nvl(ia.superseded_pk,'')) as superseded_key
from items_all ia, dssrprd da, (select fdes.*, i.itemkey from forecast_desagg fdes, items_all i where i.cod_divizie=fdes.cod_divizie and fdes.man_id<>0 and (i.sortgroup between fdes.FROM_SGRP and fdes.TO_SGRP) and fdes.interface_id=1) fd
where fd.cod_divizie=da.cod_divizie(+) and ia.cod_divizie=fd.cod_divizie and
fd.itemkey=da.cod_produs(+) and ia.itemkey=fd.itemkey and
da.cod_filiala(+)=fd.cod_filiala
group by fd.Item_prefix || ia.sync_group, fd.Item_prefix, ia.sync_group);
commit;


--------------------
Go to the top of the page
 
+Quote Post
georgem
post Apr 7 2006, 08:49 AM
Post #10


100% BMW corupt
*****

Group: Super Moderators
Posts: 2,172
Joined: 26-November 05
From: Bucuresti
Member No.: 109
Car: E34
Engine: M50 2.5 192CP





194.102.255.2
Mda, ieri dupa-amiaza am setat ip-urile pe niste servere si asta mi-a ramas in clipboard, un ip de dns.

@Darren: sa ne dai si un rezultat de la:
select * from user_db_links where db_link = 'CONS.WORLD';
si definitia lui cons.world din tnsnames.ora :finger:
Si sa vorbesti cu administorul de retea sa permita conexiunile tcp pe portul 1521 :paranoid:


--------------------
2007 Honda CBF 1000A SC58
1991 Audi 80 1.8 E - DZ, 82 kw (112 CP)
Go to the top of the page
 
+Quote Post
Darren
post Apr 7 2006, 09:57 AM
Post #11


100% BMW corupt
*****

Group: Insiders
Posts: 1,502
Joined: 17-October 05
From: Bucuresti
Member No.: 4
Car: E36 318i/1995
Engine: M43 1.8 115CP



user_db_links e gol tongue.gif

"-----------------------------------------------------------------------------------------------------------------------------------------"


--------------------
Go to the top of the page
 
+Quote Post
TiL
post Apr 7 2006, 12:51 PM
Post #12


100% BMW corupt
*****

Group: Administrators
Posts: 8,476
Joined: 17-October 05
From: Bucuresti
Member No.: 7
Car: E28 525i
Engine: M30 2.5 147cp



QUOTE

sh1t, iar nimic biggrin.gif


--------------------
Inline 6 in a 5-er 4 ever
E28 528i, E39 525i touring, E39 520i touring, E53 X5 4.4i, E70 X5 3.0si, E46 318i

ex E39 520i exclusive, E39 525tds, E46 318d touring, E28 525i, E34 525i, E28 524td, E30 318i, E28 525i
Go to the top of the page
 
+Quote Post
cristic
post Apr 7 2006, 12:53 PM
Post #13


CristiC
*****

Group: Insiders
Posts: 1,138
Joined: 19-October 05
From: Ploiesti
Member No.: 26
Car: E87
Engine: 116i 115cp 2007



QUOTE
mergem sa-ti


cand oare am dat eu CTRL+C la asta :puke: :eek: ??


--------------------
ex E30; ex E46; now E87
Go to the top of the page
 
+Quote Post
sixx
post Apr 7 2006, 01:07 PM
Post #14


xX
***

Group: Root Admin
Posts: 545
Joined: 25-October 05
From: London, UK
Member No.: 63
Car: K13R - soon
Engine: 1.3 4L





QUOTE
#2104B6


--------------------
xi // GSR
Go to the top of the page
 
+Quote Post
Gabi_323i
post Apr 7 2006, 01:30 PM
Post #15


82% BMW corupt
****

Group: Members
Posts: 821
Joined: 18-October 05
From: Bucuresti
Member No.: 18
Car: E21
Engine: M20 2.3 143CP



QUOTE
0040F442D258


--------------------
BMW E21 323i 2.3l K-Jetronic, 17" Alpina
Go to the top of the page
 
+Quote Post
TiL
post Apr 7 2006, 02:15 PM
Post #16


100% BMW corupt
*****

Group: Administrators
Posts: 8,476
Joined: 17-October 05
From: Bucuresti
Member No.: 7
Car: E28 525i
Engine: M30 2.5 147cp



QUOTE
SQL Exception: Meta-data for Container org.apache.derby.impl.store.raw.data.RAFContainer@5d42e8f9 could not be accessed


in sfarsit!


--------------------
Inline 6 in a 5-er 4 ever
E28 528i, E39 525i touring, E39 520i touring, E53 X5 4.4i, E70 X5 3.0si, E46 318i

ex E39 520i exclusive, E39 525tds, E46 318d touring, E28 525i, E34 525i, E28 524td, E30 318i, E28 525i
Go to the top of the page
 
+Quote Post
Viper05
post Apr 7 2006, 08:01 PM
Post #17


a
***

Group: Members
Posts: 545
Joined: 1-November 05
From: a
Member No.: 83
Car: a
Engine: a



http://yuyuhakusho.3xforum.ro/topic/42/Canguru/


looooooooooooooooool fratemio:D
Go to the top of the page
 
+Quote Post
akajohn
post Apr 7 2006, 09:26 PM
Post #18


27% BMW corupt
**

Group: Members
Posts: 329
Joined: 16-November 05
Member No.: 99
Car: e46 316i
Engine: M43B19 1895 cmc 105 CP





la naiba... egol... sunt acasa si abia am deschis lapul...smile.gif
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 





Google
 
RSS Lo-Fi Version Time is now: 30th March 2024 - 12:45 AM