SELECT DISTINCT 'TANDA TERIMA PT.'||F.BOOK_INITIAL AS BOOK_INITIAL, F.BOOK_COMPANY_NAME, A.CREATED_BY, F.BOOK_CODE, B.CUST_CODE,
D.CUST_NAME, A.TTF_NO_PRINT, C.KWITANSI_NO, G.PREFIX_NAME, NVL(C.INVOICE_NO_PRINT,A.INVOICE_NO) INVOICE_NO_PRINT,
C.TAX_NO, E.SJ_NO, C.SDO_NO,
(CASE WHEN A.TTF_DOC_TYPE_ID = '16' THEN A.INVOICE_DATE