View: CE_222_BATCHES_V

Product:	CE - Cash Management
Description:	Available AR remittance batches for reconciliation
Implementation/DBA Data:	APPS.CE_222_BATCHES_V

View Text

SELECT B.ROWID
, /* 1 */ 'N'
, /* 2 */ BA.BANK_ACCOUNT_ID
, /* 3 */ BA.BANK_ACCOUNT_NAME
, /* 4 */ B.BATCH_ID
, /* 5 */ NVL(B.BANK_DEPOSIT_NUMBER
, B.NAME)
, /* 6 */ L1.LOOKUP_CODE
, /* 7 */ L1.MEANING
, /* 8 */ B.BATCH_DATE
, /* 9 */ B.CURRENCY_CODE
, /* 10 */ TO_NUMBER(NULL)
, /* 11 */ TO_NUMBER(NULL)
, /* 12 */ TO_NUMBER(NULL)
, /* 13 */ TO_NUMBER(NULL)
, /* 14 */ B.GL_DATE
, /* 15 */ B.EXCHANGE_RATE_TYPE
, /* 16 */ DT.USER_CONVERSION_TYPE
, /* 17 */ B.EXCHANGE_DATE
, /* 18 */ B.EXCHANGE_RATE
, /* 19 */ TO_NUMBER(NULL)
, /* 20 */ TO_NUMBER(NULL)
, /* 21 */ B.CREATED_BY
, /* 22 */ B.CREATION_DATE
, /* 23 */ B.LAST_UPDATED_BY
, /* 24 */ B.LAST_UPDATE_DATE
, /* 25 */ TO_NUMBER(NULL)
, /* 26 */ B.BANK_DEPOSIT_NUMBER
, /* 27 */ 222
, /* 28 */ 0
, /* 29 */ BA.BANK_ACCOUNT_NUM
, /* 30 */ BANKPARTY.PARTY_NAME
, /* 31 */ BRANCHPARTY.PARTY_NAME
, /* 32 */ BA.CURRENCY_CODE
, /* 33 */ B.NAME
, /* 34 */ DECODE(B.CURRENCY_CODE
, /* 35 */ SOB.CURRENCY_CODE
, 'FUNCTIONAL'
, BA.CURRENCY_CODE
, 'BANK'
, 'FOREIGN')
, BAU.BANK_ACCT_USE_ID
, B.ORG_ID FROM CE_LOOKUPS L1
, GL_DAILY_CONVERSION_TYPES DT
, /*CE_BANK_BRANCHES_V BB
, */ HZ_PARTIES BANKPARTY
, HZ_PARTIES BRANCHPARTY
, CE_BANK_ACCOUNTS BA
, /*CE_BANK_ACCT_USES_OU_V BAU
, */ CE_BANK_ACCT_USES_ALL BAU
, AR_BATCHES_ALL B
, GL_SETS_OF_BOOKS SOB
, CE_SYSTEM_PARAMETERS SP
WHERE L1.LOOKUP_TYPE = 'BATCH_TYPE' AND L1.LOOKUP_CODE = 'RECEIPT' AND DT.CONVERSION_TYPE(+) = B.EXCHANGE_RATE_TYPE
AND BA.BANK_BRANCH_ID = BRANCHPARTY.PARTY_ID
AND BA.BANK_ID = BANKPARTY.PARTY_ID /*AND BB.BRANCH_PARTY_ID = BA.BANK_BRANCH_ID*/ AND BAU.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_ID
AND BAU.AR_USE_ENABLE_FLAG = 'Y' AND MO_GLOBAL.CHECK_ACCESS(BAU.ORG_ID) = 'Y'
AND SYSDATE <= NVL(BAU.END_DATE
, SYSDATE)
AND SYSDATE >= NVL(BA.START_DATE
, SYSDATE)
AND SYSDATE <= NVL(BA.END_DATE
, SYSDATE) AND B.REMIT_BANK_ACCT_USE_ID = BAU.BANK_ACCT_USE_ID AND B.ORG_ID = BAU.ORG_ID AND B.TYPE IN ('REMITTANCE'
, 'BR_REMITTANCE') AND B.BATCH_APPLIED_STATUS IN ('COMPLETED_APPROVAL'
, 'COMPLETED_FORMAT'
, 'STARTED_FORMAT') /*AND SP.ORG_ID = BAU.ORG_ID*/
AND BA.ACCOUNT_OWNER_ORG_ID = SP.LEGAL_ENTITY_ID AND SOB.SET_OF_BOOKS_ID = SP.SET_OF_BOOKS_ID

Columns