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

VIEW: APPS.CE_200_TRANSACTIONS_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[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
BANK_ACCOUNT_NAME VARCHAR2 (100)
Bank account name
BANK_ACCOUNT_NUM VARCHAR2 (30)
Bank account number
BANK_NAME VARCHAR2 (360)
Bank name
BANK_BRANCH_NAME VARCHAR2 (360)
Bank branch name
TRX_ID NUMBER (15)
Transaction identifier, check identifier
TRX_TYPE VARCHAR2 (7)
Transaction type, PAYMENT
TYPE_MEANING VARCHAR2 (80)
Transaction type meaning, Payment
TRX_NUMBER VARCHAR2 (40)
Transaction number, check number
CHECK_NUMBER NUMBER (15)
Check 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 including bank charges and errors
GL_DATE DATE

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

Transaction date
CLEARED_DATE DATE

Cleared date for payments
MATURITY_DATE DATE

Future pay due date
EXCHANGE_RATE_DATE DATE

Date used to determine currency exchange rate
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Currency exchange rate type
USER_EXCHANGE_RATE_TYPE VARCHAR2 (30)
Currency exchange rate type description
EXCHANGE_RATE NUMBER

Currency exchange rate
BANK_CHARGES NUMBER

Bank charges
BANK_ERRORS NUMBER

Bank errors
BATCH_NAME VARCHAR2 (255)
Batch name, check run name
BATCH_ID NUMBER

Batch identifier, check run identifier
AGENT_NAME VARCHAR2 (240)
Agent name, vendor name
CUSTOMER_NAME VARCHAR2 (0)
Customer name, Null
PAYMENT_METHOD VARCHAR2 (30)
Payment method
VENDOR_NAME VARCHAR2 (240)
Vendor name
CUSTOMER_ID NUMBER

Customer identifier, Null
SUPPLIER_ID NUMBER (15)
Vendor identifier
REFERENCE_TYPE_DSP VARCHAR2 (0)
Reference type description, Null
REFERENCE_TYPE VARCHAR2 (0)
Reference type, Null
REFERENCE_ID NUMBER

Reference identifier, Null
ACTUAL_AMOUNT_CLEARED NUMBER

Not used
CREATION_DATE DATE

Standard WHO column
CREATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
REMITTANCE_NUMBER VARCHAR2 (40)
Remittance number, batch identifier
CASH_RECEIPT_ID NUMBER

Cash receipt identifier, Null
APPLICATION_ID NUMBER

Application identifier, 200
COUNT_CLEARED NUMBER

Internal use
BANK_CURRENCY_CODE VARCHAR2 (15)
Bank currency code
TRX_CURRENCY_TYPE VARCHAR2 (10)
Transaction currency type
CODE_COMBINATION_ID NUMBER

GL account code
PERIOD_NAME VARCHAR2 (0)
Accounting period name, Null
JOURNAL_ENTRY_NAME VARCHAR2 (0)
Journal entry name, Null
DOCUMENT_NUMBER NUMBER

Document number, Null
JOURNAL_ENTRY_LINE_NUMBER NUMBER

Journal entry line number, Null
CLEARING_TRX_TYPE VARCHAR2 (7)
Transaction type for clearing, PAYMENT
JOURNAL_CATEGORY VARCHAR2 (0)
Journal category, Null
BASE_AMOUNT NUMBER

Transaction amount in functional currency
RECEIPT_CLASS_ID NUMBER

Receipt class identifier, Null
RECEIPT_METHOD_ID NUMBER

Receipt method identifier, Null
RECEIPT_CLASS_NAME VARCHAR2 (0)
Receipt class name, Null
DEPOSIT_DATE DATE

Deposit date, Null
VALUE_DATE DATE

Value date
REVERSED_RECEIPT_FLAG VARCHAR2 (0)
Reversed receipt flag, Null
CE_BANK_ACCT_USE_ID NUMBER (15)
LEGAL_ENTITY_ID NUMBER

ORG_ID NUMBER (15)
Query Text

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


SELECT ROW_ID
,      MULTI_SELECT
,      BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUM
,      BANK_NAME
,      BANK_BRANCH_NAME
,      TRX_ID
,      TRX_TYPE
,      TYPE_MEANING
,      TRX_NUMBER
,      CHECK_NUMBER
,      CURRENCY_CODE
,      AMOUNT
,      BANK_ACCOUNT_AMOUNT
,      AMOUNT_CLEARED
,      GL_DATE
,      STATUS_DSP
,      STATUS
,      TRX_DATE
,      CLEARED_DATE
,      MATURITY_DATE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE_TYPE
,      USER_EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      BANK_CHARGES
,      BANK_ERRORS
,      BATCH_NAME
,      BATCH_ID
,      AGENT_NAME
,      CUSTOMER_NAME
,      PAYMENT_METHOD
,      VENDOR_NAME
,      CUSTOMER_ID
,      SUPPLIER_ID
,      REFERENCE_TYPE_DSP
,      REFERENCE_TYPE
,      REFERENCE_ID
,      ACTUAL_AMOUNT_CLEARED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REMITTANCE_NUMBER
,      CASH_RECEIPT_ID
,      APPLICATION_ID
,      COUNT_CLEARED
,      BANK_CURRENCY_CODE
,      TRX_CURRENCY_TYPE
,      CODE_COMBINATION_ID
,      PERIOD_NAME
,      JOURNAL_ENTRY_NAME
,      DOCUMENT_NUMBER
,      JOURNAL_ENTRY_LINE_NUMBER
,      CLEARING_TRX_TYPE
,      JOURNAL_CATEGORY
,      BASE_AMOUNT
,      RECEIPT_CLASS_ID
,      RECEIPT_METHOD_ID
,      RECEIPT_CLASS_NAME
,      DEPOSIT_DATE
,      VALUE_DATE
,      REVERSED_RECEIPT_FLAG
,      CE_BANK_ACCT_USE_ID
,      LEGAL_ENTITY_ID
,      ORG_ID
FROM APPS.CE_200_TRANSACTIONS_V;

Dependencies

[top of page]

APPS.CE_200_TRANSACTIONS_V references the following:

SchemaAPPS
SynonymAP_CHECKS_ALL
SynonymAP_INV_SELECTION_CRITERIA_ALL
ViewAP_LOOKUP_CODES
SynonymAP_PAYMENT_HISTORY
SynonymAP_PAYMENT_HISTORY_ALL
PL/SQL PackageCE_AUTO_BANK_CLEAR - show dependent code
SynonymCE_BANK_ACCOUNTS
SynonymCE_BANK_ACCT_USES_ALL
SynonymCE_GL_ACCOUNTS_CCID
ViewCE_LOOKUPS
SynonymCE_SECURITY_PROFILES_GT
SynonymCE_STATEMENT_RECONCILS_ALL
SynonymCE_SYSTEM_PARAMETERS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymGL_DAILY_CONVERSION_TYPES
ViewGL_SETS_OF_BOOKS
SynonymHZ_PARTIES
APPS.CE_200_TRANSACTIONS_V is referenced by following:

SchemaAPPS
Package BodyCE_AUTO_BANK_CLEAR1 - show dependent code
Package BodyCE_AUTO_BANK_MATCH - show dependent code
ViewCE_AVAILABLE_TRANSACTIONS_V
Package BodyCE_CEXAVBCH_XMLP_PKG - show dependent code