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
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
|
|
|