SQL query question   Independent houses near kukatpally | Apartments in Pragathi Nagar | AndhraVaani.com | Log Out | Topics | Search
Register | Edit Profile

Bewarse TalkArchives - 2008Bewarse Bewarse BewarseArchive through December 14, 2008SQL query question Previous Next

Author Message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Rangupadudhi
Yavvanam Kaatesina Bewarse
Username: Rangupadudhi

Post Number: 4896
Registered: 03-2008
Posted From: 173.88.138.190

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:48 pm:Edit PostDelete PostView Post/Check IP

luxu papa luxu papa lunchi kosthava
Italian Mafioso
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 16706
Registered: 01-2005
Posted From: 76.182.87.40

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:42 pm:Edit PostDelete PostView Post/Check IP


Chip :

Gosi baa edo okati set sethhadu le..tayani olanna tollywood gunta meet n greet untey nee panta pandindhey




tollywood gunta naa adi set ayithe repe eltaa allentown ki
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Tingari_xx
Mudiripoyina Bewarse
Username: Tingari_xx

Post Number: 8576
Registered: 08-2006
Posted From: 76.109.147.47

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:38 pm:Edit PostDelete PostView Post/Check IP


Rangupadudhi :

ggi baa ni oohinchukoni


Top of pagePrevious messageNext messageBottom of pageLink to this message

Chip
Mudiripoyina Bewarse
Username: Chip

Post Number: 6672
Registered: 06-2004
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:37 pm:Edit PostDelete PostView Post/Check IP

Gosi baa edo okati set sethhadu le..tayani olanna tollywood gunta meet n greet untey nee panta pandindhey
Life is a beach..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Pedarayudu
Kurra Bewarse
Username: Pedarayudu

Post Number: 1830
Registered: 04-2007
Posted From: 75.173.128.87

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:37 pm:Edit PostDelete PostView Post/Check IP

chinnagaaa
Top of pagePrevious messageNext messageBottom of pageLink to this message

Chinna
Kurra Bewarse
Username: Chinna

Post Number: 2122
Registered: 05-2006
Posted From: 64.105.89.26

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:35 pm:Edit PostDelete PostView Post/Check IP


I'm the one who's got the gun, son. It's you who I think ought to calm down.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 16705
Registered: 01-2005
Posted From: 76.182.87.40

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:34 pm:Edit PostDelete PostView Post/Check IP


Chip :

otha tv lo SSR neeku, Pokiri Hemesh ki special show ethhadu le




danitho paatu bavalu sayya kuda kavali manaki adi untene vottam. bemmam maaya seppina atlanta lo owasis ani k pagala strip club undi allentown lo etuntadi seppu shoda baa
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Chip
Mudiripoyina Bewarse
Username: Chip

Post Number: 6671
Registered: 06-2004
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:31 pm:Edit PostDelete PostView Post/Check IP

kotha tv lo SSR neeku, Pokiri Hemesh ki special show ethhadu le
Life is a beach..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 16704
Registered: 01-2005
Posted From: 76.182.87.40

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:29 pm:Edit PostDelete PostView Post/Check IP


Gochi :

eteto potam kaaadhu,eppudanna itu allentown kooda trip eyyandi raleigh bedars




vostam kani maaku enti ani aha maaku enti adugutunna gwochi baa
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Chip
Mudiripoyina Bewarse
Username: Chip

Post Number: 6670
Registered: 06-2004
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:23 pm:Edit PostDelete PostView Post/Check IP

edevedo appi baa la unnadu..boddu meeda ekkichukunnadu
Life is a beach..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Rangupadudhi
Yavvanam Kaatesina Bewarse
Username: Rangupadudhi

Post Number: 4895
Registered: 03-2008
Posted From: 173.88.138.190

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:18 pm:Edit PostDelete PostView Post/Check IP

