VIEW: APPS.CE_AVAILABLE_BATCHES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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