Sunday, August 28, 2016

R12 SQL Query to differentiate Customer and Suppliers Data

QUERY TO CHECK CUSTOMER AND SUPPLIER DATA 

select * from (
select hp.party_number,hp.party_name,hp.status,decode(nvl(hpu.party_usage_code,hp.party_type),'ORGANIZATION','CUSTOMER',nvl(hpu.party_usage_code,hp.party_type)) party_type 
from  apps.HZ_PARTY_USG_ASSIGNMENTS hpu, hz_parties hp
where hp.party_id = hpu.party_id(+))
order by party_type;


No comments:

Post a Comment

If your Chrome browser is opening new tabs with random content

If your Chrome browser is opening new tabs with random content, it may be due to adware, a browser hijacker, or an extension that you didn...