SQL statements for Datastores
Summary
What are the concrete SQL statements for an Datastore and what kind of joins are used for joining relevant database tables?Content
Hello,
we are looking for the concrete SQL statements, which are used for getting the data of an datastore. Especially we need to know how multiple database tables are joined (inner/outer joins?).
For example the datastore Opportunity (CrmAnalyticsAM.OpportunityAM.Opportunity) uses multiple tables like MOO_OPTY, MOO_REVN, HZ_PARTIES, ... This information can be found in the mapping spreadsheet R13.19A CX OTBI Subject Area Database Mapping.xlsx, which was posted by Ling Xiang (https://cloudcustomerconnect.oracle.com/posts/38c32f731c
4