[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT SUBSTR(lv_added_zero || TO_CHAR(CASA.AXIS_SEQ),
LENGTH(TO_CHAR(CASA.AXIS_SEQ))+1,
LENGTH(lv_added_zero || TO_CHAR(CASA.AXIS_SEQ))) AS CFI_NUM, --Cash Flow Item Number
RRA.DESCRIPTION AS CFI_NAME, --Cash Flow Item Name.
RRA.DESCRIPTION AS CFI_DESC, --Cash Flow Item Description
'1' AS IS_LAST_LEVEL, --Is the Last Level
'1' AS CFI_LEVEL, --Cash Flow Item Level
'' AS PARENT_CFI_LEVEL, --Parent Cash Flow Item Number
DECODE(CASA.ITEM_SOURCE, --Cash Flow Item Source
'Main Statement',
'1',
'Supplementary Schedule',
'0',
NULL) AS CFI_SOURCE,
DECODE(CASA.ITEM_ATTRIBUTE,
'Inflow',
'1',
'Outflow',
'0',
'Others',
'2',
' ') AS CFI_ATTRIBUTE --Cash Flow Item Attribute
FROM RG_REPORT_AXES RRA,
JA_CN_CFS_ASSIGN_SUP_ALL CASA,
RG_REPORTS RP
WHERE RRA.AXIS_SET_ID = CASA.AXIS_SET_ID
AND RRA.AXIS_SEQ = CASA.AXIS_SEQ
AND RRA.AXIS_SET_ID = RP.ROW_SET_ID --CFS Row set id
AND CASA.CHART_OF_ACCOUNTS_ID = pn_chart_of_account_id --parameter: pn_chart_of_account_id
AND RP.REPORT_ID = pn_cfs_report_id --parameter: pn_cfs_report_id
ORDER BY CFI_NUM; --Added for fixing bug# 9771082
SELECT MAX(LENGTH(RRA.AXIS_SEQ))
INTO ln_max_length
FROM RG_REPORT_AXES RRA, RG_REPORTS RP
WHERE RP.ROW_SET_ID = RRA.AXIS_SET_ID
AND RP.REPORT_ID = pn_cfs_report_id; --parameter: pn_cfs_report_id
SELECT RP.NAME
INTO lv_report_name
FROM RG_REPORTS RP
WHERE RP.REPORT_ID = pn_cfs_report_id; --parameter: pn_cfs_report_id