[Home] [Help] [Dependency Information]

VIEW: APPS.XTR_REVIEW_JOURNALS_V

Object Details

Object Name:	XTR_REVIEW_JOURNALS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_REVIEW_JOURNALS_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

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

Query Text

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

SELECT ROW_ID
,      BATCH_ID
,      COMPANY_CODE
,      JOURNAL_DATE
,      DEAL_NUMBER
,      TRANSACTION_NUMBER
,      DEAL_TYPE
,      DEAL_SUBTYPE
,      AMOUNT_TYPE
,      DEBIT_AMOUNT
,      CREDIT_AMOUNT
,      CODE_COMBINATION_ID
,      COMMENTS
,      JNL_REVERSAL_IND
,      CANCELLED_IN_GL
,      CREATED_BY
,      CREATED_ON
,      UPDATED_BY
,      UPDATED_ON
,      PRODUCT_TYPE
,      PORTFOLIO_CODE
,      AUDIT_INDICATOR
,      CURRENCY
,      TRANSFER_TO_EXTERNAL_GL
,      SET_OF_BOOKS_ID
,      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
,      USER_ACTION_CODE
,      USER_AMOUNT_TYPE
,      BATCH_TYPE
FROM APPS.XTR_REVIEW_JOURNALS_V;

Dependencies

[top of page]

APPS

XTR_AMOUNT_ACTIONS

XTR_AMOUNT_TYPES

XTR_BATCHES

XTR_DATE_TYPES

XTR_JOURNALS

APPS.XTR_REVIEW_JOURNALS_V is not referenced by any database object