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_REVERSAL_TRANSACTIONS_V

Source

View Text - Preformatted


SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ BANK_ACCOUNT_ID, /* 3 */ TRX_ID, /* 4 */ TRX_TYPE, /* 5 */ TYPE_MEANING, /* 6 */ TRX_NUMBER, /* 7 */ CURRENCY_CODE, /* 8 */ AMOUNT, /* 9 */ BANK_ACCOUNT_AMOUNT, /* 10 */ AMOUNT_CLEARED, /* 11 */ GL_DATE, /* 12 */ STATUS_DSP, /* 13 */ STATUS, /* 14 */ TRX_DATE, /* 15 */ CLEARED_DATE, /* 16 */ MATURITY_DATE, /* 17 */ BATCH_NAME, /* 18 */ AGENT_NAME, /* 19 */ CUSTOMER_ID, /* 20 */ SUPPLIER_ID, /* 21 */ CREATION_DATE, /* 22 */ CREATED_BY, /* 23 */ LAST_UPDATE_DATE, /* 24 */ LAST_UPDATED_BY, /* 25 */ PAYMENT_METHOD, /* 26 */ BANK_ACCOUNT_NUM, /* 27 */ BANK_ACCOUNT_NAME, /* 28 */ BANK_CURRENCY_CODE, /* 29 */ BANK_NAME, /* 30 */ REVERSAL_CATEGORY, /* 31 */ REVERSAL_CATEGORY_ID, /* 32 */ REVERSAL_REASON, /* 33 */ REVERSAL_REASON_ID, /* 34 */ REVERSAL_COMMENTS, /* 35 */ PAYMENT_METHOD_ID, /* 36 */ BATCH_ID, /* 37 */ CASH_RECEIPT_ID, /* 38 */ APPLICATION_ID, /* 39 */ REMITTANCE_NUMBER, /* 40 */ AGENT_NUMBER, /* 41 */ TRX_RECONCILED_FLAG, /* 42 */ STATEMENT_LINE_ID, /* 43 */ STATEMENT_NUMBER, /* 44 */ STATEMENT_LINE_AMOUNT, /* 45 */ TRX_CURRENCY_TYPE, /* 46 */ BASE_AMOUNT, /* 47 */ VALUE_DATE, /* 48 */ CE_BANK_ACCT_USE_ID, ORG_ID, TO_NUMBER(NULL) FROM CE_200_REVERSAL_V WHERE CE_AUTO_BANK_MATCH.GET_200 = 1 UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ BANK_ACCOUNT_ID, /* 3 */ TRX_ID, /* 4 */ TRX_TYPE, /* 5 */ TYPE_MEANING, /* 6 */ TRX_NUMBER, /* 7 */ CURRENCY_CODE, /* 8 */ AMOUNT, /* 9 */ BANK_ACCOUNT_AMOUNT, /* 10 */ AMOUNT_CLEARED, /* 11 */ GL_DATE, /* 12 */ STATUS_DSP, /* 13 */ STATUS, /* 14 */ TRX_DATE, /* 15 */ CLEARED_DATE, /* 16 */ MATURITY_DATE, /* 17 */ BATCH_NAME, /* 18 */ AGENT_NAME, /* 19 */ CUSTOMER_ID, /* 20 */ SUPPLIER_ID, /* 21 */ CREATION_DATE, /* 22 */ CREATED_BY, /* 23 */ LAST_UPDATE_DATE, /* 24 */ LAST_UPDATED_BY, /* 25 */ PAYMENT_METHOD, /* 26 */ BANK_ACCOUNT_NUM, /* 27 */ BANK_ACCOUNT_NAME, /* 28 */ BANK_CURRENCY_CODE, /* 29 */ BANK_NAME, /* 30 */ REVERSAL_CATEGORY, /* 31 */ REVERSAL_CATEGORY_ID, /* 32 */ REVERSAL_REASON, /* 33 */ REVERSAL_REASON_ID, /* 34 */ REVERSAL_COMMENTS, /* 35 */ PAYMENT_METHOD_ID, /* 36 */ BATCH_ID, /* 37 */ CASH_RECEIPT_ID, /* 38 */ APPLICATION_ID, /* 39 */ REMITTANCE_NUMBER, /* 40 */ AGENT_NUMBER, /* 41 */ TRX_RECONCILED_FLAG, /* 42 */ STATEMENT_LINE_ID, /* 43 */ STATEMENT_NUMBER, /* 44 */ STATEMENT_LINE_AMOUNT, /* 45 */ TRX_CURRENCY_TYPE, /* 46 */ BASE_AMOUNT, /* 47 */ VALUE_DATE, /* 48 */ CE_BANK_ACCT_USE_ID, ORG_ID, TO_NUMBER(NULL) FROM CE_222_REVERSAL_V WHERE CE_AUTO_BANK_MATCH.GET_222 = 1 UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ BANK_ACCOUNT_ID, /* 3 */ TRX_ID, /* 4 */ TRX_TYPE, /* 5 */ TYPE_MEANING, /* 6 */ TRX_NUMBER, /* 7 */ CURRENCY_CODE, /* 8 */ AMOUNT, /* 9 */ BANK_ACCOUNT_AMOUNT, /* 10 */ AMOUNT_CLEARED, /* 11 */ GL_DATE, /* 12 */ STATUS_DSP, /* 13 */ STATUS, /* 14 */ TRX_DATE, /* 15 */ CLEARED_DATE, /* 16 */ MATURITY_DATE, /* 17 */ BATCH_NAME, /* 18 */ AGENT_NAME, /* 19 */ CUSTOMER_ID, /* 20 */ SUPPLIER_ID, /* 21 */ CREATION_DATE, /* 22 */ CREATED_BY, /* 23 */ LAST_UPDATE_DATE, /* 24 */ LAST_UPDATED_BY, /* 25 */ PAYMENT_METHOD, /* 26 */ BANK_ACCOUNT_NUM, /* 27 */ BANK_ACCOUNT_NAME, /* 28 */ BANK_CURRENCY_CODE, /* 29 */ BANK_NAME, /* 30 */ REVERSAL_CATEGORY, /* 31 */ REVERSAL_CATEGORY_ID, /* 32 */ REVERSAL_REASON, /* 33 */ REVERSAL_REASON_ID, /* 34 */ REVERSAL_COMMENTS, /* 35 */ PAYMENT_METHOD_ID, /* 36 */ BATCH_ID, /* 37 */ CASH_RECEIPT_ID, /* 38 */ APPLICATION_ID, /* 39 */ REMITTANCE_NUMBER, /* 40 */ AGENT_NUMBER, /* 41 */ TRX_RECONCILED_FLAG, /* 42 */ STATEMENT_LINE_ID, /* 43 */ STATEMENT_NUMBER, /* 44 */ STATEMENT_LINE_AMOUNT, /* 45 */ TRX_CURRENCY_TYPE, /* 46 */ BASE_AMOUNT, /* 47 */ VALUE_DATE, /* 48 */ CE_BANK_ACCT_USE_ID, ORG_ID, LEGAL_ENTITY_ID FROM CE_260_CF_REVERSAL_V WHERE CE_AUTO_BANK_MATCH.GET_260 = 1 UNION ALL SELECT ROW_ID, /* 1 */ MULTI_SELECT, /* 2 */ BANK_ACCOUNT_ID, /* 3 */ TRX_ID, /* 4 */ TRX_TYPE, /* 5 */ TYPE_MEANING, /* 6 */ TRX_NUMBER, /* 7 */ CURRENCY_CODE, /* 8 */ AMOUNT, /* 9 */ BANK_ACCOUNT_AMOUNT, /* 10 */ AMOUNT_CLEARED, /* 11 */ GL_DATE, /* 12 */ STATUS_DSP, /* 13 */ STATUS, /* 14 */ TRX_DATE, /* 15 */ CLEARED_DATE, /* 16 */ MATURITY_DATE, /* 17 */ BATCH_NAME, /* 18 */ AGENT_NAME, /* 19 */ CUSTOMER_ID, /* 20 */ SUPPLIER_ID, /* 21 */ CREATION_DATE, /* 22 */ CREATED_BY, /* 23 */ LAST_UPDATE_DATE, /* 24 */ LAST_UPDATED_BY, /* 25 */ PAYMENT_METHOD, /* 26 */ BANK_ACCOUNT_NUM, /* 27 */ BANK_ACCOUNT_NAME, /* 28 */ BANK_CURRENCY_CODE, /* 29 */ BANK_NAME, /* 30 */ REVERSAL_CATEGORY, /* 31 */ REVERSAL_CATEGORY_ID, /* 32 */ REVERSAL_REASON, /* 33 */ REVERSAL_REASON_ID, /* 34 */ REVERSAL_COMMENTS, /* 35 */ PAYMENT_METHOD_ID, /* 36 */ BATCH_ID, /* 37 */ CASH_RECEIPT_ID, /* 38 */ APPLICATION_ID, /* 39 */ REMITTANCE_NUMBER, /* 40 */ AGENT_NUMBER, /* 41 */ TRX_RECONCILED_FLAG, /* 42 */ STATEMENT_LINE_ID, /* 43 */ STATEMENT_NUMBER, /* 44 */ STATEMENT_LINE_AMOUNT, /* 45 */ TRX_CURRENCY_TYPE, /* 46 */ BASE_AMOUNT, /* 47 */ VALUE_DATE, /* 48 */ CE_BANK_ACCT_USE_ID, ORG_ID, TO_NUMBER(NULL) FROM CE_999_REVERSAL_V WHERE CE_AUTO_BANK_MATCH.GET_999 = 1

View Text - HTML Formatted

SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ BANK_ACCOUNT_ID
, /* 3 */ TRX_ID
, /* 4 */ TRX_TYPE
, /* 5 */ TYPE_MEANING
, /* 6 */ TRX_NUMBER
, /* 7 */ CURRENCY_CODE
, /* 8 */ AMOUNT
, /* 9 */ BANK_ACCOUNT_AMOUNT
, /* 10 */ AMOUNT_CLEARED
, /* 11 */ GL_DATE
, /* 12 */ STATUS_DSP
, /* 13 */ STATUS
, /* 14 */ TRX_DATE
, /* 15 */ CLEARED_DATE
, /* 16 */ MATURITY_DATE
, /* 17 */ BATCH_NAME
, /* 18 */ AGENT_NAME
, /* 19 */ CUSTOMER_ID
, /* 20 */ SUPPLIER_ID
, /* 21 */ CREATION_DATE
, /* 22 */ CREATED_BY
, /* 23 */ LAST_UPDATE_DATE
, /* 24 */ LAST_UPDATED_BY
, /* 25 */ PAYMENT_METHOD
, /* 26 */ BANK_ACCOUNT_NUM
, /* 27 */ BANK_ACCOUNT_NAME
, /* 28 */ BANK_CURRENCY_CODE
, /* 29 */ BANK_NAME
, /* 30 */ REVERSAL_CATEGORY
, /* 31 */ REVERSAL_CATEGORY_ID
, /* 32 */ REVERSAL_REASON
, /* 33 */ REVERSAL_REASON_ID
, /* 34 */ REVERSAL_COMMENTS
, /* 35 */ PAYMENT_METHOD_ID
, /* 36 */ BATCH_ID
, /* 37 */ CASH_RECEIPT_ID
, /* 38 */ APPLICATION_ID
, /* 39 */ REMITTANCE_NUMBER
, /* 40 */ AGENT_NUMBER
, /* 41 */ TRX_RECONCILED_FLAG
, /* 42 */ STATEMENT_LINE_ID
, /* 43 */ STATEMENT_NUMBER
, /* 44 */ STATEMENT_LINE_AMOUNT
, /* 45 */ TRX_CURRENCY_TYPE
, /* 46 */ BASE_AMOUNT
, /* 47 */ VALUE_DATE
, /* 48 */ CE_BANK_ACCT_USE_ID
, ORG_ID
, TO_NUMBER(NULL)
FROM CE_200_REVERSAL_V
WHERE CE_AUTO_BANK_MATCH.GET_200 = 1 UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ BANK_ACCOUNT_ID
, /* 3 */ TRX_ID
, /* 4 */ TRX_TYPE
, /* 5 */ TYPE_MEANING
, /* 6 */ TRX_NUMBER
, /* 7 */ CURRENCY_CODE
, /* 8 */ AMOUNT
, /* 9 */ BANK_ACCOUNT_AMOUNT
, /* 10 */ AMOUNT_CLEARED
, /* 11 */ GL_DATE
, /* 12 */ STATUS_DSP
, /* 13 */ STATUS
, /* 14 */ TRX_DATE
, /* 15 */ CLEARED_DATE
, /* 16 */ MATURITY_DATE
, /* 17 */ BATCH_NAME
, /* 18 */ AGENT_NAME
, /* 19 */ CUSTOMER_ID
, /* 20 */ SUPPLIER_ID
, /* 21 */ CREATION_DATE
, /* 22 */ CREATED_BY
, /* 23 */ LAST_UPDATE_DATE
, /* 24 */ LAST_UPDATED_BY
, /* 25 */ PAYMENT_METHOD
, /* 26 */ BANK_ACCOUNT_NUM
, /* 27 */ BANK_ACCOUNT_NAME
, /* 28 */ BANK_CURRENCY_CODE
, /* 29 */ BANK_NAME
, /* 30 */ REVERSAL_CATEGORY
, /* 31 */ REVERSAL_CATEGORY_ID
, /* 32 */ REVERSAL_REASON
, /* 33 */ REVERSAL_REASON_ID
, /* 34 */ REVERSAL_COMMENTS
, /* 35 */ PAYMENT_METHOD_ID
, /* 36 */ BATCH_ID
, /* 37 */ CASH_RECEIPT_ID
, /* 38 */ APPLICATION_ID
, /* 39 */ REMITTANCE_NUMBER
, /* 40 */ AGENT_NUMBER
, /* 41 */ TRX_RECONCILED_FLAG
, /* 42 */ STATEMENT_LINE_ID
, /* 43 */ STATEMENT_NUMBER
, /* 44 */ STATEMENT_LINE_AMOUNT
, /* 45 */ TRX_CURRENCY_TYPE
, /* 46 */ BASE_AMOUNT
, /* 47 */ VALUE_DATE
, /* 48 */ CE_BANK_ACCT_USE_ID
, ORG_ID
, TO_NUMBER(NULL)
FROM CE_222_REVERSAL_V
WHERE CE_AUTO_BANK_MATCH.GET_222 = 1 UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ BANK_ACCOUNT_ID
, /* 3 */ TRX_ID
, /* 4 */ TRX_TYPE
, /* 5 */ TYPE_MEANING
, /* 6 */ TRX_NUMBER
, /* 7 */ CURRENCY_CODE
, /* 8 */ AMOUNT
, /* 9 */ BANK_ACCOUNT_AMOUNT
, /* 10 */ AMOUNT_CLEARED
, /* 11 */ GL_DATE
, /* 12 */ STATUS_DSP
, /* 13 */ STATUS
, /* 14 */ TRX_DATE
, /* 15 */ CLEARED_DATE
, /* 16 */ MATURITY_DATE
, /* 17 */ BATCH_NAME
, /* 18 */ AGENT_NAME
, /* 19 */ CUSTOMER_ID
, /* 20 */ SUPPLIER_ID
, /* 21 */ CREATION_DATE
, /* 22 */ CREATED_BY
, /* 23 */ LAST_UPDATE_DATE
, /* 24 */ LAST_UPDATED_BY
, /* 25 */ PAYMENT_METHOD
, /* 26 */ BANK_ACCOUNT_NUM
, /* 27 */ BANK_ACCOUNT_NAME
, /* 28 */ BANK_CURRENCY_CODE
, /* 29 */ BANK_NAME
, /* 30 */ REVERSAL_CATEGORY
, /* 31 */ REVERSAL_CATEGORY_ID
, /* 32 */ REVERSAL_REASON
, /* 33 */ REVERSAL_REASON_ID
, /* 34 */ REVERSAL_COMMENTS
, /* 35 */ PAYMENT_METHOD_ID
, /* 36 */ BATCH_ID
, /* 37 */ CASH_RECEIPT_ID
, /* 38 */ APPLICATION_ID
, /* 39 */ REMITTANCE_NUMBER
, /* 40 */ AGENT_NUMBER
, /* 41 */ TRX_RECONCILED_FLAG
, /* 42 */ STATEMENT_LINE_ID
, /* 43 */ STATEMENT_NUMBER
, /* 44 */ STATEMENT_LINE_AMOUNT
, /* 45 */ TRX_CURRENCY_TYPE
, /* 46 */ BASE_AMOUNT
, /* 47 */ VALUE_DATE
, /* 48 */ CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
FROM CE_260_CF_REVERSAL_V
WHERE CE_AUTO_BANK_MATCH.GET_260 = 1 UNION ALL SELECT ROW_ID
, /* 1 */ MULTI_SELECT
, /* 2 */ BANK_ACCOUNT_ID
, /* 3 */ TRX_ID
, /* 4 */ TRX_TYPE
, /* 5 */ TYPE_MEANING
, /* 6 */ TRX_NUMBER
, /* 7 */ CURRENCY_CODE
, /* 8 */ AMOUNT
, /* 9 */ BANK_ACCOUNT_AMOUNT
, /* 10 */ AMOUNT_CLEARED
, /* 11 */ GL_DATE
, /* 12 */ STATUS_DSP
, /* 13 */ STATUS
, /* 14 */ TRX_DATE
, /* 15 */ CLEARED_DATE
, /* 16 */ MATURITY_DATE
, /* 17 */ BATCH_NAME
, /* 18 */ AGENT_NAME
, /* 19 */ CUSTOMER_ID
, /* 20 */ SUPPLIER_ID
, /* 21 */ CREATION_DATE
, /* 22 */ CREATED_BY
, /* 23 */ LAST_UPDATE_DATE
, /* 24 */ LAST_UPDATED_BY
, /* 25 */ PAYMENT_METHOD
, /* 26 */ BANK_ACCOUNT_NUM
, /* 27 */ BANK_ACCOUNT_NAME
, /* 28 */ BANK_CURRENCY_CODE
, /* 29 */ BANK_NAME
, /* 30 */ REVERSAL_CATEGORY
, /* 31 */ REVERSAL_CATEGORY_ID
, /* 32 */ REVERSAL_REASON
, /* 33 */ REVERSAL_REASON_ID
, /* 34 */ REVERSAL_COMMENTS
, /* 35 */ PAYMENT_METHOD_ID
, /* 36 */ BATCH_ID
, /* 37 */ CASH_RECEIPT_ID
, /* 38 */ APPLICATION_ID
, /* 39 */ REMITTANCE_NUMBER
, /* 40 */ AGENT_NUMBER
, /* 41 */ TRX_RECONCILED_FLAG
, /* 42 */ STATEMENT_LINE_ID
, /* 43 */ STATEMENT_NUMBER
, /* 44 */ STATEMENT_LINE_AMOUNT
, /* 45 */ TRX_CURRENCY_TYPE
, /* 46 */ BASE_AMOUNT
, /* 47 */ VALUE_DATE
, /* 48 */ CE_BANK_ACCT_USE_ID
, ORG_ID
, TO_NUMBER(NULL)
FROM CE_999_REVERSAL_V
WHERE CE_AUTO_BANK_MATCH.GET_999 = 1