A SQL Report that can provide customer name, address and whether statements are flagged for the cust
We're using 11i and a client has requested a report that provides the customer name and the address their organization uses and whether the customer has "send statements" flagged or not. I've tried creating a sql to get this information but seem to have run into issues. The table HZ_CUSTOMER_PROFILES seems to be the only table that contains the Statement Information. We have different Orgs using the same customer but not always the same address and some addresses are 'for shipping' only. So I've identified the Site_Use_Id field that links to HZ_CUST_SITE_USE_ALL table and I've located the other tables that
0