DBA Data[Home] [Help]

APPS.ARP_PROCESS_PAYINFO dependencies on IBY_TRXN_SUMMARIES_ALL

Line 320: FROM iby_trxn_summaries_all summ,

316: (SELECT /*+ leading(op) use_nl(summ,seft,ueft) */
317: op.trxn_extension_id,
318: decode(decode(summ.status, 0, 'Y', 100, 'Y', NULL), 'N', 'Y') authorized_flag,
319: nvl(seft.settle_require_vrfy_flag, 'N') settle_req_auth_flag
320: FROM iby_trxn_summaries_all summ,
321: iby_fndcpt_tx_operations op,
322: iby_fndcpt_sys_eft_pf_b seft,
323: iby_fndcpt_user_eft_pf_b ueft
324: WHERE(summ.transactionid = op.transactionid)