DBA Data[Home] [Help]

APPS.IBY_SCHED dependencies on IBY_TRXN_CORE

Line 213: SELECT /*+ NO_EXPAND use_nl(B C) INDEX (C IBY_TRXN_CORE_TRXNMID_U1)*/

209: -- Bug# 9397208
210: -- Bug# 13540887
211: -- Adding 11, 100, 111 to the statuses
212: CURSOR c_trans_core (cin_ecappid in iby_ecapp.ecappid%type) IS
213: SELECT /*+ NO_EXPAND use_nl(B C) INDEX (C IBY_TRXN_CORE_TRXNMID_U1)*/
214: b.transactionid,
215: b.status,
216: b.updatedate,
217: b.reqtype,

Line 221: iby_trxn_core c

217: b.reqtype,
218: c.referencecode,
219: b.trxnmid
220: FROM iby_trxn_summaries_all b,
221: iby_trxn_core c
222: WHERE(b.trxnmid = c.trxnmid)
223: AND b.reqtype <> 'ORAPMTREQ'
224: AND b.status not in (1, 0, 11, 100, 111)
225: AND b.needsupdt IN ('Y','F')