[Home] [Help]
View: JA_CN_CFS_ROW_SETS_V
View Text
SELECT DISTINCT RRAS.ROWID ROW_ID
,
RRAS.AXIS_SET_ID
,
RRAS.NAME ROW_SET_NAME
,
JCCA.CHART_OF_ACCOUNTS_ID
FROM JA_CN_CFS_ASSIGNMENTS_ALL JCCA
, RG_REPORT_AXIS_SETS RRAS
WHERE RRAS.AXIS_SET_TYPE = 'R'
AND JCCA.AXIS_SET_ID = RRAS.AXIS_SET_ID