eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_DBCCARD_GRAPH_PVT dependencies on IBY_TRXN_SUMMARIES_ALL

Line 220: FROM iby_trxn_summaries_all

216: SELECT COUNT(*) totalTrxn,
217: -- DECODE(trxntypeid, 3, 2, 1) factor, -- Bug 3458221
218: DECODE(trxntypeid, 8, 0, 9, 0, 1) factor,
219: TO_NUMBER(TO_CHAR(updatedate, 'hh24')) hour
220: FROM iby_trxn_summaries_all
221: WHERE TRUNC(updatedate) = TRUNC(SYSDATE)
222: AND instrtype IN ('CREDITCARD', 'PURCHASECARD')
223: AND trxntypeid IN (2,3,5,8,9,10,11)
224: AND payeeid LIKE l_payeeId

Line 311: FROM iby_trxn_summaries_all

307: DECODE(trxntypeid, 5, -1, 8, 0, 9, 0, 10, -1, 11, -1, 1) factor,
308: COUNT(*) total_trxn,
309: SUM(amount) total_amt,
310: TRUNC(updatedate) trxndate
311: FROM iby_trxn_summaries_all
312: WHERE TRUNC(updatedate) > from_date
313: AND TRUNC(updatedate) <= to_date
314: AND trxntypeid IN (2,3,5,8,9,10,11)
315: AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)

Line 467: FROM iby_trxn_summaries_all a,

463: DECODE(a.trxntypeid, 5, -1, 8, 0, 9, 0, 10, -1, 11, -1, 1) factor,
464: COUNT(*) total_trxn,
465: SUM(a.amount) total_amt,
466: TRUNC(a.updatedate) trxndate
467: FROM iby_trxn_summaries_all a,
468: iby_bepinfo b
469: WHERE TRUNC(a.updatedate) > from_date
470: AND TRUNC(a.updatedate) <= to_date
471: AND a.trxntypeid IN (2,3,5,8,9,10,11)

Line 619: FROM iby_trxn_summaries_all

615: DECODE(trxntypeid, 5, -1, 8, 0, 9, 0, 10, -1, 11, -1, 1) factor,
616: COUNT(*) total_trxn,
617: SUM(amount) total_amt,
618: TRUNC(updatedate) trxndate
619: FROM iby_trxn_summaries_all
620: WHERE TRUNC(updatedate) > from_date
621: AND TRUNC(updatedate) <= TO_DATE
622: AND trxntypeid IN (2,3,5,8,9,10,11)
623: AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)

Line 768: FROM iby_trxn_summaries_all

764: DECODE(trxntypeid, 2, 'A', 3, 'B', 'C') factor,
765: COUNT(*) total_trxn,
766: SUM(amount) total_amt,
767: TRUNC(updatedate) trxndate
768: FROM iby_trxn_summaries_all
769: WHERE TRUNC(updatedate) >= from_date
770: AND TRUNC(updatedate) <= TO_DATE
771: AND trxntypeid IN (2,3,8,9)
772: AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)