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.

VIEW: APPS.IBY_BATCHES_ALL_V

Source

View Text - Preformatted


SELECT bat.batchid merchbatchid, bat.batchstatus, pyee.name payeename, bat.batchclosedate, bep.name bepname, bat.vpsbatchid, bat.numtrxns, lk.meaning batchstate, bat.batchtotal, bat.batchsales, bat.batchcredit, bat.paymentmethodname, bat.org_id FROM IBY_BATCHES_ALL BAT,FND_LOOKUP_VALUES LK,IBY_PAYEE PYEE,IBY_BEPINFO BEP WHERE bat.bepid = bep.bepid(+) and bat.payeeid = pyee.payeeid(+) and bat.batchstateid = lk.lookup_code(+) and lk.lookup_type = 'IBY_BATCH_STATE' and language = userenv('LANG')

View Text - HTML Formatted

SELECT BAT.BATCHID MERCHBATCHID
, BAT.BATCHSTATUS
, PYEE.NAME PAYEENAME
, BAT.BATCHCLOSEDATE
, BEP.NAME BEPNAME
, BAT.VPSBATCHID
, BAT.NUMTRXNS
, LK.MEANING BATCHSTATE
, BAT.BATCHTOTAL
, BAT.BATCHSALES
, BAT.BATCHCREDIT
, BAT.PAYMENTMETHODNAME
, BAT.ORG_ID
FROM IBY_BATCHES_ALL BAT
, FND_LOOKUP_VALUES LK
, IBY_PAYEE PYEE
, IBY_BEPINFO BEP
WHERE BAT.BEPID = BEP.BEPID(+)
AND BAT.PAYEEID = PYEE.PAYEEID(+)
AND BAT.BATCHSTATEID = LK.LOOKUP_CODE(+)
AND LK.LOOKUP_TYPE = 'IBY_BATCH_STATE'
AND LANGUAGE = USERENV('LANG')