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.

[Home] [Help]

View: CE_REVERSAL_TRANSACTIONS_V

Product:	CE - Cash Management
Description:	Available transactions for reversal or unclearing
Implementation/DBA Data:	APPS.CE_REVERSAL_TRANSACTIONS_V

View Text

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

Columns

Name
ROW_ID
MULTI_SELECT
BANK_ACCOUNT_ID
TRX_ID
TRX_TYPE
TYPE_MEANING
TRX_NUMBER
CURRENCY_CODE
AMOUNT
BANK_ACCOUNT_AMOUNT
AMOUNT_CLEARED
GL_DATE
STATUS_DSP
STATUS
TRX_DATE
CLEARED_DATE
MATURITY_DATE
BATCH_NAME
AGENT_NAME
CUSTOMER_ID
SUPPLIER_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
PAYMENT_METHOD
BANK_ACCOUNT_NUM
BANK_ACCOUNT_NAME
BANK_CURRENCY_CODE
BANK_NAME
REVERSAL_CATEGORY
REVERSAL_CATEGORY_ID
REVERSAL_REASON
REVERSAL_REASON_ID
REVERSAL_COMMENTS
PAYMENT_METHOD_ID
BATCH_ID
CASH_RECEIPT_ID
APPLICATION_ID
REMITTANCE_NUMBER
AGENT_NUMBER
TRX_RECONCILED_FLAG
STATEMENT_LINE_ID
STATEMENT_NUMBER
STATEMENT_LINE_AMOUNT
TRX_CURRENCY_TYPE
BASE_AMOUNT
VALUE_DATE
CE_BANK_ACCT_USE_ID
ORG_ID
LEGAL_ENTITY_ID