DBA Data[Home] [Help]

APPS.FV_FLATFILES dependencies on FV_FACTS_FOOTNOTE_LINES

Line 185: fv_facts_footnote_lines ffl,

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
187: WHERE ffs.set_of_books_id = '||sob_id||
188: ' AND ffs.bulk_file_sub_id = '||request_id||
189: ' AND ffs.bulk_flag = ''Y''

Line 207: fv_facts_footnote_lines ffl,

203: -- count the footnotes to print in the trailer record
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