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

VIEW: APPS.CE_AVAILABLE_BATCHES_V

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

View Type

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


The CE_AVAILABLE_BATCHES_V view contains the AP payment batches and AR remittance batches selected by the CE_200_BATCHES_V view and the CE_222_BATCHES_V. The Bank Statements form and the AutoReconciliation program access these batches for reconciling a specific bank statement or a specific statement line.


[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
BATCH_ID NUMBER (15)
Batch identifier
TRX_NUMBER VARCHAR2 (40)
Transaction number
TRX_TYPE VARCHAR2 (30)
Transaction type
TYPE_MEANING VARCHAR2 (80)
Transaction type meaning
TRX_DATE DATE

Transaction date
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
ACTUAL_AMOUNT_CLEARED NUMBER

Not used
GL_DATE DATE

GL date
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Currency exchange rate type
USER_EXCHANGE_RATE_TYPE VARCHAR2 (30)
User-defined currency exchange rate type
EXCHANGE_RATE_DATE DATE

Date used in determining currency exchange rate
EXCHANGE_RATE NUMBER

Currency exchange rate
BANK_CHARGES NUMBER

Bank charge amount
BANK_ERRORS NUMBER

Bank error amount
CREATED_BY NUMBER (15)
Standard WHO column
CREATION_DATE DATE

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

Standard WHO column
CLEARED_AMOUNT NUMBER

Not used
REMITTANCE_NUMBER VARCHAR2 (40)
Remittance number
APPLICATION_ID NUMBER

Application identifier
COUNT_CLEARED NUMBER

Internal use
BANK_ACCOUNT_NUM VARCHAR2 (30)
Bank account number
BANK_NAME VARCHAR2 (360)
Bank name
BANK_BRANCH_NAME VARCHAR2 (360)
Bank branch name
BANK_CURRENCY_CODE VARCHAR2 (15)
Bank currency code
BATCH_NUMBER VARCHAR2 (40)
Batch number
TRX_CURRENCY_TYPE VARCHAR2 (10)
Transaction currency type, functional or entered
EXCHANGE_RATE_DSP NUMBER

Exchange rate description
CE_BANK_ACCT_USE_ID NUMBER

Bank Account Use identifier
ORG_ID NUMBER

Organization identifier
LEGAL_ENTITY_ID VARCHAR2 (0)
Legal Entity identifier
LOGICAL_GROUP_REFERENCE VARCHAR2 (200)
IBY LOGICAL GROUP REFERENCE
Query Text

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


SELECT ROW_ID
,      MULTI_SELECT
,      BANK_ACCOUNT_ID
,      BANK_ACCOUNT_NAME
,      BATCH_ID
,      TRX_NUMBER
,      TRX_TYPE
,      TYPE_MEANING
,      TRX_DATE
,      CURRENCY_CODE
,      AMOUNT
,      BANK_ACCOUNT_AMOUNT
,      AMOUNT_CLEARED
,      ACTUAL_AMOUNT_CLEARED
,      GL_DATE
,      EXCHANGE_RATE_TYPE
,      USER_EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE
,      BANK_CHARGES
,      BANK_ERRORS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CLEARED_AMOUNT
,      REMITTANCE_NUMBER
,      APPLICATION_ID
,      COUNT_CLEARED
,      BANK_ACCOUNT_NUM
,      BANK_NAME
,      BANK_BRANCH_NAME
,      BANK_CURRENCY_CODE
,      BATCH_NUMBER
,      TRX_CURRENCY_TYPE
,      EXCHANGE_RATE_DSP
,      CE_BANK_ACCT_USE_ID
,      ORG_ID
,      LEGAL_ENTITY_ID
,      LOGICAL_GROUP_REFERENCE
FROM APPS.CE_AVAILABLE_BATCHES_V;

Dependencies

[top of page]

APPS.CE_AVAILABLE_BATCHES_V references the following:

SchemaAPPS
ViewCE_200_BATCHES_V
ViewCE_200_GROUPS_V
ViewCE_222_BATCHES_V
PL/SQL PackageCE_AUTO_BANK_MATCH - show dependent code
PL/SQL PackageMO_GLOBAL - show dependent code

APPS.CE_AVAILABLE_BATCHES_V is not referenced by any database object