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_RECONCILED_TRANSACTIONS_V

Source

View Text - Preformatted


SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ STATEMENT_LINE_ID, /* 3 */ BANK_ACCOUNT_ID, /* 4 */ TRX_ID, /* 5 */ TRX_TYPE, /* 6 */ TYPE_MEANING, /* 7 */ TRX_NUMBER, /* 8 */ CURRENCY_CODE, /* 9 */ TRX_CURRENCY_TYPE, /* 10 */ AMOUNT, /* 11 */ BANK_ACCOUNT_AMOUNT, /* 12 */ AMOUNT_CLEARED, /* 13 */ GL_DATE, /* 14 */ STATUS_DSP, /* 15 */ STATUS, /* 16 */ TRX_DATE, /* 17 */ CLEARED_DATE, /* 18 */ MATURITY_DATE, /* 19 */ EXCHANGE_RATE_DATE, /* 20 */ EXCHANGE_RATE_TYPE, /* 21 */ EXCHANGE_RATE, /* 22 */ BANK_CHARGES, /* 23 */ BANK_ERRORS, /* 24 */ BATCH_NAME, /* 25 */ BATCH_ID, /* 26 */ AGENT_NAME, /* 27 */ CUSTOMER_NAME, /* 28 */ VENDOR_NAME, /* 29 */ CUSTOMER_ID, /* 30 */ SUPPLIER_ID, /* 31 */ REFERENCE_TYPE_DSP, /* 32 */ REFERENCE_TYPE, /* 33 */ REFERENCE_ID, /* 34 */ CREATION_DATE, /* 35 */ CREATED_BY, /* 36 */ LAST_UPDATE_DATE, /* 37 */ LAST_UPDATED_BY, /* 38 */ STATEMENT_HEADER_ID, /* 39 */ CASH_RECEIPT_ID, /* 40 */ BANK_BRANCH_ID, /* 41 */ RECEIPT_DATE, /* 42 */ POSTED_FLAG, /* 43 */ POSTED_DATE, /* 44 */ LINE_TYPE_MEANING, /* 45 */ STATEMENT_LINE_NUMBER, /* 46 */ STATEMENT_LINE_DATE, /* 47 */ STATEMENT_LINE_AMOUNT, /* 48 */ STATEMENT_LINE_STATUS_MEANING, /* 49 */ STATEMENT_LINE_TYPE_MEANING, /* 50 */ STATEMENT_HEADER_NUMBER, /* 51 */ STATEMENT_HEADER_DATE, /* 52 */ BANK_ACCOUNT_NAME, /* 53 */ BANK_ACCOUNT_NUM, /* 54 */ BANK_CURRENCY_CODE, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE, /* 56 */ LINE_TRX_TYPE, /* 57 */ REMITTANCE_NUMBER, /* 58 */ CONTROL_END_BALANCE, /* 59 */ APPLICATION_ID, /* 60 */ COUNT_CLEARED, /* 61 */ ACTUAL_AMOUNT_CLEARED, /* 62 */ CLEARING_TRX_TYPE, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', EXCHANGE_RATE, 'Y',DECODE(NVL(EXCHANGE_RATE,0),0,TO_NUMBER(NULL) ,1/EXCHANGE_RATE)), /* 64 */ NULL, /* 65 */ TO_DATE(NULL) /* 66 */ ,CE_BANK_ACCT_USE_ID ,ORG_ID ,LEGAL_ENTITY_ID FROM CE_101_RECONCILED_V UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ STATEMENT_LINE_ID, /* 3 */ BANK_ACCOUNT_ID, /* 4 */ TRX_ID, /* 5 */ TRX_TYPE, /* 6 */ TYPE_MEANING, /* 7 */ TRX_NUMBER, /* 8 */ CURRENCY_CODE, /* 9 */ TRX_CURRENCY_TYPE, /* 10 */ AMOUNT, /* 11 */ BANK_ACCOUNT_AMOUNT, /* 12 */ AMOUNT_CLEARED, /* 13 */ GL_DATE, /* 14 */ STATUS_DSP, /* 15 */ STATUS, /* 16 */ TRX_DATE, /* 17 */ CLEARED_DATE, /* 18 */ MATURITY_DATE, /* 19 */ EXCHANGE_RATE_DATE, /* 20 */ EXCHANGE_RATE_TYPE, /* 21 */ EXCHANGE_RATE, /* 22 */ BANK_CHARGES, /* 23 */ BANK_ERRORS, /* 24 */ BATCH_NAME, /* 25 */ BATCH_ID, /* 26 */ AGENT_NAME, /* 27 */ CUSTOMER_NAME, /* 28 */ VENDOR_NAME, /* 29 */ CUSTOMER_ID, /* 30 */ SUPPLIER_ID, /* 31 */ REFERENCE_TYPE_DSP, /* 32 */ REFERENCE_TYPE, /* 33 */ REFERENCE_ID, /* 34 */ CREATION_DATE, /* 35 */ CREATED_BY, /* 36 */ LAST_UPDATE_DATE, /* 37 */ LAST_UPDATED_BY, /* 38 */ STATEMENT_HEADER_ID, /* 39 */ CASH_RECEIPT_ID, /* 40 */ BANK_BRANCH_ID, /* 41 */ RECEIPT_DATE, /* 42 */ POSTED_FLAG, /* 43 */ POSTED_DATE, /* 44 */ LINE_TYPE_MEANING, /* 45 */ STATEMENT_LINE_NUMBER, /* 46 */ STATEMENT_LINE_DATE, /* 47 */ STATEMENT_LINE_AMOUNT, /* 48 */ STATEMENT_LINE_STATUS_MEANING, /* 49 */ STATEMENT_LINE_TYPE_MEANING, /* 50 */ STATEMENT_HEADER_NUMBER, /* 51 */ STATEMENT_HEADER_DATE, /* 52 */ BANK_ACCOUNT_NAME, /* 53 */ BANK_ACCOUNT_NUM, /* 54 */ BANK_CURRENCY_CODE, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE, /* 56 */ LINE_TRX_TYPE, /* 57 */ REMITTANCE_NUMBER, /* 58 */ CONTROL_END_BALANCE, /* 59 */ APPLICATION_ID, /* 60 */ COUNT_CLEARED, /* 61 */ ACTUAL_AMOUNT_CLEARED, /* 62 */ CLEARING_TRX_TYPE, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', EXCHANGE_RATE,'Y',DECODE(NVL(EXCHANGE_RATE,0), 0,TO_NUMBER(NULL), 1/EXCHANGE_RATE)), /* 64 */ NULL, /* 65 */ VALUE_DATE /* 66 */ ,CE_BANK_ACCT_USE_ID ,ORG_ID ,LEGAL_ENTITY_ID FROM CE_200_RECONCILED_V UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ STATEMENT_LINE_ID, /* 3 */ BANK_ACCOUNT_ID, /* 4 */ TRX_ID, /* 5 */ TRX_TYPE, /* 6 */ TYPE_MEANING, /* 7 */ TRX_NUMBER, /* 8 */ CURRENCY_CODE, /* 9 */ TRX_CURRENCY_TYPE, /* 10 */ AMOUNT, /* 11 */ BANK_ACCOUNT_AMOUNT, /* 12 */ AMOUNT_CLEARED, /* 13 */ GL_DATE, /* 14 */ STATUS_DSP, /* 15 */ STATUS, /* 16 */ TRX_DATE, /* 17 */ CLEARED_DATE, /* 18 */ MATURITY_DATE, /* 19 */ EXCHANGE_RATE_DATE, /* 20 */ EXCHANGE_RATE_TYPE, /* 21 */ EXCHANGE_RATE, /* 22 */ BANK_CHARGES, /* 23 */ BANK_ERRORS, /* 24 */ BATCH_NAME, /* 25 */ BATCH_ID, /* 26 */ AGENT_NAME, /* 27 */ CUSTOMER_NAME, /* 28 */ VENDOR_NAME, /* 29 */ CUSTOMER_ID, /* 30 */ SUPPLIER_ID, /* 31 */ REFERENCE_TYPE_DSP, /* 32 */ REFERENCE_TYPE, /* 33 */ REFERENCE_ID, /* 34 */ CREATION_DATE, /* 35 */ CREATED_BY, /* 36 */ LAST_UPDATE_DATE, /* 37 */ LAST_UPDATED_BY, /* 38 */ STATEMENT_HEADER_ID, /* 39 */ CASH_RECEIPT_ID, /* 40 */ BANK_BRANCH_ID, /* 41 */ RECEIPT_DATE, /* 42 */ POSTED_FLAG, /* 43 */ POSTED_DATE, /* 44 */ LINE_TYPE_MEANING, /* 45 */ STATEMENT_LINE_NUMBER, /* 46 */ STATEMENT_LINE_DATE, /* 47 */ STATEMENT_LINE_AMOUNT, /* 48 */ STATEMENT_LINE_STATUS_MEANING, /* 49 */ STATEMENT_LINE_TYPE_MEANING, /* 50 */ STATEMENT_HEADER_NUMBER, /* 51 */ STATEMENT_HEADER_DATE, /* 52 */ BANK_ACCOUNT_NAME, /* 53 */ BANK_ACCOUNT_NUM, /* 54 */ BANK_CURRENCY_CODE, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE, /* 56 */ LINE_TRX_TYPE, /* 57 */ REMITTANCE_NUMBER, /* 58 */ CONTROL_END_BALANCE, /* 59 */ APPLICATION_ID, /* 60 */ COUNT_CLEARED, /* 61 */ ACTUAL_AMOUNT_CLEARED, /* 62 */ CLEARING_TRX_TYPE, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', EXCHANGE_RATE,'Y',DECODE(NVL(EXCHANGE_RATE,0), 0,TO_NUMBER(NULL), 1/EXCHANGE_RATE)), /* 64 */ NULL, /* 65 */ VALUE_DATE /* 66 */ ,CE_BANK_ACCT_USE_ID ,ORG_ID ,LEGAL_ENTITY_ID FROM CE_222_RECONCILED_V UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ STATEMENT_LINE_ID, /* 3 */ BANK_ACCOUNT_ID, /* 4 */ TRX_ID, /* 5 */ TRX_TYPE, /* 6 */ TYPE_MEANING, /* 7 */ TRX_NUMBER, /* 8 */ CURRENCY_CODE, /* 9 */ TRX_CURRENCY_TYPE, /* 10 */ AMOUNT, /* 11 */ BANK_ACCOUNT_AMOUNT, /* 12 */ AMOUNT_CLEARED, /* 13 */ GL_DATE, /* 14 */ STATUS_DSP, /* 15 */ STATUS, /* 16 */ TRX_DATE, /* 17 */ CLEARED_DATE, /* 18 */ MATURITY_DATE, /* 19 */ EXCHANGE_RATE_DATE, /* 20 */ EXCHANGE_RATE_TYPE, /* 21 */ EXCHANGE_RATE, /* 22 */ BANK_CHARGES, /* 23 */ BANK_ERRORS, /* 24 */ BATCH_NAME, /* 25 */ BATCH_ID, /* 26 */ AGENT_NAME, /* 27 */ CUSTOMER_NAME, /* 28 */ VENDOR_NAME, /* 29 */ CUSTOMER_ID, /* 30 */ SUPPLIER_ID, /* 31 */ REFERENCE_TYPE_DSP, /* 32 */ REFERENCE_TYPE, /* 33 */ REFERENCE_ID, /* 34 */ CREATION_DATE, /* 35 */ CREATED_BY, /* 36 */ LAST_UPDATE_DATE, /* 37 */ LAST_UPDATED_BY, /* 38 */ STATEMENT_HEADER_ID, /* 39 */ CASH_RECEIPT_ID, /* 40 */ BANK_BRANCH_ID, /* 41 */ RECEIPT_DATE, /* 42 */ POSTED_FLAG, /* 43 */ POSTED_DATE, /* 44 */ LINE_TYPE_MEANING, /* 45 */ STATEMENT_LINE_NUMBER, /* 46 */ STATEMENT_LINE_DATE, /* 47 */ STATEMENT_LINE_AMOUNT, /* 48 */ STATEMENT_LINE_STATUS_MEANING, /* 49 */ STATEMENT_LINE_TYPE_MEANING, /* 50 */ STATEMENT_HEADER_NUMBER, /* 51 */ STATEMENT_HEADER_DATE, /* 52 */ BANK_ACCOUNT_NAME, /* 53 */ BANK_ACCOUNT_NUM, /* 54 */ BANK_CURRENCY_CODE, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE, /* 56 */ LINE_TRX_TYPE, /* 57 */ REMITTANCE_NUMBER, /* 58 */ CONTROL_END_BALANCE, /* 59 */ APPLICATION_ID, /* 60 */ COUNT_CLEARED, /* 61 */ ACTUAL_AMOUNT_CLEARED, /* 62 */ CLEARING_TRX_TYPE, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', EXCHANGE_RATE,'Y',DECODE(NVL(EXCHANGE_RATE,0), 0,TO_NUMBER(NULL), 1/EXCHANGE_RATE)), /* 64d */ STATEMENT_COMPLETE_FLAG, /* 65 */ TO_DATE(NULL) /* 66 */ ,CE_BANK_ACCT_USE_ID ,ORG_ID ,LEGAL_ENTITY_ID FROM CE_260_RECONCILED_V UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ STATEMENT_LINE_ID, /* 3 */ BANK_ACCOUNT_ID, /* 4 */ TRX_ID, /* 5 */ TRX_TYPE, /* 6 */ TYPE_MEANING, /* 7 */ TRX_NUMBER, /* 8 */ CURRENCY_CODE, /* 9 */ TRX_CURRENCY_TYPE, /* 10 */ AMOUNT, /* 11 */ BANK_ACCOUNT_AMOUNT, /* 12 */ AMOUNT_CLEARED, /* 13 */ GL_DATE, /* 14 */ STATUS_DSP, /* 15 */ STATUS, /* 16 */ TRX_DATE, /* 17 */ CLEARED_DATE, /* 18 */ MATURITY_DATE, /* 19 */ EXCHANGE_RATE_DATE, /* 20 */ EXCHANGE_RATE_TYPE, /* 21 */ EXCHANGE_RATE, /* 22 */ BANK_CHARGES, /* 23 */ BANK_ERRORS, /* 24 */ BATCH_NAME, /* 25 */ BATCH_ID, /* 26 */ AGENT_NAME, /* 27 */ CUSTOMER_NAME, /* 28 */ VENDOR_NAME, /* 29 */ CUSTOMER_ID, /* 30 */ SUPPLIER_ID, /* 31 */ REFERENCE_TYPE_DSP, /* 32 */ REFERENCE_TYPE, /* 33 */ REFERENCE_ID, /* 34 */ CREATION_DATE, /* 35 */ CREATED_BY, /* 36 */ LAST_UPDATE_DATE, /* 37 */ LAST_UPDATED_BY, /* 38 */ STATEMENT_HEADER_ID, /* 39 */ CASH_RECEIPT_ID, /* 40 */ BANK_BRANCH_ID, /* 41 */ RECEIPT_DATE, /* 42 */ POSTED_FLAG, /* 43 */ POSTED_DATE, /* 44 */ LINE_TYPE_MEANING, /* 45 */ STATEMENT_LINE_NUMBER, /* 46 */ STATEMENT_LINE_DATE, /* 47 */ STATEMENT_LINE_AMOUNT, /* 48 */ STATEMENT_LINE_STATUS_MEANING, /* 49 */ STATEMENT_LINE_TYPE_MEANING, /* 50 */ STATEMENT_HEADER_NUMBER, /* 51 */ STATEMENT_HEADER_DATE, /* 52 */ BANK_ACCOUNT_NAME, /* 53 */ BANK_ACCOUNT_NUM, /* 54 */ BANK_CURRENCY_CODE, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE, /* 56 */ LINE_TRX_TYPE, /* 57 */ REMITTANCE_NUMBER, /* 58 */ CONTROL_END_BALANCE, /* 59 */ APPLICATION_ID, /* 60 */ COUNT_CLEARED, /* 61 */ ACTUAL_AMOUNT_CLEARED, /* 62 */ CLEARING_TRX_TYPE, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', EXCHANGE_RATE,'Y',DECODE(NVL(EXCHANGE_RATE,0), 0,TO_NUMBER(NULL), 1/EXCHANGE_RATE)), /* 64d */ STATEMENT_COMPLETE_FLAG, /* 65 */ VALUE_DATE /* 66 */ ,CE_BANK_ACCT_USE_ID ,ORG_ID ,LEGAL_ENTITY_ID FROM CE_260_CF_RECONCILED_V UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ STATEMENT_LINE_ID, /* 3 */ BANK_ACCOUNT_ID, /* 4 */ TRX_ID, /* 5 */ TRX_TYPE, /* 6 */ TYPE_MEANING, /* 7 */ TRX_NUMBER, /* 8 */ CURRENCY_CODE, /* 9 */ TRX_CURRENCY_TYPE, /* 10 */ AMOUNT, /* 11 */ BANK_ACCOUNT_AMOUNT, /* 12 */ AMOUNT_CLEARED, /* 13 */ GL_DATE, /* 14 */ STATUS_DSP, /* 15 */ STATUS, /* 16 */ TRX_DATE, /* 17 */ CLEARED_DATE, /* 18 */ MATURITY_DATE, /* 19 */ EXCHANGE_RATE_DATE, /* 20 */ EXCHANGE_RATE_TYPE, /* 21 */ EXCHANGE_RATE, /* 22 */ BANK_CHARGES, /* 23 */ BANK_ERRORS, /* 24 */ BATCH_NAME, /* 25 */ BATCH_ID, /* 26 */ AGENT_NAME, /* 27 */ CUSTOMER_NAME, /* 28 */ VENDOR_NAME, /* 29 */ CUSTOMER_ID, /* 30 */ SUPPLIER_ID, /* 31 */ REFERENCE_TYPE_DSP, /* 32 */ REFERENCE_TYPE, /* 33 */ REFERENCE_ID, /* 34 */ CREATION_DATE, /* 35 */ CREATED_BY, /* 36 */ LAST_UPDATE_DATE, /* 37 */ LAST_UPDATED_BY, /* 38 */ STATEMENT_HEADER_ID, /* 39 */ CASH_RECEIPT_ID, /* 40 */ BANK_BRANCH_ID, /* 41 */ RECEIPT_DATE, /* 42 */ POSTED_FLAG, /* 43 */ POSTED_DATE, /* 44 */ LINE_TYPE_MEANING, /* 45 */ STATEMENT_LINE_NUMBER, /* 46 */ STATEMENT_LINE_DATE, /* 47 */ STATEMENT_LINE_AMOUNT, /* 48 */ STATEMENT_LINE_STATUS_MEANING, /* 49 */ STATEMENT_LINE_TYPE_MEANING, /* 50 */ STATEMENT_HEADER_NUMBER, /* 51 */ STATEMENT_HEADER_DATE, /* 52 */ BANK_ACCOUNT_NAME, /* 53 */ BANK_ACCOUNT_NUM, /* 54 */ BANK_CURRENCY_CODE, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE, /* 56 */ LINE_TRX_TYPE, /* 57 */ REMITTANCE_NUMBER, /* 58 */ CONTROL_END_BALANCE, /* 59 */ APPLICATION_ID, /* 60 */ COUNT_CLEARED, /* 61 */ ACTUAL_AMOUNT_CLEARED, /* 62 */ CLEARING_TRX_TYPE, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', EXCHANGE_RATE,'Y',DECODE(NVL(EXCHANGE_RATE,0), 0,TO_NUMBER(NULL), 1/EXCHANGE_RATE)), /* 64e */ NULL, /* 65 */ TO_DATE(NULL) /* 66 */ ,CE_BANK_ACCT_USE_ID ,ORG_ID ,LEGAL_ENTITY_ID FROM CE_801_RECONCILED_V UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ STATEMENT_LINE_ID, /* 3 */ BANK_ACCOUNT_ID, /* 4 */ TRX_ID, /* 5 */ TRX_TYPE, /* 6 */ TYPE_MEANING, /* 7 */ TRX_NUMBER, /* 8 */ CURRENCY_CODE, /* 9 */ TRX_CURRENCY_TYPE, /* 10 */ AMOUNT, /* 11 */ BANK_ACCOUNT_AMOUNT, /* 12 */ AMOUNT_CLEARED, /* 13 */ GL_DATE, /* 14 */ STATUS_DSP, /* 15 */ STATUS, /* 16 */ TRX_DATE, /* 17 */ CLEARED_DATE, /* 18 */ MATURITY_DATE, /* 19 */ EXCHANGE_RATE_DATE, /* 20 */ EXCHANGE_RATE_TYPE, /* 21 */ EXCHANGE_RATE, /* 22 */ BANK_CHARGES, /* 23 */ BANK_ERRORS, /* 24 */ BATCH_NAME, /* 25 */ BATCH_ID, /* 26 */ AGENT_NAME, /* 27 */ CUSTOMER_NAME, /* 28 */ VENDOR_NAME, /* 29 */ CUSTOMER_ID, /* 30 */ SUPPLIER_ID, /* 31 */ REFERENCE_TYPE_DSP, /* 32 */ REFERENCE_TYPE, /* 33 */ REFERENCE_ID, /* 34 */ CREATION_DATE, /* 35 */ CREATED_BY, /* 36 */ LAST_UPDATE_DATE, /* 37 */ LAST_UPDATED_BY, /* 38 */ STATEMENT_HEADER_ID, /* 39 */ CASH_RECEIPT_ID, /* 40 */ BANK_BRANCH_ID, /* 41 */ RECEIPT_DATE, /* 42 */ POSTED_FLAG, /* 43 */ POSTED_DATE, /* 44 */ LINE_TYPE_MEANING, /* 45 */ STATEMENT_LINE_NUMBER, /* 46 */ STATEMENT_LINE_DATE, /* 47 */ STATEMENT_LINE_AMOUNT, /* 48 */ STATEMENT_LINE_STATUS_MEANING, /* 49 */ STATEMENT_LINE_TYPE_MEANING, /* 50 */ STATEMENT_HEADER_NUMBER, /* 51 */ STATEMENT_HEADER_DATE, /* 52 */ BANK_ACCOUNT_NAME, /* 53 */ BANK_ACCOUNT_NUM, /* 54 */ BANK_CURRENCY_CODE, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE, /* 56 */ LINE_TRX_TYPE, /* 57 */ REMITTANCE_NUMBER, /* 58 */ CONTROL_END_BALANCE, /* 59 */ APPLICATION_ID, /* 60 */ COUNT_CLEARED, /* 61 */ ACTUAL_AMOUNT_CLEARED, /* 62 */ CLEARING_TRX_TYPE, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', EXCHANGE_RATE,'Y',DECODE(NVL(EXCHANGE_RATE,0), 0,TO_NUMBER(NULL), 1/EXCHANGE_RATE)), /* 64e */ NULL, /* 65 */ TO_DATE(NULL) /* 66 */ ,CE_BANK_ACCT_USE_ID ,ORG_ID ,LEGAL_ENTITY_ID FROM CE_801_EFT_RECONCILED_V UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ STATEMENT_LINE_ID, /* 3 */ BANK_ACCOUNT_ID, /* 4 */ TRX_ID, /* 5 */ TRX_TYPE, /* 6 */ TYPE_MEANING, /* 7 */ TRX_NUMBER, /* 8 */ CURRENCY_CODE, /* 9 */ TRX_CURRENCY_TYPE, /* 10 */ AMOUNT, /* 11 */ BANK_ACCOUNT_AMOUNT, /* 12 */ AMOUNT_CLEARED, /* 13 */ GL_DATE, /* 14 */ STATUS_DSP, /* 15 */ STATUS, /* 16 */ TRX_DATE, /* 17 */ CLEARED_DATE, /* 18 */ MATURITY_DATE, /* 19 */ EXCHANGE_RATE_DATE, /* 20 */ EXCHANGE_RATE_TYPE, /* 21 */ EXCHANGE_RATE, /* 22 */ BANK_CHARGES, /* 23 */ BANK_ERRORS, /* 24 */ BATCH_NAME, /* 25 */ BATCH_ID, /* 26 */ AGENT_NAME, /* 27 */ CUSTOMER_NAME, /* 28 */ VENDOR_NAME, /* 29 */ CUSTOMER_ID, /* 30 */ SUPPLIER_ID, /* 31 */ REFERENCE_TYPE_DSP, /* 32 */ REFERENCE_TYPE, /* 33 */ REFERENCE_ID, /* 34 */ CREATION_DATE, /* 35 */ CREATED_BY, /* 36 */ LAST_UPDATE_DATE, /* 37 */ LAST_UPDATED_BY, /* 38 */ STATEMENT_HEADER_ID, /* 39 */ CASH_RECEIPT_ID, /* 40 */ BANK_BRANCH_ID, /* 41 */ RECEIPT_DATE, /* 42 */ POSTED_FLAG, /* 43 */ POSTED_DATE, /* 44 */ LINE_TYPE_MEANING, /* 45 */ STATEMENT_LINE_NUMBER, /* 46 */ STATEMENT_LINE_DATE, /* 47 */ STATEMENT_LINE_AMOUNT, /* 48 */ STATEMENT_LINE_STATUS_MEANING, /* 49 */ STATEMENT_LINE_TYPE_MEANING, /* 50 */ STATEMENT_HEADER_NUMBER, /* 51 */ STATEMENT_HEADER_DATE, /* 52 */ BANK_ACCOUNT_NAME, /* 53 */ BANK_ACCOUNT_NUM, /* 54 */ BANK_CURRENCY_CODE, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE, /* 56 */ LINE_TRX_TYPE, /* 57 */ REMITTANCE_NUMBER, /* 58 */ CONTROL_END_BALANCE, /* 59 */ APPLICATION_ID, /* 60 */ COUNT_CLEARED, /* 61 */ ACTUAL_AMOUNT_CLEARED, /* 62 */ CLEARING_TRX_TYPE, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE,'N', EXCHANGE_RATE,'Y',DECODE(NVL(EXCHANGE_RATE,0), 0,TO_NUMBER(NULL), 1/EXCHANGE_RATE)), /* 64 */ NULL, /* 65 */ TO_DATE(NULL) /* 66 */ ,CE_BANK_ACCT_USE_ID ,ORG_ID ,LEGAL_ENTITY_ID FROM CE_999_RECONCILED_V

View Text - HTML Formatted

SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64 */ NULL
, /* 65 */ TO_DATE(NULL) /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM CE_101_RECONCILED_V UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64 */ NULL
, /* 65 */ VALUE_DATE /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM CE_200_RECONCILED_V UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64 */ NULL
, /* 65 */ VALUE_DATE /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM CE_222_RECONCILED_V UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64D */ STATEMENT_COMPLETE_FLAG
, /* 65 */ TO_DATE(NULL) /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM CE_260_RECONCILED_V UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64D */ STATEMENT_COMPLETE_FLAG
, /* 65 */ VALUE_DATE /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM CE_260_CF_RECONCILED_V UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64E */ NULL
, /* 65 */ TO_DATE(NULL) /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM CE_801_RECONCILED_V UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64E */ NULL
, /* 65 */ TO_DATE(NULL) /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM CE_801_EFT_RECONCILED_V UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ STATEMENT_LINE_ID
, /* 3 */ BANK_ACCOUNT_ID
, /* 4 */ TRX_ID
, /* 5 */ TRX_TYPE
, /* 6 */ TYPE_MEANING
, /* 7 */ TRX_NUMBER
, /* 8 */ CURRENCY_CODE
, /* 9 */ TRX_CURRENCY_TYPE
, /* 10 */ AMOUNT
, /* 11 */ BANK_ACCOUNT_AMOUNT
, /* 12 */ AMOUNT_CLEARED
, /* 13 */ GL_DATE
, /* 14 */ STATUS_DSP
, /* 15 */ STATUS
, /* 16 */ TRX_DATE
, /* 17 */ CLEARED_DATE
, /* 18 */ MATURITY_DATE
, /* 19 */ EXCHANGE_RATE_DATE
, /* 20 */ EXCHANGE_RATE_TYPE
, /* 21 */ EXCHANGE_RATE
, /* 22 */ BANK_CHARGES
, /* 23 */ BANK_ERRORS
, /* 24 */ BATCH_NAME
, /* 25 */ BATCH_ID
, /* 26 */ AGENT_NAME
, /* 27 */ CUSTOMER_NAME
, /* 28 */ VENDOR_NAME
, /* 29 */ CUSTOMER_ID
, /* 30 */ SUPPLIER_ID
, /* 31 */ REFERENCE_TYPE_DSP
, /* 32 */ REFERENCE_TYPE
, /* 33 */ REFERENCE_ID
, /* 34 */ CREATION_DATE
, /* 35 */ CREATED_BY
, /* 36 */ LAST_UPDATE_DATE
, /* 37 */ LAST_UPDATED_BY
, /* 38 */ STATEMENT_HEADER_ID
, /* 39 */ CASH_RECEIPT_ID
, /* 40 */ BANK_BRANCH_ID
, /* 41 */ RECEIPT_DATE
, /* 42 */ POSTED_FLAG
, /* 43 */ POSTED_DATE
, /* 44 */ LINE_TYPE_MEANING
, /* 45 */ STATEMENT_LINE_NUMBER
, /* 46 */ STATEMENT_LINE_DATE
, /* 47 */ STATEMENT_LINE_AMOUNT
, /* 48 */ STATEMENT_LINE_STATUS_MEANING
, /* 49 */ STATEMENT_LINE_TYPE_MEANING
, /* 50 */ STATEMENT_HEADER_NUMBER
, /* 51 */ STATEMENT_HEADER_DATE
, /* 52 */ BANK_ACCOUNT_NAME
, /* 53 */ BANK_ACCOUNT_NUM
, /* 54 */ BANK_CURRENCY_CODE
, /* 55 */ STATEMENT_DOC_SEQUENCE_VALUE
, /* 56 */ LINE_TRX_TYPE
, /* 57 */ REMITTANCE_NUMBER
, /* 58 */ CONTROL_END_BALANCE
, /* 59 */ APPLICATION_ID
, /* 60 */ COUNT_CLEARED
, /* 61 */ ACTUAL_AMOUNT_CLEARED
, /* 62 */ CLEARING_TRX_TYPE
, /* 63 */ DECODE(CE_AUTO_BANK_MATCH.GET_INVERSE_RATE
, 'N'
, EXCHANGE_RATE
, 'Y'
, DECODE(NVL(EXCHANGE_RATE
, 0)
, 0
, TO_NUMBER(NULL)
, 1/EXCHANGE_RATE))
, /* 64 */ NULL
, /* 65 */ TO_DATE(NULL) /* 66 */
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM CE_999_RECONCILED_V