Post date: Jan 16, 2013 7:21:8 AM
/* Formatted on 2012/04/17 18:57 (Formatter Plus v4.8.8) */ SELECT * FROM gl_transactions WHERE accounting_date BETWEEN ('1-Mar-2012') AND ('31-Mar-2012') AND segment1 = '01' --GL_JE_LINES /* Formatted on 2012/04/17 18:50 (Formatter Plus v4.8.8) */ SELECT a.je_header_id, b.je_line_num, a.NAME, a.je_source, a.je_category, a.default_effective_date, b.description, b.accounted_dr, b.accounted_cr FROM gl_je_headers a, gl_je_lines b WHERE a.je_header_id = b.je_header_id AND a.status = 'P' AND a.ledger_id = '1' AND b.code_combination_id = 1047 AND a.default_effective_date BETWEEN '01-Mar-2012' AND '29-Mar-2012' ORDER BY a.je_header_id, a.default_effective_date --GL_TRANSACTION /* Formatted on 2012/04/17 18:53 (Formatter Plus v4.8.8) */ SELECT accounting_date, user_je_category_name, segment1, segment2, entered_dr, entered_cr, attribute3 FROM gl_transactions WHERE segment1 = '01' AND segment2 LIKE '110302%' AND accounting_date BETWEEN '01-Mar-2012' AND '31-Mar-2012' ORDER BY segment2 --GL_CODE_COMBINATIONS /* Formatted on 2012/04/17 18:55 (Formatter Plus v4.8.8) */ SELECT * FROM gl_code_combinations WHERE code_combination_id = 1047 --PONDOK -- WHERE code_combination_id = 15810 --PURI /* Formatted on 2012/04/17 18:56 (Formatter Plus v4.8.8) */ SELECT SUM (b.accounted_dr), SUM (b.accounted_cr) FROM gl_je_headers a, gl_je_lines b WHERE a.je_header_id = b.je_header_id AND a.status = 'P' AND a.ledger_id = '21' AND b.code_combination_id = 15810 -- and a.je_category Like'%AD%' AND a.default_effective_date BETWEEN '01-Mar-2012' AND '31-Mar-2012' ORDER BY a.je_header_id, a.default_effective_date