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.XTR_DISC_JOURNALS_V

Object Details

Object Name:	XTR_DISC_JOURNALS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_DISC_JOURNALS_V
Subobject Name:
Status:	VALID

View Type

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

The XTR_DISC_JOURNALS_V view is used for the Discoverer report and is based on the XTR_JOURNALS view. User access to company information is enforced in the XTR_DISC_JOURNALS_V view. Please refer to the full description of XTR_JOURNALS for more details.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(15)	Yes	Identifier that groups events into one process flow.
COMPANY_CODE	VARCHAR2	(7)	Yes	Refer to base table.
JOURNAL_DATE	DATE		Yes	Refer to base table.
DEAL_NUMBER	NUMBER		Yes	Refer to base table.
TRANSACTION_NUMBER	NUMBER		Yes	Refer to base table.
DEAL_TYPE	VARCHAR2	(7)	Yes	Refer to base table.
DEAL_SUBTYPE	VARCHAR2	(7)	Yes	Refer to base table.
AMOUNT_TYPE	VARCHAR2	(7)		Refer to base table.
USER_AMOUNT_TYPE	VARCHAR2	(7)		User-defined amount type code
DEBIT_AMOUNT	NUMBER			Refer to base table.
CREDIT_AMOUNT	NUMBER			Refer to base table.
GL_ACCOUNT_NUMBER	VARCHAR2	(155)		Refer to base table.
GL_ACCOUNT_DESCRIPTION	VARCHAR2	(2000)		Refer to base table.
COMMENTS	VARCHAR2	(255)		Refer to base table.
JNL_REVERSAL_IND	VARCHAR2	(1)		Refer to base table.
CANCELLED_IN_GL	VARCHAR2	(1)		Refer to base table.
CREATED_BY	VARCHAR2	(30)	Yes	Refer to base table.
CREATED_ON	DATE		Yes	Refer to base table.
UPDATED_BY	VARCHAR2	(30)		Refer to base table.
UPDATED_ON	DATE			Refer to base table.
PRODUCT_TYPE	VARCHAR2	(10)		Refer to base table.
PORTFOLIO_CODE	VARCHAR2	(30)	Yes	Refer to base table.
AUDIT_INDICATOR	VARCHAR2	(1)		Refer to base table.
CURRENCY	VARCHAR2	(15)		Refer to base table.
TRANSFER_TO_GL	DATE			Refer to base table.
SET_OF_BOOKS_NAME	VARCHAR2	(30)	Yes	Refer to base table.
SUSPENSE_GL	VARCHAR2	(1)		Refer to base table.
ACCOUNTED_DR	NUMBER			Refer to base table.
ACCOUNTED_CR	NUMBER			Refer to base table.
GL_SL_LINK_ID	NUMBER	(15)		Refer to base table.
SETTLEMENT_NUMBER	NUMBER			Refer to base table.
ORIG_JOURNAL_DATE	DATE			Refer to base table.
ALT_JOURNAL_DATE	DATE			Refer to base table.
DATE_TYPE	VARCHAR2	(7)		Refer to base table.
USER_DATE_TYPE	VARCHAR2	(7)		User-defined date type code
ACTION_CODE	VARCHAR2	(7)		Refer to base table.
COMPANY_NAME	VARCHAR2	(50)	Yes	Refer to base table.
DEAL_TYPE_NAME	VARCHAR2	(80)	Yes	Refer to base table.
DEAL_SUBTYPE_NAME	VARCHAR2	(80)	Yes	Refer to base table.
AMOUNT_TYPE_NAME	VARCHAR2	(80)		Refer to base table.
PRODUCT_TYPE_DESC	VARCHAR2	(80)		Refer to base table.
DATE_TYPE_NAME	VARCHAR2	(80)		Refer to base table.

Query Text

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


SELECT BATCH_ID
,      COMPANY_CODE
,      JOURNAL_DATE
,      DEAL_NUMBER
,      TRANSACTION_NUMBER
,      DEAL_TYPE
,      DEAL_SUBTYPE
,      AMOUNT_TYPE
,      USER_AMOUNT_TYPE
,      DEBIT_AMOUNT
,      CREDIT_AMOUNT
,      GL_ACCOUNT_NUMBER
,      GL_ACCOUNT_DESCRIPTION
,      COMMENTS
,      JNL_REVERSAL_IND
,      CANCELLED_IN_GL
,      CREATED_BY
,      CREATED_ON
,      UPDATED_BY
,      UPDATED_ON
,      PRODUCT_TYPE
,      PORTFOLIO_CODE
,      AUDIT_INDICATOR
,      CURRENCY
,      TRANSFER_TO_GL
,      SET_OF_BOOKS_NAME
,      SUSPENSE_GL
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      GL_SL_LINK_ID
,      SETTLEMENT_NUMBER
,      ORIG_JOURNAL_DATE
,      ALT_JOURNAL_DATE
,      DATE_TYPE
,      USER_DATE_TYPE
,      ACTION_CODE
,      COMPANY_NAME
,      DEAL_TYPE_NAME
,      DEAL_SUBTYPE_NAME
,      AMOUNT_TYPE_NAME
,      PRODUCT_TYPE_DESC
,      DATE_TYPE_NAME
FROM APPS.XTR_DISC_JOURNALS_V;

Dependencies

[top of page]

APPS.XTR_DISC_JOURNALS_V references the following:

APPS: FND_GLOBAL - show dependent code; GL_CODE_COMBINATIONS_KFV; GL_SETS_OF_BOOKS; XTR_AMOUNT_TYPES; XTR_COMPANY_AUTHORITIES; XTR_DATE_TYPES; XTR_DEALER_CODES; XTR_DEAL_SUBTYPES; XTR_DEAL_TYPES; XTR_GL_REFERENCES; XTR_JOURNALS; XTR_PARTY_INFO; XTR_PRODUCT_TYPES

APPS.XTR_DISC_JOURNALS_V is not referenced by any database object