Query 4 Maret 2013 - RSPI

Post date: Mar 04, 2013 10:47:16 AM

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-Feb-2013' AND '28-Feb-2013'

ORDER BY a.je_header_id, a.default_effective_date

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-Feb-2013' AND '28-Feb-2013'

ORDER BY segment2

/* Formatted on 2013/03/04 14:37 (Formatter Plus v4.8.8) */

-- Tanggal 2 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '02-Feb-2013' AND '02-Feb-2013'

and segment2='11030240'

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '02-Feb-2013' AND '02-Feb-2013'

and segment2='11030291'

--Tanggal 4 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '04-Feb-2013' AND '04-Feb-2013'

and segment2='11030240'

--Tanggal 5 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '05-Feb-2013' AND '05-Feb-2013'

and segment2='11030240'

-- Tanggal 6 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '06-Feb-2013' AND '06-Feb-2013'

and segment2='11030230'

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '06-Feb-2013' AND '06-Feb-2013'

and segment2='11030250'

-- Tanggal 7 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '07-Feb-2013' AND '07-Feb-2013'

and segment2='11030240'

-- Tanggal 9 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '09-Feb-2013' AND '09-Feb-2013'

and segment2='11030210'

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '09-Feb-2013' AND '09-Feb-2013'

and segment2='11030260'

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '09-Feb-2013' AND '09-Feb-2013'

and segment2='11030280'

-- Tanggal 10 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '10-Feb-2013' AND '10-Feb-2013'

and segment2='11030260'

-- Tanggal 11 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '11-Feb-2013' AND '11-Feb-2013'

and segment2='11030240'

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '11-Feb-2013' AND '11-Feb-2013'

and segment2='11030292'

-- Tanggal 12 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '12-Feb-2013' AND '12-Feb-2013'

and segment2='11030210'

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '12-Feb-2013' AND '12-Feb-2013'

and segment2='11030250'

-- Tanggal 13 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '13-Feb-2013' AND '13-Feb-2013'

and segment2='11030230'

-- Tanggal 14 February 2013

-- Ada transaksi yang seharusnya tidak jadi invoice credit card (140213.C-BCA21)

-- Tanggal 21 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '21-Feb-2013' AND '21-Feb-2013'

-- and segment2='11030230'

-- Tanggal 22 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '22-Feb-2013' AND '22-Feb-2013'

-- Tanggal 23 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '23-Feb-2013' AND '23-Feb-2013'

-- Tanggal 24 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '24-Feb-2013' AND '24-Feb-2013'

-- Tanggal 25 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '25-Feb-2013' AND '25-Feb-2013'

-- Tanggal 26 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '26-Feb-2013' AND '26-Feb-2013'

-- Tanggal 27 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '27-Feb-2013' AND '27-Feb-2013'

-- Tanggal 28 Feb 2013

SELECT rowid,gt.*

FROM gl_transactions gt

WHERE segment1 = '01'

AND segment2 LIKE '110302%'

AND accounting_date BETWEEN '28-Feb-2013' AND '28-Feb-2013'

-- Backup Table RA_INTERFACE_LINES_ALL setelah itu transfer ulang

create table rila_04032013 as

select *

from ra_interface_lines_all

where gl_date between ('01-Feb-2013') and ('28-Feb-2013')

and set_of_books_id='1'

-- DELETE ISI TABLE RILA

delete ra_interface_lines_all

where gl_date between ('01-Feb-2013') and ('28-Feb-2013')

and set_of_books_id='1'