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


VIEW: APPS.XTR_JOURNALS_V

Object Details
Object Name: XTR_JOURNALS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXTR.XTR_JOURNALS_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)
BATCH_ID NUMBER (15) Yes
COMPANY_CODE VARCHAR2 (7) Yes
JOURNAL_DATE DATE
Yes
DEAL_NUMBER NUMBER
Yes
TRANSACTION_NUMBER NUMBER
Yes
DEAL_TYPE VARCHAR2 (7)
DEAL_SUBTYPE VARCHAR2 (30)
AMOUNT_TYPE VARCHAR2 (7)
DEBIT_AMOUNT NUMBER

CREDIT_AMOUNT NUMBER

CODE_COMBINATION_ID NUMBER (15) Yes
COMMENTS VARCHAR2 (255)
JNL_REVERSAL_IND VARCHAR2 (1)
CANCELLED_IN_GL VARCHAR2 (1)
CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

PRODUCT_TYPE VARCHAR2 (10)
PORTFOLIO_CODE VARCHAR2 (30) Yes
AUDIT_INDICATOR VARCHAR2 (1)
CURRENCY VARCHAR2 (15)
TRANSFER_TO_EXTERNAL_GL DATE

SET_OF_BOOKS_ID NUMBER (15) Yes
SUSPENSE_GL VARCHAR2 (1)
ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

GL_SL_LINK_ID NUMBER (15)
SETTLEMENT_NUMBER NUMBER

ORIG_JOURNAL_DATE DATE

ALT_JOURNAL_DATE DATE

DATE_TYPE VARCHAR2 (7)
ACTION_CODE VARCHAR2 (7)
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
,      ACTION_CODE
FROM APPS.XTR_JOURNALS_V;

Dependencies

[top of page]

APPS.XTR_JOURNALS_V references the following:

SchemaAPPS
SynonymXTR_JOURNALS

APPS.XTR_JOURNALS_V is not referenced by any database object