eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CE_AVAILABLE_TRANSACTIONS_V

Source

View Text - Preformatted


SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ BANK_ACCOUNT_ID, /* 3 */ BANK_ACCOUNT_NAME, /* 4 */ BANK_ACCOUNT_NUM, /* 5 */ BANK_NAME, /* 6 */ BANK_BRANCH_NAME, /* 7 */ TRX_ID, /* 8 */ TRX_TYPE, /* 9 */ TYPE_MEANING, /* 10 */ TRX_NUMBER, /* 11 */ TO_NUMBER(NULL), /* 12 */ CURRENCY_CODE, /* 13 */ AMOUNT, /* 14 */ BANK_ACCOUNT_AMOUNT, /* 15 */ AMOUNT_CLEARED, /* 16 */ GL_DATE, /* 17 */ STATUS_DSP, /* 18 */ STATUS, /* 19 */ DESCRIPTION, /* 20 */ TRX_DATE, /* 21 */ CLEARED_DATE, /* 22 */ MATURITY_DATE, /* 23 */ EXCHANGE_RATE_DATE, /* 24 */ EXCHANGE_RATE_TYPE, /* 25 */ USER_EXCHANGE_RATE_TYPE, /* 26 */ EXCHANGE_RATE, /* 27 */ BANK_CHARGES, /* 28 */ BANK_ERRORS, /* 29 */ BATCH_NAME, /* 30 */ BATCH_ID, /* 31 */ AGENT_NAME, /* 32 */ CUSTOMER_NAME, /* 33 */ PAYMENT_METHOD, /* 34 */ VENDOR_NAME, /* 35 */ CUSTOMER_ID, /* 36 */ SUPPLIER_ID, /* 37 */ REFERENCE_TYPE_DSP, /* 38 */ REFERENCE_TYPE, /* 39 */ REFERENCE_ID, /* 40 */ ACTUAL_AMOUNT_CLEARED, /* 41 */ CREATION_DATE, /* 42 */ CREATED_BY, /* 43 */ LAST_UPDATE_DATE, /* 44 */ LAST_UPDATED_BY, /* 45 */ REMITTANCE_NUMBER, /* 46 */ CASH_RECEIPT_ID, /* 47 */ APPLICATION_ID, /* 48 */ COUNT_CLEARED, /* 49 */ BANK_CURRENCY_CODE, /* 50 */ TRX_CURRENCY_TYPE, /* 51 */ CODE_COMBINATION_ID, /* 52 */ PERIOD_NAME, /* 53 */ JOURNAL_ENTRY_NAME, /* 54 */ DOCUMENT_NUMBER, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER, /* 56 */ CLEARING_TRX_TYPE, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N',EXCHANGE_RATE, /* 58 */ 'Y',DECODE(NVL(EXCHANGE_RATE,0),0,NULL,1/EXCHANGE_RATE)), JOURNAL_CATEGORY, /* 59 */ BASE_AMOUNT, /* 60 */ RECEIPT_CLASS_ID, /* 61 */ RECEIPT_METHOD_ID, /* 62 */ RECEIPT_CLASS_NAME, /* 63 */ DEPOSIT_DATE, /* 64 */ NULL, /* 65 */ TO_DATE(NULL), /* 66 */ CE_BANK_ACCT_USE_ID, LEGAL_ENTITY_ID, ORG_ID, NULL, NULL FROM CE_101_TRANSACTIONS_V WHERE CE_AUTO_BANK_MATCH.GET_101 = 1 UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ BANK_ACCOUNT_ID, /* 3 */ BANK_ACCOUNT_NAME, /* 4 */ BANK_ACCOUNT_NUM, /* 5 */ BANK_NAME, /* 6 */ BANK_BRANCH_NAME, /* 7 */ TRX_ID, /* 8 */ TRX_TYPE, /* 9 */ TYPE_MEANING, /* 10 */ TRX_NUMBER, /* 11 */ CHECK_NUMBER, /* 12 */ CURRENCY_CODE, /* 13 */ AMOUNT, /* 14 */ BANK_ACCOUNT_AMOUNT, /* 15 */ AMOUNT_CLEARED, /* 16 */ GL_DATE, /* 17 */ STATUS_DSP, /* 18 */ STATUS, /* 19 */ NULL, /* 20 */ TRX_DATE, /* 21 */ CLEARED_DATE, /* 22 */ MATURITY_DATE, /* 23 */ EXCHANGE_RATE_DATE, /* 24 */ EXCHANGE_RATE_TYPE, /* 25 */ USER_EXCHANGE_RATE_TYPE, /* 26 */ EXCHANGE_RATE, /* 27 */ BANK_CHARGES, /* 28 */ BANK_ERRORS, /* 29 */ BATCH_NAME, /* 30 */ BATCH_ID, /* 31 */ AGENT_NAME, /* 32 */ CUSTOMER_NAME, /* 33 */ PAYMENT_METHOD, /* 34 */ VENDOR_NAME, /* 35 */ CUSTOMER_ID, /* 36 */ SUPPLIER_ID, /* 37 */ REFERENCE_TYPE_DSP, /* 38 */ REFERENCE_TYPE, /* 39 */ REFERENCE_ID, /* 40 */ ACTUAL_AMOUNT_CLEARED, /* 41 */ CREATION_DATE, /* 42 */ CREATED_BY, /* 43 */ LAST_UPDATE_DATE, /* 44 */ LAST_UPDATED_BY, /* 45 */ REMITTANCE_NUMBER, /* 46 */ CASH_RECEIPT_ID, /* 47 */ APPLICATION_ID, /* 48 */ COUNT_CLEARED, /* 49 */ BANK_CURRENCY_CODE, /* 50 */ TRX_CURRENCY_TYPE, /* 51 */ CODE_COMBINATION_ID, /* 52 */ PERIOD_NAME, /* 53 */ JOURNAL_ENTRY_NAME, /* 54 */ DOCUMENT_NUMBER, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER, /* 56 */ CLEARING_TRX_TYPE, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', /* 58 */ EXCHANGE_RATE, 'Y',DECODE(EXCHANGE_RATE,NULL,NULL,1/EXCHANGE_RATE)), JOURNAL_CATEGORY, /* 59 */ BASE_AMOUNT, /* 60 */ RECEIPT_CLASS_ID, /* 61 */ RECEIPT_METHOD_ID, /* 62 */ RECEIPT_CLASS_NAME, /* 63 */ DEPOSIT_DATE, /* 64 */ NULL, /* 65 */ VALUE_DATE, /* 66 */ CE_BANK_ACCT_USE_ID, LEGAL_ENTITY_ID, ORG_ID, NULL, NULL FROM CE_200_TRANSACTIONS_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 */ BANK_ACCOUNT_NUM, /* 5 */ BANK_NAME, /* 6 */ BANK_BRANCH_NAME, /* 7 */ TRX_ID, /* 8 */ TRX_TYPE, /* 9 */ TYPE_MEANING, /* 10 */ TRX_NUMBER, /* 11 */ TO_NUMBER(NULL), /* 12 */ CURRENCY_CODE, /* 13 */ AMOUNT, /* 14 */ BANK_ACCOUNT_AMOUNT, /* 15 */ AMOUNT_CLEARED, /* 16 */ GL_DATE, /* 17 */ STATUS_DSP, /* 18 */ STATUS, /* 19 */ NULL, /* 20 */ TRX_DATE, /* 21 */ CLEARED_DATE, /* 22 */ MATURITY_DATE, /* 23 */ EXCHANGE_RATE_DATE, /* 24 */ EXCHANGE_RATE_TYPE, /* 25 */ USER_EXCHANGE_RATE_TYPE, /* 26 */ EXCHANGE_RATE, /* 27 */ BANK_CHARGES, /* 28 */ BANK_ERRORS, /* 29 */ BATCH_NAME, /* 30 */ BATCH_ID, /* 31 */ AGENT_NAME, /* 32 */ CUSTOMER_NAME, /* 33 */ PAYMENT_METHOD, /* 34 */ VENDOR_NAME, /* 35 */ CUSTOMER_ID, /* 36 */ SUPPLIER_ID, /* 37 */ REFERENCE_TYPE_DSP, /* 38 */ REFERENCE_TYPE, /* 39 */ REFERENCE_ID, /* 40 */ ACTUAL_AMOUNT_CLEARED, /* 41 */ CREATION_DATE, /* 42 */ CREATED_BY, /* 43 */ LAST_UPDATE_DATE, /* 44 */ LAST_UPDATED_BY, /* 45 */ REMITTANCE_NUMBER, /* 46 */ CASH_RECEIPT_ID, /* 47 */ APPLICATION_ID, /* 48 */ COUNT_CLEARED, /* 49 */ BANK_CURRENCY_CODE, /* 50 */ TRX_CURRENCY_TYPE, /* 51 */ CODE_COMBINATION_ID, /* 52 */ PERIOD_NAME, /* 53 */ JOURNAL_ENTRY_NAME, /* 54 */ DOCUMENT_NUMBER, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER, /* 56 */ CLEARING_TRX_TYPE, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', /* 58 */ EXCHANGE_RATE,'Y',DECODE(EXCHANGE_RATE,NULL,NULL,1/EXCHANGE_RATE)), JOURNAL_CATEGORY, /* 59 */ BASE_AMOUNT, /* 60 */ RECEIPT_CLASS_ID, /* 61 */ RECEIPT_METHOD_ID, /* 62 */ RECEIPT_CLASS_NAME, /* 63 */ DEPOSIT_DATE, /* 64 */ REVERSED_RECEIPT_FLAG, /* 65 */ VALUE_DATE, /* 66 */ CE_BANK_ACCT_USE_ID, LEGAL_ENTITY_ID, ORG_ID, NULL, NULL FROM CE_222_TRANSACTIONS_V WHERE CE_AUTO_BANK_MATCH.GET_222 = 1 UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ BANK_ACCOUNT_ID, /* 3 */ BANK_ACCOUNT_NAME, /* 4 */ BANK_ACCOUNT_NUM, /* 5 */ BANK_NAME, /* 6 */ BANK_BRANCH_NAME, /* 7 */ TRX_ID, /* 8 */ TRX_TYPE, /* 9 */ TYPE_MEANING, /* 10 */ TRX_NUMBER, /* 11 */ TO_NUMBER(NULL), /* 12 */ CURRENCY_CODE, /* 13 */ AMOUNT, /* 14 */ BANK_ACCOUNT_AMOUNT, /* 15 */ AMOUNT_CLEARED, /* 16 */ GL_DATE, /* 17 */ STATUS_DSP, /* 18 */ STATUS, /* 19 */ NULL, /* 20 */ TRX_DATE, /* 21 */ CLEARED_DATE, /* 22 */ MATURITY_DATE, /* 23 */ EXCHANGE_RATE_DATE, /* 24 */ EXCHANGE_RATE_TYPE, /* 25 */ USER_EXCHANGE_RATE_TYPE, /* 26 */ EXCHANGE_RATE, /* 27 */ BANK_CHARGES, /* 28 */ BANK_ERRORS, /* 29 */ BATCH_NAME, /* 30 */ BATCH_ID, /* 31 */ AGENT_NAME, /* 32 */ CUSTOMER_NAME, /* 33 */ PAYMENT_METHOD, /* 34 */ VENDOR_NAME, /* 35 */ CUSTOMER_ID, /* 36 */ SUPPLIER_ID, /* 37 */ REFERENCE_TYPE_DSP, /* 38 */ REFERENCE_TYPE, /* 39 */ REFERENCE_ID, /* 40 */ ACTUAL_AMOUNT_CLEARED, /* 41 */ CREATION_DATE, /* 42 */ CREATED_BY, /* 43 */ LAST_UPDATE_DATE, /* 44 */ LAST_UPDATED_BY, /* 45 */ REMITTANCE_NUMBER, /* 46 */ CASH_RECEIPT_ID, /* 47 */ APPLICATION_ID, /* 48 */ COUNT_CLEARED, /* 49 */ BANK_CURRENCY_CODE, /* 50 */ TRX_CURRENCY_TYPE, /* 51 */ CODE_COMBINATION_ID, /* 52 */ PERIOD_NAME, /* 53 */ JOURNAL_ENTRY_NAME, /* 54 */ DOCUMENT_NUMBER, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER, /* 56 */ CLEARING_TRX_TYPE, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', /* 58 */ EXCHANGE_RATE,'Y',DECODE(EXCHANGE_RATE,NULL,NULL,1/EXCHANGE_RATE)), JOURNAL_CATEGORY, /* 59 */ BASE_AMOUNT, /* 60 */ RECEIPT_CLASS_ID, /* 61 */ RECEIPT_METHOD_ID, /* 62 */ RECEIPT_CLASS_NAME, /* 63 */ DEPOSIT_DATE, /* 64 */ NULL, /* 65 */ TO_DATE(NULL), /* 66 */ CE_BANK_ACCT_USE_ID, LEGAL_ENTITY_ID, ORG_ID, NULL, NULL FROM CE_260_TRANSACTIONS_V WHERE CE_AUTO_BANK_MATCH.GET_260 = 1 UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ BANK_ACCOUNT_ID, /* 3 */ BANK_ACCOUNT_NAME, /* 4 */ BANK_ACCOUNT_NUM, /* 5 */ BANK_NAME, /* 6 */ BANK_BRANCH_NAME, /* 7 */ TRX_ID, /* 8 */ TRX_TYPE, /* 9 */ TYPE_MEANING, /* 10 */ TRX_NUMBER, /* 11 */ TO_NUMBER(NULL), /* 12 */ CURRENCY_CODE, /* 13 */ AMOUNT, /* 14 */ BANK_ACCOUNT_AMOUNT, /* 15 */ AMOUNT_CLEARED, /* 16 */ GL_DATE, /* 17 */ STATUS_DSP, /* 18 */ STATUS, /* 19 */ NULL, /* 20 */ TRX_DATE, /* 21 */ CLEARED_DATE, /* 22 */ MATURITY_DATE, /* 23 */ EXCHANGE_RATE_DATE, /* 24 */ EXCHANGE_RATE_TYPE, /* 25 */ USER_EXCHANGE_RATE_TYPE, /* 26 */ EXCHANGE_RATE, /* 27 */ BANK_CHARGES, /* 28 */ BANK_ERRORS, /* 29 */ BATCH_NAME, /* 30 */ BATCH_ID, /* 31 */ AGENT_NAME, /* 32 */ CUSTOMER_NAME, /* 33 */ PAYMENT_METHOD, /* 34 */ VENDOR_NAME, /* 35 */ CUSTOMER_ID, /* 36 */ SUPPLIER_ID, /* 37 */ REFERENCE_TYPE_DSP, /* 38 */ REFERENCE_TYPE, /* 39 */ REFERENCE_ID, /* 40 */ ACTUAL_AMOUNT_CLEARED, /* 41 */ CREATION_DATE, /* 42 */ CREATED_BY, /* 43 */ LAST_UPDATE_DATE, /* 44 */ LAST_UPDATED_BY, /* 45 */ REMITTANCE_NUMBER, /* 46 */ CASH_RECEIPT_ID, /* 47 */ APPLICATION_ID, /* 48 */ COUNT_CLEARED, /* 49 */ BANK_CURRENCY_CODE, /* 50 */ TRX_CURRENCY_TYPE, /* 51 */ CODE_COMBINATION_ID, /* 52 */ PERIOD_NAME, /* 53 */ JOURNAL_ENTRY_NAME, /* 54 */ DOCUMENT_NUMBER, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER, /* 56 */ CLEARING_TRX_TYPE, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', /* 58 */ EXCHANGE_RATE,'Y',DECODE(EXCHANGE_RATE,NULL,NULL,1/EXCHANGE_RATE)), JOURNAL_CATEGORY, /* 59 */ BASE_AMOUNT, /* 60 */ RECEIPT_CLASS_ID, /* 61 */ RECEIPT_METHOD_ID, /* 62 */ RECEIPT_CLASS_NAME, /* 63 */ DEPOSIT_DATE, /* 64 */ NULL, /* 65 */ TO_DATE(NULL), /* 66 */ CE_BANK_ACCT_USE_ID, LEGAL_ENTITY_ID, ORG_ID, COUNTERPARTY, TRXN_SUBTYPE FROM CE_260_CF_TRANSACTIONS_V WHERE CE_AUTO_BANK_MATCH.GET_260 = 1 UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ BANK_ACCOUNT_ID, /* 3 */ BANK_ACCOUNT_NAME, /* 4 */ BANK_ACCOUNT_NUM, /* 5 */ BANK_NAME, /* 6 */ BANK_BRANCH_NAME, /* 7 */ TRX_ID, /* 8 */ TRX_TYPE, /* 9 */ TYPE_MEANING, /* 10 */ TRX_NUMBER, /* 11 */ CHECK_NUMBER, /* 12 */ CURRENCY_CODE, /* 13 */ AMOUNT, /* 14 */ BANK_ACCOUNT_AMOUNT, /* 15 */ AMOUNT_CLEARED, /* 16 */ GL_DATE, /* 17 */ STATUS_DSP, /* 18 */ STATUS, /* 19 */ NULL, /* 20 */ TRX_DATE, /* 21 */ CLEARED_DATE, /* 22 */ MATURITY_DATE, /* 23 */ EXCHANGE_RATE_DATE, /* 24 */ EXCHANGE_RATE_TYPE, /* 25 */ USER_EXCHANGE_RATE_TYPE, /* 26 */ EXCHANGE_RATE, /* 27 */ BANK_CHARGES, /* 28 */ BANK_ERRORS, /* 29 */ BATCH_NAME, /* 30 */ BATCH_ID, /* 31 */ AGENT_NAME, /* 32 */ CUSTOMER_NAME, /* 33 */ PAYMENT_METHOD, /* 34 */ VENDOR_NAME, /* 35 */ CUSTOMER_ID, /* 36 */ SUPPLIER_ID, /* 37 */ REFERENCE_TYPE_DSP, /* 38 */ REFERENCE_TYPE, /* 39 */ REFERENCE_ID, /* 40 */ ACTUAL_AMOUNT_CLEARED, /* 41 */ CREATION_DATE, /* 42 */ CREATED_BY, /* 43 */ LAST_UPDATE_DATE, /* 44 */ LAST_UPDATED_BY, /* 45 */ REMITTANCE_NUMBER, /* 46 */ CASH_RECEIPT_ID, /* 47 */ APPLICATION_ID, /* 48 */ COUNT_CLEARED, /* 49 */ BANK_CURRENCY_CODE, /* 50 */ TRX_CURRENCY_TYPE, /* 51 */ CODE_COMBINATION_ID, /* 52 */ PERIOD_NAME, /* 53 */ JOURNAL_ENTRY_NAME, /* 54 */ DOCUMENT_NUMBER, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER, /* 56 */ CLEARING_TRX_TYPE, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', /* 58 */ EXCHANGE_RATE,'Y',DECODE(EXCHANGE_RATE,NULL,NULL,1/EXCHANGE_RATE)), JOURNAL_CATEGORY, /* 59 */ BASE_AMOUNT, /* 60 */ RECEIPT_CLASS_ID, /* 61 */ RECEIPT_METHOD_ID, /* 62 */ RECEIPT_CLASS_NAME, /* 63 */ DEPOSIT_DATE, /* 64 */ REVERSED_RECEIPT_FLAG, /* 65 */ TO_DATE(NULL), /* 66 */ CE_BANK_ACCT_USE_ID, LEGAL_ENTITY_ID, ORG_ID, NULL, NULL FROM CE_801_TRANSACTIONS_V WHERE CE_AUTO_BANK_MATCH.GET_801 = 1 UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ BANK_ACCOUNT_ID, /* 3 */ BANK_ACCOUNT_NAME, /* 4 */ BANK_ACCOUNT_NUM, /* 5 */ BANK_NAME, /* 6 */ BANK_BRANCH_NAME, /* 7 */ TRX_ID, /* 8 */ TRX_TYPE, /* 9 */ TYPE_MEANING, /* 10 */ TRX_NUMBER, /* 11 */ CHECK_NUMBER, /* 12 */ CURRENCY_CODE, /* 13 */ AMOUNT, /* 14 */ BANK_ACCOUNT_AMOUNT, /* 15 */ AMOUNT_CLEARED, /* 16 */ GL_DATE, /* 17 */ STATUS_DSP, /* 18 */ STATUS, /* 19 */ NULL, /* 20 */ TRX_DATE, /* 21 */ CLEARED_DATE, /* 22 */ MATURITY_DATE, /* 23 */ EXCHANGE_RATE_DATE, /* 24 */ EXCHANGE_RATE_TYPE, /* 25 */ USER_EXCHANGE_RATE_TYPE, /* 26 */ EXCHANGE_RATE, /* 27 */ BANK_CHARGES, /* 28 */ BANK_ERRORS, /* 29 */ BATCH_NAME, /* 30 */ BATCH_ID, /* 31 */ AGENT_NAME, /* 32 */ CUSTOMER_NAME, /* 33 */ PAYMENT_METHOD, /* 34 */ VENDOR_NAME, /* 35 */ CUSTOMER_ID, /* 36 */ SUPPLIER_ID, /* 37 */ REFERENCE_TYPE_DSP, /* 38 */ REFERENCE_TYPE, /* 39 */ REFERENCE_ID, /* 40 */ ACTUAL_AMOUNT_CLEARED, /* 41 */ CREATION_DATE, /* 42 */ CREATED_BY, /* 43 */ LAST_UPDATE_DATE, /* 44 */ LAST_UPDATED_BY, /* 45 */ REMITTANCE_NUMBER, /* 46 */ CASH_RECEIPT_ID, /* 47 */ APPLICATION_ID, /* 48 */ COUNT_CLEARED, /* 49 */ BANK_CURRENCY_CODE, /* 50 */ TRX_CURRENCY_TYPE, /* 51 */ CODE_COMBINATION_ID, /* 52 */ PERIOD_NAME, /* 53 */ JOURNAL_ENTRY_NAME, /* 54 */ DOCUMENT_NUMBER, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER, /* 56 */ CLEARING_TRX_TYPE, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', /* 58 */ EXCHANGE_RATE,'Y',DECODE(EXCHANGE_RATE,NULL,NULL,1/EXCHANGE_RATE)), JOURNAL_CATEGORY, /* 59 */ BASE_AMOUNT, /* 60 */ RECEIPT_CLASS_ID, /* 61 */ RECEIPT_METHOD_ID, /* 62 */ RECEIPT_CLASS_NAME, /* 63 */ DEPOSIT_DATE, /* 64 */ REVERSED_RECEIPT_FLAG, /* 65 */ TO_DATE(NULL), /* 66 */ CE_BANK_ACCT_USE_ID, LEGAL_ENTITY_ID, ORG_ID, NULL, NULL FROM CE_801_EFT_TRANSACTIONS_V WHERE CE_AUTO_BANK_MATCH.GET_801 = 1 UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ BANK_ACCOUNT_ID, /* 3 */ BANK_ACCOUNT_NAME, /* 4 */ BANK_ACCOUNT_NUM, /* 5 */ BANK_NAME, /* 6 */ BANK_BRANCH_NAME, /* 7 */ TRX_ID, /* 8 */ TRX_TYPE, /* 9 */ TYPE_MEANING, /* 10 */ TRX_NUMBER, /* 11 */ TO_NUMBER(NULL), /* 12 */ CURRENCY_CODE, /* 13 */ AMOUNT, /* 14 */ BANK_ACCOUNT_AMOUNT, /* 15 */ AMOUNT_CLEARED, /* 16 */ GL_DATE, /* 17 */ STATUS_DSP, /* 17 */ STATUS, /* 18 */ NULL, /* 20 */ TRX_DATE, /* 21 */ CLEARED_DATE, /* 22 */ MATURITY_DATE, /* 23 */ EXCHANGE_RATE_DATE, /* 24 */ EXCHANGE_RATE_TYPE, /* 25 */ USER_EXCHANGE_RATE_TYPE, /* 26 */ EXCHANGE_RATE, /* 27 */ BANK_CHARGES, /* 28 */ BANK_ERRORS, /* 29 */ BATCH_NAME, /* 30 */ BATCH_ID, /* 31 */ AGENT_NAME, /* 32 */ CUSTOMER_NAME, /* 33 */ PAYMENT_METHOD, /* 34 */ VENDOR_NAME, /* 35 */ CUSTOMER_ID, /* 36 */ SUPPLIER_ID, /* 37 */ REFERENCE_TYPE_DSP, /* 38 */ REFERENCE_TYPE, /* 39 */ REFERENCE_ID, /* 40 */ ACTUAL_AMOUNT_CLEARED, /* 41 */ CREATION_DATE, /* 42 */ CREATED_BY, /* 43 */ LAST_UPDATE_DATE, /* 44 */ LAST_UPDATED_BY, /* 45 */ REMITTANCE_NUMBER, /* 46 */ CASH_RECEIPT_ID, /* 47 */ APPLICATION_ID, /* 48 */ COUNT_CLEARED, /* 49 */ BANK_CURRENCY_CODE, /* 50 */ TRX_CURRENCY_TYPE, /* 51 */ CODE_COMBINATION_ID, /* 52 */ PERIOD_NAME, /* 53 */ JOURNAL_ENTRY_NAME, /* 54 */ DOCUMENT_NUMBER, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER, /* 56 */ CLEARING_TRX_TYPE, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', /* 58 */ EXCHANGE_RATE,'Y',DECODE(EXCHANGE_RATE,NULL,NULL,1/EXCHANGE_RATE)), JOURNAL_CATEGORY, /* 59 */ BASE_AMOUNT, /* 60 */ TO_NUMBER(NULL), /* 61 */ TO_NUMBER(NULL), /* 62 */ NULL, /* 63 */ TO_DATE(NULL), /* 64 */ NULL, /* 65 */ TO_DATE(NULL), /* 66 */ CE_BANK_ACCT_USE_ID, LEGAL_ENTITY_ID, ORG_ID, NULL, NULL FROM CE_999_TRANSACTIONS_V WHERE CE_AUTO_BANK_MATCH.GET_999 = 1

