[Home] [Help] [Dependency Information]
Object Name: | CE_200_GROUPS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CE.CE_200_GROUPS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
MULTI_SELECT | CHAR | (1) | ||
BANK_ACCOUNT_ID | NUMBER | (15) | Yes | |
BANK_ACCOUNT_NAME | VARCHAR2 | (100) | Yes | |
BATCH_ID | NUMBER | (15) | Yes | |
TRX_NUMBER | VARCHAR2 | (40) | ||
TRX_TYPE | VARCHAR2 | (30) | Yes | |
TYPE_MEANING | VARCHAR2 | (80) | Yes | |
TRX_DATE | DATE | |||
CURRENCY_CODE | VARCHAR2 | (10) | ||
AMOUNT | NUMBER | |||
BANK_ACCOUNT_AMOUNT | NUMBER | |||
AMOUNT_CLEARED | NUMBER | |||
ACTUAL_AMOUNT_CLEARED | NUMBER | |||
GL_DATE | DATE | |||
EXCHANGE_RATE_TYPE | VARCHAR2 | (0) | ||
USER_EXCHANGE_RATE_TYPE | VARCHAR2 | (0) | ||
EXCHANGE_RATE_DATE | DATE | |||
EXCHANGE_RATE | NUMBER | |||
BANK_CHARGES | NUMBER | |||
BANK_ERRORS | NUMBER | |||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
CLEARED_AMOUNT | NUMBER | |||
REMITTANCE_NUMBER | VARCHAR2 | (40) | ||
APPLICATION_ID | NUMBER | |||
COUNT_CLEARED | NUMBER | |||
BANK_ACCOUNT_NUM | VARCHAR2 | (30) | ||
BANK_NAME | VARCHAR2 | (360) | Yes | |
BANK_BRANCH_NAME | VARCHAR2 | (360) | Yes | |
BANK_CURRENCY_CODE | VARCHAR2 | (15) | ||
BATCH_NUMBER | VARCHAR2 | (40) | ||
TRX_CURRENCY_TYPE | VARCHAR2 | (10) | ||
CE_BANK_ACCT_USE_ID | NUMBER | |||
ORG_ID | NUMBER | |||
LEGAL_ENTITY_ID | NUMBER | |||
LOGICAL_GROUP_REFERENCE | VARCHAR2 | (200) |
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
, CE_BANK_ACCT_USE_ID
, ORG_ID
, LEGAL_ENTITY_ID
, LOGICAL_GROUP_REFERENCE
FROM APPS.CE_200_GROUPS_V;
|
|
|