SELECT A.DIM_ATTR_ID, A.PRICE_PLAN_DIM_ID, A.PRICE_PLAN_ID, A.ATTR_PPA_CODE, B.DIM_CODE, A.ATTR_SHORT_NAME, A.ATTR_LONG_NAME, A.ATTR_PLURAL_NAME, A.ATTR_DATA_TYPE, A.ATTR_CLASSIFICATION, A.DEFAULT_ORDER_FLAG FROM QPR_DIM_ATTRIBUTES A, QPR_DIMENSIONS B WHERE A.PRICE_PLAN_DIM_ID = B.PRICE_PLAN_DIM_ID
SELECT A.DIM_ATTR_ID
, A.PRICE_PLAN_DIM_ID
, A.PRICE_PLAN_ID
, A.ATTR_PPA_CODE
, B.DIM_CODE
, A.ATTR_SHORT_NAME
, A.ATTR_LONG_NAME
, A.ATTR_PLURAL_NAME
, A.ATTR_DATA_TYPE
, A.ATTR_CLASSIFICATION
, A.DEFAULT_ORDER_FLAG
FROM QPR_DIM_ATTRIBUTES A
, QPR_DIMENSIONS B
WHERE A.PRICE_PLAN_DIM_ID = B.PRICE_PLAN_DIM_ID
|
|
|