DBA Data[Home] [Help]

APPS.FV_FLATFILES dependencies on FV_1099C

Line 447: FROM fv_1099c;

443: -- Select creditors tin
444: -- ---------------------------------------------------
445: SELECT distinct rpad(replace(creditors_tin,'-',''),9) ct
446: INTO v_creditors_tin
447: FROM fv_1099c;
448:
449: -- ---------------------------------------------------
450: -- Create Creditor/Transmitter 'A' Record
451: -- ---------------------------------------------------

Line 519: FROM fv_1099c

515: ||''000000000000000''
516: ||''000000000000000''
517: ||''000000000000000''
518: ||lpad('' '',275)
519: FROM fv_1099c
520: WHERE amount > invoice_minimum
521: AND reportable_flag = ''Y''
522: AND set_of_books_id = sob_id';
523: