| Author |
Message |
    
Nitho
Celebrity Bewarse
Username: Nitho
Post Number: 8121
Registered: 12-2004
Posted From: 204.17.116.130
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 30, 2010 - 2:43 pm: |
|
Tingari_xx:OM mama ni em annav ninna
nenu emi ana ledhu sodara.. kasepu uthithi fighting chesukunnam..
OM baa office lo busy ayyi untadu.. lekha pothe DB loki rakha povatama... food ayyina manestadu kani,,, DB loki rakha pothe nidra pattadu baa ki... |
Tingari_xx
Bewarse Legend
Username: Tingari_xx
Post Number: 24987
Registered: 08-2006
Posted From: 205.157.110.11
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 30, 2010 - 2:41 pm: |
|
nitho ba
OM mama ni em annav ninna
i was NOT a bewarse, and then i saw Gosi post
|
Nitho
Celebrity Bewarse
Username: Nitho
Post Number: 8119
Registered: 12-2004
Posted From: 204.17.116.130
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 30, 2010 - 2:40 pm: |
|
Rangupadudhi: om lekapoye sariki meeku thosthunnattu
Om baa eedhi.. emi ayyi poyyadu..
ninna kasepu fight chesa OM baa tho.. |
Rangupadudhi
Bewarse Legend
Username: Rangupadudhi
Post Number: 11317
Registered: 03-2008
Posted From: 24.209.32.90
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 30, 2010 - 2:27 pm: |
|
Nitho:ayyithe aa chat lo matladu ko vachu kadha.. malli DB enti mee gola,,
nitho baa om lekapoye sariki meeku thosthunnattu ledhu eeyala 
Best Upcoming Bewarse Award Winner for 2008 
|
Nitho
Celebrity Bewarse
Username: Nitho
Post Number: 8118
Registered: 12-2004
Posted From: 204.17.116.130
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 30, 2010 - 2:25 pm: |
|
Littlestar:roju chat loo chava dobutu.. maalli mail id antava..
ayyithe aa chat lo matladu ko vachu kadha.. malli DB enti mee gola,, |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 12973
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 30, 2010 - 2:21 pm: |
|
orni nuvva mama...kiki...sare YM lo cheptha  |
Littlestar
Pilla Bewarse
Username: Littlestar
Post Number: 171
Registered: 11-2005
Posted From: 12.145.34.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 30, 2010 - 2:06 pm: |
|
nee yenkama ravan,
roju chat loo chava dobutu.. maalli mail id antava.. ninnu 
aa denver project ee ga chesidi nuvu.. think chesi yahoo loo chat ki ra... roju dobinchukontavu ga ..mama maama ani.. malli mail id adugutava.. |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 12972
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 30, 2010 - 12:39 pm: |
|
Littlestar:hey ravan,
nee gola emitooo ardam kaadu naaku
clear ga mail cheyi.. SQLs pamputa
Oracle apps lo chesthunnara mama meeru? mail id enti cheppandi. |
Littlestar
Pilla Bewarse
Username: Littlestar
Post Number: 169
Registered: 11-2005
Posted From: 12.145.34.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 30, 2010 - 12:12 pm: |
|
hey ravan,
nee gola emitooo ardam kaadu naaku
clear ga mail cheyi.. SQLs pamputa.. |
Nitho
Celebrity Bewarse
Username: Nitho
Post Number: 8111
Registered: 12-2004
Posted From: 204.17.116.130
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 30, 2010 - 11:53 am: |
|
Ravanabrahma:
Inkko sari SQL help ani DB lo thadu vesavo.. |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 12971
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 30, 2010 - 11:20 am: |
|
thank you littlestar and sensation mamalu...chala use ayyay ee queries. inka evo adigaru..open orders, open invoices, active services leni accounts..so chosthunna inka adi. |
Littlestar
Pilla Bewarse
Username: Littlestar
Post Number: 168
Registered: 11-2005
Posted From: 76.172.54.225
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 30, 2010 - 2:24 am: |
|
customer may have multiple accounts like pay account, shipping and etc..
Let me know, what exactly you are trying to achieve..
like party merging etc.. based on that i might throw some idea..
based on the provided sql you will get the complete customer info..
in your sql you missed the below tables
hz_cust_acct_sites_all , hz_cust_site_uses_all
Note:
you can tweek the sql accordinly like having count(*)>1 etc...
|
Littlestar
Pilla Bewarse
Username: Littlestar
Post Number: 167
Registered: 11-2005
Posted From: 76.172.54.225
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, March 30, 2010 - 2:12 am: |
|
SELECT hp.party_name , hp.party_number , hca.account_number , hca.cust_account_id , hp.party_id , hps.party_site_id , hps.location_id , hl.address1 , hl.address2 , hl.address3 , hl.city , hl.state , hl.country , hl.postal_code , hcsu.site_use_code , hcsu.site_use_id , hcsa.bill_to_flagFROM hz_parties hp , hz_party_sites hps , hz_locations hl , hz_cust_accounts_all hca , hz_cust_acct_sites_all hcsa , hz_cust_site_uses_all hcsuWHERE hp.party_id = hps.party_idAND hps.location_id = hl.location_idAND hp.party_id = hca.party_idAND hcsa.party_site_id = hps.party_site_idAND hcsu.cust_acct_site_id = hcsa.cust_acct_site_idAND hca.cust_account_id = hcsa.cust_account_idAND hca.account_number = :customer_number |
Sensation
Yavvanam Kaatesina Bewarse
Username: Sensation
Post Number: 2384
Registered: 12-2004
Posted From: 24.30.37.9
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 11:05 pm: |
|
Following query should give party tied to more than one account number and having different status. when the statuses are different, Iam assuming party is tied to more than one account.
select
count( distinct ca.status ),
p.party_name
from
APPS.hz_cust_accounts ca,
apps.hz_parties p,
apps.hz_party_sites ps,
apps.hz_locations l
where ca.party_id = p.party_id
and p.party_id = ps.party_id
and ps.location_id = l.location_id
and l.COUNTRY = 'US'
group by p.party_name
having count(distinct ca.status) > 1
incase you want the party that is tied to multiple accounts and you want the active account information, here is the query
select
sub.party_name,
hca.account_number
from
apps.hz_cust_accounts hca
(select
count( distinct ca.status ),
p.party_name,
p.party_id
from
APPS.hz_cust_accounts ca,
apps.hz_parties p,
apps.hz_party_sites ps,
apps.hz_locations l
where ca.party_id = p.party_id
and p.party_id = ps.party_id
and ps.location_id = l.location_id
and l.COUNTRY = 'US'
group by p.party_name,p.party_id
having count(distinct ca.status) > 1 ) sub
where sub.party_id=hca.party_id and
hcs.status='A' |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 12956
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 3:33 pm: |
|
Gudivada04:bemmam, mothaniki DB vaallatho day to day work antha laaginchesthannav ga..
 nerchukuntunna mama work |
