eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IBY_MERGE dependencies on IBY_FNDCPT_TX_OPERATIONS

Line 346: ,iby_fndcpt_tx_operations o

342: AND instr_assignment_id IS NOT NULL
343: AND ( EXISTS (
344: SELECT 1
345: FROM iby_trxn_summaries_all s
346: ,iby_fndcpt_tx_operations o
347: WHERE o.trxn_extension_id = dup.trxn_extension_id
348: AND s.transactionid = o.transactionid
349: AND s.reqtype IN ('ORAPMTREQ','ORAPMTBATCHREQ')
350: AND s.status <> 0 )

Line 353: Select 1 from iby_fndcpt_tx_operations o

349: AND s.reqtype IN ('ORAPMTREQ','ORAPMTBATCHREQ')
350: AND s.status <> 0 )
351: OR NOT EXISTS
352: (
353: Select 1 from iby_fndcpt_tx_operations o
354: where o.trxn_extension_id = dup.trxn_extension_id
355: )
356: )
357: AND EXISTS

Line 393: ,iby_fndcpt_tx_operations o

389: AND instr_assignment_id IS NOT NULL
390: AND ( EXISTS (
391: SELECT 1
392: FROM iby_trxn_summaries_all s
393: ,iby_fndcpt_tx_operations o
394: WHERE o.trxn_extension_id = dup.trxn_extension_id
395: AND s.transactionid = o.transactionid
396: AND s.reqtype IN ('ORAPMTREQ','ORAPMTBATCHREQ')
397: AND s.status <> 0 )

Line 400: Select 1 from iby_fndcpt_tx_operations o

396: AND s.reqtype IN ('ORAPMTREQ','ORAPMTBATCHREQ')
397: AND s.status <> 0 )
398: OR NOT EXISTS
399: (
400: Select 1 from iby_fndcpt_tx_operations o
401: where o.trxn_extension_id = dup.trxn_extension_id
402: )
403: )
404: AND EXISTS

Line 446: ,iby_fndcpt_tx_operations o

442: AND instr_assignment_id IS NOT NULL
443: AND ( EXISTS (
444: SELECT 1
445: FROM iby_trxn_summaries_all s
446: ,iby_fndcpt_tx_operations o
447: WHERE o.trxn_extension_id = dup.trxn_extension_id
448: AND s.transactionid = o.transactionid
449: AND s.reqtype IN ('ORAPMTREQ','ORAPMTBATCHREQ')
450: AND s.status <> 0 )

Line 453: Select 1 from iby_fndcpt_tx_operations o

449: AND s.reqtype IN ('ORAPMTREQ','ORAPMTBATCHREQ')
450: AND s.status <> 0 )
451: OR NOT EXISTS
452: (
453: Select 1 from iby_fndcpt_tx_operations o
454: where o.trxn_extension_id = dup.trxn_extension_id
455: )
456: )
457: AND EXISTS

Line 486: ,iby_fndcpt_tx_operations o

482: AND
483: ( EXISTS (
484: SELECT 1
485: FROM iby_trxn_summaries_all s
486: ,iby_fndcpt_tx_operations o
487: WHERE o.trxn_extension_id = dup.trxn_extension_id
488: AND s.transactionid = o.transactionid
489: AND s.reqtype IN ('ORAPMTREQ','ORAPMTBATCHREQ')
490: AND s.status <> 0 )

Line 493: Select 1 from iby_fndcpt_tx_operations o

489: AND s.reqtype IN ('ORAPMTREQ','ORAPMTBATCHREQ')
490: AND s.status <> 0 )
491: OR NOT EXISTS
492: (
493: Select 1 from iby_fndcpt_tx_operations o
494: where o.trxn_extension_id = dup.trxn_extension_id
495: )
496: );
497: