APPS.AR_AUTOREC_API dependencies on IBY_TRXN_SUMMARIES_ALL

Line 4398: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

4394: AND crh.current_record_flag = 'Y'
4395: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
4396: AND trxn_ext.authorized_flag = 'N'
4397: AND NOT EXISTS (SELECT 'x'
4398: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
4399: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
4400: AND op.transactionid = summ.transactionid
4401: AND summ.reqtype in ('ORAPMTREQ','ORAPMTBATCHREQ')
4402: AND summ.status IN(0, 11, 100))

Line 4447: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

4443: AND crh.current_record_flag = 'Y'
4444: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
4445: AND trxn_ext.authorized_flag = 'N'
4446: AND NOT EXISTS (SELECT 'x'
4447: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
4448: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
4449: AND op.transactionid = summ.transactionid
4450: AND summ.reqtype in ('ORAPMTREQ','ORAPMTBATCHREQ')
4451: AND summ.status IN(0, 11, 100));

Line 4507: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

4503: AND crh.current_record_flag = 'Y'
4504: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
4505: AND trxn_ext.authorized_flag = 'Y'
4506: AND EXISTS (SELECT 'x'
4507: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
4508: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
4509: AND op.transactionid = summ.transactionid
4510: AND summ.reqtype in ('ORAPMTREQ','ORAPMTBATCHREQ')
4511: AND summ.status IN(0, 11, 100))

Line 4530: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

4526: AND crh.current_record_flag = 'Y'
4527: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
4528: AND trxn_ext.authorized_flag = 'Y'
4529: AND EXISTS (SELECT 'x'
4530: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
4531: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
4532: AND op.transactionid = summ.transactionid
4533: AND summ.reqtype in ('ORAPMTREQ','ORAPMTBATCHREQ')
4534: AND summ.status IN(0, 11, 100))