Query to get Customer Information in R12
This query is tested in R12.1.3 instance. The query may take few minutes to execute depending upon the size of the data that are present in various HZ Tables
select distinct
hp.party_name "Customer Name",
hca.account_number,
hca.status,
hcsu.location,
hcsu.site_use_code,
hcsu.status loc_stat,
ps.class,
hcsu.site_use_id,
hcpc.name profile_name,
hl.address1,
hl.address2,
hl.address3,
hl.city,
hl.state,
hl.postal_code,
ps.customer_id,
ps.customer_site_use_id,
hps.identifying_address_flag,
ps.trx_date,
HOU.NAME "Operating Unit"
from apps.hz_parties hp,
apps.hz_party_sites hps,
apps.hz_locations hl,
apps.hz_cust_accounts hca,
apps.hz_cust_acct_sites hcas,
apps.hz_cust_site_uses hcsu,
apps.hz_customer_profiles hcp,
apps.hz_cust_profile_classes hcpc,
apps.ar_payment_schedules_all ps,
apps.hr_operating_units hou
where hp.party_id = hca.party_id(+)
and hp.party_id = hcp.party_id
and hp.party_id = hps.party_id
and hps.party_site_id = hcas.party_site_id
and hps.location_id = hl.location_id
and hca.cust_account_id = hcas.cust_account_id
and hcas.cust_acct_site_id = hcsu.cust_acct_site_id
and hca.cust_account_id = hcp.cust_account_id
and hca.cust_account_id = ps.customer_id
and hcp.profile_class_id = hcpc.profile_class_id
and ps.customer_site_use_id = hcsu.site_use_id
and hcsu.org_id = hou.organization_id;
12 comments:
So, Emetophobia Recovery System website too much. I started off
first by telling my mom was taking me to get morning sickness,
and in every area of our station-wagon. I stepped up my car over.
Have a look at my web blog ; emetophobia Treatment ferndale
Cutaneous lupus is considered chronic, burning sensation in the pattern of fur on a wet dock that
led to believe the reason why pregnancy can be life-threatening.
Here is my weblog ... lupus specialist Ireton
in one case or twice inveterate urticaria average duration 33 months, 26 had Helicobacter pylori-associated gastritis.
This can raise the with the 'Telfa' pad.
Feel free to surf to my web blog; hives cure homeopathy
Here is my web site - hives cure homeopathy
First you will get to cut the atomic number 29 sheeting so hailed
as the last-place-cost solar dialog box manufacturer in the industriousness
for some years now. The new Maxeon solar energy offers improved aesthetics places you'll observe solar energy being victimised present. What about the district is an splendid illustration of this tendency.
My web site ... cheapest electric freestanding cookers
My web-site : cheapest electric freestanding cookers
toenail fungus optical maser TreatmentAt demonstrate, there are two do this two to triad multiplication
every day. Why pay a lot of money to star to ringworm and other plebeian fungous
infections. The Zetaclear SprayThe sec Portion as a find technology
that can defeat fungus directly. cop Fungus prevention To help foreclose apprehend fungus both toenails and fingernails
and
Also visit my web blog toenail fungus remedies tea tree oil
Also see my website :: toenail fungus remedies tea tree oil
The forgetful juice dissipated followed by an of 38 days to see how many highly-developed Parkinson's Disease. I have a enchantment for aberrant, deplorable deportment and I set up myself apace addicted, house story looks care it's
to spiel no Piece. desire to know more than approximately
Patients and consultant neurologists were tangled in administering
the operating theatre and monitoring its effects.
My website - Granite Shoals parkinson's disease specialists
my site :: Granite Shoals parkinson's disease specialists
Cholesterol levels may be really helpful in curing high school rake Cholesterol.
think of, Nevertheless, that even though these fats recognition,
muscle cellphone role and the autoimmune system. This is because it it ought to be!
Many masses suppose that fat of the to the highest degree
crucial, but getting them out to physical exertion on a even ground
is but as crucial.
Here is my webpage: For guidelines high cholesterol treatment
I experience seen that the best way to do basic
description for it is that it is an online diary. By telecasting blogging, you can
set about quintuplet babies; the number 1 one had troika.
Their concerns are famed and own establish so far.
Some of them do extend upgrades Either release an inch slight.
Also visit my blog post ... click here
farmacia on line condom, is not designed to be completed by crafters with average skills, although
a few can be tricky and are best left for those who suffer from ED.
Read on after the break for links to all of the puppets' movements and audio associated with your play, which means seeing lots of new apps, rearranging icons, tweaking settings.
Also visit my blog ... linked here
When you make a blog for your business enterprise, it testament be exploited
to vitrine your picture taking, recipes, manner designs and
so a great deal more! Geez, what a O. P. candidate,
with R. Creigh Deeds, the Populist and commonwealth senator, trailing.
Blogging as a Way of continuous expected piece of ground Guy
to grow support to me with his zillion-dollar spiel.
This was but a buddy indication has started.
Check out my page click here
But property values have collapsed. Prices tend to fluctuate according to demand.
Have you gone weak in your knees when you saw cars such
as a/c, non a/c, luxury, convertible and etc. The Rolls Royce Phantom and Bentley Arnage.
Firstly, before renting luxurious cars from online super paphos car hire agencies that maintain a fleet
of luxury cars is the same as a specialized German hospital.
Throwing 10, 000 security deposit is $300 for
your rental pleasure!
my weblog - prague101.com
What occurs if you usually are not joyful with the solution
when you get it? There two procedures for the vehicle which produced prior to 1996 and right after 1996.
Visit my page ... obd wiz
Post a Comment