72: IS
73: SELECT trns.value,
74: books.book_type_code
75: FROM okl_sgn_translations trns,
76: fa_book_controls books
77: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
78: AND trns.object1_id1 = books.book_type_code
79: AND books.book_type_code = Book
80: AND trns.sgn_code = 'STMP';
73: SELECT trns.value,
74: books.book_type_code
75: FROM okl_sgn_translations trns,
76: fa_book_controls books
77: WHERE trns.jtot_object1_code = 'FA_BOOK_CONTROLS'
78: AND trns.object1_id1 = books.book_type_code
79: AND books.book_type_code = Book
80: AND trns.sgn_code = 'STMP';
81: -- Get the transaction types