eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on RG_REPORT_AXES

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 5899: l_row_name rg_report_axes.description%TYPE;

5895: l_amount_in_char VARCHAR2(30);
5896: l_acct_type NUMBER;
5897: l_prev_acct_type NUMBER:= 0;
5898: l_row_set_name rg_report_axis_sets.name%TYPE;
5899: l_row_name rg_report_axes.description%TYPE;
5900: acct_low NUMBER;
5901: acct_high NUMBER;
5902: l_row_set_id NUMBER;
5903: l_acct_axis_seq VARCHAR2(10);

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 6079: ,rg_report_axes r2

6075: '|',
6076: decode(l_amount_sign,-1,'C','D'), --field7
6077: '|'
6078: FROM rg_reports r1
6079: ,rg_report_axes r2
6080: WHERE r1.report_id = g_balance_statement_report_id
6081: AND r1.row_set_id = r2.axis_set_id
6082: AND r2.axis_seq = J100_rec.field8)
6083: WHERE request_id = g_concurrent_request_id

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; */

Line 6297: FROM rg_report_axes r2

6293: TRIM(TO_CHAR(l_amount,'99999999999999990D00','NLS_NUMERIC_CHARACTERS = '',.''')),
6294: '|',
6295: decode(l_amount_sign,-1,'R','D'), --field6
6296: '|'
6297: FROM rg_report_axes r2
6298: WHERE r2.axis_set_id = l_row_set_id
6299: AND r2.axis_seq = J150_rec.field8
6300: AND ROWNUM = 1) --There may exist multiple records in rg_report_contents for a axis_set_id and axis_seq
6301: WHERE request_id = g_concurrent_request_id

Line 6319: FROM rg_report_axes r2

6315: TRIM(TO_CHAR(l_amount,'99999999999999990D00','NLS_NUMERIC_CHARACTERS = '',.''')),
6316: '|',
6317: decode(l_amount_sign,-1,'P','N'), --field6
6318: '|'
6319: FROM rg_report_axes r2
6320: WHERE r2.axis_set_id = l_row_set_id
6321: AND r2.axis_seq = J150_rec.field8
6322: AND ROWNUM = 1) --There may exist multiple records in rg_report_calculations for a axis_set_id and axis_seq
6323: WHERE request_id = g_concurrent_request_id