View: IBY_BATCHES_ALL_V

Product:	IBY - Payments
Description:	View used to work with batch transactions.
Implementation/DBA Data:	APPS.IBY_BATCHES_ALL_V

View Text

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')

Columns