eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_FLATFILES dependencies on FV_FACTS_TEMP

Line 64: FROM fv_facts_temp fft,

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

Line 156: FROM fv_facts_temp fft,

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

Line 184: fv_facts_temp fft,

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

Line 220: fv_facts_temp fft

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'
224: AND ffs.Bulk_File_Sub_id = request_id