APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on RG_REPORTS

Line 859: rg_reports r1,

855: SELECT amount_type
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

Line 893: rg_reports r1,

889: SELECT amount_type
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

Line 4312: FROM rg_reports r1

4308: ,'''||g_last_update_date||'''
4309: ,'||g_last_update_login||'
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||'

Line 4362: FROM rg_reports r1

4358: ,'''||g_last_update_date||'''
4359: ,'||g_last_update_login||'
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||'

Line 5938: FROM rg_reports

5934: END IF;
5935:
5936: SELECT row_set_id
5937: INTO l_row_set_id
5938: FROM rg_reports
5939: WHERE report_id =g_balance_statement_report_id;
5940:
5941: l_icx_num_format := NVL(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),',.');
5942:

Line 5953: FROM rg_reports r,

5949: /* SELECT fmt
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)

Line 6078: FROM rg_reports r1

6074: TRIM(TO_CHAR(l_amount,'99999999999999990D00','NLS_NUMERIC_CHARACTERS = '',.''')),
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)

Line 6218: FROM rg_reports

6214: END IF;
6215:
6216: SELECT row_set_id
6217: INTO l_row_set_id
6218: FROM rg_reports
6219: WHERE report_id =g_income_statement_report_id;
6220:
6221: l_icx_num_format :=fnd_profile.value('ICX_NUMERIC_CHARACTERS');
6222:

Line 6232: FROM rg_reports r,

6228: /* SELECT fmt
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)