556: -- Select creditors tin
557: -- ---------------------------------------------------
558: SELECT distinct rpad(replace(creditors_tin,'-',''),9) ct
559: INTO v_creditors_tin
560: FROM fv_1099c;
561:
562: -- ---------------------------------------------------
563: -- Create Creditor/Transmitter 'A' Record
564: -- ---------------------------------------------------
628: ||''000000000000000''
629: ||''000000000000000''
630: ||''000000000000000''
631: ||lpad('' '',275)
632: FROM fv_1099c
633: WHERE amount > invoice_minimum
634: AND reportable_flag = ''Y''
635: AND set_of_books_id = sob_id';
636: