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