[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT(*) totalTrxn,
-- DECODE(trxntypeid, 3, 2, 1) factor, -- Bug 3458221
DECODE(trxntypeid, 8, 0, 9, 0, 1) factor,
TO_NUMBER(TO_CHAR(updatedate, 'hh24')) hour
FROM iby_trxn_summaries_all
WHERE TRUNC(updatedate) = TRUNC(SYSDATE)
AND instrtype IN ('CREDITCARD', 'PURCHASECARD')
AND trxntypeid IN (2,3,5,8,9,10,11)
AND payeeid LIKE l_payeeId
AND status IN
(-99,0,1,2,4,5,8,15,16,17,19,20,21,100,109,111,9999)
GROUP BY TO_CHAR(updatedate, 'hh24'),
-- DECODE(trxntypeid, 3, 2, 1) -- Bug 3458221
DECODE(trxntypeid, 8, 0, 9, 0, 1)
ORDER BY hour ASC;
SELECT CurrencyNameCode currency,
instrtype type,
-- DECODE(trxntypeid, 3, 2, 5,-1, 10, -1, 11, -1, 1) factor, -- Bug 3458221
DECODE(trxntypeid, 5, -1, 8, 0, 9, 0, 10, -1, 11, -1, 1) factor,
COUNT(*) total_trxn,
SUM(amount) total_amt,
TRUNC(updatedate) trxndate
FROM iby_trxn_summaries_all
WHERE TRUNC(updatedate) > from_date
AND TRUNC(updatedate) <= to_date
AND trxntypeid IN (2,3,5,8,9,10,11)
AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)
AND payeeid LIKE l_payeeId
AND status IN
(-99,0,1,2,4,5,8,15,16,17,19,20,21,100,109,111,9999)
GROUP BY instrtype,
-- DECODE(trxntypeid, 3, 2, 5,-1, 10, -1, 11, -1, 1), -- Bug 3458221
DECODE(trxntypeid, 5, -1, 8, 0, 9, 0, 10, -1, 11, -1, 1),
CurrencyNameCode, TRUNC(updatedate)
ORDER BY instrtype, TRUNC(updatedate) ASC;
SELECT a.CurrencyNameCode currency,
b.name TYPE,
-- DECODE(a.trxntypeid, 3, 2, 5,-1, 10, -1, 11, -1, 1) factor, -- Bug 3458221
DECODE(a.trxntypeid, 5, -1, 8, 0, 9, 0, 10, -1, 11, -1, 1) factor,
COUNT(*) total_trxn,
SUM(a.amount) total_amt,
TRUNC(a.updatedate) trxndate
FROM iby_trxn_summaries_all a,
iby_bepinfo b
WHERE TRUNC(a.updatedate) > from_date
AND TRUNC(a.updatedate) <= to_date
AND a.trxntypeid IN (2,3,5,8,9,10,11)
AND a.instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)
AND a.payeeid LIKE l_payeeId
AND a.bepid = b.bepid
AND a.status IN
(-99,0,1,2,4,5,8,15,16,17,19,20,21,100,109,111,9999)
GROUP BY b.name,
-- DECODE(a.trxntypeid, 3, 2, 5,-1, 10, -1, 11, -1, 1), -- Bug 3458221
DECODE(a.trxntypeid, 5, -1, 8, 0, 9, 0, 10, -1, 11, -1, 1),
a.CurrencyNameCode, TRUNC(a.updatedate)
ORDER BY b.name, TRUNC(a.updatedate) ASC;
SELECT CurrencyNameCode currency,
instrsubtype TYPE,
-- DECODE(trxntypeid, 3, 2, 5,-1, 10, -1, 11, -1, 1) factor, -- Bug 3458221
DECODE(trxntypeid, 5, -1, 8, 0, 9, 0, 10, -1, 11, -1, 1) factor,
COUNT(*) total_trxn,
SUM(amount) total_amt,
TRUNC(updatedate) trxndate
FROM iby_trxn_summaries_all
WHERE TRUNC(updatedate) > from_date
AND TRUNC(updatedate) <= TO_DATE
AND trxntypeid IN (2,3,5,8,9,10,11)
AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)
AND instrsubtype IS NOT NULL
AND payeeid LIKE l_payeeId
AND status IN
(-99,0,1,2,4,5,8,15,16,17,19,20,21,100,109,111,9999)
GROUP BY instrsubtype,
-- DECODE(trxntypeid, 3, 2, 5,-1, 10, -1, 11, -1, 1), -- Bug 3458221
DECODE(trxntypeid, 5, -1, 8, 0, 9, 0, 10, -1, 11, -1, 1),
CurrencyNameCode, TRUNC(updatedate)
ORDER BY instrsubtype, TRUNC(updatedate) ASC;
SELECT CurrencyNameCode currency,
DECODE(trxntypeid, 2, 'A', 3, 'B', 'C') factor,
COUNT(*) total_trxn,
SUM(amount) total_amt,
TRUNC(updatedate) trxndate
FROM iby_trxn_summaries_all
WHERE TRUNC(updatedate) >= from_date
AND TRUNC(updatedate) <= TO_DATE
AND trxntypeid IN (2,3,8,9)
AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)
AND payeeid LIKE l_payeeId
AND status IN
(-99,1,2,4,5,8,15,16,17,19,20,21,9999)
GROUP BY DECODE(trxntypeid, 2, 'A', 3, 'B', 'C'),
CurrencyNameCode, TRUNC(updatedate)
ORDER BY TRUNC(updatedate) ASC;