View Text - HTML Formatted

SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ BANK_ACCOUNT_ID
, /* 3 */ BANK_ACCOUNT_NAME
, /* 4 */ BANK_ACCOUNT_NUM
, /* 5 */ BANK_NAME
, /* 6 */ BANK_BRANCH_NAME
, /* 7 */ TRX_ID
, /* 8 */ TRX_TYPE
, /* 9 */ TYPE_MEANING
, /* 10 */ TRX_NUMBER
, /* 11 */ TO_NUMBER(NULL)
, /* 12 */ CURRENCY_CODE
, /* 13 */ AMOUNT
, /* 14 */ BANK_ACCOUNT_AMOUNT
, /* 15 */ AMOUNT_CLEARED
, /* 16 */ GL_DATE
, /* 17 */ STATUS_DSP
, /* 18 */ STATUS
, /* 19 */ DESCRIPTION
, /* 20 */ TRX_DATE
, /* 21 */ CLEARED_DATE
, /* 22 */ MATURITY_DATE
, /* 23 */ EXCHANGE_RATE_DATE
, /* 24 */ EXCHANGE_RATE_TYPE
, /* 25 */ USER_EXCHANGE_RATE_TYPE
, /* 26 */ EXCHANGE_RATE
, /* 27 */ BANK_CHARGES
, /* 28 */ BANK_ERRORS
, /* 29 */ BATCH_NAME
, /* 30 */ BATCH_ID
, /* 31 */ AGENT_NAME
, /* 32 */ CUSTOMER_NAME
, /* 33 */ PAYMENT_METHOD
, /* 34 */ VENDOR_NAME
, /* 35 */ CUSTOMER_ID
, /* 36 */ SUPPLIER_ID
, /* 37 */ REFERENCE_TYPE_DSP
, /* 38 */ REFERENCE_TYPE
, /* 39 */ REFERENCE_ID
, /* 40 */ ACTUAL_AMOUNT_CLEARED
, /* 41 */ CREATION_DATE
, /* 42 */ CREATED_BY
, /* 43 */ LAST_UPDATE_DATE
, /* 44 */ LAST_UPDATED_BY
, /* 45 */ REMITTANCE_NUMBER
, /* 46 */ CASH_RECEIPT_ID
, /* 47 */ APPLICATION_ID
, /* 48 */ COUNT_CLEARED
, /* 49 */ BANK_CURRENCY_CODE
, /* 50 */ TRX_CURRENCY_TYPE
, /* 51 */ CODE_COMBINATION_ID
, /* 52 */ PERIOD_NAME
, /* 53 */ JOURNAL_ENTRY_NAME
, /* 54 */ DOCUMENT_NUMBER
, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER
, /* 56 */ CLEARING_TRX_TYPE
, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, /* 58 */ 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, NULL
, 1/EXCHANGE_RATE))
, JOURNAL_CATEGORY
, /* 59 */ BASE_AMOUNT
, /* 60 */ RECEIPT_CLASS_ID
, /* 61 */ RECEIPT_METHOD_ID
, /* 62 */ RECEIPT_CLASS_NAME
, /* 63 */ DEPOSIT_DATE
, /* 64 */ NULL
, /* 65 */ TO_DATE(NULL)
, /* 66 */ CE_BANK_ACCT_USE_ID
, LEGAL_ENTITY_ID
, ORG_ID
, NULL
, NULL
FROM CE_101_TRANSACTIONS_V
WHERE CE_AUTO_BANK_MATCH.GET_101 = 1 UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ BANK_ACCOUNT_ID
, /* 3 */ BANK_ACCOUNT_NAME
, /* 4 */ BANK_ACCOUNT_NUM
, /* 5 */ BANK_NAME
, /* 6 */ BANK_BRANCH_NAME
, /* 7 */ TRX_ID
, /* 8 */ TRX_TYPE
, /* 9 */ TYPE_MEANING
, /* 10 */ TRX_NUMBER
, /* 11 */ CHECK_NUMBER
, /* 12 */ CURRENCY_CODE
, /* 13 */ AMOUNT
, /* 14 */ BANK_ACCOUNT_AMOUNT
, /* 15 */ AMOUNT_CLEARED
, /* 16 */ GL_DATE
, /* 17 */ STATUS_DSP
, /* 18 */ STATUS
, /* 19 */ NULL
, /* 20 */ TRX_DATE
, /* 21 */ CLEARED_DATE
, /* 22 */ MATURITY_DATE
, /* 23 */ EXCHANGE_RATE_DATE
, /* 24 */ EXCHANGE_RATE_TYPE
, /* 25 */ USER_EXCHANGE_RATE_TYPE
, /* 26 */ EXCHANGE_RATE
, /* 27 */ BANK_CHARGES
, /* 28 */ BANK_ERRORS
, /* 29 */ BATCH_NAME
, /* 30 */ BATCH_ID
, /* 31 */ AGENT_NAME
, /* 32 */ CUSTOMER_NAME
, /* 33 */ PAYMENT_METHOD
, /* 34 */ VENDOR_NAME
, /* 35 */ CUSTOMER_ID
, /* 36 */ SUPPLIER_ID
, /* 37 */ REFERENCE_TYPE_DSP
, /* 38 */ REFERENCE_TYPE
, /* 39 */ REFERENCE_ID
, /* 40 */ ACTUAL_AMOUNT_CLEARED
, /* 41 */ CREATION_DATE
, /* 42 */ CREATED_BY
, /* 43 */ LAST_UPDATE_DATE
, /* 44 */ LAST_UPDATED_BY
, /* 45 */ REMITTANCE_NUMBER
, /* 46 */ CASH_RECEIPT_ID
, /* 47 */ APPLICATION_ID
, /* 48 */ COUNT_CLEARED
, /* 49 */ BANK_CURRENCY_CODE
, /* 50 */ TRX_CURRENCY_TYPE
, /* 51 */ CODE_COMBINATION_ID
, /* 52 */ PERIOD_NAME
, /* 53 */ JOURNAL_ENTRY_NAME
, /* 54 */ DOCUMENT_NUMBER
, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER
, /* 56 */ CLEARING_TRX_TYPE
, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, /* 58 */ EXCHANGE_RATE
, 'Y'
, DECODE(EXCHANGE_RATE
, NULL
, NULL
, 1/EXCHANGE_RATE))
, JOURNAL_CATEGORY
, /* 59 */ BASE_AMOUNT
, /* 60 */ RECEIPT_CLASS_ID
, /* 61 */ RECEIPT_METHOD_ID
, /* 62 */ RECEIPT_CLASS_NAME
, /* 63 */ DEPOSIT_DATE
, /* 64 */ NULL
, /* 65 */ VALUE_DATE
, /* 66 */ CE_BANK_ACCT_USE_ID
, LEGAL_ENTITY_ID
, ORG_ID
, NULL
, NULL
FROM CE_200_TRANSACTIONS_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 */ BANK_ACCOUNT_NUM
, /* 5 */ BANK_NAME
, /* 6 */ BANK_BRANCH_NAME
, /* 7 */ TRX_ID
, /* 8 */ TRX_TYPE
, /* 9 */ TYPE_MEANING
, /* 10 */ TRX_NUMBER
, /* 11 */ TO_NUMBER(NULL)
, /* 12 */ CURRENCY_CODE
, /* 13 */ AMOUNT
, /* 14 */ BANK_ACCOUNT_AMOUNT
, /* 15 */ AMOUNT_CLEARED
, /* 16 */ GL_DATE
, /* 17 */ STATUS_DSP
, /* 18 */ STATUS
, /* 19 */ NULL
, /* 20 */ TRX_DATE
, /* 21 */ CLEARED_DATE
, /* 22 */ MATURITY_DATE
, /* 23 */ EXCHANGE_RATE_DATE
, /* 24 */ EXCHANGE_RATE_TYPE
, /* 25 */ USER_EXCHANGE_RATE_TYPE
, /* 26 */ EXCHANGE_RATE
, /* 27 */ BANK_CHARGES
, /* 28 */ BANK_ERRORS
, /* 29 */ BATCH_NAME
, /* 30 */ BATCH_ID
, /* 31 */ AGENT_NAME
, /* 32 */ CUSTOMER_NAME
, /* 33 */ PAYMENT_METHOD
, /* 34 */ VENDOR_NAME
, /* 35 */ CUSTOMER_ID
, /* 36 */ SUPPLIER_ID
, /* 37 */ REFERENCE_TYPE_DSP
, /* 38 */ REFERENCE_TYPE
, /* 39 */ REFERENCE_ID
, /* 40 */ ACTUAL_AMOUNT_CLEARED
, /* 41 */ CREATION_DATE
, /* 42 */ CREATED_BY
, /* 43 */ LAST_UPDATE_DATE
, /* 44 */ LAST_UPDATED_BY
, /* 45 */ REMITTANCE_NUMBER
, /* 46 */ CASH_RECEIPT_ID
, /* 47 */ APPLICATION_ID
, /* 48 */ COUNT_CLEARED
, /* 49 */ BANK_CURRENCY_CODE
, /* 50 */ TRX_CURRENCY_TYPE
, /* 51 */ CODE_COMBINATION_ID
, /* 52 */ PERIOD_NAME
, /* 53 */ JOURNAL_ENTRY_NAME
, /* 54 */ DOCUMENT_NUMBER
, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER
, /* 56 */ CLEARING_TRX_TYPE
, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, /* 58 */ EXCHANGE_RATE
, 'Y'
, DECODE(EXCHANGE_RATE
, NULL
, NULL
, 1/EXCHANGE_RATE))
, JOURNAL_CATEGORY
, /* 59 */ BASE_AMOUNT
, /* 60 */ RECEIPT_CLASS_ID
, /* 61 */ RECEIPT_METHOD_ID
, /* 62 */ RECEIPT_CLASS_NAME
, /* 63 */ DEPOSIT_DATE
, /* 64 */ REVERSED_RECEIPT_FLAG
, /* 65 */ VALUE_DATE
, /* 66 */ CE_BANK_ACCT_USE_ID
, LEGAL_ENTITY_ID
, ORG_ID
, NULL
, NULL
FROM CE_222_TRANSACTIONS_V
WHERE CE_AUTO_BANK_MATCH.GET_222 = 1 UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ BANK_ACCOUNT_ID
, /* 3 */ BANK_ACCOUNT_NAME
, /* 4 */ BANK_ACCOUNT_NUM
, /* 5 */ BANK_NAME
, /* 6 */ BANK_BRANCH_NAME
, /* 7 */ TRX_ID
, /* 8 */ TRX_TYPE
, /* 9 */ TYPE_MEANING
, /* 10 */ TRX_NUMBER
, /* 11 */ TO_NUMBER(NULL)
, /* 12 */ CURRENCY_CODE
, /* 13 */ AMOUNT
, /* 14 */ BANK_ACCOUNT_AMOUNT
, /* 15 */ AMOUNT_CLEARED
, /* 16 */ GL_DATE
, /* 17 */ STATUS_DSP
, /* 18 */ STATUS
, /* 19 */ NULL
, /* 20 */ TRX_DATE
, /* 21 */ CLEARED_DATE
, /* 22 */ MATURITY_DATE
, /* 23 */ EXCHANGE_RATE_DATE
, /* 24 */ EXCHANGE_RATE_TYPE
, /* 25 */ USER_EXCHANGE_RATE_TYPE
, /* 26 */ EXCHANGE_RATE
, /* 27 */ BANK_CHARGES
, /* 28 */ BANK_ERRORS
, /* 29 */ BATCH_NAME
, /* 30 */ BATCH_ID
, /* 31 */ AGENT_NAME
, /* 32 */ CUSTOMER_NAME
, /* 33 */ PAYMENT_METHOD
, /* 34 */ VENDOR_NAME
, /* 35 */ CUSTOMER_ID
, /* 36 */ SUPPLIER_ID
, /* 37 */ REFERENCE_TYPE_DSP
, /* 38 */ REFERENCE_TYPE
, /* 39 */ REFERENCE_ID
, /* 40 */ ACTUAL_AMOUNT_CLEARED
, /* 41 */ CREATION_DATE
, /* 42 */ CREATED_BY
, /* 43 */ LAST_UPDATE_DATE
, /* 44 */ LAST_UPDATED_BY
, /* 45 */ REMITTANCE_NUMBER
, /* 46 */ CASH_RECEIPT_ID
, /* 47 */ APPLICATION_ID
, /* 48 */ COUNT_CLEARED
, /* 49 */ BANK_CURRENCY_CODE
, /* 50 */ TRX_CURRENCY_TYPE
, /* 51 */ CODE_COMBINATION_ID
, /* 52 */ PERIOD_NAME
, /* 53 */ JOURNAL_ENTRY_NAME
, /* 54 */ DOCUMENT_NUMBER
, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER
, /* 56 */ CLEARING_TRX_TYPE
, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, /* 58 */ EXCHANGE_RATE
, 'Y'
, DECODE(EXCHANGE_RATE
, NULL
, NULL
, 1/EXCHANGE_RATE))
, JOURNAL_CATEGORY
, /* 59 */ BASE_AMOUNT
, /* 60 */ RECEIPT_CLASS_ID
, /* 61 */ RECEIPT_METHOD_ID
, /* 62 */ RECEIPT_CLASS_NAME
, /* 63 */ DEPOSIT_DATE
, /* 64 */ NULL
, /* 65 */ TO_DATE(NULL)
, /* 66 */ CE_BANK_ACCT_USE_ID
, LEGAL_ENTITY_ID
, ORG_ID
, NULL
, NULL
FROM CE_260_TRANSACTIONS_V
WHERE CE_AUTO_BANK_MATCH.GET_260 = 1 UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ BANK_ACCOUNT_ID
, /* 3 */ BANK_ACCOUNT_NAME
, /* 4 */ BANK_ACCOUNT_NUM
, /* 5 */ BANK_NAME
, /* 6 */ BANK_BRANCH_NAME
, /* 7 */ TRX_ID
, /* 8 */ TRX_TYPE
, /* 9 */ TYPE_MEANING
, /* 10 */ TRX_NUMBER
, /* 11 */ TO_NUMBER(NULL)
, /* 12 */ CURRENCY_CODE
, /* 13 */ AMOUNT
, /* 14 */ BANK_ACCOUNT_AMOUNT
, /* 15 */ AMOUNT_CLEARED
, /* 16 */ GL_DATE
, /* 17 */ STATUS_DSP
, /* 18 */ STATUS
, /* 19 */ NULL
, /* 20 */ TRX_DATE
, /* 21 */ CLEARED_DATE
, /* 22 */ MATURITY_DATE
, /* 23 */ EXCHANGE_RATE_DATE
, /* 24 */ EXCHANGE_RATE_TYPE
, /* 25 */ USER_EXCHANGE_RATE_TYPE
, /* 26 */ EXCHANGE_RATE
, /* 27 */ BANK_CHARGES
, /* 28 */ BANK_ERRORS
, /* 29 */ BATCH_NAME
, /* 30 */ BATCH_ID
, /* 31 */ AGENT_NAME
, /* 32 */ CUSTOMER_NAME
, /* 33 */ PAYMENT_METHOD
, /* 34 */ VENDOR_NAME
, /* 35 */ CUSTOMER_ID
, /* 36 */ SUPPLIER_ID
, /* 37 */ REFERENCE_TYPE_DSP
, /* 38 */ REFERENCE_TYPE
, /* 39 */ REFERENCE_ID
, /* 40 */ ACTUAL_AMOUNT_CLEARED
, /* 41 */ CREATION_DATE
, /* 42 */ CREATED_BY
, /* 43 */ LAST_UPDATE_DATE
, /* 44 */ LAST_UPDATED_BY
, /* 45 */ REMITTANCE_NUMBER
, /* 46 */ CASH_RECEIPT_ID
, /* 47 */ APPLICATION_ID
, /* 48 */ COUNT_CLEARED
, /* 49 */ BANK_CURRENCY_CODE
, /* 50 */ TRX_CURRENCY_TYPE
, /* 51 */ CODE_COMBINATION_ID
, /* 52 */ PERIOD_NAME
, /* 53 */ JOURNAL_ENTRY_NAME
, /* 54 */ DOCUMENT_NUMBER
, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER
, /* 56 */ CLEARING_TRX_TYPE
, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, /* 58 */ EXCHANGE_RATE
, 'Y'
, DECODE(EXCHANGE_RATE
, NULL
, NULL
, 1/EXCHANGE_RATE))
, JOURNAL_CATEGORY
, /* 59 */ BASE_AMOUNT
, /* 60 */ RECEIPT_CLASS_ID
, /* 61 */ RECEIPT_METHOD_ID
, /* 62 */ RECEIPT_CLASS_NAME
, /* 63 */ DEPOSIT_DATE
, /* 64 */ NULL
, /* 65 */ TO_DATE(NULL)
, /* 66 */ CE_BANK_ACCT_USE_ID
, LEGAL_ENTITY_ID
, ORG_ID
, COUNTERPARTY
, TRXN_SUBTYPE
FROM CE_260_CF_TRANSACTIONS_V
WHERE CE_AUTO_BANK_MATCH.GET_260 = 1 UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ BANK_ACCOUNT_ID
, /* 3 */ BANK_ACCOUNT_NAME
, /* 4 */ BANK_ACCOUNT_NUM
, /* 5 */ BANK_NAME
, /* 6 */ BANK_BRANCH_NAME
, /* 7 */ TRX_ID
, /* 8 */ TRX_TYPE
, /* 9 */ TYPE_MEANING
, /* 10 */ TRX_NUMBER
, /* 11 */ CHECK_NUMBER
, /* 12 */ CURRENCY_CODE
, /* 13 */ AMOUNT
, /* 14 */ BANK_ACCOUNT_AMOUNT
, /* 15 */ AMOUNT_CLEARED
, /* 16 */ GL_DATE
, /* 17 */ STATUS_DSP
, /* 18 */ STATUS
, /* 19 */ NULL
, /* 20 */ TRX_DATE
, /* 21 */ CLEARED_DATE
, /* 22 */ MATURITY_DATE
, /* 23 */ EXCHANGE_RATE_DATE
, /* 24 */ EXCHANGE_RATE_TYPE
, /* 25 */ USER_EXCHANGE_RATE_TYPE
, /* 26 */ EXCHANGE_RATE
, /* 27 */ BANK_CHARGES
, /* 28 */ BANK_ERRORS
, /* 29 */ BATCH_NAME
, /* 30 */ BATCH_ID
, /* 31 */ AGENT_NAME
, /* 32 */ CUSTOMER_NAME
, /* 33 */ PAYMENT_METHOD
, /* 34 */ VENDOR_NAME
, /* 35 */ CUSTOMER_ID
, /* 36 */ SUPPLIER_ID
, /* 37 */ REFERENCE_TYPE_DSP
, /* 38 */ REFERENCE_TYPE
, /* 39 */ REFERENCE_ID
, /* 40 */ ACTUAL_AMOUNT_CLEARED
, /* 41 */ CREATION_DATE
, /* 42 */ CREATED_BY
, /* 43 */ LAST_UPDATE_DATE
, /* 44 */ LAST_UPDATED_BY
, /* 45 */ REMITTANCE_NUMBER
, /* 46 */ CASH_RECEIPT_ID
, /* 47 */ APPLICATION_ID
, /* 48 */ COUNT_CLEARED
, /* 49 */ BANK_CURRENCY_CODE
, /* 50 */ TRX_CURRENCY_TYPE
, /* 51 */ CODE_COMBINATION_ID
, /* 52 */ PERIOD_NAME
, /* 53 */ JOURNAL_ENTRY_NAME
, /* 54 */ DOCUMENT_NUMBER
, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER
, /* 56 */ CLEARING_TRX_TYPE
, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, /* 58 */ EXCHANGE_RATE
, 'Y'
, DECODE(EXCHANGE_RATE
, NULL
, NULL
, 1/EXCHANGE_RATE))
, JOURNAL_CATEGORY
, /* 59 */ BASE_AMOUNT
, /* 60 */ RECEIPT_CLASS_ID
, /* 61 */ RECEIPT_METHOD_ID
, /* 62 */ RECEIPT_CLASS_NAME
, /* 63 */ DEPOSIT_DATE
, /* 64 */ REVERSED_RECEIPT_FLAG
, /* 65 */ TO_DATE(NULL)
, /* 66 */ CE_BANK_ACCT_USE_ID
, LEGAL_ENTITY_ID
, ORG_ID
, NULL
, NULL
FROM CE_801_TRANSACTIONS_V
WHERE CE_AUTO_BANK_MATCH.GET_801 = 1 UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ BANK_ACCOUNT_ID
, /* 3 */ BANK_ACCOUNT_NAME
, /* 4 */ BANK_ACCOUNT_NUM
, /* 5 */ BANK_NAME
, /* 6 */ BANK_BRANCH_NAME
, /* 7 */ TRX_ID
, /* 8 */ TRX_TYPE
, /* 9 */ TYPE_MEANING
, /* 10 */ TRX_NUMBER
, /* 11 */ CHECK_NUMBER
, /* 12 */ CURRENCY_CODE
, /* 13 */ AMOUNT
, /* 14 */ BANK_ACCOUNT_AMOUNT
, /* 15 */ AMOUNT_CLEARED
, /* 16 */ GL_DATE
, /* 17 */ STATUS_DSP
, /* 18 */ STATUS
, /* 19 */ NULL
, /* 20 */ TRX_DATE
, /* 21 */ CLEARED_DATE
, /* 22 */ MATURITY_DATE
, /* 23 */ EXCHANGE_RATE_DATE
, /* 24 */ EXCHANGE_RATE_TYPE
, /* 25 */ USER_EXCHANGE_RATE_TYPE
, /* 26 */ EXCHANGE_RATE
, /* 27 */ BANK_CHARGES
, /* 28 */ BANK_ERRORS
, /* 29 */ BATCH_NAME
, /* 30 */ BATCH_ID
, /* 31 */ AGENT_NAME
, /* 32 */ CUSTOMER_NAME
, /* 33 */ PAYMENT_METHOD
, /* 34 */ VENDOR_NAME
, /* 35 */ CUSTOMER_ID
, /* 36 */ SUPPLIER_ID
, /* 37 */ REFERENCE_TYPE_DSP
, /* 38 */ REFERENCE_TYPE
, /* 39 */ REFERENCE_ID
, /* 40 */ ACTUAL_AMOUNT_CLEARED
, /* 41 */ CREATION_DATE
, /* 42 */ CREATED_BY
, /* 43 */ LAST_UPDATE_DATE
, /* 44 */ LAST_UPDATED_BY
, /* 45 */ REMITTANCE_NUMBER
, /* 46 */ CASH_RECEIPT_ID
, /* 47 */ APPLICATION_ID
, /* 48 */ COUNT_CLEARED
, /* 49 */ BANK_CURRENCY_CODE
, /* 50 */ TRX_CURRENCY_TYPE
, /* 51 */ CODE_COMBINATION_ID
, /* 52 */ PERIOD_NAME
, /* 53 */ JOURNAL_ENTRY_NAME
, /* 54 */ DOCUMENT_NUMBER
, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER
, /* 56 */ CLEARING_TRX_TYPE
, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, /* 58 */ EXCHANGE_RATE
, 'Y'
, DECODE(EXCHANGE_RATE
, NULL
, NULL
, 1/EXCHANGE_RATE))
, JOURNAL_CATEGORY
, /* 59 */ BASE_AMOUNT
, /* 60 */ RECEIPT_CLASS_ID
, /* 61 */ RECEIPT_METHOD_ID
, /* 62 */ RECEIPT_CLASS_NAME
, /* 63 */ DEPOSIT_DATE
, /* 64 */ REVERSED_RECEIPT_FLAG
, /* 65 */ TO_DATE(NULL)
, /* 66 */ CE_BANK_ACCT_USE_ID
, LEGAL_ENTITY_ID
, ORG_ID
, NULL
, NULL
FROM CE_801_EFT_TRANSACTIONS_V
WHERE CE_AUTO_BANK_MATCH.GET_801 = 1 UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ BANK_ACCOUNT_ID
, /* 3 */ BANK_ACCOUNT_NAME
, /* 4 */ BANK_ACCOUNT_NUM
, /* 5 */ BANK_NAME
, /* 6 */ BANK_BRANCH_NAME
, /* 7 */ TRX_ID
, /* 8 */ TRX_TYPE
, /* 9 */ TYPE_MEANING
, /* 10 */ TRX_NUMBER
, /* 11 */ TO_NUMBER(NULL)
, /* 12 */ CURRENCY_CODE
, /* 13 */ AMOUNT
, /* 14 */ BANK_ACCOUNT_AMOUNT
, /* 15 */ AMOUNT_CLEARED
, /* 16 */ GL_DATE
, /* 17 */ STATUS_DSP
, /* 17 */ STATUS
, /* 18 */ NULL
, /* 20 */ TRX_DATE
, /* 21 */ CLEARED_DATE
, /* 22 */ MATURITY_DATE
, /* 23 */ EXCHANGE_RATE_DATE
, /* 24 */ EXCHANGE_RATE_TYPE
, /* 25 */ USER_EXCHANGE_RATE_TYPE
, /* 26 */ EXCHANGE_RATE
, /* 27 */ BANK_CHARGES
, /* 28 */ BANK_ERRORS
, /* 29 */ BATCH_NAME
, /* 30 */ BATCH_ID
, /* 31 */ AGENT_NAME
, /* 32 */ CUSTOMER_NAME
, /* 33 */ PAYMENT_METHOD
, /* 34 */ VENDOR_NAME
, /* 35 */ CUSTOMER_ID
, /* 36 */ SUPPLIER_ID
, /* 37 */ REFERENCE_TYPE_DSP
, /* 38 */ REFERENCE_TYPE
, /* 39 */ REFERENCE_ID
, /* 40 */ ACTUAL_AMOUNT_CLEARED
, /* 41 */ CREATION_DATE
, /* 42 */ CREATED_BY
, /* 43 */ LAST_UPDATE_DATE
, /* 44 */ LAST_UPDATED_BY
, /* 45 */ REMITTANCE_NUMBER
, /* 46 */ CASH_RECEIPT_ID
, /* 47 */ APPLICATION_ID
, /* 48 */ COUNT_CLEARED
, /* 49 */ BANK_CURRENCY_CODE
, /* 50 */ TRX_CURRENCY_TYPE
, /* 51 */ CODE_COMBINATION_ID
, /* 52 */ PERIOD_NAME
, /* 53 */ JOURNAL_ENTRY_NAME
, /* 54 */ DOCUMENT_NUMBER
, /* 55 */ JOURNAL_ENTRY_LINE_NUMBER
, /* 56 */ CLEARING_TRX_TYPE
, /* 57 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, /* 58 */ EXCHANGE_RATE
, 'Y'
, DECODE(EXCHANGE_RATE
, NULL
, NULL
, 1/EXCHANGE_RATE))
, JOURNAL_CATEGORY
, /* 59 */ BASE_AMOUNT
, /* 60 */ TO_NUMBER(NULL)
, /* 61 */ TO_NUMBER(NULL)
, /* 62 */ NULL
, /* 63 */ TO_DATE(NULL)
, /* 64 */ NULL
, /* 65 */ TO_DATE(NULL)
, /* 66 */ CE_BANK_ACCT_USE_ID
, LEGAL_ENTITY_ID
, ORG_ID
, NULL
, NULL
FROM CE_999_TRANSACTIONS_V
WHERE CE_AUTO_BANK_MATCH.GET_999 = 1