[Home] [Help]
View: JA_CN_CFS_ROWS_V
View Text
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'