DBA Data[Home] [Help]

APPS.FV_FLATFILES dependencies on FV_FACTS_FOOTNOTE_LINES

Line 186: fv_facts_footnote_lines ffl,

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

Line 208: fv_facts_footnote_lines ffl,

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