----- Original Message ----- From: "Ferry" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, October 19, 2005 2:33 AM Subject: Re: [indo-oracle] Cari record outstanding
> > hanya record no 5, 6, 7 dan 8. > Tampaknya row ke 8 tglnya bulan JUNI bukan JULI!? > > Apakah ada "TANDA" bagi suatu record untuk dinyatakan > sbg outstanding (sebagai lawan dari closed), atau hanya kriteria bulan? > > -------- > Anggap bulan aktif 07-2005; jadi filter pertama WHERE bulan 07-2005 > kemudian filter kedua AND yang outstanding hg meskipun transaksinya bulan > 07-2005 > kalau sudah tidak outstanding, rownya tidak dimasukkan sbg result set. > > jadi querynya kira-kira > SELECT... > WHERE bulan 07-2005 AND yang outstanding mungkin pake OR.... pak > .... > > ferry > sends. > > > ----- Original Message ----- > From: "m4z3" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Tuesday, October 18, 2005 9:29 AM > Subject: [indo-oracle] Cari record outstanding > > > > Hi rekan2, > > Saya mempunyai view union dr bbrp tabel yg isi recordnya spt dibawah: > > > > VENDOR_NO DATED ORDER_NO REL_NO SEQ_NO LIN_NO PART_NO TRAN_CODE > IDR_PRICE DIRECTION Qty > > IV0032 05/01/05 10256 1 1 1 A1 ARR-NONINV 46696212 + 2 > > IV0032 28/02/05 10256 1 1 1 A1 SUPPPAY 46696212 - 2 > > IV0032 05/01/05 10256 2 1 1 B5 ARR-NONINV 61859919.15 + 3 > > IV0032 28/02/05 10256 2 1 1 B5 SUPPPAY 61859919.15 - 3 > > IV0032 15/07/05 11213 1 1 1 R0 ARR-NONINV 61859919.15 + 1 > > IV0032 30/07/05 11213 1 1 1 R0 SUPPPAY 61859919.15 - 1 > > IV0032 30/07/05 21551 1 1 1 F1 ARR-NONINV 61859919.15 + 5 > > IV0032 08/06/05 11111 1 1 1 F1 ARR-NONINV 61859919.15 + 8 > > > > saya ingin menghasilkan report misalkan > > di bulan Juli 2005 (per akhir bulan) yg muncul > > hanya record2 yg outstanding saja dan record2 yg tgl > > transaksinya di bulan bersangkutan (Juli 2005), jd yg muncul > > hanya record no 5, 6, 7 dan 8. > > > > Mungkin rekan2 bisa memberikan masukan mengenai > > sintak sql atau pl/sql utk menghasil record2 > > yg diingikan dg waktu eksekusi yg minimum. > > > > -- > > m4z3 > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
