DBA Data[Home] [Help]

APPS.FV_FLATFILES dependencies on FV_FACTS_FOOTNOTE_HDR

Line 185: fv_facts_footnote_hdr ffh,

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

Line 207: FROM fv_facts_footnote_hdr ffh,

203:
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