[Home] [Help]
60: ELSIF conc_prog = 'FVFCTHRC' THEN
61: statement :=
62: 'SELECT facts_report_info
63: FROM fv_facts_temp fft,
64: fv_facts_submission ffs,
65: fv_treasury_symbols fts
66: WHERE fft.treasury_symbol_id = ffs.treasury_symbol_id
67: AND fts.treasury_symbol_id = fft.treasury_symbol_id
68: AND ffs.bulk_flag = ''Y''
80: fv_flatfiles.create_flat_file(statement);
81:
82: statement :=
83: 'SELECT ''TRL'' || LPAD(to_char(count(*)), 10, ''0'') || LPAD('' '', 403)
84: FROM fv_facts_submission ffs
85: WHERE ffs.bulk_flag = ''Y''
86: AND ffs.Bulk_File_Sub_Id = '||request_id||
87: ' AND ffs.set_of_books_id = '||sob_id ;
88:
152: ELSIF conc_prog = 'FVFCTDRC' THEN
153: statement :=
154: 'SELECT facts_report_info
155: FROM fv_facts_temp fft,
156: fv_facts_submission ffs,
157: fv_treasury_symbols fts
158: WHERE fft.treasury_symbol_id = ffs.treasury_symbol_id
159: AND fts.treasury_symbol_id = fft.treasury_symbol_id
160: AND ffs.bulk_flag = ''Y''
178: ||''F''||SUBSTR(fft.facts_report_info,52,74)
179: ||RPAD('' '', 17)||SUBSTR(fft.facts_report_info,143,1)
180: ||LPAD(TO_CHAR(ffl.footnote_seq_number),3,''0'')
181: ||RPAD(ffl.footnote_text,255)
182: FROM fv_facts_submission ffs,
183: fv_facts_temp fft,
184: fv_facts_footnote_hdr ffh,
185: fv_facts_footnote_lines ffl,
186: fv_treasury_symbols fts
204: SELECT LPAD(to_char(count(*)), 10, '0')
205: INTO v_footnote_count
206: FROM fv_facts_footnote_hdr ffh,
207: fv_facts_footnote_lines ffl,
208: fv_facts_submission ffs
209: WHERE ffh.footnote_header_id = ffl.footnote_header_id
210: AND ffh.treasury_symbol_id = ffs.treasury_symbol_id
211: AND ffs.Bulk_File_Sub_id = request_id
212: AND ffs.set_of_books_id = sob_id
214: AND ffs.bulk_flag = 'Y';
215:
216: SELECT LPAD(to_char(count(*)), 10, '0')
217: INTO v_trailer_count
218: FROM fv_facts_submission ffs ,
219: fv_facts_temp fft
220: WHERE fft.treasury_symbol_id = ffs.treasury_symbol_id
221: AND ffs.bulk_flag = 'Y'
222: AND fct_int_record_category = 'REPORTED_NEW'