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.

[Home] [Help]

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 624: FROM iby_trxn_summaries_all

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

Line 639: FROM iby_trxn_summaries_all

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

Line 856: FROM iby_trxn_summaries_all

852: DECODE(trxntypeid, 5, -1, 8, 0, 9, 0, 10, -1, 11, -1, 1) factor,
853: COUNT(*) total_trxn,
854: SUM(amount) total_amt,
855: TRUNC(updatedate) trxndate
856: FROM iby_trxn_summaries_all
857: WHERE TRUNC(updatedate) >= l_date
858: AND trxntypeid IN (2,3,5,8,9,10,11)
859: AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)
860: AND payeeid LIKE l_payeeId

Line 975: FROM iby_trxn_summaries_all a,

971: DECODE(a.trxntypeid, 5, -1, 8, 0, 9, 0, 10, -1, 11, -1, 1) factor,
972: COUNT(*) total_trxn,
973: SUM(a.amount) total_amt,
974: TRUNC(a.updatedate) trxndate
975: FROM iby_trxn_summaries_all a,
976: iby_bepinfo b
977: WHERE TRUNC(updatedate) >= l_date
978: AND a.trxntypeid IN (2,3,5,8,9,10,11)
979: AND a.instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)

Line 1097: FROM iby_trxn_summaries_all a,

1093: -- DECODE(a.trxntypeid, 3, 2, 1) factor, -- Bug 3306449
1094: -- DECODE(a.trxntypeid, 2, 0, 1) factor, -- Bug 3458221
1095: DECODE(a.trxntypeid, 8, 0, 9, 0, 1) factor,
1096: COUNT(*) total_trxn
1097: FROM iby_trxn_summaries_all a,
1098: iby_payee b
1099: WHERE TRUNC(updatedate) >= l_date
1100: AND trxntypeid IN (2,3,5,8,9,10,11)
1101: AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)