Receivables - EBS (MOSC)

MOSC Banner

A SQL Report that can provide customer name, address and whether statements are flagged for the cust

edited Apr 3, 2013 2:55AM in Receivables - EBS (MOSC) 4 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center