APPS.AR_AUTOREM_API dependencies on IBY_TRXN_SUMMARIES_ALL

Line 5779: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

5775: AND cr.type = 'CASH'
5776: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
5777: AND trxn_ext.settled_flag = 'N'
5778: AND NOT EXISTS (SELECT 'x'
5779: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
5780: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
5781: AND op.transactionid = summ.transactionid
5782: AND summ.reqtype in ('ORAPMTCAPTURE','ORAPMTBATCHREQ')
5783: AND summ.status IN(0, 11, 100, 111))

Line 5831: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

5827: AND cr.type = 'CASH'
5828: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
5829: AND trxn_ext.settled_flag = 'N'
5830: AND NOT EXISTS (SELECT 'x'
5831: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
5832: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
5833: AND op.transactionid = summ.transactionid
5834: AND summ.reqtype in ('ORAPMTCAPTURE','ORAPMTBATCHREQ')
5835: AND summ.status IN(0, 11, 100, 111));

Line 5860: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

5856: AND cr.type = 'MISC'
5857: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
5858: AND trxn_ext.returned_flag = 'N'
5859: AND NOT EXISTS (SELECT 'x'
5860: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
5861: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
5862: AND op.transactionid = summ.transactionid
5863: AND summ.reqtype in ('ORAPMTRETURN','ORAPMTCREDIT')
5864: AND status IN(0, 11, 100, 111))

Line 5912: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

5908: AND cr.type = 'MISC'
5909: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
5910: AND trxn_ext.returned_flag = 'N'
5911: AND NOT EXISTS (SELECT 'x'
5912: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
5913: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
5914: AND op.transactionid = summ.transactionid
5915: AND summ.reqtype in ('ORAPMTRETURN','ORAPMTCREDIT')
5916: AND status IN(0, 11, 100, 111));

Line 5960: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

5956: AND crh.current_record_flag = 'Y'
5957: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
5958: AND trxn_ext.settled_flag = 'Y'
5959: AND EXISTS (SELECT 'x'
5960: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
5961: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
5962: AND op.transactionid = summ.transactionid
5963: AND summ.reqtype in ('ORAPMTCAPTURE','ORAPMTBATCHREQ')
5964: AND summ.status IN(0, 11, 100, 111))

Line 5987: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

5983: AND crh.current_record_flag = 'Y'
5984: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
5985: AND trxn_ext.returned_flag = 'Y'
5986: AND EXISTS (SELECT 'x'
5987: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
5988: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
5989: AND op.transactionid = summ.transactionid
5990: AND summ.reqtype in ('ORAPMTRETURN','ORAPMTCREDIT')
5991: AND status IN(0, 11, 100, 111))