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_PVT dependencies on IBY_TRXN_SUMMARIES_ALL

Line 239: FROM iby_trxn_summaries_all

235: Status,
236: COUNT(*) total_trxn,
237: SUM(amount) total_amt,
238: TRUNC(updatedate) trxndate
239: FROM iby_trxn_summaries_all
240: WHERE TRUNC(updatedate) >= l_date
241: AND trxntypeid IN (2,3)
242: AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)
243: AND payeeid LIKE l_payeeId

Line 254: FROM iby_trxn_summaries_all

250: Status,
251: COUNT(*) total_trxn,
252: SUM(amount) total_amt,
253: TRUNC(updatedate) trxndate
254: FROM iby_trxn_summaries_all
255: WHERE TRUNC(updatedate) >= l_date
256: AND trxntypeid IN (3,8,9)
257: AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)
258: AND payeeid LIKE l_payeeId

Line 269: FROM iby_trxn_summaries_all

265: Status,
266: COUNT(*) total_trxn,
267: SUM(amount) total_amt,
268: TRUNC(updatedate) trxndate
269: FROM iby_trxn_summaries_all
270: WHERE TRUNC(updatedate) >= l_date
271: AND trxntypeid IN (5,10,11)
272: AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)
273: AND payeeid LIKE l_payeeId

Line 282: FROM iby_trxn_summaries_all

278: SELECT CurrencyNameCode currency,
279: COUNT(*) total_trxn,
280: SUM(amount) total_amt,
281: TRUNC(updatedate) trxndate
282: FROM iby_trxn_summaries_all
283: WHERE transactionid IN
284: (
285: SELECT transactionid
286: FROM iby_trxn_summaries_all

Line 286: FROM iby_trxn_summaries_all

282: FROM iby_trxn_summaries_all
283: WHERE transactionid IN
284: (
285: SELECT transactionid
286: FROM iby_trxn_summaries_all
287: WHERE instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)
288: AND status = 0
289: GROUP BY transactionid
290: HAVING COUNT(*) = 1

Line 628: FROM iby_trxn_summaries_all

624: Status,
625: COUNT(*) total_trxn,
626: SUM(amount) total_amt,
627: TRUNC(updatedate) trxndate
628: FROM iby_trxn_summaries_all
629: WHERE TRUNC(updatedate) >= l_date
630: AND trxntypeid IN (2,3)
631: AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)
632: AND payeeid LIKE l_payeeId

Line 643: FROM iby_trxn_summaries_all

639: Status,
640: COUNT(*) total_trxn,
641: SUM(amount) total_amt,
642: TRUNC(updatedate) trxndate
643: FROM iby_trxn_summaries_all
644: WHERE TRUNC(updatedate) >= l_date
645: AND trxntypeid IN (3,8,9)
646: AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)
647: AND payeeid LIKE l_payeeId

Line 864: FROM iby_trxn_summaries_all

860: DECODE(trxntypeid, 5, -1, 8, 0, 9, 0, 10, -1, 11, -1, 1) factor,
861: COUNT(*) total_trxn,
862: SUM(amount) total_amt,
863: TRUNC(updatedate) trxndate
864: FROM iby_trxn_summaries_all
865: WHERE TRUNC(updatedate) >= l_date
866: AND trxntypeid IN (2,3,5,8,9,10,11)
867: AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)
868: AND payeeid LIKE l_payeeId

Line 987: FROM iby_trxn_summaries_all a,

983: DECODE(a.trxntypeid, 5, -1, 8, 0, 9, 0, 10, -1, 11, -1, 1) factor,
984: COUNT(*) total_trxn,
985: SUM(a.amount) total_amt,
986: TRUNC(a.updatedate) trxndate
987: FROM iby_trxn_summaries_all a,
988: iby_bepinfo b
989: WHERE TRUNC(updatedate) >= l_date
990: AND a.trxntypeid IN (2,3,5,8,9,10,11)
991: AND a.instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)

Line 1113: FROM iby_trxn_summaries_all a,

1109: -- DECODE(a.trxntypeid, 3, 2, 1) factor, -- Bug 3306449
1110: -- DECODE(a.trxntypeid, 2, 0, 1) factor, -- Bug 3458221
1111: DECODE(a.trxntypeid, 8, 0, 9, 0, 1) factor,
1112: COUNT(*) total_trxn
1113: FROM iby_trxn_summaries_all a,
1114: iby_payee b
1115: WHERE TRUNC(updatedate) >= l_date
1116: AND trxntypeid IN (2,3,5,8,9,10,11)
1117: AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)