neenu saradaaki anna lee....aa quote neenu latex ani typescripting book laa chadiva lee.....choosi thega navvukunna aggi baa ni oohinchukoni
Italian Mafioso
Top of pagePrevious messageNext messageBottom of pageLink to this message

Chip
Mudiripoyina Bewarse
Username: Chip

Post Number: 6668
Registered: 06-2004
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:05 pm:Edit PostDelete PostView Post/Check IP

nenu skool la system admin course chesa..eppudu chusina aa lab lo padi undevadini assignments cheskunta
Life is a beach..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Chip
Mudiripoyina Bewarse
Username: Chip

Post Number: 6667
Registered: 06-2004
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:03 pm:Edit PostDelete PostView Post/Check IP

nee yenks adevadeo edava post sethey nuvvu post sesedeymena. Unix techies ki, business/end users ki windows kottedy ledu..period.
Life is a beach..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 56401
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:02 pm:Edit PostDelete PostView Post/Check IP

1hr tingesh
I am Gochi and I approve this message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Tingari_xx
Mudiripoyina Bewarse
Username: Tingari_xx

Post Number: 8575
Registered: 08-2006
Posted From: 76.109.147.47

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:00 pm:Edit PostDelete PostView Post/Check IP

philly airport nunchi allentown entha distance lo vundi gochio
Top of pagePrevious messageNext messageBottom of pageLink to this message

Rangupadudhi
Yavvanam Kaatesina Bewarse
Username: Rangupadudhi

Post Number: 4894
Registered: 03-2008
Posted From: 173.88.138.190

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 6:00 pm:Edit PostDelete PostView Post/Check IP

eppatikappudu ubuntu install antaaav,system shutdown chesemundu daily ubuntu uninstall sesthaaava rangesh //

leedhu gochi baa....8.10 nunchi 8.04 ki downgrade iyyaa...latest version laa konni issues vunnaayi...so downgrade iyyaa.....

linux install cheyyatam antee eedho arati pandu thintunnatlu vundhi .....80gb laa idhivaraku 20gb xp, 35gb data and rest ubuntu vundeedhi.......ippudu mothaaniki lepi...15gb root parition icchi migathaadhi /home jeesa....inka nunchi no windows annamaata
Italian Mafioso
Top of pagePrevious messageNext messageBottom of pageLink to this message

Rangupadudhi
Yavvanam Kaatesina Bewarse
Username: Rangupadudhi

Post Number: 4893
Registered: 03-2008
Posted From: 173.88.138.190

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:58 pm:Edit PostDelete PostView Post/Check IP

ubantu ledu, elagubantu ledu //

shadow baa ekkado chadivaa........Real Men use UNIX antaa
Italian Mafioso
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 56399
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:57 pm:Edit PostDelete PostView Post/Check IP

eppatikappudu ubuntu install antaaav,system shutdown chesemundu daily ubuntu uninstall sesthaaava rangesh


I am Gochi and I approve this message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Chip
Mudiripoyina Bewarse
Username: Chip

Post Number: 6666
Registered: 06-2004
Posted From: 68.198.151.34

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:57 pm:Edit PostDelete PostView Post/Check IP

ubantu ledu, elagubantu ledu
Life is a beach..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 56398
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:56 pm:Edit PostDelete PostView Post/Check IP

eteto potam kaaadhu,eppudanna itu allentown kooda trip eyyandi raleigh bedars


I am Gochi and I approve this message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Rangupadudhi
Yavvanam Kaatesina Bewarse
Username: Rangupadudhi

Post Number: 4892
Registered: 03-2008
Posted From: 173.88.138.190

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:55 pm:Edit PostDelete PostView Post/Check IP

fressh gaa ubuntu install jeesaa
Italian Mafioso
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8260
Registered: 06-2004
Posted From: 97.89.232.163

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:54 pm:Edit PostDelete PostView Post/Check IP

rachesh..christmas week kaakunda jan 1st vache weekend..kuduruthunda..car ee veltha anukuntunna...

sare ala friend inti varaku vellostha...bbye..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 56396
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:53 pm:Edit PostDelete PostView Post/Check IP

rattayya ninnu puvvulllo pettukuni soosukuntaadu,detroit laaagincheyyi racchesh


I am Gochi and I approve this message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 16703
Registered: 01-2005
Posted From: 76.182.87.40

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:50 pm:Edit PostDelete PostView Post/Check IP


Ravanabrahma :




Atlant ki train aah simple gaa 9 hrs untadi. Drive ante seppi alositta lekapothe detroit potaa nenu. retayya kalise batch eeh naa
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8259
Registered: 06-2004
Posted From: 97.89.232.163

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:45 pm:Edit PostDelete PostView Post/Check IP


Racchamass :

asala swetch enti




jan 1st weekend appudu okallu atlanta rammantunnaru..saradaga train lo veldama ani korika kaligindi anthe...manaki antha opika undadu ga...malla friday work from home pettali...kuduruthundo ledo mari chodali...
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 16702
Registered: 01-2005
Posted From: 76.182.87.40

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:42 pm:Edit PostDelete PostView Post/Check IP


Ravanabrahma :

malla car ekkadanna pettali..malla vere vaallu pick chesukovali..edava gola




asala swetch enti
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8258
Registered: 06-2004
Posted From: 97.89.232.163

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:40 pm:Edit PostDelete PostView Post/Check IP

rachesh
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8257
Registered: 06-2004
Posted From: 97.89.232.163

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:39 pm:Edit PostDelete PostView Post/Check IP

naaku enduko train lo journey cheyyalani korigga undi

vadhule chali..malla car ekkadanna pettali..malla vere vaallu pick chesukovali..edava gola..
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 16701
Registered: 01-2005
Posted From: 76.182.87.40

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:39 pm:Edit PostDelete PostView Post/Check IP


Ravanabrahma :

kiki..nenu ninna night maa friend okadigithe webcam lo choyinchadu iphone lo oka icon untadi ani..




nee yenks
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Tingari_xx
Mudiripoyina Bewarse
Username: Tingari_xx

Post Number: 8571
Registered: 08-2006
Posted From: 76.109.147.47

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:36 pm:Edit PostDelete PostView Post/Check IP


Ravanabrahma :

enu ninna night okallani adigithe webcam lo choyincharu iphone




webcam ila kooda use avutunda
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8256
Registered: 06-2004
Posted From: 97.89.232.163

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:34 pm:Edit PostDelete PostView Post/Check IP


Tingari_xx :

nee yenks, nenu aithe googling seddam anukunna..unlocking seyatam lo miss avudda ani




kiki..nenu ninna night maa friend okadigithe webcam lo choyinchadu iphone lo oka icon untadi ani..naaku aa icon ledu photos lo ani kangaru padipoya...
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 16700
Registered: 01-2005
Posted From: 76.182.87.40

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:33 pm:Edit PostDelete PostView Post/Check IP


Ravanabrahma :

camera icon undi phone lo...




putos la susi ledu ledu ante etta camera ledu ani
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Tingari_xx
Mudiripoyina Bewarse
Username: Tingari_xx

Post Number: 8569
Registered: 08-2006
Posted From: 76.109.147.47

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:32 pm:Edit PostDelete PostView Post/Check IP


Ravanabrahma :

..




nee yenks, nenu aithe googling seddam anukunna..unlocking seyatam lo miss avudda ani
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 16699
Registered: 01-2005
Posted From: 76.182.87.40

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:32 pm:Edit PostDelete PostView Post/Check IP


Tingari_xx :

idedo gosannai valla "friend" laagulu esukune age lo raasinatlundi




twingu baa muzic and song baagunde
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Tingari_xx
Mudiripoyina Bewarse
Username: Tingari_xx

Post Number: 8568
Registered: 08-2006
Posted From: 76.109.147.47

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:30 pm:Edit PostDelete PostView Post/Check IP


Racchamass :

edo laa unde nuvve leka
emi baalede nuvellaka
em cheyyalo paalu poka
unnane nee kallo ayina raaka
oooh noo ooh no
nuvve naa santosham
gillava naa pranam




idedo gosannai valla "friend" laagulu esukune age lo raasinatlundi
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8254
Registered: 06-2004
Posted From: 97.89.232.163

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:30 pm:Edit PostDelete PostView Post/Check IP

malla ekkada ethukutharo ani malla answer koda pettesa..kiki.

camera icon undi phone lo...
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 16698
Registered: 01-2005
Posted From: 76.182.87.40

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:25 pm:Edit PostDelete PostView Post/Check IP

edo laa unde nuvve leka
emi baalede nuvellaka
em cheyyalo paalu poka
unnane nee kallo ayina raaka
oooh noo ooh no
nuvve naa santosham
gillava naa pranam

I miss you I miss you I miss you deep down in here


kummesindi paata. Neninthe lo gwochi baa MP3 link unte ettu vurgent gaa
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 56391
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:24 pm:Edit PostDelete PostView Post/Check IP


I am Gochi and I approve this message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 16697
Registered: 01-2005
Posted From: 76.182.87.40

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:22 pm:Edit PostDelete PostView Post/Check IP

corona extraa istart sesaa
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Racchamass
Celebrity Bewarse
Username: Racchamass

Post Number: 16696
Registered: 01-2005
Posted From: 76.182.87.40

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:16 pm:Edit PostDelete PostView Post/Check IP

nee yenks bemmam maaya
Our greatest glory is not in never falling, but in rising every time we fall
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 56389
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 5:00 pm:Edit PostDelete PostView Post/Check IP

pda baa,mana hemesh kochen kosam oka moodu analytic functions tho stored procedure raasi nookaava


I am Gochi and I approve this message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Pedarayudu
Kurra Bewarse
Username: Pedarayudu

Post Number: 1815
Registered: 04-2007
Posted From: 129.138.250.120

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 4:58 pm:Edit PostDelete PostView Post/Check IP

Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 56386
Registered: 07-2004
Posted From: 24.229.138.244

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 4:52 pm:Edit PostDelete PostView Post/Check IP


I am Gochi and I approve this message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8253
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 4:33 pm:Edit PostDelete PostView Post/Check IP

kiki.problem ardamaindi le..aa next order by lo select lo leni column icha..kiki.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8252
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 4:27 pm:Edit PostDelete PostView Post/Check IP

ila raasa..not a group by expression antundi..

group by pv.vendor_id,
pv.vendor_name,
pvs.address_line1,
pvs.address_line2,
pvs.address_line3,
pvs.city,
pvs.state,
pvs.zip,
pv.num_1099,
atm.name
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 8251
Registered: 06-2004
Posted From: 65.196.167.82

Rating:N/A
Votes: 0(Vote!)

Posted on Friday, December 12, 2008 - 4:26 pm:Edit PostDelete PostView Post/Check IP

select lo following unnay...group by ela rastharu?

SELECT pv.vendor_id "Vendor ID",
pv.vendor_name "Vendor Name",
pvs.address_line1 "Address Line1",
pvs.address_line2 "Address Line2",
pvs.address_line3 "Address Line3",
pvs.city "City",
pvs.state "State",
pvs.zip "Zip",
pv.num_1099 "TIN",
' ' "SIC4",
atm.name "Payment term",
' ' "Account Code",
-- (ac.creation_date - ai.creation_date) "DPO",
count(ap_invoices_pkg.get_po_number( ai.invoice_id)) "POCt",
count(ai.invoice_num) "InvoiceCt",
sum(ai.invoice_amount) "Invoice Amount",
count(ac.amount) "PaymentCt",
sum(ac.amount) "PaymentAmt"