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 63: FROM fv_facts_temp fft,

59: -- -----------------------------------------------------------------------------------
60: ELSIF conc_prog = 'FVFCTHRC' THEN
61: statement :=
62: 'SELECT facts_report_info
63: FROM fv_facts_temp fft,
64: fv_facts_submission ffs,
65: fv_treasury_symbols fts
66: WHERE fft.treasury_symbol_id = ffs.treasury_symbol_id
67: AND fts.treasury_symbol_id = fft.treasury_symbol_id

Line 155: FROM fv_facts_temp fft,

151: -- -----------------------------------------------------------------------------------
152: ELSIF conc_prog = 'FVFCTDRC' THEN
153: statement :=
154: 'SELECT facts_report_info
155: FROM fv_facts_temp fft,
156: fv_facts_submission ffs,
157: fv_treasury_symbols fts
158: WHERE fft.treasury_symbol_id = ffs.treasury_symbol_id
159: AND fts.treasury_symbol_id = fft.treasury_symbol_id

Line 183: fv_facts_temp fft,

179: ||RPAD('' '', 17)||SUBSTR(fft.facts_report_info,143,1)
180: ||LPAD(TO_CHAR(ffl.footnote_seq_number),3,''0'')
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||

Line 219: fv_facts_temp fft

215:
216: SELECT LPAD(to_char(count(*)), 10, '0')
217: INTO v_trailer_count
218: FROM fv_facts_submission ffs ,
219: fv_facts_temp fft
220: WHERE fft.treasury_symbol_id = ffs.treasury_symbol_id
221: AND ffs.bulk_flag = 'Y'
222: AND fct_int_record_category = 'REPORTED_NEW'
223: AND ffs.Bulk_File_Sub_id = request_id