APPS.AR_AUTOREM_API dependencies on IBY_TRXN_SUMMARIES_ALL

Line 3815: FROM iby_trxn_summaries_all summ,

3811: IBY_AR_UTILS.get_authorization_status(l_payment_trxn_extension_id,l_auth_flag);
3812:
3813: /* SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG
3814: into l_auth_flag
3815: FROM iby_trxn_summaries_all summ,
3816: iby_fndcpt_tx_operations op
3817: WHERE summ.transactionid = op.transactionid
3818: AND reqtype = 'ORAPMTREQ'
3819: AND status IN(0, 100)

Line 3824: FROM iby_trxn_summaries_all

3820: AND trxntypeid IN(2, 3, 20)
3821: AND op.trxn_extension_id = l_payment_trxn_extension_id
3822: AND summ.trxnmid =
3823: (SELECT MAX(trxnmid)
3824: FROM iby_trxn_summaries_all
3825: WHERE transactionid = summ.transactionid
3826: AND reqtype = 'ORAPMTREQ'
3827: AND status IN(0, 100)
3828: AND trxntypeid IN(2, 3, 20)); */

Line 4561: FROM iby_trxn_summaries_all summ,

4557: IBY_AR_UTILS.get_authorization_status(l_payment_trxn_extension_id,l_auth_flag);
4558:
4559: /* SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG
4560: into l_auth_flag
4561: FROM iby_trxn_summaries_all summ,
4562: iby_fndcpt_tx_operations op
4563: WHERE summ.transactionid = op.transactionid
4564: AND reqtype = 'ORAPMTREQ'
4565: AND status IN(0, 100)

Line 4570: FROM iby_trxn_summaries_all

4566: AND trxntypeid IN(2, 3, 20)
4567: AND op.trxn_extension_id = l_payment_trxn_extension_id
4568: AND summ.trxnmid =
4569: (SELECT MAX(trxnmid)
4570: FROM iby_trxn_summaries_all
4571: WHERE transactionid = summ.transactionid
4572: AND reqtype = 'ORAPMTREQ'
4573: AND status IN(0, 100)
4574: AND trxntypeid IN(2, 3, 20)); */

Line 5472: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

5468: AND cr.type = 'CASH'
5469: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
5470: AND trxn_ext.settled_flag = 'N'
5471: AND NOT EXISTS (SELECT 'x'
5472: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
5473: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
5474: AND op.transactionid = summ.transactionid
5475: AND summ.reqtype in ('ORAPMTCAPTURE','ORAPMTBATCHREQ')
5476: AND summ.status IN(0, 11, 100))

Line 5524: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

5520: AND cr.type = 'CASH'
5521: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
5522: AND trxn_ext.settled_flag = 'N'
5523: AND NOT EXISTS (SELECT 'x'
5524: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
5525: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
5526: AND op.transactionid = summ.transactionid
5527: AND summ.reqtype in ('ORAPMTCAPTURE','ORAPMTBATCHREQ')
5528: AND summ.status IN(0, 11, 100));

Line 5553: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

5549: AND cr.type = 'MISC'
5550: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
5551: AND trxn_ext.returned_flag = 'N'
5552: AND NOT EXISTS (SELECT 'x'
5553: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
5554: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
5555: AND op.transactionid = summ.transactionid
5556: AND summ.reqtype in ('ORAPMTRETURN','ORAPMTCREDIT')
5557: AND status IN(0, 11, 100))

Line 5605: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

5601: AND cr.type = 'MISC'
5602: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
5603: AND trxn_ext.returned_flag = 'N'
5604: AND NOT EXISTS (SELECT 'x'
5605: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
5606: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
5607: AND op.transactionid = summ.transactionid
5608: AND summ.reqtype in ('ORAPMTRETURN','ORAPMTCREDIT')
5609: AND status IN(0, 11, 100));

Line 5653: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

5649: AND crh.current_record_flag = 'Y'
5650: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
5651: AND trxn_ext.settled_flag = 'Y'
5652: AND EXISTS (SELECT 'x'
5653: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
5654: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
5655: AND op.transactionid = summ.transactionid
5656: AND summ.reqtype in ('ORAPMTCAPTURE','ORAPMTBATCHREQ')
5657: AND summ.status IN(0, 11, 100))

Line 5680: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ

5676: AND crh.current_record_flag = 'Y'
5677: AND cr.payment_trxn_extension_id = trxn_ext.trxn_extension_id
5678: AND trxn_ext.returned_flag = 'Y'
5679: AND EXISTS (SELECT 'x'
5680: FROM iby_fndcpt_tx_operations op, iby_trxn_summaries_all summ
5681: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
5682: AND op.transactionid = summ.transactionid
5683: AND summ.reqtype in ('ORAPMTRETURN','ORAPMTCREDIT')
5684: AND status IN(0, 11, 100))