View: JE_NL_EFT_BATCHES_V

View Text

SELECT JNEB.ROWID ROW_ID
, JNEB.BATCH_ID BATCH_ID
, JNEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JNEB.LAST_UPDATED_BY LAST_UPDATED_BY
, JNEB.CHECKRUN_NAME CHECKRUN_NAME
, TRUNC(JNEB.DATE_CREATED) DATE_CREATED
, JNEB.BATCH_FORMAT BATCH_FORMAT
, JNEB.MEDIUM_ID MEDIUM_ID
, JNEB.MEDIUM_SEQNO MEDIUM_SEQNO
, JNEB.PAYER_BANK_ACCOUNT PAYER_BANK_ACCOUNT
, JNEB.TOT_BANK_ACCOUNTS TOT_BANK_ACCOUNTS
, JNEB.TOT_PAYMENT_AMOUNT TOT_PAYMENT_AMOUNT
, JNEB.TOT_PAYMENTS TOT_PAYMENTS
, JNEB.TOT_RECORDS TOT_RECORDS
, JNEB.NO_OF_CANCELLATIONS NO_OF_CANCELLATIONS
, JNEB.FIRST_PAYMENT_NUMBER FIRST_PAYMENT_NUMBER
, JNEB.LAST_PAYMENT_NUMBER LAST_PAYMENT_NUMBER
, JNEB.CREATION_DATE CREATION_DATE
, JNEB.CREATED_BY CREATED_BY
, JNEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ISC.STATUS STATUS
, ISC.CHECK_DATE CHECK_DATE
, BA.BANK_ACCOUNT_NUM BANK_NUMBER
, CF.NAME PAYMENT_FORMAT
, BB.BANK_NAME BANK_NAME
, BA.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, ISC.CURRENCY_CODE CURRENCY_CODE
, L.MEANING MEDIUM_TYPE
, M.MEDIUM_IDENTIFICATION MEDIUM_IDENTIFICATION
, TRUNC(M.DATE_GENERATED) DATE_GENERATED
, M.DATE_DUPLICATE DATE_DUPLICATE
, M.DATE_SENT DATE_SENT
FROM JE_NL_EFT_BATCHES JNEB
, AP_BANK_BRANCHES BB
, AP_BANK_ACCOUNTS BA
, AP_CHECK_FORMATS CF
, AP_CHECK_STOCKS CS
, AP_INVOICE_SELECTION_CRITERIA ISC
, FND_LOOKUPS L
, JE_NL_EFT_MEDIA M
WHERE ISC.CHECKRUN_NAME = JNEB.CHECKRUN_NAME
AND CS.CHECK_STOCK_ID = ISC.CHECK_STOCK_ID
AND CF.CHECK_FORMAT_ID = CS.CHECK_FORMAT_ID
AND BA.BANK_ACCOUNT_ID = CS. BANK_ACCOUNT_ID
AND BB.BANK_BRANCH_ID = BA.BANK_BRANCH_ID
AND M.MEDIUM_ID(+) = JNEB.MEDIUM_ID
AND L.LOOKUP_CODE (+) = M.MEDIUM_TYPE
AND L.LOOKUP_TYPE (+) = 'JENL_MEDIUMCODE'

Columns