DBA Data[Home] [Help]

VIEW: APPS.CSM_HZ_STYLE_FMT_VARIATION_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, B.STYLE_FORMAT_CODE, B.VARIATION_NUMBER, B.VARIATION_RANK, B.SELECTION_CONDITION FROM CSM_HZ_STYLE_FMT_VARIATION_ACC ACC, HZ_STYLE_FMT_VARIATIONS B WHERE B.STYLE_FORMAT_CODE=ACC.STYLE_FORMAT_CODE AND B.VARIATION_NUMBER=ACC.VARIATION_NUMBER AND B.VARIATION_RANK=ACC.VARIATION_RANK
View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.STYLE_FORMAT_CODE
, B.VARIATION_NUMBER
, B.VARIATION_RANK
, B.SELECTION_CONDITION
FROM CSM_HZ_STYLE_FMT_VARIATION_ACC ACC
, HZ_STYLE_FMT_VARIATIONS B
WHERE B.STYLE_FORMAT_CODE=ACC.STYLE_FORMAT_CODE
AND B.VARIATION_NUMBER=ACC.VARIATION_NUMBER
AND B.VARIATION_RANK=ACC.VARIATION_RANK