APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on RG_REPORT_AXES_V

Line 860: rg_report_axes_v r2

856: INTO l_fsg_output_check
857: FROM (SELECT r2.*
858: FROM fnd_concurrent_requests req,
859: rg_reports r1,
860: rg_report_axes_v r2
861: WHERE req.request_id = g_balance_statement_request_id
862: AND r1.report_id = req.argument7 --arguement7 in fnd_concurrent_requests holds the report id
863: AND r1.column_set_id = r2.axis_set_id
864: ORDER BY r2.sequence)

Line 894: rg_report_axes_v r2

890: INTO l_fsg_output_check
891: FROM (SELECT r2.*
892: FROM fnd_concurrent_requests req,
893: rg_reports r1,
894: rg_report_axes_v r2
895: WHERE req.request_id = g_income_statement_request_id
896: AND r1.report_id = req.argument7 --arguement7 in fnd_concurrent_requests holds the report id
897: AND r1.column_set_id = r2.axis_set_id
898: ORDER BY r2.sequence)

Line 4263: l_bal_agglutination_code rg_report_axes_v.description%TYPE;

4259: return;
4260: END register_I051;
4261:
4262: PROCEDURE register_I052(p_account_flex_value fnd_flex_values.flex_value%TYPE) AS
4263: l_bal_agglutination_code rg_report_axes_v.description%TYPE;
4264: l_income_agglutination_code rg_report_axes_v.description%TYPE;
4265: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I052';
4266: sql_stmt VARCHAR2(5000);
4267: BEGIN

Line 4264: l_income_agglutination_code rg_report_axes_v.description%TYPE;

4260: END register_I051;
4261:
4262: PROCEDURE register_I052(p_account_flex_value fnd_flex_values.flex_value%TYPE) AS
4263: l_bal_agglutination_code rg_report_axes_v.description%TYPE;
4264: l_income_agglutination_code rg_report_axes_v.description%TYPE;
4265: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I052';
4266: sql_stmt VARCHAR2(5000);
4267: BEGIN
4268:

Line 4314: ,rg_report_axes_v r3

4310: FROM
4311: (SELECT DECODE('''||g_agglutination_code_source||''',''FSG_LINE'',to_char(r3.sequence),r3.description) row_seq_ident
4312: FROM rg_reports r1
4313: ,rg_report_axis_sets r2
4314: ,rg_report_axes_v r3
4315: ,rg_report_axis_contents r4
4316: WHERE r1.report_id = '||g_balance_statement_report_id||'
4317: AND r1.row_set_id = r2.axis_set_id
4318: AND r2.axis_set_id = r3.axis_set_id

Line 4364: ,rg_report_axes_v r3

4360: FROM
4361: (SELECT DECODE('''||g_agglutination_code_source||''',''FSG_LINE'',to_char(r3.sequence),r3.description) row_seq_ident
4362: FROM rg_reports r1
4363: ,rg_report_axis_sets r2
4364: ,rg_report_axes_v r3
4365: ,rg_report_axis_contents r4
4366: WHERE r1.report_id = '||g_income_statement_report_id||'
4367: AND r1.row_set_id = r2.axis_set_id
4368: AND r2.axis_set_id = r3.axis_set_id

Line 5954: rg_report_axes_v ra

5950: INTO l_format
5951: FROM (SELECT nvl2(ra.display_format,decode(instr(ra.display_format,'.'),0,'999,999,999,999',
5952: '999,999,999,999.9999'),'999,999,999,999.9999') fmt
5953: FROM rg_reports r,
5954: rg_report_axes_v ra
5955: WHERE r.report_id =g_balance_statement_report_id
5956: AND r.column_set_id =ra.axis_set_id
5957: ORDER BY ra.sequence)
5958: WHERE ROWNUM=1; */

Line 6233: rg_report_axes_v ra

6229: INTO l_format
6230: FROM (SELECT nvl2(ra.display_format,decode(instr(ra.display_format,'.'),0,'999,999,999,999',
6231: '999,999,999,999.9999'),'999,999,999,999.9999') fmt
6232: FROM rg_reports r,
6233: rg_report_axes_v ra
6234: WHERE r.report_id =g_income_statement_report_id
6235: AND r.column_set_id =ra.axis_set_id
6236: ORDER BY ra.sequence)
6237: WHERE ROWNUM=1; */