DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CE_REVERSAL_TRANSACTIONS_V

Object Details
Object Name: CE_REVERSAL_TRANSACTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_REVERSAL_TRANSACTIONS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


The CE_REVERSAL_TRANSACTIONS_V view contains transactions that can be reversed or uncleared. The Bank Statements form uses this view to select the AR receipts for reversal, and the Unclear Transactions form uses this view to select transactions for unclearing. This view consolidates the data selected by the following views:
CE_200_REVERSAL_V and CE_222_REVERSAL_V.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Database row identifier
MULTI_SELECT CHAR (1)
Column used internally
BANK_ACCOUNT_ID NUMBER (15)
Bank account identifier
TRX_ID NUMBER

Transaction identifier
TRX_TYPE VARCHAR2 (30)
Transaction type
TYPE_MEANING VARCHAR2 (80)
Transaction type meaning
TRX_NUMBER VARCHAR2 (100)
Transaction number
CURRENCY_CODE VARCHAR2 (15)
Transaction currency code
AMOUNT NUMBER

Transaction amount
BANK_ACCOUNT_AMOUNT NUMBER

Transaction amount in bank currency
AMOUNT_CLEARED NUMBER

Cleared amount in bank currency including bank charges and errors
GL_DATE DATE

GL date
STATUS_DSP VARCHAR2 (80)
Transaction status description
STATUS VARCHAR2 (30)
Transaction status
TRX_DATE DATE

Transaction date
CLEARED_DATE DATE

Cleared date
MATURITY_DATE DATE

Transaction maturity date
BATCH_NAME VARCHAR2 (255)
Batch name
AGENT_NAME VARCHAR2 (360)
Agent name
CUSTOMER_ID NUMBER

Customer identifier
SUPPLIER_ID NUMBER

Supplier identifier
CREATION_DATE DATE

Standard WHO column
CREATED_BY NUMBER

Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
PAYMENT_METHOD VARCHAR2 (30)
Payment method
BANK_ACCOUNT_NUM VARCHAR2 (30)
Bank account number
BANK_ACCOUNT_NAME VARCHAR2 (100)
Bank account name
BANK_CURRENCY_CODE VARCHAR2 (15)
Bank currency code
BANK_NAME VARCHAR2 (360)
Bank name
REVERSAL_CATEGORY VARCHAR2 (80)
Reversal category
REVERSAL_CATEGORY_ID VARCHAR2 (20)
Reversal category identifier
REVERSAL_REASON VARCHAR2 (80)
Reversal reason
REVERSAL_REASON_ID VARCHAR2 (30)
Reversal reason identifier
REVERSAL_COMMENTS VARCHAR2 (240)
Comments for reversal
PAYMENT_METHOD_ID VARCHAR2 (40)
Payment method identifier
BATCH_ID VARCHAR2 (40)
Batch identifier
CASH_RECEIPT_ID NUMBER

Cash receipt identifier
APPLICATION_ID NUMBER

Application identifier
REMITTANCE_NUMBER VARCHAR2 (40)
Remittance number
AGENT_NUMBER VARCHAR2 (30)
Agent number
TRX_RECONCILED_FLAG VARCHAR2 (1)
Flag to indicate whether the transaction is reconciled or not
STATEMENT_LINE_ID NUMBER

Statement line identifier
STATEMENT_NUMBER VARCHAR2 (50)
Statement number
STATEMENT_LINE_AMOUNT NUMBER

Statement line amount
TRX_CURRENCY_TYPE VARCHAR2 (10)
Transaction currency type
BASE_AMOUNT NUMBER

Transaction amount in functional currency
VALUE_DATE DATE

Value date
CE_BANK_ACCT_USE_ID NUMBER

Bank Account Use identifier
ORG_ID NUMBER

Organization identifier
LEGAL_ENTITY_ID NUMBER

Legal Entity identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.CE_REVERSAL_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.CE_REVERSAL_TRANSACTIONS_V references the following:

SchemaAPPS
PL/SQL PackageARP_CASHBOOK - show dependent code
ViewCE_200_REVERSAL_V
ViewCE_222_REVERSAL_V
ViewCE_260_CF_REVERSAL_V
ViewCE_999_REVERSAL_V
PL/SQL PackageCE_AUTO_BANK_CLEAR - show dependent code
PL/SQL PackageCE_AUTO_BANK_MATCH - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageIBY_FD_EXTRACT_GEN_PVT - show dependent code

APPS.CE_REVERSAL_TRANSACTIONS_V is not referenced by any database object