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