SELECT JCCA.ROWID ROW_ID,
JCCA.CHART_OF_ACCOUNTS_ID,
JCCA.AXIS_SET_ID,
JCCA.AXIS_SEQ,
RRAS.NAME ROW_SET_NAME,
RRA.DESCRIPTION ROW_ITEM
FROM JA_CN_CFS_ASSIGNMENTS_ALL JCCA,
RG_REPORT_AXIS_SETS RRAS,
RG_REPORT_AXES RRA
WHERE JCCA.AXIS_SET_ID = RRAS.AXIS_SET_ID
AND JCCA.AXIS_SET_ID = RRA.AXIS_SET_ID
AND JCCA.AXIS_SEQ = RRA.AXIS_SEQ
AND RRAS.AXIS_SET_TYPE ='R'
SELECT JCCA.ROWID ROW_ID
,
JCCA.CHART_OF_ACCOUNTS_ID
,
JCCA.AXIS_SET_ID
,
JCCA.AXIS_SEQ
,
RRAS.NAME ROW_SET_NAME
,
RRA.DESCRIPTION ROW_ITEM
FROM JA_CN_CFS_ASSIGNMENTS_ALL JCCA
,
RG_REPORT_AXIS_SETS RRAS
,
RG_REPORT_AXES RRA
WHERE JCCA.AXIS_SET_ID = RRAS.AXIS_SET_ID
AND JCCA.AXIS_SET_ID = RRA.AXIS_SET_ID
AND JCCA.AXIS_SEQ = RRA.AXIS_SEQ
AND RRAS.AXIS_SET_TYPE ='R'
|
|
|