SELECT name , name , null , to_number(null) , receipt_method_id FROM ar_receipt_methods union select name, description, type, cust_trx_type_id, to_number(null) from ra_cust_trx_types
View Text - HTML Formatted
SELECT NAME , NAME , NULL , TO_NUMBER(NULL) , RECEIPT_METHOD_ID FROM AR_RECEIPT_METHODS UNION SELECT NAME , DESCRIPTION , TYPE , CUST_TRX_TYPE_ID , TO_NUMBER(NULL) FROM RA_CUST_TRX_TYPES