Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to join price list tables with price strategy and customer site details

Received Response
22
Views
1
Comments
Mazher Shaikh
Mazher Shaikh Rank 1 - Community Starter
in Oracle Analytics Publisher

i have below tables from price list and price strategy

qp_price_list_items_int
,qp_price_list_charges
,qp_tier_lines
,qp_pricing_strategies_tl

I want above tables to be joined with below customer site and account tables
hz_cust_acct_sites_all
,hz_cust_site_uses_all

Let me know if there is any joining condition between these tables i want to fetch customer price lines details for my BIP report

Tagged:

Answers