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_SCHED dependencies on IBY_TRANS_BANKACCT_V

Line 243: SELECT iby_trans_bankacct_v.TRANSACTIONID,

239: AND iby_trans_fi_v.ecappid = cin_ecappid;
240:
241: /* Bug# 10192851
242: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
243: SELECT iby_trans_bankacct_v.TRANSACTIONID,
244: iby_trans_bankacct_v.STATUS,
245: iby_trans_bankacct_v.UPDATEDATE,
246: iby_trans_bankacct_v.REQTYPE,
247: iby_trans_bankacct_v.REFERENCECODE,

Line 244: iby_trans_bankacct_v.STATUS,

240:
241: /* Bug# 10192851
242: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
243: SELECT iby_trans_bankacct_v.TRANSACTIONID,
244: iby_trans_bankacct_v.STATUS,
245: iby_trans_bankacct_v.UPDATEDATE,
246: iby_trans_bankacct_v.REQTYPE,
247: iby_trans_bankacct_v.REFERENCECODE,
248: iby_trans_bankacct_v.TRXNMID

Line 245: iby_trans_bankacct_v.UPDATEDATE,

241: /* Bug# 10192851
242: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
243: SELECT iby_trans_bankacct_v.TRANSACTIONID,
244: iby_trans_bankacct_v.STATUS,
245: iby_trans_bankacct_v.UPDATEDATE,
246: iby_trans_bankacct_v.REQTYPE,
247: iby_trans_bankacct_v.REFERENCECODE,
248: iby_trans_bankacct_v.TRXNMID
249: FROM iby_trans_bankacct_v

Line 246: iby_trans_bankacct_v.REQTYPE,

242: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
243: SELECT iby_trans_bankacct_v.TRANSACTIONID,
244: iby_trans_bankacct_v.STATUS,
245: iby_trans_bankacct_v.UPDATEDATE,
246: iby_trans_bankacct_v.REQTYPE,
247: iby_trans_bankacct_v.REFERENCECODE,
248: iby_trans_bankacct_v.TRXNMID
249: FROM iby_trans_bankacct_v
250: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')

Line 247: iby_trans_bankacct_v.REFERENCECODE,

243: SELECT iby_trans_bankacct_v.TRANSACTIONID,
244: iby_trans_bankacct_v.STATUS,
245: iby_trans_bankacct_v.UPDATEDATE,
246: iby_trans_bankacct_v.REQTYPE,
247: iby_trans_bankacct_v.REFERENCECODE,
248: iby_trans_bankacct_v.TRXNMID
249: FROM iby_trans_bankacct_v
250: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
251: AND iby_trans_bankacct_v.reqtype <> 'ORAPMTREQ'

Line 248: iby_trans_bankacct_v.TRXNMID

244: iby_trans_bankacct_v.STATUS,
245: iby_trans_bankacct_v.UPDATEDATE,
246: iby_trans_bankacct_v.REQTYPE,
247: iby_trans_bankacct_v.REFERENCECODE,
248: iby_trans_bankacct_v.TRXNMID
249: FROM iby_trans_bankacct_v
250: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
251: AND iby_trans_bankacct_v.reqtype <> 'ORAPMTREQ'
252: AND iby_trans_bankacct_v.status <> 0

Line 249: FROM iby_trans_bankacct_v

245: iby_trans_bankacct_v.UPDATEDATE,
246: iby_trans_bankacct_v.REQTYPE,
247: iby_trans_bankacct_v.REFERENCECODE,
248: iby_trans_bankacct_v.TRXNMID
249: FROM iby_trans_bankacct_v
250: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
251: AND iby_trans_bankacct_v.reqtype <> 'ORAPMTREQ'
252: AND iby_trans_bankacct_v.status <> 0
253: AND iby_trans_bankacct_v.ecappid = cin_ecappid;

Line 250: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')

246: iby_trans_bankacct_v.REQTYPE,
247: iby_trans_bankacct_v.REFERENCECODE,
248: iby_trans_bankacct_v.TRXNMID
249: FROM iby_trans_bankacct_v
250: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
251: AND iby_trans_bankacct_v.reqtype <> 'ORAPMTREQ'
252: AND iby_trans_bankacct_v.status <> 0
253: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
254: */

Line 251: AND iby_trans_bankacct_v.reqtype <> 'ORAPMTREQ'

247: iby_trans_bankacct_v.REFERENCECODE,
248: iby_trans_bankacct_v.TRXNMID
249: FROM iby_trans_bankacct_v
250: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
251: AND iby_trans_bankacct_v.reqtype <> 'ORAPMTREQ'
252: AND iby_trans_bankacct_v.status <> 0
253: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
254: */
255:

Line 252: AND iby_trans_bankacct_v.status <> 0

248: iby_trans_bankacct_v.TRXNMID
249: FROM iby_trans_bankacct_v
250: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
251: AND iby_trans_bankacct_v.reqtype <> 'ORAPMTREQ'
252: AND iby_trans_bankacct_v.status <> 0
253: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
254: */
255:
256: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS

Line 253: AND iby_trans_bankacct_v.ecappid = cin_ecappid;

249: FROM iby_trans_bankacct_v
250: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
251: AND iby_trans_bankacct_v.reqtype <> 'ORAPMTREQ'
252: AND iby_trans_bankacct_v.status <> 0
253: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
254: */
255:
256: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
257: SELECT trxn.TRANSACTIONID,

Line 518: SELECT iby_trans_bankacct_v.TRANSACTIONID,

514:
515: -- r_trans_fi c_trans_fi%ROWTYPE;
516:
517: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
518: SELECT iby_trans_bankacct_v.TRANSACTIONID,
519: iby_trans_bankacct_v.STATUS,
520: iby_trans_bankacct_v.UPDATEDATE,
521: iby_trans_bankacct_v.REQTYPE,
522: iby_trans_bankacct_v.REFERENCECODE,

Line 519: iby_trans_bankacct_v.STATUS,

515: -- r_trans_fi c_trans_fi%ROWTYPE;
516:
517: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
518: SELECT iby_trans_bankacct_v.TRANSACTIONID,
519: iby_trans_bankacct_v.STATUS,
520: iby_trans_bankacct_v.UPDATEDATE,
521: iby_trans_bankacct_v.REQTYPE,
522: iby_trans_bankacct_v.REFERENCECODE,
523: iby_trans_bankacct_v.TRXNMID

Line 520: iby_trans_bankacct_v.UPDATEDATE,

516:
517: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
518: SELECT iby_trans_bankacct_v.TRANSACTIONID,
519: iby_trans_bankacct_v.STATUS,
520: iby_trans_bankacct_v.UPDATEDATE,
521: iby_trans_bankacct_v.REQTYPE,
522: iby_trans_bankacct_v.REFERENCECODE,
523: iby_trans_bankacct_v.TRXNMID
524: FROM iby_trans_bankacct_v

Line 521: iby_trans_bankacct_v.REQTYPE,

517: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
518: SELECT iby_trans_bankacct_v.TRANSACTIONID,
519: iby_trans_bankacct_v.STATUS,
520: iby_trans_bankacct_v.UPDATEDATE,
521: iby_trans_bankacct_v.REQTYPE,
522: iby_trans_bankacct_v.REFERENCECODE,
523: iby_trans_bankacct_v.TRXNMID
524: FROM iby_trans_bankacct_v
525: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')

Line 522: iby_trans_bankacct_v.REFERENCECODE,

518: SELECT iby_trans_bankacct_v.TRANSACTIONID,
519: iby_trans_bankacct_v.STATUS,
520: iby_trans_bankacct_v.UPDATEDATE,
521: iby_trans_bankacct_v.REQTYPE,
522: iby_trans_bankacct_v.REFERENCECODE,
523: iby_trans_bankacct_v.TRXNMID
524: FROM iby_trans_bankacct_v
525: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
526: AND iby_trans_bankacct_v.ecappid = cin_ecappid;

Line 523: iby_trans_bankacct_v.TRXNMID

519: iby_trans_bankacct_v.STATUS,
520: iby_trans_bankacct_v.UPDATEDATE,
521: iby_trans_bankacct_v.REQTYPE,
522: iby_trans_bankacct_v.REFERENCECODE,
523: iby_trans_bankacct_v.TRXNMID
524: FROM iby_trans_bankacct_v
525: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
526: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
527:

Line 524: FROM iby_trans_bankacct_v

520: iby_trans_bankacct_v.UPDATEDATE,
521: iby_trans_bankacct_v.REQTYPE,
522: iby_trans_bankacct_v.REFERENCECODE,
523: iby_trans_bankacct_v.TRXNMID
524: FROM iby_trans_bankacct_v
525: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
526: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
527:
528: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;

Line 525: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')

521: iby_trans_bankacct_v.REQTYPE,
522: iby_trans_bankacct_v.REFERENCECODE,
523: iby_trans_bankacct_v.TRXNMID
524: FROM iby_trans_bankacct_v
525: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
526: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
527:
528: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;
529:

Line 526: AND iby_trans_bankacct_v.ecappid = cin_ecappid;

522: iby_trans_bankacct_v.REFERENCECODE,
523: iby_trans_bankacct_v.TRXNMID
524: FROM iby_trans_bankacct_v
525: WHERE iby_trans_bankacct_v.needsupdt IN ('Y','F')
526: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
527:
528: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;
529:
530: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS