DBA Data[Home] [Help]

APPS.AR_ECAPP_PKG dependencies on IBY_TRXN_SUMMARIES_ALL

Line 118: ar_settlement_errors_gt gt, iby_trxn_summaries_all summ,

114: CURSOR C1 IS
115: SELECT cr.cash_receipt_id, cr.receipt_number, cr.org_id,
116: summ.bepcode, summ.bepmessage, summ.instrtype
117: FROM ar_cash_receipts_all cr, ar_cash_receipt_history_all crh ,
118: ar_settlement_errors_gt gt, iby_trxn_summaries_all summ,
119: iby_fndcpt_tx_operations op
120: WHERE gt.req_type in ('ORAPMTCAPTURE', 'ORAPMTRETURN', 'ORAPMTCREDIT', 'ORAPMTVOID', 'ORAPMTBATCHREQ')
121: AND summ.transactionid = gt.txn_id
122: AND summ.reqtype = gt.req_type

Line 136: FROM iby_trxn_summaries_all summ_in

132: WHERE gt_in.txn_id = gt.txn_id
133: AND gt_in.status = 0)
134: AND summ.rowid IN
135: (SELECT max(rowid)
136: FROM iby_trxn_summaries_all summ_in
137: WHERE summ.transactionid = summ_in.transactionid
138: AND summ_in.status not in (1, 0))
139: ORDER by cr.org_id, cr.cash_receipt_id;
140: