VIEW: APPS.QPR_HIERARCHIES_V

Source

View Text - Preformatted

SELECT a.hierarchy_id, a.price_plan_dim_id, a.price_plan_id, a.hierarchy_ppa_code||'_H', b.dim_code, a.default_flag, a.hier_type_code, a.hier_short_name, a.hier_long_name, a.hier_plural_name, a.calendar_code, a.hier_default_order FROM qpr_hierarchies a, qpr_dimensions b WHERE a.price_plan_dim_id=b.price_plan_dim_id

View Text - HTML Formatted

SELECT A.HIERARCHY_ID
, A.PRICE_PLAN_DIM_ID
, A.PRICE_PLAN_ID
, A.HIERARCHY_PPA_CODE||'_H'
, B.DIM_CODE
, A.DEFAULT_FLAG
, A.HIER_TYPE_CODE
, A.HIER_SHORT_NAME
, A.HIER_LONG_NAME
, A.HIER_PLURAL_NAME
, A.CALENDAR_CODE
, A.HIER_DEFAULT_ORDER
FROM QPR_HIERARCHIES A
, QPR_DIMENSIONS B
WHERE A.PRICE_PLAN_DIM_ID=B.PRICE_PLAN_DIM_ID