Product: | CE - Cash Management |
---|---|
Description: | Available batches for reconciliation |
Implementation/DBA Data: | APPS.CE_AVAILABLE_BATCHES_V |
SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ BANK_ACCOUNT_ID
, /* 3 */ BANK_ACCOUNT_NAME
, /* 4 */ BATCH_ID
, /* 5 */ TRX_NUMBER
, /* 6 */ TRX_TYPE
, /* 7 */ TYPE_MEANING
, /* 8 */ TRX_DATE
, /* 9 */ CURRENCY_CODE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ ACTUAL_AMOUNT_CLEARED
, /* 14 */ GL_DATE
, /* 15 */ EXCHANGE_RATE_TYPE
, /* 16 */ USER_EXCHANGE_RATE_TYPE
, /* 17 */ EXCHANGE_RATE_DATE
, /* 18 */ EXCHANGE_RATE
, /* 19 */ BANK_CHARGES
, /* 20 */ BANK_ERRORS
, /* 21 */ CREATED_BY
, /* 22 */ CREATION_DATE
, /* 23 */ LAST_UPDATED_BY
, /* 24 */ LAST_UPDATE_DATE
, /* 25 */ CLEARED_AMOUNT
, /* 26 */ REMITTANCE_NUMBER
, /* 27 */ APPLICATION_ID
, /* 28 */ COUNT_CLEARED
, /* 29 */ BANK_ACCOUNT_NUM
, /* 30 */ BANK_NAME
, /* 31 */ BANK_BRANCH_NAME
, /* 32 */ BANK_CURRENCY_CODE
, /* 33 */ BATCH_NUMBER
, /* 34 */ TRX_CURRENCY_TYPE
, /* 35 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, /* 36 */ 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, NULL
, 1/EXCHANGE_RATE))
, CE_BANK_ACCT_USE_ID
, ORG_ID
, NULL
, NULL FROM CE_200_BATCHES_V WHERE CE_AUTO_BANK_MATCH.GET_200 = 1 UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ BANK_ACCOUNT_ID
, /* 3 */ BANK_ACCOUNT_NAME
, /* 4 */ BATCH_ID
, /* 5 */ TRX_NUMBER
, /* 6 */ TRX_TYPE
, /* 7 */ TYPE_MEANING
, /* 8 */ TRX_DATE
, /* 9 */ CURRENCY_CODE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ ACTUAL_AMOUNT_CLEARED
, /* 14 */ GL_DATE
, /* 15 */ EXCHANGE_RATE_TYPE
, /* 16 */ USER_EXCHANGE_RATE_TYPE
, /* 17 */ EXCHANGE_RATE_DATE
, /* 18 */ EXCHANGE_RATE
, /* 19 */ BANK_CHARGES
, /* 20 */ BANK_ERRORS
, /* 21 */ CREATED_BY
, /* 22 */ CREATION_DATE
, /* 23 */ LAST_UPDATED_BY
, /* 24 */ LAST_UPDATE_DATE
, /* 25 */ CLEARED_AMOUNT
, /* 26 */ REMITTANCE_NUMBER
, /* 27 */ APPLICATION_ID
, /* 28 */ COUNT_CLEARED
, /* 29 */ BANK_ACCOUNT_NUM
, /* 30 */ BANK_NAME
, /* 31 */ BANK_BRANCH_NAME
, /* 32 */ BANK_CURRENCY_CODE
, /* 33 */ BATCH_NUMBER
, /* 34 */ TRX_CURRENCY_TYPE
, /* 35 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, /* 36 */ 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, NULL
, 1/EXCHANGE_RATE))
, CE_BANK_ACCT_USE_ID
, ORG_ID
, NULL
, LOGICAL_GROUP_REFERENCE
FROM CE_200_GROUPS_V
WHERE CE_AUTO_BANK_MATCH.GET_200_GROUP = 1 UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ BANK_ACCOUNT_ID
, /* 3 */ BANK_ACCOUNT_NAME
, /* 4 */ BATCH_ID
, /* 5 */ TRX_NUMBER
, /* 6 */ TRX_TYPE
, /* 7 */ TYPE_MEANING
, /* 8 */ TRX_DATE
, /* 9 */ CURRENCY_CODE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ ACTUAL_AMOUNT_CLEARED
, /* 14 */ GL_DATE
, /* 15 */ EXCHANGE_RATE_TYPE
, /* 16 */ USER_EXCHANGE_RATE_TYPE
, /* 17 */ EXCHANGE_RATE_DATE
, /* 18 */ EXCHANGE_RATE
, /* 19 */ BANK_CHARGES
, /* 20 */ BANK_ERRORS
, /* 21 */ CREATED_BY
, /* 22 */ CREATION_DATE
, /* 23 */ LAST_UPDATED_BY
, /* 24 */ LAST_UPDATE_DATE
, /* 25 */ CLEARED_AMOUNT
, /* 26 */ REMITTANCE_NUMBER
, /* 27 */ APPLICATION_ID
, /* 28 */ COUNT_CLEARED
, /* 29 */ BANK_ACCOUNT_NUM
, /* 30 */ BANK_NAME
, /* 31 */ BANK_BRANCH_NAME
, /* 32 */ BANK_CURRENCY_CODE
, /* 33 */ BATCH_NUMBER
, /* 34 */ TRX_CURRENCY_TYPE
, /* 35 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, /* 36 */ 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, NULL
, 1/EXCHANGE_RATE))
, CE_BANK_ACCT_USE_ID
, ORG_ID
, NULL
, NULL FROM CE_222_BATCHES_V WHERE CE_AUTO_BANK_MATCH.GET_222 = 1