[Home] [Help]
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
Name |
MERCHBATCHID |
BATCHSTATUS |
PAYEENAME |
BATCHCLOSEDATE |
BEPNAME |
VPSBATCHID |
NUMTRXNS |
BATCHSTATE |
BATCHTOTAL |
BATCHSALES |
BATCHCREDIT |
PAYMENTMETHODNAME |
ORG_ID |