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.

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

VIEW: APPS.CE_JE_MAPPINGS_V

Object Details

Object Name:	CE_JE_MAPPINGS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CE_JE_MAPPINGS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		ROWID from CE_JE_MAPPINGS
BANK_ACCOUNT_NAME	VARCHAR2	(100)	Yes	Bank Account Name
BANK_ACCOUNT_NUM	VARCHAR2	(30)		Bank Account Number
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
BANK_BRANCH_NAME	VARCHAR2	(360)	Yes	Bank branch name
BANK_NAME	VARCHAR2	(360)	Yes	Bank Name
TRX_CODE	VARCHAR2	(30)	Yes	Transaction code
SEARCH_STRING_TXT	VARCHAR2	(255)		Search String
GL_ACCOUNT_CCID	NUMBER	(15)	Yes	GL Account code combination id
REFERENCE_TXT	VARCHAR2	(80)		Reference text
START_DATE	DATE			Start date of the transaction code
END_DATE	DATE			End date of the transaction code
BANK_ACCOUNT_ID	NUMBER	(15)	Yes	Bank Account identifier
TRX_CODE_ID	NUMBER	(15)	Yes	Transaction code identifier
JE_MAPPING_ID	NUMBER	(15)	Yes	Journal Entry Mapping identifier
TRXN_SUBTYPE_CODE_ID	NUMBER	(15)		Transaction Subtype Code identifier
TRANSACTION_SUB_TYPE_NAME	VARCHAR2	(30)		Transaction Subtype Name
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standad Who column

Query Text

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


SELECT ROW_ID
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUM
,      CURRENCY_CODE
,      BANK_BRANCH_NAME
,      BANK_NAME
,      TRX_CODE
,      SEARCH_STRING_TXT
,      GL_ACCOUNT_CCID
,      REFERENCE_TXT
,      START_DATE
,      END_DATE
,      BANK_ACCOUNT_ID
,      TRX_CODE_ID
,      JE_MAPPING_ID
,      TRXN_SUBTYPE_CODE_ID
,      TRANSACTION_SUB_TYPE_NAME
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.CE_JE_MAPPINGS_V;

Dependencies

[top of page]

APPS.CE_JE_MAPPINGS_V references the following:

APPS: CE_BANK_ACCOUNTS; CE_BANK_BRANCHES_V; CE_JE_MAPPINGS; CE_TRANSACTION_CODES; CE_TRXNS_SUBTYPE_CODES

APPS.CE_JE_MAPPINGS_V is referenced by following:

APPS: CE_JE_CREATION - show dependent code