APPS.AR_AUTOREC_API dependencies on IBY_TRXN_SUMMARIES_ALL

Line 2341: iby_trxn_summaries_all summ

2337: FROM ar_receipts_gt r,
2338: ar_cash_receipts cr,
2339: ar_cash_receipt_history crh,
2340: iby_fndcpt_tx_operations op,
2341: iby_trxn_summaries_all summ
2342: WHERE r.gt_id = p_gt_id
2343: AND cr.cash_receipt_id = r.cash_receipt_id
2344: AND crh.cash_receipt_id = cr.cash_receipt_id
2345: AND crh.status = 'CONFIRMED'

Line 2354: FROM iby_trxn_summaries_all

2350: AND summ.status IN(0, 100, 111)
2351: AND((trxntypeid IN(2, 3)) OR((trxntypeid = 20)
2352: AND(summ.trxnmid =
2353: (SELECT MAX(trxnmid)
2354: FROM iby_trxn_summaries_all
2355: WHERE transactionid = summ.transactionid
2356: AND(reqtype = 'ORAPMTREQ')
2357: AND(status IN(0, 100, 111))
2358: AND(trxntypeid = 20)))))

Line 2373: iby_trxn_summaries_all summ

2369: FROM ar_receipts_gt r,
2370: ar_cash_receipts cr,
2371: ar_cash_receipt_history crh,
2372: iby_fndcpt_tx_operations op,
2373: iby_trxn_summaries_all summ
2374: WHERE r.gt_id = p_gt_id
2375: AND cr.cash_receipt_id = r.cash_receipt_id
2376: AND crh.cash_receipt_id = cr.cash_receipt_id
2377: AND crh.status = 'CONFIRMED'

Line 2386: FROM iby_trxn_summaries_all

2382: AND summ.status IN(0, 100, 111)
2383: AND((trxntypeid IN(2, 3)) OR((trxntypeid = 20)
2384: AND(summ.trxnmid =
2385: (SELECT MAX(trxnmid)
2386: FROM iby_trxn_summaries_all
2387: WHERE transactionid = summ.transactionid
2388: AND(reqtype = 'ORAPMTREQ')
2389: AND(status IN(0, 100, 111))
2390: AND(trxntypeid = 20)))))

Line 5197: FROM iby_trxn_summaries_all summ,

5193: FROM ar_receipts_gt r,
5194: ar_cash_receipts cr,
5195: ar_cash_receipt_history crh,
5196: (SELECT op.trxn_extension_id, summ.status
5197: FROM iby_trxn_summaries_all summ,
5198: iby_fndcpt_tx_operations op
5199: WHERE(summ.transactionid = op.transactionid)
5200: AND(reqtype = 'ORAPMTREQ')
5201: AND(status IN(0, 100, 111, 31, 32))

Line 5205: FROM iby_trxn_summaries_all

5201: AND(status IN(0, 100, 111, 31, 32))
5202: AND((trxntypeid IN(2, 3)) OR((trxntypeid = 20)
5203: AND(summ.trxnmid =
5204: (SELECT MAX(trxnmid)
5205: FROM iby_trxn_summaries_all
5206: WHERE transactionid = summ.transactionid
5207: AND(reqtype = 'ORAPMTREQ')
5208: AND(status IN(0, 100, 111, 31, 32))
5209: AND(trxntypeid = 20)))))

Line 5257: FROM iby_trxn_summaries_all summ,

5253: FROM ar_receipts_gt r,
5254: ar_cash_receipts cr,
5255: ar_cash_receipt_history crh,
5256: (SELECT op.trxn_extension_id, summ.status
5257: FROM iby_trxn_summaries_all summ,
5258: iby_fndcpt_tx_operations op
5259: WHERE(summ.transactionid = op.transactionid)
5260: AND(reqtype = 'ORAPMTREQ')
5261: AND(status IN(0, 100, 111, 31, 32))

Line 5265: FROM iby_trxn_summaries_all

5261: AND(status IN(0, 100, 111, 31, 32))
5262: AND((trxntypeid IN(2, 3)) OR((trxntypeid = 20)
5263: AND(summ.trxnmid =
5264: (SELECT MAX(trxnmid)
5265: FROM iby_trxn_summaries_all
5266: WHERE transactionid = summ.transactionid
5267: AND(reqtype = 'ORAPMTREQ')
5268: AND(status IN(0, 100, 111, 31, 32))
5269: AND(trxntypeid = 20)))))