Gudivada04
Celebrity Bewarse
Username: Gudivada04
Post Number: 7228
Registered: 09-2004
Posted From: 66.244.207.150
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 3:31 pm: |
|
Ravanabrahma:
bemmam, mothaniki DB vaallatho day to day work antha laaginchesthannav ga.. |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 12955
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 3:29 pm: |
|
Sensation:RB,
DO you want same paty name that is tied to more than two account numbers? If thats what you want
mama...mee query work ayyindi..ippudu oka account active ga undi...vere account inactive ayina account unna party names ee ravali ante ela? ca.status is A or I untay? ippudu query ela marchali? |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 12952
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 12:29 pm: |
|
Sensation:RB,
DO you want same paty name that is tied to more than two account numbers? If thats what you want
yaa avunu mama...mee query try chesanu..work ayyindi |
Sensation
Yavvanam Kaatesina Bewarse
Username: Sensation
Post Number: 2380
Registered: 12-2004
Posted From: 24.30.37.9
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 11:48 am: |
|
RB,
DO you want same paty name that is tied to more than two account numbers? If thats what you want
it will be like this
select
count( distinct ca.account_number ),
p.party_name
from
APPS.hz_cust_accounts ca,
apps.hz_parties p,
apps.hz_party_sites ps,
apps.hz_locations l
where ca.party_id = p.party_id
and p.party_id = ps.party_id
and ps.location_id = l.location_id
and l.COUNTRY = 'US'
group by p.party_name
having count(distinct ca.account_number) > 1 |
Onlymovies
Bewarse Legend
Username: Onlymovies
Post Number: 12076
Registered: 01-2009
Posted From: 199.173.224.32
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 11:34 am: |
|
Blazewada:innerhtml antey im\nnerhtml.content = responsetext antam ade kada, antey responsetext is html content kada, antey html tags in form of string kada.
yeah query vacina data ni java script lo html tags lo convert chesukuni innerHtml.content ki set cheyyali..
???
|
Blazewada
Celebrity Bewarse
Username: Blazewada
Post Number: 8544
Registered: 08-2008
Posted From: 218.186.8.238
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 11:06 am: |
|
Onlymovies:nenu general ga innerHTML value update chesevadini
innerhtml antey im\nnerhtml.content = responsetext antam ade kada, antey responsetext is html content kada, antey html tags in form of string kada.
konchem kudirithey oka try chestaara? it will be helpful for me. chaala load ekkuvain di, chooddamanana time kudaraltedu adi. andukani.
Give me another Chance.. I wanna grow up one again 
|
Onlymovies
Bewarse Legend
Username: Onlymovies
Post Number: 12074
Registered: 01-2009
Posted From: 199.173.224.31
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 11:02 am: |
|
Blazewada:as of now, ajax:select vadutnna, but aid javas crit kinda convert ayyaka, internal gaa class.create ane functtioncall avuddi, akkada class not defined ane javascroipt esrror vastondi.coudlnt debug that one.
nenu ajax tags vadaledu baa..
???
|
Onlymovies
Bewarse Legend
Username: Onlymovies
Post Number: 12073
Registered: 01-2009
Posted From: 199.173.224.31
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 11:02 am: |
|
Blazewada:its like page auto refresh for every 10 seconds , ade window refersh appudu ajx call avvali.
table contents are editable, antey edited table contents save chesi amlley same table relaod chesedappudu, ooonly table load avvali, nnot entire page cosntituents.
nenu general ga innerHTML value update chesevadini, table refresh kosam.. ajax vaadi 2 years ayyindi.. so exact ga gurtu ledu..
???
|
Blazewada
Celebrity Bewarse
Username: Blazewada
Post Number: 8543
Registered: 08-2008
Posted From: 218.186.8.238
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 10:57 am: |
|
Onlymovies:eppudu update avvali table content? i mean ee event trigger chestundi ee table content change ..
its like page auto refresh for every 10 seconds , ade window refersh appudu ajx call avvali.
table contents are editable, antey edited table contents save chesi amlley same table relaod chesedappudu, ooonly table load avvali, nnot entire page cosntituents.
prastutanii iframe vadutunnam, but ajax anedi impplement cheyyali . drop dowwn avaraku
one more problem:
as of now, ajax:select vadutnna, but aid javas crit kinda convert ayyaka, internal gaa class.create ane functtioncall avuddi, akkada class not defined ane javascroipt esrror vastondi.coudlnt debug that one.
http://ajaxtags.sourceforge.net/advanced.html
Give me another Chance.. I wanna grow up one again
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 12950
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 10:52 am: |
|
adi konchem theda kottidhi..this will work
select c.account_number, p1.party_name, c.status from APPS.hz_cust_accounts c, apps.hz_parties p1
where p1.party_name in (SELECT p.party_name
FROM apps.hz_parties p,
apps.hz_party_sites ps,
apps.hz_locations l
where p.party_id = ps.party_id
and ps.location_id = l.location_id
and l.COUNTRY = 'US'
having count(party_name) > 1
group by p.party_name)
and c.party_id = p1.party_id |
Onlymovies
Bewarse Legend
Username: Onlymovies
Post Number: 12060
Registered: 01-2009
Posted From: 199.173.224.31
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 10:51 am: |
|
Ravanabrahma:
query chooste work avutadi annattu gane vundi..test chesi choodu..
???
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 12949
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 10:50 am: |
|
idi correct oo kado test cheyyali..kani test case ki oka party name chaalu annaru ani mundu duplicate party names kanukkoni okati thesukoni different account numbers unnayemo chosi ichesa aa name ni. |
Onlymovies
Bewarse Legend
Username: Onlymovies
Post Number: 12059
Registered: 01-2009
Posted From: 199.173.224.31
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 10:50 am: |
|
Blazewada:OMeesh, struts ajax implementation lo. oka html table special ga refresh chese tags emunnayi, ajax:htmlcontent akundaa, i just want to take table id and refresh the content inthat table itself.
eppudu update avvali table content? i mean ee event trigger chestundi ee table content change ..
???
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 12948
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 10:49 am: |
|
select c.account_number, p1.party_name, c.status from APPS.hz_cust_accounts c, apps.hz_parties p1
where c.party_id in (SELECT p.party_id
FROM apps.hz_parties p,
apps.hz_party_sites ps,
apps.hz_locations l
where p.party_id = ps.party_id
and ps.location_id = l.location_id
and l.COUNTRY = 'US'
having count(party_name) > 1
group by p.party_id)
and c.party_id = p1.party_id |
Blazewada
Celebrity Bewarse
Username: Blazewada
Post Number: 8542
Registered: 08-2008
Posted From: 218.186.8.238
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 10:48 am: |
|
Onlymovies:
OMeesh, struts ajax implementation lo. oka html table special ga refresh chese tags emunnayi, ajax:htmlcontent akundaa, i just want to take table id and refresh the content inthat table itself.
manchi solutoin emanna untey cheppandi, inc ase teliyakapoina oka sari try cheynadi, POC lo implement ccheyyali andukani.
Give me another Chance.. I wanna grow up one again
|
Onlymovies
Bewarse Legend
Username: Onlymovies
Post Number: 12052
Registered: 01-2009
Posted From: 199.173.224.31
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 10:45 am: |
|
Ravanabrahma:verega workaround chesa mama...
ikkada post cheyy query..
i ll try to understand.. future lo use avvachu
???
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 12947
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 10:44 am: |
|
hmm...verega workaround chesa mama...test chesthaniki oka party name chaalu annaru..so duplicate party_names query chesi oka name thesukoni dani account numbers multiple unnayani confirm chesukoni pampanu aa party name..inka req lo actual ga oka account inactive ga undi inkokati active ga undali..I mean active status unna sare activity undakodadu aa active ki.. |
Onlymovies
Bewarse Legend
Username: Onlymovies
Post Number: 12048
Registered: 01-2009
Posted From: 199.173.224.31
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 10:34 am: |
|
logic konchem complecated ga anipistundi..
naaku SQL anta baaga raadu, so i cannot help anukuntunna.. but aalcohista.. idea vaste chepta
???
|
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 12946
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 10:29 am: |
|
idi correct eena...chala sepu execute avuthundi.
select DISTINCT
ca.account_number,
p.party_name
from
APPS.hz_cust_accounts ca,
apps.hz_parties p,
apps.hz_party_sites ps,
apps.hz_locations l
where ca.party_id = p.party_id
and p.party_id = ps.party_id
and ps.location_id = l.location_id
and l.COUNTRY = 'US'
and exists (select 'x' from APPS.hz_cust_accounts ca1, apps.hz_parties p1
where ca.account_number != ca1.account_number
-- and p.party_number != p1.party_number
and p.party_name = p1.party_name) |
Ravanabrahma
Bewarse Legend
Username: Ravanabrahma
Post Number: 12945
Registered: 06-2004
Posted From: 169.143.0.103
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, March 29, 2010 - 10:28 am: |
|
naaku two tables unnay....accounts a, parties p
indulo a.party_id = p.party_id
and p.party_name ane column undi and a.account_number ane column undi..ippudu naa req enti ante
find the same party_name with duplicate names but having different account_number?
nothing but same party_name undi different account_numbers unna party_names kavali? |
Archives - 2010