meet my clipboard |
meet my clipboard |
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 -------------------- 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 |
|
|
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 |
|
|
|
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 |
|
|
|
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:
|
|
|
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 -------------------- xi // GSR
|
|
|
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" |
|
|
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..
|
|
|
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 |
-------------------- BMW E21 323i 2.3l K-Jetronic, 17" Alpina
|
|
|
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; -------------------- |
|
|
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) |
|
|
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
"-----------------------------------------------------------------------------------------------------------------------------------------" -------------------- |
|
|
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 -------------------- 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 |
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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 |
|
|
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 |
|
|
|
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... |
|
|
Lo-Fi Version | Time is now: 30th March 2024 - 12:45 AM |